Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5941

create-test-configuration.sh does not properly create Hive Metastore schema

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.11.0
    • Fix Version/s: Impala 2.11.0
    • Component/s: Infrastructure
    • Labels:
      None

      Description

      When running create-test-configuration.sh to create the hive metastore schema, it is unable to find some of the SQL files:

      19:58:48 psql:/data/jenkins/workspace/impala-asf-master-core-data-load/Impala-Toolchain/cdh_components/hive-1.1.0-cdh5.14.0-SNAPSHOT/scripts/metastore/upgrade/postgres/hive-schema-1.1.0.postgres.sql:1488: hive-txn-schema-0.13.0.postgres.sql: No such file or directory
      19:58:48 psql:/data/jenkins/workspace/impala-asf-master-core-data-load/Impala-Toolchain/cdh_components/hive-1.1.0-cdh5.14.0-SNAPSHOT/scripts/metastore/upgrade/postgres/hive-schema-1.1.0.postgres.sql:1493: 040-HIVE-16556.postgres.sql: No such file or directory

      create-test-configuration.sh is running ${HIVE_HOME}/scripts/metastore/upgrade/postgres/hive-schema-1.1.0.postgres.sql
      This SQL file uses \i to include other SQL files:
      ------------------------------
      – Transaction and lock tables
      ------------------------------
      \i hive-txn-schema-0.13.0.postgres.sql;

      – ------------------------------------------
      – Cloudera specific metastore schema patches
      – ------------------------------------------
      \i 040-HIVE-16556.postgres.sql;

      However, these do not include the path, so they will not be found unless the psql command itself is running from the appropriate directory. (If the Hive SQL scripts used \ir, it would work.)

        Attachments

          Activity

            People

            • Assignee:
              joemcdonnell Joe McDonnell
              Reporter:
              joemcdonnell Joe McDonnell
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: