[jira] [Updated] (HIVE-18699) Check for duplicate partitions in HiveMetastore.exchange_partitions
[ https://issues.apache.org/jira/browse/HIVE-18699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Peter Vary updated HIVE-18699: -- Resolution: Fixed Fix Version/s: 3.0.0 Status: Resolved (was: Patch Available) Pushed to master. Thanks for the patch [~kuczoram]! > Check for duplicate partitions in HiveMetastore.exchange_partitions > --- > > Key: HIVE-18699 > URL: https://issues.apache.org/jira/browse/HIVE-18699 > Project: Hive > Issue Type: Bug > Components: Metastore >Reporter: Marta Kuczora >Assignee: Marta Kuczora >Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-18699.1.patch > > > The HiveMetastore.exchange_partitions method throws the following exception > if the dest table already contains a partition with the same values as the > partition to be exchanged. > {noformat} > org.apache.hadoop.hive.metastore.api.MetaException: Insert of object > "org.apache.hadoop.hive.metastore.model.MPartition@4e78fff5" using statement > "INSERT INTO PARTITIONS > (PART_ID,CREATE_TIME,LAST_ACCESS_TIME,PART_NAME,SD_ID,TBL_ID) VALUES > (?,?,?,?,?,?)" failed : The statement was > aborted because it would have caused a duplicate key value in a unique or > primary key constraint or unique index > identified by 'UNIQUEPARTITION' defined on 'PARTITIONS'. > {noformat} > This use case could be handled better by checking if the partition already > exists in dest table and if it is, throw a MetaException with a proper error > message. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-18699) Check for duplicate partitions in HiveMetastore.exchange_partitions
[ https://issues.apache.org/jira/browse/HIVE-18699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marta Kuczora updated HIVE-18699: - Attachment: (was: HIVE-18699.1.patch) > Check for duplicate partitions in HiveMetastore.exchange_partitions > --- > > Key: HIVE-18699 > URL: https://issues.apache.org/jira/browse/HIVE-18699 > Project: Hive > Issue Type: Bug > Components: Metastore >Reporter: Marta Kuczora >Assignee: Marta Kuczora >Priority: Minor > Attachments: HIVE-18699.1.patch > > > The HiveMetastore.exchange_partitions method throws the following exception > if the dest table already contains a partition with the same values as the > partition to be exchanged. > {noformat} > org.apache.hadoop.hive.metastore.api.MetaException: Insert of object > "org.apache.hadoop.hive.metastore.model.MPartition@4e78fff5" using statement > "INSERT INTO PARTITIONS > (PART_ID,CREATE_TIME,LAST_ACCESS_TIME,PART_NAME,SD_ID,TBL_ID) VALUES > (?,?,?,?,?,?)" failed : The statement was > aborted because it would have caused a duplicate key value in a unique or > primary key constraint or unique index > identified by 'UNIQUEPARTITION' defined on 'PARTITIONS'. > {noformat} > This use case could be handled better by checking if the partition already > exists in dest table and if it is, throw a MetaException with a proper error > message. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-18699) Check for duplicate partitions in HiveMetastore.exchange_partitions
[ https://issues.apache.org/jira/browse/HIVE-18699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marta Kuczora updated HIVE-18699: - Attachment: HIVE-18699.1.patch > Check for duplicate partitions in HiveMetastore.exchange_partitions > --- > > Key: HIVE-18699 > URL: https://issues.apache.org/jira/browse/HIVE-18699 > Project: Hive > Issue Type: Bug > Components: Metastore >Reporter: Marta Kuczora >Assignee: Marta Kuczora >Priority: Minor > Attachments: HIVE-18699.1.patch > > > The HiveMetastore.exchange_partitions method throws the following exception > if the dest table already contains a partition with the same values as the > partition to be exchanged. > {noformat} > org.apache.hadoop.hive.metastore.api.MetaException: Insert of object > "org.apache.hadoop.hive.metastore.model.MPartition@4e78fff5" using statement > "INSERT INTO PARTITIONS > (PART_ID,CREATE_TIME,LAST_ACCESS_TIME,PART_NAME,SD_ID,TBL_ID) VALUES > (?,?,?,?,?,?)" failed : The statement was > aborted because it would have caused a duplicate key value in a unique or > primary key constraint or unique index > identified by 'UNIQUEPARTITION' defined on 'PARTITIONS'. > {noformat} > This use case could be handled better by checking if the partition already > exists in dest table and if it is, throw a MetaException with a proper error > message. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-18699) Check for duplicate partitions in HiveMetastore.exchange_partitions
[ https://issues.apache.org/jira/browse/HIVE-18699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marta Kuczora updated HIVE-18699: - Status: Patch Available (was: Open) > Check for duplicate partitions in HiveMetastore.exchange_partitions > --- > > Key: HIVE-18699 > URL: https://issues.apache.org/jira/browse/HIVE-18699 > Project: Hive > Issue Type: Bug > Components: Metastore >Reporter: Marta Kuczora >Assignee: Marta Kuczora >Priority: Minor > Attachments: HIVE-18699.1.patch > > > The HiveMetastore.exchange_partitions method throws the following exception > if the dest table already contains a partition with the same values as the > partition to be exchanged. > {noformat} > org.apache.hadoop.hive.metastore.api.MetaException: Insert of object > "org.apache.hadoop.hive.metastore.model.MPartition@4e78fff5" using statement > "INSERT INTO PARTITIONS > (PART_ID,CREATE_TIME,LAST_ACCESS_TIME,PART_NAME,SD_ID,TBL_ID) VALUES > (?,?,?,?,?,?)" failed : The statement was > aborted because it would have caused a duplicate key value in a unique or > primary key constraint or unique index > identified by 'UNIQUEPARTITION' defined on 'PARTITIONS'. > {noformat} > This use case could be handled better by checking if the partition already > exists in dest table and if it is, throw a MetaException with a proper error > message. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-18699) Check for duplicate partitions in HiveMetastore.exchange_partitions
[ https://issues.apache.org/jira/browse/HIVE-18699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marta Kuczora updated HIVE-18699: - Status: Open (was: Patch Available) > Check for duplicate partitions in HiveMetastore.exchange_partitions > --- > > Key: HIVE-18699 > URL: https://issues.apache.org/jira/browse/HIVE-18699 > Project: Hive > Issue Type: Bug > Components: Metastore >Reporter: Marta Kuczora >Assignee: Marta Kuczora >Priority: Minor > Attachments: HIVE-18699.1.patch > > > The HiveMetastore.exchange_partitions method throws the following exception > if the dest table already contains a partition with the same values as the > partition to be exchanged. > {noformat} > org.apache.hadoop.hive.metastore.api.MetaException: Insert of object > "org.apache.hadoop.hive.metastore.model.MPartition@4e78fff5" using statement > "INSERT INTO PARTITIONS > (PART_ID,CREATE_TIME,LAST_ACCESS_TIME,PART_NAME,SD_ID,TBL_ID) VALUES > (?,?,?,?,?,?)" failed : The statement was > aborted because it would have caused a duplicate key value in a unique or > primary key constraint or unique index > identified by 'UNIQUEPARTITION' defined on 'PARTITIONS'. > {noformat} > This use case could be handled better by checking if the partition already > exists in dest table and if it is, throw a MetaException with a proper error > message. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-18699) Check for duplicate partitions in HiveMetastore.exchange_partitions
[ https://issues.apache.org/jira/browse/HIVE-18699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marta Kuczora updated HIVE-18699: - Attachment: HIVE-18699.1.patch > Check for duplicate partitions in HiveMetastore.exchange_partitions > --- > > Key: HIVE-18699 > URL: https://issues.apache.org/jira/browse/HIVE-18699 > Project: Hive > Issue Type: Bug > Components: Metastore >Reporter: Marta Kuczora >Assignee: Marta Kuczora >Priority: Minor > Attachments: HIVE-18699.1.patch > > > The HiveMetastore.exchange_partitions method throws the following exception > if the dest table already contains a partition with the same values as the > partition to be exchanged. > {noformat} > org.apache.hadoop.hive.metastore.api.MetaException: Insert of object > "org.apache.hadoop.hive.metastore.model.MPartition@4e78fff5" using statement > "INSERT INTO PARTITIONS > (PART_ID,CREATE_TIME,LAST_ACCESS_TIME,PART_NAME,SD_ID,TBL_ID) VALUES > (?,?,?,?,?,?)" failed : The statement was > aborted because it would have caused a duplicate key value in a unique or > primary key constraint or unique index > identified by 'UNIQUEPARTITION' defined on 'PARTITIONS'. > {noformat} > This use case could be handled better by checking if the partition already > exists in dest table and if it is, throw a MetaException with a proper error > message. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-18699) Check for duplicate partitions in HiveMetastore.exchange_partitions
[ https://issues.apache.org/jira/browse/HIVE-18699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marta Kuczora updated HIVE-18699: - Status: Patch Available (was: Open) > Check for duplicate partitions in HiveMetastore.exchange_partitions > --- > > Key: HIVE-18699 > URL: https://issues.apache.org/jira/browse/HIVE-18699 > Project: Hive > Issue Type: Bug > Components: Metastore >Reporter: Marta Kuczora >Assignee: Marta Kuczora >Priority: Minor > Attachments: HIVE-18699.1.patch > > > The HiveMetastore.exchange_partitions method throws the following exception > if the dest table already contains a partition with the same values as the > partition to be exchanged. > {noformat} > org.apache.hadoop.hive.metastore.api.MetaException: Insert of object > "org.apache.hadoop.hive.metastore.model.MPartition@4e78fff5" using statement > "INSERT INTO PARTITIONS > (PART_ID,CREATE_TIME,LAST_ACCESS_TIME,PART_NAME,SD_ID,TBL_ID) VALUES > (?,?,?,?,?,?)" failed : The statement was > aborted because it would have caused a duplicate key value in a unique or > primary key constraint or unique index > identified by 'UNIQUEPARTITION' defined on 'PARTITIONS'. > {noformat} > This use case could be handled better by checking if the partition already > exists in dest table and if it is, throw a MetaException with a proper error > message. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-18699) Check for duplicate partitions in HiveMetastore.exchange_partitions
[ https://issues.apache.org/jira/browse/HIVE-18699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marta Kuczora updated HIVE-18699: - Description: The HiveMetastore.exchange_partitions method throws the following exception if the dest table already contains a partition with the same values as the partition to be exchanged. {noformat} org.apache.hadoop.hive.metastore.api.MetaException: Insert of object "org.apache.hadoop.hive.metastore.model.MPartition@4e78fff5" using statement "INSERT INTO PARTITIONS (PART_ID,CREATE_TIME,LAST_ACCESS_TIME,PART_NAME,SD_ID,TBL_ID) VALUES (?,?,?,?,?,?)" failed : The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'UNIQUEPARTITION' defined on 'PARTITIONS'. {noformat} This use case could be handled better by checking if the partition already exists in dest table and if it is, throw a MetaException with a proper error message. was: The HiveMetastore.exchange_partitions method throws the following exception if the dest table already contains a partition with the same values as the partition to be exchanged. {noformat} org.apache.hadoop.hive.metastore.api.MetaException: Insert of object "org.apache.hadoop.hive.metastore.model.MPartition@4e78fff5" using statement "INSERT INTO PARTITIONS (PART_ID,CREATE_TIME,LAST_ACCESS_TIME,PART_NAME,SD_ID,TBL_ID) VALUES (?,?,?,?,?,?)" failed : The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'UNIQUEPARTITION' defined on 'PARTITIONS'. {noformat} This use case could be handled better by checking if the partition already exists in dest table and if it is, throw a MetaException with a proper error message. > Check for duplicate partitions in HiveMetastore.exchange_partitions > --- > > Key: HIVE-18699 > URL: https://issues.apache.org/jira/browse/HIVE-18699 > Project: Hive > Issue Type: Bug > Components: Metastore >Reporter: Marta Kuczora >Assignee: Marta Kuczora >Priority: Minor > > The HiveMetastore.exchange_partitions method throws the following exception > if the dest table already contains a partition with the same values as the > partition to be exchanged. > {noformat} > org.apache.hadoop.hive.metastore.api.MetaException: Insert of object > "org.apache.hadoop.hive.metastore.model.MPartition@4e78fff5" using statement > "INSERT INTO PARTITIONS > (PART_ID,CREATE_TIME,LAST_ACCESS_TIME,PART_NAME,SD_ID,TBL_ID) VALUES > (?,?,?,?,?,?)" failed : The statement was > aborted because it would have caused a duplicate key value in a unique or > primary key constraint or unique index > identified by 'UNIQUEPARTITION' defined on 'PARTITIONS'. > {noformat} > This use case could be handled better by checking if the partition already > exists in dest table and if it is, throw a MetaException with a proper error > message. -- This message was sent by Atlassian JIRA (v7.6.3#76005)