You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by an...@apache.org on 2018/06/09 20:57:38 UTC
[1/2] trafodion git commit: jenkins regr failures updates.
Repository: trafodion
Updated Branches:
refs/heads/master 2b5cfad24 -> 985e2a148
jenkins regr failures updates.
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/84fe7391
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/84fe7391
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/84fe7391
Branch: refs/heads/master
Commit: 84fe7391cfe65f40cb91b2a14a2f05783aa5e27d
Parents: 2b5cfad
Author: Anoop Sharma <an...@esgyn.com>
Authored: Sat Jun 9 17:52:24 2018 +0000
Committer: Anoop Sharma <an...@esgyn.com>
Committed: Sat Jun 9 17:52:24 2018 +0000
----------------------------------------------------------------------
core/sql/regress/hive/DIFF008.KNOWN | 2 +-
core/sql/regress/hive/EXPECTED008 | 9 +-
core/sql/regress/hive/EXPECTED018 | 590 +++++++++++++++----------------
core/sql/regress/hive/TEST008 | 7 +-
core/sql/regress/hive/TEST018 | 20 +-
5 files changed, 318 insertions(+), 310 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/84fe7391/core/sql/regress/hive/DIFF008.KNOWN
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/DIFF008.KNOWN b/core/sql/regress/hive/DIFF008.KNOWN
index 36d5524..fc40bdd 100644
--- a/core/sql/regress/hive/DIFF008.KNOWN
+++ b/core/sql/regress/hive/DIFF008.KNOWN
@@ -1,4 +1,4 @@
-280c280,283
+283c283,286
< --- SQL command prepared.
---
> *** ERROR[4002] Column T00804.A is not found. Table T00804 not exposed. Tables in scope: HIVE.HIVE.T00804. Default schema: HIVE.SCH008.
http://git-wip-us.apache.org/repos/asf/trafodion/blob/84fe7391/core/sql/regress/hive/EXPECTED008
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED008 b/core/sql/regress/hive/EXPECTED008
index e1c034b..32e9b0f 100644
--- a/core/sql/regress/hive/EXPECTED008
+++ b/core/sql/regress/hive/EXPECTED008
@@ -92,9 +92,12 @@ A B
--- 1 row(s) selected.
>>
->>create table t00803 as select * from sch008.t00802;
-
---- SQL operation complete.
+>>-- hive execution of create as select... runs into an error due to a
+>>-- security issue.
+>>-- Use regrhive until that issue is fixed.
+>>sh echo "create table sch008.t00803 as select * from sch008.t00802;" > TEST008_junk;
+>>sh regrhive.ksh -f TEST008_junk;
+>>--create table t00803 as select * from sch008.t00802;
>>invoke t00803;
-- Definition of hive table HIVE.SCH008.T00803
http://git-wip-us.apache.org/repos/asf/trafodion/blob/84fe7391/core/sql/regress/hive/EXPECTED018
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED018 b/core/sql/regress/hive/EXPECTED018
index 6efd7d8..d55e131 100644
--- a/core/sql/regress/hive/EXPECTED018
+++ b/core/sql/regress/hive/EXPECTED018
@@ -4,7 +4,7 @@
--- SQL operation complete.
>>obey TEST018(create_hive_tables);
->>drop table unload_customer_address;
+>>drop table if exists unload_customer_address;
--- SQL operation complete.
>>create external table unload_customer_address
@@ -29,7 +29,7 @@
--- SQL operation complete.
>>
>>
->>drop table unload_customer_demographics;
+>>drop table if exists unload_customer_demographics;
--- SQL operation complete.
>>create external table unload_customer_demographics
@@ -49,7 +49,7 @@
--- SQL operation complete.
>>
->>drop table unload_customer;
+>>drop table if exists unload_customer;
--- SQL operation complete.
>>create external table unload_customer
@@ -78,7 +78,7 @@
--- SQL operation complete.
>>
->>drop table unload_customer_name;
+>>drop table if exists unload_customer_name;
--- SQL operation complete.
>>create external table unload_customer_name
@@ -91,7 +91,7 @@
--- SQL operation complete.
>>
->>drop table unload_customer_and_address;
+>>drop table if exists unload_customer_and_address;
--- SQL operation complete.
>>create external table unload_customer_and_address
@@ -133,7 +133,7 @@
--- SQL operation complete.
>>
->>drop table tmp_unload_table;
+>>drop table if exists tmp_unload_table;
--- SQL operation complete.
>>create external table tmp_unload_table
@@ -145,7 +145,7 @@
--- SQL operation complete.
>>
->>drop table unload_store_sales_summary;
+>>drop table if exists unload_store_sales_summary;
--- SQL operation complete.
>>create external table unload_store_sales_summary
@@ -161,14 +161,14 @@
--- SQL operation complete.
>>
->>drop table null_format_default;
+>>drop table if exists null_format_default;
--- SQL operation complete.
>>create external table null_format_default (a string, b string);
--- SQL operation complete.
>>
->>drop table null_format_empty;
+>>drop table if exists null_format_empty;
--- SQL operation complete.
>>create external table null_format_empty(a string, b string)
@@ -177,7 +177,7 @@
--- SQL operation complete.
>>
->>drop table null_format_colon;
+>>drop table if exists null_format_colon;
--- SQL operation complete.
>>create external table null_format_colon(a string, b string)
@@ -334,18 +334,18 @@
>>load with no recovery into customer_address
+>select * from hive.hive.customer_address;
Task: LOAD Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRESS
-Task: CLEANUP Status: Started Time: 2018-06-03 13:49:19.204593
-Task: CLEANUP Status: Ended Time: 2018-06-03 13:49:19.222331
-Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.018
-Task: LOADING DATA Status: Started Time: 2018-06-03 13:49:19.222421
+Task: CLEANUP Status: Started Time: 2018-06-09 17:40:45.278065
+Task: CLEANUP Status: Ended Time: 2018-06-09 17:40:45.290331
+Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.012
+Task: LOADING DATA Status: Started Time: 2018-06-09 17:40:45.290390
Rows Processed: 50000
Error Rows: 0
-Task: LOADING DATA Status: Ended Time: 2018-06-03 13:49:22.940917
-Task: LOADING DATA Status: Ended Elapsed Time: 00:00:03.718
-Task: COMPLETION Status: Started Time: 2018-06-03 13:49:22.940955
+Task: LOADING DATA Status: Ended Time: 2018-06-09 17:40:48.820602
+Task: LOADING DATA Status: Ended Elapsed Time: 00:00:03.530
+Task: COMPLETION Status: Started Time: 2018-06-09 17:40:48.820638
Rows Loaded: 50000
-Task: COMPLETION Status: Ended Time: 2018-06-03 13:49:23.267922
-Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.327
+Task: COMPLETION Status: Ended Time: 2018-06-09 17:40:49.238250
+Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.418
--- 50000 row(s) loaded.
>>--
@@ -370,18 +370,18 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.327
>>load with no recovery into customer_demographics
+>select * from hive.hive.customer_demographics where cd_demo_sk <= 20000;
Task: LOAD Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS
-Task: CLEANUP Status: Started Time: 2018-06-03 13:49:26.314264
-Task: CLEANUP Status: Ended Time: 2018-06-03 13:49:26.327028
-Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.013
-Task: LOADING DATA Status: Started Time: 2018-06-03 13:49:26.327061
+Task: CLEANUP Status: Started Time: 2018-06-09 17:40:52.377408
+Task: CLEANUP Status: Ended Time: 2018-06-09 17:40:52.386813
+Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.009
+Task: LOADING DATA Status: Started Time: 2018-06-09 17:40:52.386838
Rows Processed: 20000
Error Rows: 0
-Task: LOADING DATA Status: Ended Time: 2018-06-03 13:49:52.790342
-Task: LOADING DATA Status: Ended Elapsed Time: 00:00:26.463
-Task: COMPLETION Status: Started Time: 2018-06-03 13:49:52.790421
+Task: LOADING DATA Status: Ended Time: 2018-06-09 17:41:16.137751
+Task: LOADING DATA Status: Ended Elapsed Time: 00:00:23.751
+Task: COMPLETION Status: Started Time: 2018-06-09 17:41:16.137853
Rows Loaded: 20000
-Task: COMPLETION Status: Ended Time: 2018-06-03 13:49:53.148626
-Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.358
+Task: COMPLETION Status: Ended Time: 2018-06-09 17:41:16.491299
+Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.353
--- 20000 row(s) loaded.
>>--
@@ -407,18 +407,18 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.358
>>load with no recovery into customer_demographics_salt
+>select * from hive.hive.customer_demographics where cd_demo_sk <= 20000;
Task: LOAD Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT
-Task: CLEANUP Status: Started Time: 2018-06-03 13:50:01.500528
-Task: CLEANUP Status: Ended Time: 2018-06-03 13:50:01.517388
-Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.017
-Task: LOADING DATA Status: Started Time: 2018-06-03 13:50:01.517433
+Task: CLEANUP Status: Started Time: 2018-06-09 17:41:24.998553
+Task: CLEANUP Status: Ended Time: 2018-06-09 17:41:25.10210
+Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.012
+Task: LOADING DATA Status: Started Time: 2018-06-09 17:41:25.10261
Rows Processed: 20000
Error Rows: 0
-Task: LOADING DATA Status: Ended Time: 2018-06-03 13:50:23.907352
-Task: LOADING DATA Status: Ended Elapsed Time: 00:00:22.390
-Task: COMPLETION Status: Started Time: 2018-06-03 13:50:23.907430
+Task: LOADING DATA Status: Ended Time: 2018-06-09 17:41:45.52416
+Task: LOADING DATA Status: Ended Elapsed Time: 00:00:20.042
+Task: COMPLETION Status: Started Time: 2018-06-09 17:41:45.52541
Rows Loaded: 20000
-Task: COMPLETION Status: Ended Time: 2018-06-03 13:50:24.328501
-Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.421
+Task: COMPLETION Status: Ended Time: 2018-06-09 17:41:45.389161
+Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.337
--- 20000 row(s) loaded.
>>--
@@ -434,18 +434,18 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.421
>>load with no recovery into customer_salt
+>select * from hive.hive.customer;
Task: LOAD Status: Started Object: TRAFODION.HBASE.CUSTOMER_SALT
-Task: CLEANUP Status: Started Time: 2018-06-03 13:50:25.566007
-Task: CLEANUP Status: Ended Time: 2018-06-03 13:50:25.580339
-Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.014
-Task: LOADING DATA Status: Started Time: 2018-06-03 13:50:25.580376
+Task: CLEANUP Status: Started Time: 2018-06-09 17:41:46.627722
+Task: CLEANUP Status: Ended Time: 2018-06-09 17:41:46.637628
+Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.010
+Task: LOADING DATA Status: Started Time: 2018-06-09 17:41:46.637658
Rows Processed: 100000
Error Rows: 0
-Task: LOADING DATA Status: Ended Time: 2018-06-03 13:50:35.601691
-Task: LOADING DATA Status: Ended Elapsed Time: 00:00:10.021
-Task: COMPLETION Status: Started Time: 2018-06-03 13:50:35.601799
+Task: LOADING DATA Status: Ended Time: 2018-06-09 17:41:55.847653
+Task: LOADING DATA Status: Ended Elapsed Time: 00:00:09.210
+Task: COMPLETION Status: Started Time: 2018-06-09 17:41:55.847723
Rows Loaded: 100000
-Task: COMPLETION Status: Ended Time: 2018-06-03 13:50:35.951750
-Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.350
+Task: COMPLETION Status: Ended Time: 2018-06-09 17:41:56.137917
+Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.290
--- 100000 row(s) loaded.
>>--
@@ -470,18 +470,18 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.350
>>load with no recovery into store_sales_salt
+>select * from hive.hive.store_sales where ss_item_sk <= 1000;
Task: LOAD Status: Started Object: TRAFODION.HBASE.STORE_SALES_SALT
-Task: CLEANUP Status: Started Time: 2018-06-03 13:50:38.171676
-Task: CLEANUP Status: Ended Time: 2018-06-03 13:50:38.188339
-Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.017
-Task: LOADING DATA Status: Started Time: 2018-06-03 13:50:38.188391
+Task: CLEANUP Status: Started Time: 2018-06-09 17:41:58.274023
+Task: CLEANUP Status: Ended Time: 2018-06-09 17:41:58.286784
+Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.013
+Task: LOADING DATA Status: Started Time: 2018-06-09 17:41:58.286847
Rows Processed: 160756
Error Rows: 0
-Task: LOADING DATA Status: Ended Time: 2018-06-03 13:50:55.853013
-Task: LOADING DATA Status: Ended Elapsed Time: 00:00:17.665
-Task: COMPLETION Status: Started Time: 2018-06-03 13:50:55.853140
+Task: LOADING DATA Status: Ended Time: 2018-06-09 17:42:21.653423
+Task: LOADING DATA Status: Ended Elapsed Time: 00:00:23.367
+Task: COMPLETION Status: Started Time: 2018-06-09 17:42:21.653526
Rows Loaded: 160756
-Task: COMPLETION Status: Ended Time: 2018-06-03 13:50:56.210166
-Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.357
+Task: COMPLETION Status: Ended Time: 2018-06-09 17:42:22.8839
+Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.355
--- 160756 row(s) loaded.
>>--
@@ -568,13 +568,13 @@ a ?
+> into '/user/trafodion/hive/exttables/null_format_default'
+> select * from null_format_src;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:51:03.627942
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:51:03.632111
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
-Task: EXTRACT Status: Started Time: 2018-06-03 13:51:03.632160
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:42:29.847942
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:42:29.853505
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.006
+Task: EXTRACT Status: Started Time: 2018-06-09 17:42:29.853551
Rows Processed: 10
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:51:03.698352
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.066
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:42:29.928972
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.075
--- 10 row(s) unloaded.
>>select * from hive.hive.null_format_default;
@@ -599,13 +599,13 @@ a
+> into '/user/trafodion/hive/exttables/null_format_empty'
+> select * from null_format_src;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:51:05.257108
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:51:05.261694
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2018-06-03 13:51:05.261815
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:42:30.389243
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:42:30.393574
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
+Task: EXTRACT Status: Started Time: 2018-06-09 17:42:30.393606
Rows Processed: 10
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:51:05.326953
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.065
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:42:30.459700
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.066
--- 10 row(s) unloaded.
>>select * from hive.hive.null_format_empty;
@@ -630,13 +630,13 @@ a
+> into '/user/trafodion/hive/exttables/null_format_colon'
+> select * from null_format_src;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:51:06.807418
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:51:07.98651
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.291
-Task: EXTRACT Status: Started Time: 2018-06-03 13:51:07.98903
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:42:30.898845
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:42:30.902857
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
+Task: EXTRACT Status: Started Time: 2018-06-09 17:42:30.902898
Rows Processed: 10
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:51:07.167356
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.068
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:42:30.989645
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.087
--- 10 row(s) unloaded.
>>select * from hive.hive.null_format_colon;
@@ -698,16 +698,16 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+>select * from trafodion.hbase.customer_address
+>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:05.907863
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:05.920688
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.013
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:05.920738
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:14.417396
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:14.423277
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.006
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:14.423315
Rows Processed: 50000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:07.1351
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.081
-Task: MERGE FILES Status: Started Time: 2018-06-03 13:52:07.1415
-Task: MERGE FILES Status: Ended Time: 2018-06-03 13:52:07.40677
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.039
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:15.434339
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.011
+Task: MERGE FILES Status: Started Time: 2018-06-09 17:43:15.434373
+Task: MERGE FILES Status: Ended Time: 2018-06-09 17:43:15.470747
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.036
--- 50000 row(s) unloaded.
>>log;
@@ -739,16 +739,16 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+>select * from trafodion.hbase.customer_demographics
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:10.57783
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:10.66851
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.009
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:10.66928
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:18.847896
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:18.855498
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.008
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:18.855551
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:10.399937
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.333
-Task: MERGE FILES Status: Started Time: 2018-06-03 13:52:10.399999
-Task: MERGE FILES Status: Ended Time: 2018-06-03 13:52:10.426133
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.026
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:19.184708
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.329
+Task: MERGE FILES Status: Started Time: 2018-06-09 17:43:19.184743
+Task: MERGE FILES Status: Ended Time: 2018-06-09 17:43:19.218961
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.034
--- 20000 row(s) unloaded.
>>log;
@@ -766,16 +766,16 @@ cat /tmp/merged_customer_demogs | wc -l
+>select * from trafodion.hbase.customer_demographics
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:12.937886
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:12.942161
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:12.942221
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:21.687406
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:21.704987
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.018
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:21.705276
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:13.297996
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.356
-Task: MERGE FILES Status: Started Time: 2018-06-03 13:52:13.298046
-Task: MERGE FILES Status: Ended Time: 2018-06-03 13:52:13.337955
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.040
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:21.979866
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.275
+Task: MERGE FILES Status: Started Time: 2018-06-09 17:43:21.979918
+Task: MERGE FILES Status: Ended Time: 2018-06-09 17:43:22.412918
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.433
--- 20000 row(s) unloaded.
>>log;
@@ -806,16 +806,16 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:17.561397
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:17.565716
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:17.565770
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:26.437414
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:26.442466
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:26.442511
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:18.516730
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.951
-Task: MERGE FILES Status: Started Time: 2018-06-03 13:52:18.516810
-Task: MERGE FILES Status: Ended Time: 2018-06-03 13:52:18.580776
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.064
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:27.382778
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.940
+Task: MERGE FILES Status: Started Time: 2018-06-09 17:43:27.382824
+Task: MERGE FILES Status: Ended Time: 2018-06-09 17:43:27.439254
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.056
--- 20000 row(s) unloaded.
>>
@@ -832,16 +832,16 @@ regrhadoop.ksh fs -du -s /user/trafodion/bulkload/customer_demographics_salt/mer
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:21.177732
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:21.182737
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:21.182789
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:30.787097
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:30.796651
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.010
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:30.796721
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:21.987418
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.805
-Task: MERGE FILES Status: Started Time: 2018-06-03 13:52:21.987481
-Task: MERGE FILES Status: Ended Time: 2018-06-03 13:52:22.29948
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.042
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:31.183916
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.387
+Task: MERGE FILES Status: Started Time: 2018-06-09 17:43:31.183951
+Task: MERGE FILES Status: Ended Time: 2018-06-09 17:43:31.221177
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.037
--- 20000 row(s) unloaded.
>>
@@ -873,13 +873,13 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:24.703017
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:24.708869
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:33.707859
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:33.713733
Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.006
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:24.708941
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:33.713805
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:25.367954
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.659
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:34.300087
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.586
--- 20000 row(s) unloaded.
>>
@@ -898,16 +898,16 @@ regrhadoop.ksh fs -ls /user/trafodion/bulkload/customer_demographics_salt/file*
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:29.907550
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:29.918987
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:38.507694
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:38.518463
Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.011
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:29.919067
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:38.518548
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:30.169671
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.251
-Task: MERGE FILES Status: Started Time: 2018-06-03 13:52:30.169719
-Task: MERGE FILES Status: Ended Time: 2018-06-03 13:52:30.212138
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.042
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:38.771495
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.253
+Task: MERGE FILES Status: Started Time: 2018-06-09 17:43:38.771542
+Task: MERGE FILES Status: Ended Time: 2018-06-09 17:43:38.809784
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.038
--- 20000 row(s) unloaded.
>>
@@ -1039,16 +1039,16 @@ CD_DEMO_SK CD_GENDER
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:38.283526
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:38.377555
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.094
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:38.377676
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:46.777403
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:46.780786
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.003
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:46.780818
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:39.54355
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.677
-Task: MERGE FILES Status: Started Time: 2018-06-03 13:52:39.54835
-Task: MERGE FILES Status: Ended Time: 2018-06-03 13:52:39.103849
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.049
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:47.427635
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.647
+Task: MERGE FILES Status: Started Time: 2018-06-09 17:43:47.427707
+Task: MERGE FILES Status: Ended Time: 2018-06-09 17:43:47.461224
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.034
--- 20000 row(s) unloaded.
>>log;
@@ -1082,16 +1082,16 @@ regrhadoop.ksh fs -ls /user/trafodion/bulkload/customer_demographics_salt/merged
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:41.528731
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:41.533680
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:41.533715
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:49.717494
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:49.723609
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.006
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:49.723648
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:41.793430
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.260
-Task: MERGE FILES Status: Started Time: 2018-06-03 13:52:41.793483
-Task: MERGE FILES Status: Ended Time: 2018-06-03 13:52:41.956719
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.163
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:50.312670
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.589
+Task: MERGE FILES Status: Started Time: 2018-06-09 17:43:50.312728
+Task: MERGE FILES Status: Ended Time: 2018-06-09 17:43:50.369918
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.057
--- 20000 row(s) unloaded.
>>--sh sleep 10;
@@ -1140,13 +1140,13 @@ CD_DEMO_SK CD_GENDER
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:44.728318
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:44.733629
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:44.733682
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:52.198113
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:52.201251
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.003
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:52.201291
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:45.42324
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.309
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:52.414619
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.213
--- 20000 row(s) unloaded.
>>--sh sleep 10;
@@ -1154,7 +1154,7 @@ Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.309
*** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry.
-*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1528033961955, failedModTS = 1528033965014, failedLoc = hdfs://localhost:36000/user/trafodion/hive/exttables/unload_customer_demographics
+*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1528566230364, failedModTS = 1528566232395, failedLoc = hdfs://localhost:36000/user/trafodion/hive/exttables/unload_customer_demographics
(EXPR)
--------------------
@@ -1196,13 +1196,13 @@ CD_DEMO_SK CD_GENDER
+>INTO '/user/trafodion/hive/exttables/unload_customer_address'
+>select * from trafodion.hbase.customer_address ;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:50.189253
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:50.193894
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:50.193965
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:55.418573
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:55.425136
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:55.425221
Rows Processed: 50000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:50.898351
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.704
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:56.523873
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.099
--- 50000 row(s) unloaded.
>>--sh sleep 10;
@@ -1251,13 +1251,13 @@ CA_ADDRESS_SK CA_ADDRESS_ID
+>INTO '/user/trafodion/hive/exttables/unload_customer_address'
+>select * from trafodion.hbase.customer_address ;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:53.288446
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:53.293371
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:53.293412
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:43:58.758859
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:43:58.762443
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
+Task: EXTRACT Status: Started Time: 2018-06-09 17:43:58.762473
Rows Processed: 50000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:52:54.39479
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.746
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:43:59.444192
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.682
--- 50000 row(s) unloaded.
>>--sh sleep 10;
@@ -1265,7 +1265,7 @@ Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.746
*** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry.
-*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1528033970835, failedModTS = 1528033973983, failedLoc = hdfs://localhost:36000/user/trafodion/hive/exttables/unload_customer_address
+*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1528566236077, failedModTS = 1528566239402, failedLoc = hdfs://localhost:36000/user/trafodion/hive/exttables/unload_customer_address
(EXPR)
--------------------
@@ -1319,13 +1319,13 @@ CA_ADDRESS_SK CA_ADDRESS_ID
+>INTO '/user/trafodion/hive/exttables/unload_customer'
+>select * from trafodion.hbase.customer_salt;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:52:57.737802
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:52:57.745513
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.008
-Task: EXTRACT Status: Started Time: 2018-06-03 13:52:57.745566
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:44:03.41301
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:44:03.45246
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
+Task: EXTRACT Status: Started Time: 2018-06-09 17:44:03.45343
Rows Processed: 100000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:53:00.981694
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:03.236
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:44:06.290798
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:03.245
--- 100000 row(s) unloaded.
>>--sh sleep 10;
@@ -1375,13 +1375,13 @@ C_CUSTOMER_SK C_CUSTOMER_ID
+>INTO '/user/trafodion/hive/exttables/unload_customer_demographics'
+>select * from trafodion.hbase.customer_demographics_salt;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:53:04.47919
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:53:04.54712
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
-Task: EXTRACT Status: Started Time: 2018-06-03 13:53:04.54758
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:44:09.587474
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:44:09.598500
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.011
+Task: EXTRACT Status: Started Time: 2018-06-09 17:44:09.598564
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:53:04.308855
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.254
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:44:09.849118
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.251
--- 20000 row(s) unloaded.
>>--sh sleep 10;
@@ -1430,16 +1430,16 @@ CD_DEMO_SK CD_GENDER
+>INTO '/user/trafodion/bulkload/customer_address'
+>select * from trafodion.hbase.customer_address where ca_address_sk < 100;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:53:06.107949
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:53:06.112081
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
-Task: EXTRACT Status: Started Time: 2018-06-03 13:53:06.112114
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:44:11.587457
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:44:11.590813
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.003
+Task: EXTRACT Status: Started Time: 2018-06-09 17:44:11.590840
Rows Processed: 99
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:53:06.162235
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.050
-Task: MERGE FILES Status: Started Time: 2018-06-03 13:53:06.162273
-Task: MERGE FILES Status: Ended Time: 2018-06-03 13:53:06.186390
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.024
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:44:11.637490
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.047
+Task: MERGE FILES Status: Started Time: 2018-06-09 17:44:11.637534
+Task: MERGE FILES Status: Ended Time: 2018-06-09 17:44:11.662686
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.025
--- 99 row(s) unloaded.
>>
@@ -1474,13 +1474,13 @@ regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/unload_customer_demographic
+>INTO '/user/trafodion/hive/exttables/unload_store_sales_summary'
+>select ss_sold_date_sk,ss_store_sk, sum (ss_quantity) from store_sales_salt group by ss_sold_date_sk ,ss_store_sk;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:53:09.7602
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:53:09.11839
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
-Task: EXTRACT Status: Started Time: 2018-06-03 13:53:09.11899
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:44:14.117956
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:44:14.123273
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
+Task: EXTRACT Status: Started Time: 2018-06-09 17:44:14.123310
Rows Processed: 12349
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:53:12.473268
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:03.461
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:44:17.108547
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:02.985
--- 12349 row(s) unloaded.
>>--sh sleep 10;
@@ -1598,13 +1598,13 @@ SS_SOLD_DATE_SK SS_STORE_SK SS_QUANTITY
+>INTO '/user/trafodion/hive/exttables/unload_customer_and_address'
+>select * from trafodion.hbase.customer_salt c join trafodion.hbase.customer_address ca on c.c_current_addr_sk = ca.ca_address_sk ;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:53:14.118218
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:53:14.122109
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
-Task: EXTRACT Status: Started Time: 2018-06-03 13:53:14.122177
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:44:18.718184
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:44:18.723264
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
+Task: EXTRACT Status: Started Time: 2018-06-09 17:44:18.723297
Rows Processed: 100000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:53:16.966582
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:02.844
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:44:21.333099
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:02.610
--- 100000 row(s) unloaded.
>>--sh sleep 10;
@@ -1651,13 +1651,13 @@ C_CUSTOMER_SK C_CUSTOMER_ID
+>INTO '/user/trafodion/hive/exttables/unload_customer_address'
+>select * from customer_address where ca_address_sk < 1000 union select * from customer_address where ca_address_sk > 40000 and ca_address_sk < 41000;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:53:21.327239
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:53:21.332207
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2018-06-03 13:53:21.332251
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:44:25.852275
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:44:25.859385
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
+Task: EXTRACT Status: Started Time: 2018-06-09 17:44:25.859457
Rows Processed: 1998
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:53:21.643527
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.311
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:44:26.531699
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.672
--- 1998 row(s) unloaded.
>>--sh sleep 10;
@@ -1768,7 +1768,7 @@ ESP_EXCHANGE ============================== SEQ_NO 3 ONLY CHILD 2
use_snapshot_scan ...... TRUE
full_table_name ........ TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT
snapshot_name .......... TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT_SNAP111
- snapshot_temp_location /user/trafodion/bulkload/20180603135323/
+ snapshot_temp_location /user/trafodion/bulkload/20180609174428/
grep -i -e 'explain reg' -e snapshot -e full_table_name -e esp_exchange LOG018_REGULAR_SCAN_PLAN.TXT | grep -v snapshot_scan_run_id
>>--no snapshot
>>explain reg;
@@ -1852,7 +1852,7 @@ grep -i -e 'explain snp' -e snapshot -e full_table_name -e esp_exchange LOG018_S
use_snapshot_scan ...... TRUE
full_table_name ........ TRAFODION.HBASE.CUSTOMER_ADDRESS
snapshot_name .......... TRAFODION.HBASE.CUSTOMER_ADDRESS_SNAP111
- snapshot_temp_location /user/trafodion/bulkload/20180603135329/
+ snapshot_temp_location /user/trafodion/bulkload/20180609174435/
grep -i -e 'explain reg' -e snapshot -e full_table_name -e esp_exchange LOG018_REGULAR_SCAN_PLAN.TXT | grep -v snapshot_scan_run_id
>>--no snapshot
>>explain reg;
@@ -1947,12 +1947,12 @@ ESP_EXCHANGE ============================== SEQ_NO 6 ONLY CHILD 5
use_snapshot_scan ...... TRUE
full_table_name ........ TRAFODION.HBASE.CUSTOMER_SALT
snapshot_name .......... TRAFODION.HBASE.CUSTOMER_SALT_SNAP111
- snapshot_temp_location /user/trafodion/bulkload/20180603135347/
+ snapshot_temp_location /user/trafodion/bulkload/20180609174451/
ESP_EXCHANGE ============================== SEQ_NO 2 ONLY CHILD 1
use_snapshot_scan ...... TRUE
full_table_name ........ TRAFODION.HBASE.CUSTOMER_ADDRESS
snapshot_name .......... TRAFODION.HBASE.CUSTOMER_ADDRESS_SNAP111
- snapshot_temp_location /user/trafodion/bulkload/20180603135347/
+ snapshot_temp_location /user/trafodion/bulkload/20180609174451/
grep -i -e 'explain reg' -e snapshot -e full_table_name -e esp_exchange LOG018_REGULAR_SCAN_PLAN.TXT | grep -v snapshot_scan_run_id
>>--no snapshot
>>explain reg;
@@ -2070,17 +2070,17 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+>select * from customer_address
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:55:15.529591
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:55:15.551030
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.021
-Task: VERIFY SNAPSHO Status: Started Time: 2018-06-03 13:55:15.551111
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:47:20.208094
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:47:20.215236
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
+Task: VERIFY SNAPSHO Status: Started Time: 2018-06-09 17:47:20.215286
Snapshots verified: 1
-Task: VERIFY SNAPSHO Status: Ended Time: 2018-06-03 13:55:16.9270
-Task: VERIFY SNAPSHO Status: Ended Elapsed Time: 00:00:00.458
-Task: EXTRACT Status: Started Time: 2018-06-03 13:55:16.9402
+Task: VERIFY SNAPSHO Status: Ended Time: 2018-06-09 17:47:21.128406
+Task: VERIFY SNAPSHO Status: Ended Elapsed Time: 00:00:00.913
+Task: EXTRACT Status: Started Time: 2018-06-09 17:47:21.128501
Rows Processed: 50000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:55:16.898232
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.889
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:47:22.543626
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.415
--- 50000 row(s) unloaded.
>>
@@ -2151,17 +2151,17 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+>INTO '/user/trafodion/hive/exttables/unload_customer_demographics'
+>select * from trafodion.hbase.customer_demographics_salt <<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:55:20.387582
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:55:20.390665
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.003
-Task: VERIFY SNAPSHO Status: Started Time: 2018-06-03 13:55:20.390739
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:47:26.717723
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:47:26.719372
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.002
+Task: VERIFY SNAPSHO Status: Started Time: 2018-06-09 17:47:26.719409
Snapshots verified: 1
-Task: VERIFY SNAPSHO Status: Ended Time: 2018-06-03 13:55:20.729287
-Task: VERIFY SNAPSHO Status: Ended Elapsed Time: 00:00:00.339
-Task: EXTRACT Status: Started Time: 2018-06-03 13:55:20.729319
+Task: VERIFY SNAPSHO Status: Ended Time: 2018-06-09 17:47:27.97771
+Task: VERIFY SNAPSHO Status: Ended Elapsed Time: 00:00:00.378
+Task: EXTRACT Status: Started Time: 2018-06-09 17:47:27.97879
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:55:31.637644
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:10.908
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:47:57.439922
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:30.342
--- 20000 row(s) unloaded.
>>
@@ -2208,21 +2208,21 @@ CD_DEMO_SK CD_GENDER
+>INTO '/user/trafodion/hive/exttables/unload_customer_demographics'
+>select * from trafodion.hbase.customer_demographics_salt <<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:55:33.468457
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:55:33.478567
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.010
-Task: CREATE SNAPSHO Status: Started Time: 2018-06-03 13:55:33.478640
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:47:59.337618
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:47:59.344843
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
+Task: CREATE SNAPSHO Status: Started Time: 2018-06-09 17:47:59.344900
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended Time: 2018-06-03 13:55:34.230765
-Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.752
-Task: EXTRACT Status: Started Time: 2018-06-03 13:55:34.230866
+Task: CREATE SNAPSHO Status: Ended Time: 2018-06-09 17:48:00.54419
+Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.710
+Task: EXTRACT Status: Started Time: 2018-06-09 17:48:00.54513
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:55:35.111780
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.881
-Task: DELETE SNAPSHO Status: Started Time: 2018-06-03 13:55:35.111848
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:48:01.605513
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.551
+Task: DELETE SNAPSHO Status: Started Time: 2018-06-09 17:48:01.605604
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended Time: 2018-06-03 13:55:35.142906
-Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.031
+Task: DELETE SNAPSHO Status: Ended Time: 2018-06-09 17:48:01.626100
+Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.020
--- 20000 row(s) unloaded.
>>
@@ -2230,7 +2230,7 @@ Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.031
*** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry.
-*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1528034131528, failedModTS = 1528034135036, failedLoc = hdfs://localhost:36000/user/trafodion/hive/exttables/unload_customer_demographics
+*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1528566477316, failedModTS = 1528566481538, failedLoc = hdfs://localhost:36000/user/trafodion/hive/exttables/unload_customer_demographics
(EXPR)
--------------------
@@ -2273,21 +2273,21 @@ CD_DEMO_SK CD_GENDER
+>INTO '/user/trafodion/hive/exttables/unload_customer_demographics'
+>select * from trafodion.hbase.customer_demographics_salt <<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:55:38.97129
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:55:38.107724
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.011
-Task: CREATE SNAPSHO Status: Started Time: 2018-06-03 13:55:38.107775
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:48:04.578355
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:48:04.591721
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.013
+Task: CREATE SNAPSHO Status: Started Time: 2018-06-09 17:48:04.591828
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended Time: 2018-06-03 13:55:38.789769
-Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.682
-Task: EXTRACT Status: Started Time: 2018-06-03 13:55:38.789853
+Task: CREATE SNAPSHO Status: Ended Time: 2018-06-09 17:48:05.300803
+Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.709
+Task: EXTRACT Status: Started Time: 2018-06-09 17:48:05.300887
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:55:39.542249
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.752
-Task: DELETE SNAPSHO Status: Started Time: 2018-06-03 13:55:39.542328
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:48:06.351362
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.050
+Task: DELETE SNAPSHO Status: Started Time: 2018-06-09 17:48:06.351468
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended Time: 2018-06-03 13:55:39.548261
-Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.006
+Task: DELETE SNAPSHO Status: Ended Time: 2018-06-09 17:48:06.359782
+Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.008
--- 20000 row(s) unloaded.
>>
@@ -2335,21 +2335,21 @@ CD_DEMO_SK CD_GENDER
+>INTO '/user/trafodion/hive/exttables/unload_customer_address'
+>select * from customer_address where ca_address_sk < 1000 union select * from customer_address where ca_address_sk > 40000 and ca_address_sk < 41000;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:55:41.309378
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:55:41.315499
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.006
-Task: CREATE SNAPSHO Status: Started Time: 2018-06-03 13:55:41.315623
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:48:08.197842
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:48:08.202115
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
+Task: CREATE SNAPSHO Status: Started Time: 2018-06-09 17:48:08.202168
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended Time: 2018-06-03 13:55:41.913219
-Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.598
-Task: EXTRACT Status: Started Time: 2018-06-03 13:55:41.913309
+Task: CREATE SNAPSHO Status: Ended Time: 2018-06-09 17:48:08.779880
+Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.578
+Task: EXTRACT Status: Started Time: 2018-06-09 17:48:08.779962
Rows Processed: 1998
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:55:42.186190
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.273
-Task: DELETE SNAPSHO Status: Started Time: 2018-06-03 13:55:42.186241
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:48:09.67664
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.288
+Task: DELETE SNAPSHO Status: Started Time: 2018-06-09 17:48:09.67729
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended Time: 2018-06-03 13:55:42.192108
-Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.006
+Task: DELETE SNAPSHO Status: Ended Time: 2018-06-09 17:48:09.72732
+Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.005
--- 1998 row(s) unloaded.
>>
@@ -2423,21 +2423,21 @@ CA_ADDRESS_SK CA_ADDRESS_ID
+>INTO '/user/trafodion/hive/exttables/unload_customer_and_address'
+>select * from trafodion.hbase.customer_salt c join trafodion.hbase.customer_address ca on c.c_current_addr_sk = ca.ca_address_sk ;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:55:43.878753
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:55:43.883230
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
-Task: CREATE SNAPSHO Status: Started Time: 2018-06-03 13:55:43.883286
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:48:10.748291
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:48:10.768016
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.020
+Task: CREATE SNAPSHO Status: Started Time: 2018-06-09 17:48:10.768149
Snapshots created: 2
-Task: CREATE SNAPSHO Status: Ended Time: 2018-06-03 13:55:46.70975
-Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:02.188
-Task: EXTRACT Status: Started Time: 2018-06-03 13:55:46.71083
+Task: CREATE SNAPSHO Status: Ended Time: 2018-06-09 17:48:12.942498
+Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:02.174
+Task: EXTRACT Status: Started Time: 2018-06-09 17:48:12.942579
Rows Processed: 100000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:55:49.239764
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:03.169
-Task: DELETE SNAPSHO Status: Started Time: 2018-06-03 13:55:49.239818
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:48:16.813832
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:03.871
+Task: DELETE SNAPSHO Status: Started Time: 2018-06-09 17:48:16.813898
Snapshots deleted: 2
-Task: DELETE SNAPSHO Status: Ended Time: 2018-06-03 13:55:49.251199
-Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.011
+Task: DELETE SNAPSHO Status: Ended Time: 2018-06-09 17:48:16.830698
+Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.017
--- 100000 row(s) unloaded.
>>--sh sleep 10;
@@ -2504,21 +2504,21 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+>INTO '/user/trafodion/hive/exttables/unload_customer_name'
+>select c_first_name,c_last_name from trafodion.hbase.customer_salt;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2018-06-03 13:55:52.931550
-Task: EMPTY TARGET Status: Ended Time: 2018-06-03 13:55:52.938609
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
-Task: CREATE SNAPSHO Status: Started Time: 2018-06-03 13:55:52.938647
+Task: EMPTY TARGET Status: Started Time: 2018-06-09 17:48:20.667269
+Task: EMPTY TARGET Status: Ended Time: 2018-06-09 17:48:20.672836
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.006
+Task: CREATE SNAPSHO Status: Started Time: 2018-06-09 17:48:20.672874
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended Time: 2018-06-03 13:55:53.412302
-Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.474
-Task: EXTRACT Status: Started Time: 2018-06-03 13:55:53.412379
+Task: CREATE SNAPSHO Status: Ended Time: 2018-06-09 17:48:21.93087
+Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.420
+Task: EXTRACT Status: Started Time: 2018-06-09 17:48:21.93156
Rows Processed: 100000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:55:54.579128
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.167
-Task: DELETE SNAPSHO Status: Started Time: 2018-06-03 13:55:54.579501
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:48:22.494774
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.402
+Task: DELETE SNAPSHO Status: Started Time: 2018-06-09 17:48:22.494928
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended Time: 2018-06-03 13:55:54.585021
-Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.006
+Task: DELETE SNAPSHO Status: Ended Time: 2018-06-09 17:48:22.502206
+Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.007
--- 100000 row(s) unloaded.
>>--sh sleep 10;
@@ -2562,7 +2562,7 @@ C_FIRST_NAME
>>--unload 100 --should give error [8447]
>>unload into '//\a//c' select * from CUSTOMER_ADDRESS;
Task: UNLOAD Status: Started
-Task: EXTRACT Status: Started Time: 2018-06-03 13:55:57.249893
+Task: EXTRACT Status: Started Time: 2018-06-09 17:48:26.57442
*** ERROR[8447] An error occurred during hdfs access. Error Detail: Java exception in HdfsClient::hdfsOpen(). java.io.IOException: No FileSystem for scheme: null
org.apache.hadoop.fs.FileSystem.getFileSystemClass(FileSystem.java:2676)
@@ -2596,10 +2596,10 @@ unload with delimiter 0 into '/user/trafodion/bulkload/test' select * from CUST
>>--unload 103 -- should not give an error
>>unload with delimiter '\a' into '/user/trafodion/bulkload/test' select * from customer_address;
Task: UNLOAD Status: Started
-Task: EXTRACT Status: Started Time: 2018-06-03 13:55:57.648284
+Task: EXTRACT Status: Started Time: 2018-06-09 17:48:26.488709
Rows Processed: 50000
-Task: EXTRACT Status: Ended Time: 2018-06-03 13:55:58.455790
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.808
+Task: EXTRACT Status: Ended Time: 2018-06-09 17:48:27.279734
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.791
--- 50000 row(s) unloaded.
>>--unload 24 -- should give an error
http://git-wip-us.apache.org/repos/asf/trafodion/blob/84fe7391/core/sql/regress/hive/TEST008
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/TEST008 b/core/sql/regress/hive/TEST008
index 5333de3..61dfd60 100644
--- a/core/sql/regress/hive/TEST008
+++ b/core/sql/regress/hive/TEST008
@@ -45,7 +45,12 @@ invoke t00802;
insert into t00802 values (1,2);
select * from t00802;
-create table t00803 as select * from sch008.t00802;
+-- hive execution of create as select... runs into an error due to a
+-- security issue.
+-- Use regrhive until that issue is fixed.
+sh echo "create table sch008.t00803 as select * from sch008.t00802;" > TEST008_junk;
+sh regrhive.ksh -f TEST008_junk;
+--create table t00803 as select * from sch008.t00802;
invoke t00803;
select * from t00803;
http://git-wip-us.apache.org/repos/asf/trafodion/blob/84fe7391/core/sql/regress/hive/TEST018
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/TEST018 b/core/sql/regress/hive/TEST018
index e793677..812328d 100644
--- a/core/sql/regress/hive/TEST018
+++ b/core/sql/regress/hive/TEST018
@@ -757,7 +757,7 @@ log LOG018;
log;
?section create_hive_tables
-drop table unload_customer_address;
+drop table if exists unload_customer_address;
create external table unload_customer_address
(
ca_address_sk int,
@@ -778,7 +778,7 @@ row format delimited fields terminated by '|'
location '/user/trafodion/hive/exttables/unload_customer_address';
-drop table unload_customer_demographics;
+drop table if exists unload_customer_demographics;
create external table unload_customer_demographics
(
cd_demo_sk int,
@@ -794,7 +794,7 @@ create external table unload_customer_demographics
row format delimited fields terminated by '|'
location '/user/trafodion/hive/exttables/unload_customer_demographics';
-drop table unload_customer;
+drop table if exists unload_customer;
create external table unload_customer
(
c_customer_sk int,
@@ -819,7 +819,7 @@ create external table unload_customer
row format delimited fields terminated by '|' LINES TERMINATED BY '\n'
location '/user/trafodion/hive/exttables/unload_customer';
-drop table unload_customer_name;
+drop table if exists unload_customer_name;
create external table unload_customer_name
(
c_first_name string,
@@ -828,7 +828,7 @@ create external table unload_customer_name
row format delimited fields terminated by '|' LINES TERMINATED BY '\n'
location '/user/trafodion/hive/exttables/unload_customer_name';
-drop table unload_customer_and_address;
+drop table if exists unload_customer_and_address;
create external table unload_customer_and_address
(
c_customer_sk int,
@@ -866,7 +866,7 @@ create external table unload_customer_and_address
row format delimited fields terminated by '|' LINES TERMINATED BY '\n'
location '/user/trafodion/hive/exttables/unload_customer_and_address';
-drop table tmp_unload_table;
+drop table if exists tmp_unload_table;
create external table tmp_unload_table
(
filed string
@@ -874,7 +874,7 @@ create external table tmp_unload_table
row format delimited fields terminated by '|'
location '/user/trafodion/hive/exttables/tmp_unload_table';
-drop table unload_store_sales_summary;
+drop table if exists unload_store_sales_summary;
create external table unload_store_sales_summary
(
ss_sold_date_sk int,
@@ -886,15 +886,15 @@ create external table unload_store_sales_summary
row format delimited fields terminated by '|'
location '/user/trafodion/hive/exttables/unload_store_sales_summary';
-drop table null_format_default;
+drop table if exists null_format_default;
create external table null_format_default (a string, b string);
-drop table null_format_empty;
+drop table if exists null_format_empty;
create external table null_format_empty(a string, b string)
row format delimited fields terminated by '|'
null defined as '';
-drop table null_format_colon;
+drop table if exists null_format_colon;
create external table null_format_colon(a string, b string)
row format delimited fields terminated by '|'
null defined as ':';
[2/2] trafodion git commit: PR-1598 Jenkins regression failures fix.
Posted by an...@apache.org.
PR-1598 Jenkins regression failures fix.
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/985e2a14
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/985e2a14
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/985e2a14
Branch: refs/heads/master
Commit: 985e2a148b445d721a8e8cee813d5367224841c7
Parents: 2b5cfad 84fe739
Author: Anoop Sharma <an...@esgyn.com>
Authored: Sat Jun 9 20:57:18 2018 +0000
Committer: Anoop Sharma <an...@esgyn.com>
Committed: Sat Jun 9 20:57:18 2018 +0000
----------------------------------------------------------------------
core/sql/regress/hive/DIFF008.KNOWN | 2 +-
core/sql/regress/hive/EXPECTED008 | 9 +-
core/sql/regress/hive/EXPECTED018 | 590 +++++++++++++++----------------
core/sql/regress/hive/TEST008 | 7 +-
core/sql/regress/hive/TEST018 | 20 +-
5 files changed, 318 insertions(+), 310 deletions(-)
----------------------------------------------------------------------