Repository: incubator-impala Updated Branches: refs/heads/master 36b4ea6f6 -> ac1215fd3
IMPALA-3939: Data loading may fail on tpch kudu Change-Id: I7f229a9f74fa4dceb14335914b0dde9bf607264e Reviewed-on: http://gerrit.cloudera.org:8080/3818 Reviewed-by: Tim Armstrong <[email protected]> Tested-by: Internal Jenkins Project: http://git-wip-us.apache.org/repos/asf/incubator-impala/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-impala/commit/b9f6392e Tree: http://git-wip-us.apache.org/repos/asf/incubator-impala/tree/b9f6392e Diff: http://git-wip-us.apache.org/repos/asf/incubator-impala/diff/b9f6392e Branch: refs/heads/master Commit: b9f6392e848555da1697394f57c7e7be9bcb923f Parents: 36b4ea6 Author: Matthew Jacobs <[email protected]> Authored: Fri Jul 29 14:34:11 2016 -0700 Committer: Internal Jenkins <[email protected]> Committed: Sat Jul 30 03:59:29 2016 +0000 ---------------------------------------------------------------------- testdata/datasets/tpch/tpch_schema_template.sql | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/b9f6392e/testdata/datasets/tpch/tpch_schema_template.sql ---------------------------------------------------------------------- diff --git a/testdata/datasets/tpch/tpch_schema_template.sql b/testdata/datasets/tpch/tpch_schema_template.sql index cdff1df..25d8d78 100644 --- a/testdata/datasets/tpch/tpch_schema_template.sql +++ b/testdata/datasets/tpch/tpch_schema_template.sql @@ -25,7 +25,7 @@ L_COMMENT STRING ---- ROW_FORMAT DELIMITED FIELDS TERMINATED BY '|' ---- CREATE_KUDU -create table {db_name}{db_suffix}.{table_name} ( +create table if not exists {db_name}{db_suffix}.{table_name} ( L_ORDERKEY BIGINT, L_PARTKEY BIGINT, L_SUPPKEY BIGINT, @@ -73,7 +73,7 @@ P_COMMENT STRING ---- ROW_FORMAT DELIMITED FIELDS TERMINATED BY '|' ---- CREATE_KUDU -create table {db_name}{db_suffix}.{table_name} ( +create table if not exists {db_name}{db_suffix}.{table_name} ( P_PARTKEY BIGINT, P_NAME STRING, P_MFGR STRING, @@ -110,7 +110,7 @@ PS_COMMENT STRING ---- ROW_FORMAT DELIMITED FIELDS TERMINATED BY '|' ---- CREATE_KUDU -create table {db_name}{db_suffix}.{table_name} ( +create table if not exists {db_name}{db_suffix}.{table_name} ( PS_PARTKEY BIGINT, PS_SUPPKEY BIGINT, PS_AVAILQTY BIGINT, @@ -145,7 +145,7 @@ S_COMMENT STRING ---- ROW_FORMAT DELIMITED FIELDS TERMINATED BY '|' ---- CREATE_KUDU -create table {db_name}{db_suffix}.{table_name} ( +create table if not exists {db_name}{db_suffix}.{table_name} ( S_SUPPKEY BIGINT, S_NAME STRING, S_ADDRESS STRING, @@ -179,7 +179,7 @@ N_COMMENT STRING ---- ROW_FORMAT DELIMITED FIELDS TERMINATED BY '|' ---- CREATE_KUDU -create table {db_name}{db_suffix}.{table_name} ( +create table if not exists {db_name}{db_suffix}.{table_name} ( N_NATIONKEY SMALLINT, N_NAME STRING, N_REGIONKEY SMALLINT, @@ -209,7 +209,7 @@ R_COMMENT STRING ---- ROW_FORMAT DELIMITED FIELDS TERMINATED BY '|' ---- CREATE_KUDU -create table {db_name}{db_suffix}.{table_name} ( +create table if not exists {db_name}{db_suffix}.{table_name} ( R_REGIONKEY SMALLINT, R_NAME STRING, R_COMMENT STRING @@ -244,7 +244,7 @@ O_COMMENT STRING ---- ROW_FORMAT DELIMITED FIELDS TERMINATED BY '|' ---- CREATE_KUDU -create table {db_name}{db_suffix}.{table_name} ( +create table if not exists {db_name}{db_suffix}.{table_name} ( O_ORDERKEY BIGINT, O_CUSTKEY BIGINT, O_ORDERSTATUS STRING, @@ -284,7 +284,7 @@ C_COMMENT STRING ---- ROW_FORMAT DELIMITED FIELDS TERMINATED BY '|' ---- CREATE_KUDU -create table {db_name}{db_suffix}.{table_name} ( +create table if not exists {db_name}{db_suffix}.{table_name} ( C_CUSTKEY BIGINT, C_NAME STRING, C_ADDRESS STRING, @@ -315,7 +315,7 @@ revenue supplier_no bigint total_revenue Decimal(38,4) ---- CREATE_KUDU -create table {db_name}{db_suffix}.{table_name} ( +create table if not exists {db_name}{db_suffix}.{table_name} ( supplier_no bigint, total_revevue double ) @@ -334,7 +334,7 @@ max_revenue ---- COLUMNS max_revenue Decimal(38, 4) ---- CREATE_KUDU -create table {db_name}{db_suffix}.{table_name} ( +create table if not exists {db_name}{db_suffix}.{table_name} ( max_revenue bigint ) distribute by hash (max_revenue) into 9 buckets
