hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marco Gaido (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10210) Compute partition column stats fails when partition value is zero-leading integer
Date Wed, 30 Mar 2016 11:01:25 GMT

    [ https://issues.apache.org/jira/browse/HIVE-10210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15217800#comment-15217800
] 

Marco Gaido commented on HIVE-10210:
------------------------------------

The same issue happens if the partitioning column is a char().

> Compute partition column stats fails when partition value is zero-leading integer
> ---------------------------------------------------------------------------------
>
>                 Key: HIVE-10210
>                 URL: https://issues.apache.org/jira/browse/HIVE-10210
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Chaoyu Tang
>            Assignee: Chaoyu Tang
>
> The command "Analyze table .. partition compute statistics for columns" fails if the
partition value is not a normalize integer with leading zeros. For example:
> create table colstatspartint (key int, value string) partitioned by (part int);
> insert into colstatspartint partition (part='0003') select key, value from src limit
30;
> analyze table colstatspartint partition (part='0003') compute statistics for columns;
or
> analyze table colstatspartint partition (part=0003) compute statistics for columns;
> you will get the error:
> {code}
> 15/04/03 10:13:19 ERROR metastore.RetryingHMSHandler: NoSuchObjectException(message:Partition
for which stats is gathered doesn't exist.)
> 	at org.apache.hadoop.hive.metastore.ObjectStore.updatePartitionColumnStatistics(ObjectStore.java:5952)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:606)
> 	at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:114)
> 	at com.sun.proxy.$Proxy6.updatePartitionColumnStatistics(Unknown Source)
> 	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.update_partition_column_statistics(HiveMetaStore.java:4346)
> 	at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.set_aggr_stats_for(HiveMetaStore.java:5678)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message