[jira] [Created] (IMPALA-5941) create-test-configuration.sh does not properly create Hive Metastore schema

["Joe McDonnell (JIRA)" <ji...@apache.org>]

Joe McDonnell created IMPALA-5941:
-------------------------------------

             Summary: create-test-configuration.sh does not properly create Hive Metastore schema
                 Key: IMPALA-5941
                 URL: https://issues.apache.org/jira/browse/IMPALA-5941
             Project: IMPALA
          Issue Type: Bug
          Components: Infrastructure
    Affects Versions: Impala 2.11.0
            Reporter: Joe McDonnell
            Assignee: Joe McDonnell


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.)



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)