title: How to find out if a Hive table is external or internal?
body: <p>I have multiple questions here. I am looking for any hive shell commands or queries to find the below details. </p>
  
  <ol>
  <li><p>Given a hive database name, how can I get the list of external tables in that database?</p></li>
  <li><p>Given a hive table name, how can I find out whether the table is external or internal?</p></li>
  </ol>
  
  <p>Thanks in advance</p>