Hive
  1. Hive
  2. HIVE-6945

issues with dropping partitions on Oracle

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.13.0
    • Fix Version/s: 0.14.0, 0.13.1
    • Component/s: None
    • Labels:
      None

      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.

      1. HIVE-6945-0.13.1.patch
        20 kB
        Sushanth Sowmyan
      2. HIVE-6945.02.patch
        12 kB
        Sergey Shelukhin
      3. HIVE-6945.01.patch
        12 kB
        Sergey Shelukhin
      4. HIVE-6945.patch
        9 kB
        Sergey Shelukhin

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Sergey Shelukhin
            Reporter:
            Sergey Shelukhin
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development