[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sushanth Sowmyan updated HIVE-6945: --- Attachment: HIVE-6945-0.13.1.patch Attaching updated patch for 0.13.1 that causes all tests to pass. (It was to do with reordering of TBLPROPERTIES contents in the .out files) > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Affects Versions: 0.13.0 >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Fix For: 0.14.0 > > Attachments: HIVE-6945-0.13.1.patch, HIVE-6945.01.patch, > HIVE-6945.02.patch, HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sushanth Sowmyan updated HIVE-6945: --- Fix Version/s: 0.13.1 > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Affects Versions: 0.13.0 >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Fix For: 0.14.0, 0.13.1 > > Attachments: HIVE-6945-0.13.1.patch, HIVE-6945.01.patch, > HIVE-6945.02.patch, HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-6945: --- Resolution: Fixed Fix Version/s: 0.14.0 Status: Resolved (was: Patch Available) > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Affects Versions: 0.13.0 >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Fix For: 0.14.0 > > Attachments: HIVE-6945.01.patch, HIVE-6945.02.patch, HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-6945: --- Attachment: HIVE-6945.02.patch > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Affects Versions: 0.13.0 >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-6945.01.patch, HIVE-6945.02.patch, HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-6945: --- Attachment: (was: HIVE-6945.01.patch) > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Affects Versions: 0.13.0 >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-6945.01.patch, HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-6945: --- Attachment: HIVE-6945.01.patch > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Affects Versions: 0.13.0 >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-6945.01.patch, HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-6945: --- Attachment: HIVE-6945.01.patch some missed places on sql path > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Affects Versions: 0.13.0 >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-6945.01.patch, HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thejas M Nair updated HIVE-6945: Affects Version/s: 0.13.0 > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Affects Versions: 0.13.0 >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-6945: --- Attachment: HIVE-6945.patch > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-6945: --- Status: Patch Available (was: Open) > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > Attachments: HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle
[ https://issues.apache.org/jira/browse/HIVE-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-6945: --- Description: 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is translated by DN into decimal rather than long. This appears to be specific to some cases because it seemed to have worked before (different version of Oracle? JDBC? DN? Maybe depends on whether db was auto-created). 2) When partition dropping code falls back to JDO, it creates objects to return, then drops partitions. It appears that dropping makes DN objects invalid. We create metastore partition objects out of DN objects before drop, however the list of partition column values is re-used, rather than copied, into these. DN appears to clear this list during drop, so the returned object becomes invalid and the exception is thrown. > issues with dropping partitions on Oracle > - > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug >Reporter: Sergey Shelukhin >Assignee: Sergey Shelukhin > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is > translated by DN into decimal rather than long. This appears to be specific > to some cases because it seemed to have worked before (different version of > Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to > return, then drops partitions. It appears that dropping makes DN objects > invalid. We create metastore partition objects out of DN objects before drop, > however the list of partition column values is re-used, rather than copied, > into these. DN appears to clear this list during drop, so the returned object > becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)
