[jira] [Created] (HIVE-22002) Insert into table partition fails partially with stats.autogather is on.

["Naveen Gangam (JIRA)" <ji...@apache.org>]

Naveen Gangam created HIVE-22002:
------------------------------------

             Summary: Insert into table partition fails partially with stats.autogather is on.
                 Key: HIVE-22002
                 URL: https://issues.apache.org/jira/browse/HIVE-22002
             Project: Hive
          Issue Type: Bug
          Components: HiveServer2
    Affects Versions: 4.0.0
            Reporter: Naveen Gangam


create table test_double(id int) partitioned by (dbtest double); 
insert into test_double partition(dbtest) values (1,9.9); --> this works
insert into test_double partition(dbtest) values (1,10); --> this fails 

But if we change it to
insert into test_double partition(dbtest) values (1, cast (10 as double)); it succeeds 

-> the problem is only seen when trying to insert a whole number i.e. 10, 10.0, 15, 14.0 etc. The issue is not seen when inserting a number with decimal values other than 0. So insert of 10.1 goes though. 

The underlying exception from the HMS is 
{code}
2019-07-11T07:58:16,670 ERROR [pool-6-thread-196]: server.TThreadPoolServer (TThreadPoolServer.java:run(297)) - Error occurred during processing of message. java.lang.IndexOutOfBoundsException: Index: 0 at java.util.Collections$EmptyList.get(Collections.java:4454) ~[?:1.8.0_112] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.updatePartColumnStatsWithMerge(HiveMetaStore.java:7808) ~[hive-exec-3.1.0.3.1.0.0-78.jar:3.1.0.3.1.0.0-78] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.set_aggr_stats_for(HiveMetaStore.java:7769) ~[hive-exec-3.1.0.3.1.0.0-78.jar:3.1.0.3.1.0.0-78] 
{code}

With {{hive.stats.column.autogather=false}}, this exception does not occur with or without the explicit casting.

The issue stems from the fact that HS2 created a partition with value {{dbtest=10}} for the table and the stats processor is attempting to add column statistics for partition with value {{dbtest=10.0}}. Thus HMS {{getPartitionsByNames}} cannot find the partition with that value and thus fails to insert the stats. So while the failure initiates on HMS side, the cause in the HS2 query planning.

It makes sense that turning off {{hive.stats.column.autogather}} resolves the issue because there is no StatsTask in a query plan.

But {{SHOW PARTITIONS}} shows the partition as created while the query planner is not including it any plan because of the absence of stats on the partition.




--
This message was sent by Atlassian JIRA
(v7.6.14#76016)