title: Impala/Hive to get list of tables along with its size
body: <p>I have used a query in <strong>Oracle DB</strong> to produce the list of tables in a database along with its owner and respective table size. Here is the sample query i have shared.</p>
  
  <pre><code>select owner, table_name, round((num_rows*avg_row_len)/(1024*1024)) MB 
  from all_tables 
  where owner not like 'SYS%'  -- Exclude system tables.
  and num_rows &gt; 0  -- Ignore empty Tables.
  order by MB desc -- Biggest first.
  </code></pre>
  
  <p>I want the similar output from Impala/Hive.</p>
  
  <p>Note: I tried <code>show table stats &lt;table_name&gt;</code> which will show the stats for individual table. But i want to get all the table stats in one go. Can someone help me in this.</p>