[ 
https://issues.apache.org/jira/browse/HIVE-23960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pravin Sinha updated HIVE-23960:
--------------------------------
    Description: 
{color:#172b4d}Creating a partition with data and adding another partition is 
leading to unbalanced calls to open/commit transaction during 
get_partitions_by_names call.{color}

{color:#172b4d}Issue was discovered during REPL DUMP operation which uses  this 
HMS call to get the metadata of partition. This error occurs when there is a 
partition with no column statistics.{color}

{color:#172b4d}To reproduce:{color}
{code:java}
CREATE TABLE student_part_acid(name string, age int, gpa double) PARTITIONED BY 
(ds string) STORED AS orc;
LOAD DATA INPATH ‘/user/hive/partDir/student_part_acid/ds=20110924’ INTO TABLE 
student_part_acid partition(ds=20110924);
ALTER TABLE student_part_acid ADD PARTITION (ds=20110925);

Now if we try to preform REPL DUMP it fails with this the error "Unbalanced 
calls to open/commit transaction" on the HS2 side. 
{code}

  was:
{color:#172b4d}Creating a partition with data and adding another partition is 
leading to unbalanced calls to open/commit transaction during 
get_partitions_by_names call.
{color}

{color:#172b4d}Issue was discovered during REPL DUMP operation which uses  this 
HMS call to get the metadata of partition. This error occurs when there is a 
partition with no column statistics.{color}

{color:#172b4d}To reproduce:{color}
{code:java}
CREATE TABLE student_part_acid(name string, age int, gpa double) PARTITIONED BY 
(ds string) STORED AS orc;
LOAD DATA INPATH ‘/user/hive/partDir/student_part_acid/ds=20110924’ INTO TABLE 
student_part_acid partition(ds=20110924);
ALTER TABLE student_part_acid ADD PARTITION (ds=20110925);

Now we try to preform REPL DUMP it fails with this the error "Unbalanced calls 
to open/commit transaction" on the HS2 side. 
{code}


> Partition with no column statistics leads to unbalanced calls to 
> openTransaction/commitTransaction error during get_partitions_by_names
> ---------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-23960
>                 URL: https://issues.apache.org/jira/browse/HIVE-23960
>             Project: Hive
>          Issue Type: Task
>            Reporter: Pravin Sinha
>            Assignee: Pravin Sinha
>            Priority: Major
>
> {color:#172b4d}Creating a partition with data and adding another partition is 
> leading to unbalanced calls to open/commit transaction during 
> get_partitions_by_names call.{color}
> {color:#172b4d}Issue was discovered during REPL DUMP operation which uses  
> this HMS call to get the metadata of partition. This error occurs when there 
> is a partition with no column statistics.{color}
> {color:#172b4d}To reproduce:{color}
> {code:java}
> CREATE TABLE student_part_acid(name string, age int, gpa double) PARTITIONED 
> BY (ds string) STORED AS orc;
> LOAD DATA INPATH ‘/user/hive/partDir/student_part_acid/ds=20110924’ INTO 
> TABLE student_part_acid partition(ds=20110924);
> ALTER TABLE student_part_acid ADD PARTITION (ds=20110925);
> Now if we try to preform REPL DUMP it fails with this the error "Unbalanced 
> calls to open/commit transaction" on the HS2 side. 
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to