You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by ta...@apache.org on 2018/10/27 05:19:02 UTC
[4/5] impala git commit: IMPALA-7758: Fix LOCATION clause when
creating chars_formats_*
IMPALA-7758: Fix LOCATION clause when creating chars_formats_*
The current location resolves to /user/hive/warehouse/chars_formats_*.
Impala's test data actually lives at /test-warehouse/chars_formats_*.
Tested this by reloading data from scratch and running the core tests.
Change-Id: I781b484e7a15ccaa5de590563d68b3dca6a658e5
Reviewed-on: http://gerrit.cloudera.org:8080/11789
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
Project: http://git-wip-us.apache.org/repos/asf/impala/repo
Commit: http://git-wip-us.apache.org/repos/asf/impala/commit/2e5d6581
Tree: http://git-wip-us.apache.org/repos/asf/impala/tree/2e5d6581
Diff: http://git-wip-us.apache.org/repos/asf/impala/diff/2e5d6581
Branch: refs/heads/master
Commit: 2e5d65819aaa52e1a89bc5cc212bba3b1b404339
Parents: aa654d4
Author: David Knupp <dk...@cloudera.com>
Authored: Wed Oct 24 13:38:14 2018 -0700
Committer: Impala Public Jenkins <im...@cloudera.com>
Committed: Sat Oct 27 00:56:54 2018 +0000
----------------------------------------------------------------------
testdata/bin/load-dependent-tables.sql | 10 +++++-----
1 file changed, 5 insertions(+), 5 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/impala/blob/2e5d6581/testdata/bin/load-dependent-tables.sql
----------------------------------------------------------------------
diff --git a/testdata/bin/load-dependent-tables.sql b/testdata/bin/load-dependent-tables.sql
index e94def7..d4ff102 100644
--- a/testdata/bin/load-dependent-tables.sql
+++ b/testdata/bin/load-dependent-tables.sql
@@ -39,7 +39,7 @@ CREATE EXTERNAL TABLE alltypesmixedformat (
partitioned by (year int, month int)
row format delimited fields terminated by ',' escaped by '\\'
stored as TEXTFILE
-LOCATION '${hiveconf:hive.metastore.warehouse.dir}/alltypesmixedformat';
+LOCATION '/test-warehouse/alltypesmixedformat';
INSERT OVERWRITE TABLE alltypesmixedformat PARTITION (year=2009, month=1)
SELECT id, bool_col, tinyint_col, smallint_col, int_col, bigint_col,
@@ -76,26 +76,26 @@ DROP TABLE IF EXISTS functional_parquet.chars_formats;
CREATE EXTERNAL TABLE functional_parquet.chars_formats
(cs CHAR(5), cl CHAR(140), vc VARCHAR(32))
STORED AS PARQUET
-LOCATION '${hiveconf:hive.metastore.warehouse.dir}/chars_formats_parquet';
+LOCATION '/test-warehouse/chars_formats_parquet';
DROP TABLE IF EXISTS functional_orc_def.chars_formats;
CREATE EXTERNAL TABLE functional_orc_def.chars_formats
(cs CHAR(5), cl CHAR(140), vc VARCHAR(32))
STORED AS ORC
-LOCATION '${hiveconf:hive.metastore.warehouse.dir}/chars_formats_orc_def';
+LOCATION '/test-warehouse/chars_formats_orc_def';
DROP TABLE IF EXISTS functional.chars_formats;
CREATE EXTERNAL TABLE functional.chars_formats
(cs CHAR(5), cl CHAR(140), vc VARCHAR(32))
ROW FORMAT delimited fields terminated by ',' escaped by '\\'
STORED AS TEXTFILE
-LOCATION '${hiveconf:hive.metastore.warehouse.dir}/chars_formats_text';
+LOCATION '/test-warehouse/chars_formats_text';
DROP TABLE IF EXISTS functional_avro_snap.chars_formats;
CREATE EXTERNAL TABLE functional_avro_snap.chars_formats
(cs CHAR(5), cl CHAR(140), vc VARCHAR(32))
STORED AS AVRO
-LOCATION '${hiveconf:hive.metastore.warehouse.dir}/chars_formats_avro_snap'
+LOCATION '/test-warehouse/chars_formats_avro_snap'
TBLPROPERTIES ('avro.schema.literal'='{"type":"record",
"name":"CharTypesTest","doc":"Schema generated by Kite",
"fields":[