[
https://issues.apache.org/jira/browse/IMPALA-5941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joe McDonnell resolved IMPALA-5941.
-----------------------------------
Resolution: Fixed
Fix Version/s: Impala 2.11.0
commit eecbbcb7c7f392c417d4b65117435faf6ef32820
Author: Joe McDonnell <joemcdonn...@cloudera.com>
Date: Fri Sep 15 09:30:24 2017 -0700
IMPALA-5941: Fix Metastore schema creation in create-test-configuration.sh
The Hive Metastore schema script includes other SQL
scripts using \i, which expects absolute paths. Since
we currently invoke it from outside the schema script
directory, it is unable to find those included scripts.
The fix is to switch to the Hive Metastore script
directory when invoking the schema script.
Change-Id: Ic312df4597c7d211d4ecd551d572f751aea0cd24
Reviewed-on: http://gerrit.cloudera.org:8080/8081
Reviewed-by: Tim Armstrong <tarmstr...@cloudera.com>
Tested-by: David Knupp <dkn...@cloudera.com>
> 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
> Fix For: Impala 2.11.0
>
>
> 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)
