[jira] [Updated] (HIVE-6945) issues with dropping partitions on Oracle

["Sushanth Sowmyan (JIRA)" <ji...@apache.org>]

     [ 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)