You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Pravin Sinha (Jira)" <ji...@apache.org> on 2020/07/30 22:19:00 UTC
[jira] [Updated] (HIVE-23960) Partition with no column statistics
leads to unbalanced calls to openTransaction/commitTransaction error during
get_partitions_by_names
[ 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)