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

HIVE-13076 uses create table if not exists for the postgres script

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.0, 2.4.0, 2.3.2
    • Component/s: None
    • Labels:
      None

      Description

      HIVE-13076 addes a new table to the schema but the patch script uses CREATE TABLE IF NOT EXISTS syntax to add the new table. The issue is that the IF NOT EXISTS clause is only available from postgres 9.1 onwards. So the script will fail for older versions of postgres.

        Attachments

        1. HIVE-17891.01.patch
          0.7 kB
          Vihang Karajgaonkar
        2. HIVE-17891.02.patch
          0.7 kB
          Vihang Karajgaonkar
        3. HIVE-17891.03.patch
          0.7 kB
          Vihang Karajgaonkar
        4. HIVE-17891.04.patch
          0.7 kB
          Vihang Karajgaonkar

          Activity

            People

            • Assignee:
              vihangk1 Vihang Karajgaonkar
              Reporter:
              vihangk1 Vihang Karajgaonkar
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: