title: Get total size of HIVE partitioned table
body: <p>We have HDP 2.6 cluster with HIVE 2.0.We have created clustered partitioned internal table in HIVE. We need to know size of total table in HIVE.</p>
  
  <p>We already have issued ANALYZE command against same.</p>
  
  <pre><code>ANALYZE TABLE A_ITT_ITEM_SALES COMPUTE STATISTICS FOR COLUMNS;
  </code></pre>
  
  <p>When we try to check size -</p>
  
  <pre><code>describe extended a_itt_item_sales
  </code></pre>
  
  <p>In Detailed Table infromation I get -</p>
  
  <pre><code>...parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[FieldSchema(name:trans_date, type:date, comment:null)], parameters:{transient_lastDdlTime=1529059590, last_modified_time=1529059590, last_modified_by=admin, serialization.null.format=}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)...
  </code></pre>
  
  <p>How do we get total size of table when it is clustered partitioned/compressed?</p>