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

• 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
• Target Version: Impala 2.11.0
• Epic Color: ghx-label-7
• Assignee: Joe McDonnell
• Reporter: Joe McDonnell
• Created: 15/Sep/17 16:20
• Updated: 06/Oct/17 18:52
• Resolved: 06/Oct/17 18:52

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