You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Karen Coppage (Jira)" <ji...@apache.org> on 2020/02/05 12:35:00 UTC
[jira] [Resolved] (HIVE-10210) Compute partition column stats fails
when partition value is zero-leading integer
[ https://issues.apache.org/jira/browse/HIVE-10210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karen Coppage resolved HIVE-10210.
----------------------------------
Resolution: Duplicate
> 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
> Priority: Major
>
> 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
(v8.3.4#803005)