[ https://issues.apache.org/jira/browse/HIVE-6727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14176731#comment-14176731 ]
Bing Li commented on HIVE-6727: ------------------------------- This issue also happens when the table is managed but specified a location which is not in hive warehouse directory on hdfs. > Table level stats for external tables are set incorrectly > --------------------------------------------------------- > > Key: HIVE-6727 > URL: https://issues.apache.org/jira/browse/HIVE-6727 > Project: Hive > Issue Type: Bug > Reporter: Harish Butani > Assignee: Bing Li > > if you do the following: > {code} > CREATE EXTERNAL TABLE anaylyze_external (a INT) LOCATION > 'data/files/ext_test'; > describe formatted anaylyze_external; > {code} > The table level stats are: > {noformat} > Table Parameters: > COLUMN_STATS_ACCURATE true > EXTERNAL TRUE > numFiles 0 > numRows 6 > rawDataSize 6 > totalSize 0 > {noformat} > numFiles and totalSize is always 0. > Issue is: > MetaStoreUtils:updateUnpartitionedTableStatsFast attempts to set table level > stats from FileStatus. But it doesn't account for External tables, it always > calls Warehouse.getFileStatusesForUnpartitionedTable -- This message was sent by Atlassian JIRA (v6.3.4#6332)