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

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

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.2, 2.4.0, 3.0.0
    • 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.04.patch
          0.7 kB
          Vihang Karajgaonkar
        2. HIVE-17891.03.patch
          0.7 kB
          Vihang Karajgaonkar
        3. HIVE-17891.02.patch
          0.7 kB
          Vihang Karajgaonkar
        4. HIVE-17891.01.patch
          0.7 kB
          Vihang Karajgaonkar

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              vihangk1 Vihang Karajgaonkar Assign to me
              Reporter:
              vihangk1 Vihang Karajgaonkar

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment