[jira] [Commented] (HIVE-6727) Table level stats for external tables are set incorrectly

["Bing Li (JIRA)" <ji...@apache.org>]

    [ 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)