Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-6945

issues with dropping partitions on Oracle

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.13.0
    • 0.13.1, 0.14.0
    • None
    • 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.

      Attachments

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

        Activity

          People

            sershe Sergey Shelukhin
            sershe Sergey Shelukhin
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: