Chaoyu Tang created HIVE-10210:
----------------------------------

             Summary: 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)

Reply via email to