You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by sa...@apache.org on 2017/05/08 20:28:34 UTC
[2/8] incubator-trafodion git commit: Changes to move all Trafodion
created hdfs files under /user/trafodion
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f094aa0d/core/sql/regress/hive/EXPECTED018
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED018 b/core/sql/regress/hive/EXPECTED018
index e05f25a..b2ba64c 100644
--- a/core/sql/regress/hive/EXPECTED018
+++ b/core/sql/regress/hive/EXPECTED018
@@ -146,18 +146,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: 2017-04-06 22:12:34.718
-Task: CLEANUP Status: Ended Time: 2017-04-06 22:12:34.740
+Task: CLEANUP Status: Started Time: 2017-05-01 18:46:29.746
+Task: CLEANUP Status: Ended Time: 2017-05-01 18:46:29.768
Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.022
-Task: LOADING DATA Status: Started Time: 2017-04-06 22:12:34.740
+Task: LOADING DATA Status: Started Time: 2017-05-01 18:46:29.768
Rows Processed: 50000
Error Rows: 0
-Task: LOADING DATA Status: Ended Time: 2017-04-06 22:12:44.470
-Task: LOADING DATA Status: Ended Elapsed Time: 00:00:09.306
-Task: COMPLETION Status: Started Time: 2017-04-06 22:12:44.471
+Task: LOADING DATA Status: Ended Time: 2017-05-01 18:46:39.501
+Task: LOADING DATA Status: Ended Elapsed Time: 00:00:09.236
+Task: COMPLETION Status: Started Time: 2017-05-01 18:46:39.509
Rows Loaded: 50000
-Task: COMPLETION Status: Ended Time: 2017-04-06 22:12:44.324
-Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.277
+Task: COMPLETION Status: Ended Time: 2017-05-01 18:46:39.346
+Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.341
--- 50000 row(s) loaded.
>>--
@@ -182,18 +182,18 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.277
>>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: 2017-04-06 22:12:49.421
-Task: CLEANUP Status: Ended Time: 2017-04-06 22:12:49.444
-Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.023
-Task: LOADING DATA Status: Started Time: 2017-04-06 22:12:49.444
+Task: CLEANUP Status: Started Time: 2017-05-01 18:46:42.390
+Task: CLEANUP Status: Ended Time: 2017-05-01 18:46:42.404
+Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.014
+Task: LOADING DATA Status: Started Time: 2017-05-01 18:46:42.404
Rows Processed: 20000
Error Rows: 0
-Task: LOADING DATA Status: Ended Time: 2017-04-06 22:13:02.917
-Task: LOADING DATA Status: Ended Elapsed Time: 00:00:12.647
-Task: COMPLETION Status: Started Time: 2017-04-06 22:13:02.920
+Task: LOADING DATA Status: Ended Time: 2017-05-01 18:46:55.199
+Task: LOADING DATA Status: Ended Elapsed Time: 00:00:12.795
+Task: COMPLETION Status: Started Time: 2017-05-01 18:46:55.199
Rows Loaded: 20000
-Task: COMPLETION Status: Ended Time: 2017-04-06 22:13:02.456
-Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.364
+Task: COMPLETION Status: Ended Time: 2017-05-01 18:46:55.606
+Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.407
--- 20000 row(s) loaded.
>>--
@@ -219,18 +219,18 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.364
>>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: 2017-04-06 22:13:07.339
-Task: CLEANUP Status: Ended Time: 2017-04-06 22:13:07.489
-Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.015
-Task: LOADING DATA Status: Started Time: 2017-04-06 22:13:07.489
+Task: CLEANUP Status: Started Time: 2017-05-01 18:47:00.293
+Task: CLEANUP Status: Ended Time: 2017-05-01 18:47:00.311
+Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.018
+Task: LOADING DATA Status: Started Time: 2017-05-01 18:47:00.311
Rows Processed: 20000
Error Rows: 0
-Task: LOADING DATA Status: Ended Time: 2017-04-06 22:13:16.513
-Task: LOADING DATA Status: Ended Elapsed Time: 00:00:09.465
-Task: COMPLETION Status: Started Time: 2017-04-06 22:13:16.513
+Task: LOADING DATA Status: Ended Time: 2017-05-01 18:47:10.603
+Task: LOADING DATA Status: Ended Elapsed Time: 00:00:10.292
+Task: COMPLETION Status: Started Time: 2017-05-01 18:47:10.603
Rows Loaded: 20000
-Task: COMPLETION Status: Ended Time: 2017-04-06 22:13:16.803
-Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.290
+Task: COMPLETION Status: Ended Time: 2017-05-01 18:47:11.346
+Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.431
--- 20000 row(s) loaded.
>>--
@@ -246,18 +246,18 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.290
>>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: 2017-04-06 22:13:19.244
-Task: CLEANUP Status: Ended Time: 2017-04-06 22:13:19.256
-Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.012
-Task: LOADING DATA Status: Started Time: 2017-04-06 22:13:19.256
+Task: CLEANUP Status: Started Time: 2017-05-01 18:47:13.570
+Task: CLEANUP Status: Ended Time: 2017-05-01 18:47:13.584
+Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.015
+Task: LOADING DATA Status: Started Time: 2017-05-01 18:47:13.584
Rows Processed: 100000
Error Rows: 0
-Task: LOADING DATA Status: Ended Time: 2017-04-06 22:13:31.650
-Task: LOADING DATA Status: Ended Elapsed Time: 00:00:11.808
-Task: COMPLETION Status: Started Time: 2017-04-06 22:13:31.651
+Task: LOADING DATA Status: Ended Time: 2017-05-01 18:47:25.306
+Task: LOADING DATA Status: Ended Elapsed Time: 00:00:11.722
+Task: COMPLETION Status: Started Time: 2017-05-01 18:47:25.306
Rows Loaded: 100000
-Task: COMPLETION Status: Ended Time: 2017-04-06 22:13:31.364
-Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.299
+Task: COMPLETION Status: Ended Time: 2017-05-01 18:47:25.645
+Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.339
--- 100000 row(s) loaded.
>>--
@@ -282,18 +282,18 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.299
>>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: 2017-04-06 22:13:35.969
-Task: CLEANUP Status: Ended Time: 2017-04-06 22:13:35.986
+Task: CLEANUP Status: Started Time: 2017-05-01 18:47:28.700
+Task: CLEANUP Status: Ended Time: 2017-05-01 18:47:28.717
Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.017
-Task: LOADING DATA Status: Started Time: 2017-04-06 22:13:35.986
+Task: LOADING DATA Status: Started Time: 2017-05-01 18:47:28.717
Rows Processed: 160756
Error Rows: 0
-Task: LOADING DATA Status: Ended Time: 2017-04-06 22:13:50.490
-Task: LOADING DATA Status: Ended Elapsed Time: 00:00:14.504
-Task: COMPLETION Status: Started Time: 2017-04-06 22:13:50.490
+Task: LOADING DATA Status: Ended Time: 2017-05-01 18:47:42.429
+Task: LOADING DATA Status: Ended Elapsed Time: 00:00:13.711
+Task: COMPLETION Status: Started Time: 2017-05-01 18:47:42.429
Rows Loaded: 160756
-Task: COMPLETION Status: Ended Time: 2017-04-06 22:13:50.824
-Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.334
+Task: COMPLETION Status: Ended Time: 2017-05-01 18:47:42.753
+Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.324
--- 160756 row(s) loaded.
>>--
@@ -377,16 +377,16 @@ a
>>
>>-- using unload
>>unload with purgedata from target
-+> into '/user/hive/exttables/null_format_default'
++> into '/user/trafodion/hive/exttables/null_format_default'
+> select * from null_format_src;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:14:00.918
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:14:00.164
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
-Task: EXTRACT Status: Started Time: 2017-04-06 22:14:00.164
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:47:51.294
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:47:51.296
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.002
+Task: EXTRACT Status: Started Time: 2017-05-01 18:47:51.296
Rows Processed: 10
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:14:00.442
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.426
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:47:51.439
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.142
--- 10 row(s) unloaded.
>>select * from hive.hive.null_format_default;
@@ -408,16 +408,16 @@ a
--- 10 row(s) selected.
>>
>>unload with purgedata from target
-+> into '/user/hive/exttables/null_format_empty'
++> into '/user/trafodion/hive/exttables/null_format_empty'
+> select * from null_format_src;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:14:01.304
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:14:01.308
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
-Task: EXTRACT Status: Started Time: 2017-04-06 22:14:01.308
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:47:52.194
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:47:52.195
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.002
+Task: EXTRACT Status: Started Time: 2017-05-01 18:47:52.195
Rows Processed: 10
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:14:01.529
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.221
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:47:52.297
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.102
--- 10 row(s) unloaded.
>>select * from hive.hive.null_format_empty;
@@ -439,16 +439,16 @@ a ?
--- 10 row(s) selected.
>>
>>unload with purgedata from target
-+> into '/user/hive/exttables/null_format_colon'
++> into '/user/trafodion/hive/exttables/null_format_colon'
+> select * from null_format_src;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:14:03.674
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:14:03.680
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
-Task: EXTRACT Status: Started Time: 2017-04-06 22:14:03.680
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:47:53.342
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:47:53.357
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.001
+Task: EXTRACT Status: Started Time: 2017-05-01 18:47:53.358
Rows Processed: 10
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:14:03.778
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.098
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:47:53.305
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.270
--- 10 row(s) unloaded.
>>select * from hive.hive.null_format_colon;
@@ -488,7 +488,7 @@ a
>>
>>--exp1
>>explain options 'f'
-+>UNLOAD EXTRACT TO '/bulkload/customer_address'
++>UNLOAD EXTRACT TO '/user/trafodion/bulkload/customer_address'
+>select * from trafodion.hbase.customer_address
+><<+ cardinality 10e10 >>;
@@ -506,24 +506,24 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+> PURGEDATA FROM TARGET DELIMITER '|' RECORD_SEPARATOR '\n' NULL_STRING 'NULL'
+>MERGE FILE 'merged_customer_address.gz' OVERWRITE
+>COMPRESSION GZIP
-+>INTO '/bulkload/customer_address'
++>INTO '/user/trafodion/bulkload/customer_address'
+>select * from trafodion.hbase.customer_address
+>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:14:57.526
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:14:57.532
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.006
-Task: EXTRACT Status: Started Time: 2017-04-06 22:14:57.532
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:01.614
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:01.615
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.001
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:01.615
Rows Processed: 50000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:14:58.628
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.096
-Task: MERGE FILES Status: Started Time: 2017-04-06 22:14:58.628
-Task: MERGE FILES Status: Ended Time: 2017-04-06 22:14:58.678
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.050
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:02.955
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.340
+Task: MERGE FILES Status: Started Time: 2017-05-01 18:49:02.955
+Task: MERGE FILES Status: Ended Time: 2017-05-01 18:49:02.995
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.040
--- 50000 row(s) unloaded.
>>log;
-regrhadoop.ksh fs -copyToLocal /bulkload/customer_address/merged_customer_address.gz /tmp
+regrhadoop.ksh fs -copyToLocal /user/trafodion/bulkload/customer_address/merged_customer_address.gz /tmp
gunzip -f /tmp/merged_customer_address.gz
cat /tmp/merged_customer_address | wc -l
50000
@@ -547,24 +547,24 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+>WITH PURGEDATA FROM TARGET
+>MERGE FILE 'merged_customer_demogs.gz' OVERWRITE
+>COMPRESSION GZIP
-+>INTO '/bulkload/customer_demographics'
++>INTO '/user/trafodion/bulkload/customer_demographics'
+>select * from trafodion.hbase.customer_demographics
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:15:02.643
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:02.651
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:06.594
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:06.602
Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.008
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:02.651
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:06.602
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:03.182
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.531
-Task: MERGE FILES Status: Started Time: 2017-04-06 22:15:03.182
-Task: MERGE FILES Status: Ended Time: 2017-04-06 22:15:03.208
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.026
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:07.141
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.539
+Task: MERGE FILES Status: Started Time: 2017-05-01 18:49:07.142
+Task: MERGE FILES Status: Ended Time: 2017-05-01 18:49:07.178
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.037
--- 20000 row(s) unloaded.
>>log;
-regrhadoop.ksh fs -copyToLocal /bulkload/customer_demographics/merged_customer_demogs.gz /tmp
+regrhadoop.ksh fs -copyToLocal /user/trafodion/bulkload/customer_demographics/merged_customer_demogs.gz /tmp
gunzip -f /tmp/merged_customer_demogs.gz
cat /tmp/merged_customer_demogs | wc -l
20000
@@ -574,29 +574,29 @@ cat /tmp/merged_customer_demogs | wc -l
+>WITH PURGEDATA FROM TARGET
+>MERGE FILE 'merged_customer_demogs_2' OVERWRITE
+>--COMPRESSION GZIP
-+>INTO '/bulkload/customer_demographics'
++>INTO '/user/trafodion/bulkload/customer_demographics'
+>select * from trafodion.hbase.customer_demographics
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:15:06.683
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:06.695
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.012
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:06.695
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:10.514
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:10.521
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:10.521
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:07.116
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.316
-Task: MERGE FILES Status: Started Time: 2017-04-06 22:15:07.118
-Task: MERGE FILES Status: Ended Time: 2017-04-06 22:15:07.390
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.027
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:10.860
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.339
+Task: MERGE FILES Status: Started Time: 2017-05-01 18:49:10.860
+Task: MERGE FILES Status: Ended Time: 2017-05-01 18:49:10.903
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.043
--- 20000 row(s) unloaded.
>>log;
-regrhadoop.ksh fs -cat /bulkload/customer_demographics/merged_customer_demogs_2 | wc -l
+regrhadoop.ksh fs -cat /user/trafodion/bulkload/customer_demographics/merged_customer_demogs_2 | wc -l
20000
>>----------------------------------
>>--exp 3
>>explain options 'f'
-+>UNLOAD EXTRACT TO '/bulkload/customer_demographics_salt'
++>UNLOAD EXTRACT TO '/user/trafodion/bulkload/customer_demographics_salt'
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
@@ -618,52 +618,51 @@ 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: 2017-04-06 22:15:12.414
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:12.419
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:12.419
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:16.748
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:16.761
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.001
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:16.761
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:13.186
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.767
-Task: MERGE FILES Status: Started Time: 2017-04-06 22:15:13.186
-Task: MERGE FILES Status: Ended Time: 2017-04-06 22:15:13.222
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.036
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:17.195
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.943
+Task: MERGE FILES Status: Started Time: 2017-05-01 18:49:17.196
+Task: MERGE FILES Status: Ended Time: 2017-05-01 18:49:17.724
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.053
--- 20000 row(s) unloaded.
>>
>>log;
-regrhadoop.ksh fs -du -s /bulkload/customer_demographics_salt/merged_customer_demogs_3
-778224 778224 /bulkload/customer_demographics_salt/merged_customer_demogs_3
+regrhadoop.ksh fs -du -s /user/trafodion/bulkload/customer_demographics_salt/merged_customer_demogs_3
>>-------------------
>>--unload 5
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
+>MERGE FILE 'merged_customer_demogs_4.gz' OVERWRITE
+>COMPRESSION GZIP
-+>INTO '/bulkload/customer_demographics_salt'
++>INTO '/user/trafodion/bulkload/customer_demographics_salt'
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:15:16.391
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:16.448
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.006
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:16.449
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:20.244
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:20.247
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.003
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:20.247
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:16.503
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.459
-Task: MERGE FILES Status: Started Time: 2017-04-06 22:15:16.503
-Task: MERGE FILES Status: Ended Time: 2017-04-06 22:15:16.551
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.047
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:20.801
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.554
+Task: MERGE FILES Status: Started Time: 2017-05-01 18:49:20.801
+Task: MERGE FILES Status: Ended Time: 2017-05-01 18:49:20.849
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.048
--- 20000 row(s) unloaded.
>>
>>log;
-regrhadoop.ksh fs -du -s /bulkload/customer_demographics_salt/merged_customer_demogs_4.gz
-78431 78431 /bulkload/customer_demographics_salt/merged_customer_demogs_4.gz
+regrhadoop.ksh fs -du -s /user/trafodion/bulkload/customer_demographics_salt/merged_customer_demogs_4.gz
+78431 78431 /user/trafodion/bulkload/customer_demographics_salt/merged_customer_demogs_4.gz
>>
>>--exp4
>>explain options 'f'
-+>UNLOAD EXTRACT TO '/bulkload/customer_demographics_salt'
++>UNLOAD EXTRACT TO '/user/trafodion/bulkload/customer_demographics_salt'
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
@@ -679,26 +678,26 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
>>--unload 6
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
-+>--MERGE FILE '/bulkload/merged_customer_demogs_2.gz' OVERWRITE
++>--MERGE FILE '/user/trafodion/bulkload/merged_customer_demogs_2.gz' OVERWRITE
+>--COMPRESSION GZIP
-+>INTO '/bulkload/customer_demographics_salt'
++>INTO '/user/trafodion/bulkload/customer_demographics_salt'
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:15:19.875
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:19.883
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.008
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:19.883
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:24.752
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:24.849
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.010
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:24.850
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:20.492
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.609
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:24.711
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.626
--- 20000 row(s) unloaded.
>>
>>log;
-regrhadoop.ksh fs -cat /bulkload/customer_demographics_salt/file* | wc -l
+regrhadoop.ksh fs -cat /user/trafodion/bulkload/customer_demographics_salt/file* | wc -l
20000
-regrhadoop.ksh fs -ls /bulkload/customer_demographics_salt/file* | grep file | wc -l
+regrhadoop.ksh fs -ls /user/trafodion/bulkload/customer_demographics_salt/file* | grep file | wc -l
4
>>
>>--unload 7
@@ -706,28 +705,28 @@ regrhadoop.ksh fs -ls /bulkload/customer_demographics_salt/file* | grep file |
+>WITH PURGEDATA FROM TARGET
+>MERGE FILE 'merged_customer_demogs_2.gz' OVERWRITE
+>COMPRESSION GZIP
-+>INTO '/bulkload/customer_demographics_salt'
++>INTO '/user/trafodion/bulkload/customer_demographics_salt'
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:15:26.413
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:26.427
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.014
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:26.427
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:30.834
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:30.854
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.020
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:30.854
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:26.994
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.567
-Task: MERGE FILES Status: Started Time: 2017-04-06 22:15:26.994
-Task: MERGE FILES Status: Ended Time: 2017-04-06 22:15:27.511
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.056
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:31.428
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.574
+Task: MERGE FILES Status: Started Time: 2017-05-01 18:49:31.428
+Task: MERGE FILES Status: Ended Time: 2017-05-01 18:49:31.517
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.089
--- 20000 row(s) unloaded.
>>
->>sh regrhadoop.ksh fs -copyToLocal /bulkload/customer_demographics_salt/merged_customer_demogs_2.gz /tmp ;
+>>sh regrhadoop.ksh fs -copyToLocal /user/trafodion/bulkload/customer_demographics_salt/merged_customer_demogs_2.gz /tmp ;
>>sh gunzip -f /tmp/merged_customer_demogs_2.gz ;
->>sh regrhadoop.ksh fs -rm /user/hive/exttables/unload_customer_demographics/* ;
->>sh regrhadoop.ksh fs -copyFromLocal /tmp/merged_customer_demogs_2 /user/hive/exttables/unload_customer_demographics ;
->>sh rm /bulkload/merged_customer_demogs_2 ;
+>>sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/unload_customer_demographics/* ;
+>>sh regrhadoop.ksh fs -copyFromLocal /tmp/merged_customer_demogs_2 /user/trafodion/hive/exttables/unload_customer_demographics ;
+>>sh rm /user/trafodion/bulkload/merged_customer_demogs_2 ;
>>
>>cqd HIVE_MAX_STRING_LENGTH_IN_BYTES '100';
@@ -847,24 +846,24 @@ CD_DEMO_SK CD_GENDER
+>WITH PURGEDATA FROM TARGET
+>MERGE FILE 'merged_customer_demogs_4.gz' OVERWRITE
+>COMPRESSION GZIP
-+>INTO '/bulkload/customer_demographics_salt'
++>INTO '/user/trafodion/bulkload/customer_demographics_salt'
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:15:36.975
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:36.980
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:36.980
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:42.894
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:42.904
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.010
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:42.904
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:37.782
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.802
-Task: MERGE FILES Status: Started Time: 2017-04-06 22:15:37.782
-Task: MERGE FILES Status: Ended Time: 2017-04-06 22:15:37.834
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.051
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:43.534
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.630
+Task: MERGE FILES Status: Started Time: 2017-05-01 18:49:43.534
+Task: MERGE FILES Status: Ended Time: 2017-05-01 18:49:43.583
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.049
--- 20000 row(s) unloaded.
>>log;
-regrhadoop.ksh fs -ls /bulkload/customer_demographics_salt/merged* | grep merge | wc -l
+regrhadoop.ksh fs -ls /user/trafodion/bulkload/customer_demographics_salt/merged* | grep merge | wc -l
1
>>
>>
@@ -874,7 +873,7 @@ regrhadoop.ksh fs -ls /bulkload/customer_demographics_salt/merged* | grep merge
+>WITH PURGEDATA FROM TARGET
+>MERGE FILE 'merged_customer_demogs_2' OVERWRITE
+>COMPRESSION GZIP
-+>INTO '/bulkload/customer_demographics_salt'
++>INTO '/user/trafodion/bulkload/customer_demographics_salt'
+>select * from trafodion.hbase.customer_demographics_salt
+><<+ cardinality 10e10 >>;
@@ -890,20 +889,20 @@ regrhadoop.ksh fs -ls /bulkload/customer_demographics_salt/merged* | grep merge
+>WITH PURGEDATA FROM TARGET
+>MERGE FILE 'merged_customer_demographics' OVERWRITE
+>--COMPRESSION GZIP
-+>INTO '/user/hive/exttables/unload_customer_demographics'
++>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: 2017-04-06 22:15:41.344
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:41.352
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:46.855
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:46.863
Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.008
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:41.352
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:46.863
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:41.871
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.518
-Task: MERGE FILES Status: Started Time: 2017-04-06 22:15:41.871
-Task: MERGE FILES Status: Ended Time: 2017-04-06 22:15:41.922
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.051
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:47.716
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.852
+Task: MERGE FILES Status: Started Time: 2017-05-01 18:49:47.716
+Task: MERGE FILES Status: Ended Time: 2017-05-01 18:49:47.799
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.083
--- 20000 row(s) unloaded.
>>--sh sleep 10;
@@ -948,17 +947,17 @@ CD_DEMO_SK CD_GENDER
+>WITH PURGEDATA FROM TARGET
+>--MERGE FILE 'merged_customer_demographics' OVERWRITE
+>--COMPRESSION GZIP
-+>INTO '/user/hive/exttables/unload_customer_demographics'
++>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: 2017-04-06 22:15:43.724
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:43.729
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:43.729
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:49.955
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:49.962
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:49.962
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:44.561
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.832
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:50.550
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.588
--- 20000 row(s) unloaded.
>>--sh sleep 10;
@@ -966,7 +965,7 @@ Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.832
*** 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 = 1491516941, failedModTS = 1491516943, failedLoc = hdfs://localhost:30200/user/hive/exttables/unload_customer_demographics
+*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1493664587, failedModTS = 1493664590, failedLoc = hdfs://localhost:25600/user/trafodion/hive/exttables/unload_customer_demographics
(EXPR)
--------------------
@@ -1005,16 +1004,16 @@ CD_DEMO_SK CD_GENDER
>>--unload 12
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
-+>INTO '/user/hive/exttables/unload_customer_address'
++>INTO '/user/trafodion/hive/exttables/unload_customer_address'
+>select * from trafodion.hbase.customer_address ;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:15:47.646
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:47.101
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.037
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:47.101
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:53.855
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:53.858
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.003
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:53.858
Rows Processed: 50000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:47.960
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.859
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:54.791
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.933
--- 50000 row(s) unloaded.
>>--sh sleep 10;
@@ -1060,16 +1059,16 @@ CA_ADDRESS_SK CA_ADDRESS_ID
>>--test with numeric delimiers
>>UNLOAD
+>WITH PURGEDATA FROM TARGET DELIMITER 124 RECORD_SEPARATOR 10
-+>INTO '/user/hive/exttables/unload_customer_address'
++>INTO '/user/trafodion/hive/exttables/unload_customer_address'
+>select * from trafodion.hbase.customer_address ;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:15:50.334
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:50.339
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:50.339
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:49:57.416
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:49:57.421
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.006
+Task: EXTRACT Status: Started Time: 2017-05-01 18:49:57.422
Rows Processed: 50000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:51.398
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.059
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:49:58.307
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.885
--- 50000 row(s) unloaded.
>>--sh sleep 10;
@@ -1077,7 +1076,7 @@ Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.059
*** 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 = 1491516947, failedModTS = 1491516950, failedLoc = hdfs://localhost:30200/user/hive/exttables/unload_customer_address
+*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1493664594, failedModTS = 1493664597, failedLoc = hdfs://localhost:25600/user/trafodion/hive/exttables/unload_customer_address
(EXPR)
--------------------
@@ -1128,16 +1127,16 @@ CA_ADDRESS_SK CA_ADDRESS_ID
+>WITH PURGEDATA FROM TARGET
+>--MERGE FILE 'merged_customer_demographics' OVERWRITE
+>--COMPRESSION GZIP
-+>INTO '/user/hive/exttables/unload_customer'
++>INTO '/user/trafodion/hive/exttables/unload_customer'
+>select * from trafodion.hbase.customer_salt;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:15:54.359
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:15:54.366
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.006
-Task: EXTRACT Status: Started Time: 2017-04-06 22:15:54.366
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:50:01.495
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:50:01.497
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.002
+Task: EXTRACT Status: Started Time: 2017-05-01 18:50:01.497
Rows Processed: 100000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:15:58.306
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:03.665
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:50:04.887
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:03.390
--- 100000 row(s) unloaded.
>>--sh sleep 10;
@@ -1184,16 +1183,16 @@ C_CUSTOMER_SK C_CUSTOMER_ID
+>WITH PURGEDATA FROM TARGET
+>--MERGE FILE 'merged_customer_demographics' OVERWRITE
+>--COMPRESSION GZIP
-+>INTO '/user/hive/exttables/unload_customer_demographics'
++>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: 2017-04-06 22:16:00.724
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:16:00.732
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.008
-Task: EXTRACT Status: Started Time: 2017-04-06 22:16:00.732
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:50:07.724
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:50:07.734
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.009
+Task: EXTRACT Status: Started Time: 2017-05-01 18:50:07.734
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:16:00.991
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.259
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:50:08.712
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.337
--- 20000 row(s) unloaded.
>>--sh sleep 10;
@@ -1239,19 +1238,19 @@ CD_DEMO_SK CD_GENDER
+> PURGEDATA FROM TARGET DELIMITER '|' RECORD_SEPARATOR '\n' NULL_STRING 'NULL'
+>MERGE FILE 'merged_customer_address.gz' OVERWRITE
+>COMPRESSION GZIP
-+>INTO '/bulkload/customer_address'
++>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: 2017-04-06 22:16:02.675
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:16:02.679
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:50:10.860
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:50:10.909
Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2017-04-06 22:16:02.679
+Task: EXTRACT Status: Started Time: 2017-05-01 18:50:10.910
Rows Processed: 99
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:16:02.736
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.056
-Task: MERGE FILES Status: Started Time: 2017-04-06 22:16:02.736
-Task: MERGE FILES Status: Ended Time: 2017-04-06 22:16:02.759
-Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.023
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:50:10.159
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.068
+Task: MERGE FILES Status: Started Time: 2017-05-01 18:50:10.159
+Task: MERGE FILES Status: Ended Time: 2017-05-01 18:50:10.193
+Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.034
--- 99 row(s) unloaded.
>>
@@ -1261,16 +1260,16 @@ Task: MERGE FILES Status: Ended Elapsed Time: 00:00:00.023
+> PURGEDATA FROM TARGET DELIMITER '|' RECORD_SEPARATOR '\n' NULL_STRING 'NULL'
+>MERGE FILE 'merged_customer_address.gz'
+>COMPRESSION GZIP
-+>INTO '/bulkload/customer_address'
++>INTO '/user/trafodion/bulkload/customer_address'
+>select * from trafodion.hbase.customer_address where ca_address_sk < 100;
-*** ERROR[8965] File /bulkload/customer_address/merged_customer_address.gz already exists.
+*** ERROR[8965] File /user/trafodion/bulkload/customer_address/merged_customer_address.gz already exists.
--- 0 row(s) unloaded.
>>
>>
>>log;
-regrhadoop.ksh fs -rm /user/hive/exttables/unload_customer_demographics/*
+regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/unload_customer_demographics/*
>>
>>
>>cqd HDFS_IO_BUFFERSIZE reset;
@@ -1283,16 +1282,16 @@ regrhadoop.ksh fs -rm /user/hive/exttables/unload_customer_demographics/*
>>UNLOAD
+>WITH
+> PURGEDATA FROM TARGET DELIMITER '|' RECORD_SEPARATOR '\n'
-+>INTO '/user/hive/exttables/unload_store_sales_summary'
++>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: 2017-04-06 22:16:06.343
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:16:06.349
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2017-04-06 22:16:06.349
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:50:13.905
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:50:13.912
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.008
+Task: EXTRACT Status: Started Time: 2017-05-01 18:50:13.912
Rows Processed: 12349
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:16:10.661
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:04.312
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:50:18.119
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:04.207
--- 12349 row(s) unloaded.
>>--sh sleep 10;
@@ -1407,16 +1406,16 @@ SS_SOLD_DATE_SK SS_STORE_SK SS_QUANTITY
>>--unload 18
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
-+>INTO '/user/hive/exttables/unload_customer_and_address'
++>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: 2017-04-06 22:16:12.575
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:16:12.581
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: EXTRACT Status: Started Time: 2017-04-06 22:16:12.581
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:50:20.184
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:50:20.186
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.003
+Task: EXTRACT Status: Started Time: 2017-05-01 18:50:20.186
Rows Processed: 100000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:16:15.847
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:03.267
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:50:23.138
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:02.952
--- 100000 row(s) unloaded.
>>--sh sleep 10;
@@ -1460,16 +1459,16 @@ C_CUSTOMER_SK C_CUSTOMER_ID
>>UNLOAD
+>WITH
+> PURGEDATA FROM TARGET
-+>INTO '/user/hive/exttables/unload_customer_address'
++>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: 2017-04-06 22:16:19.304
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:16:19.318
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.014
-Task: EXTRACT Status: Started Time: 2017-04-06 22:16:19.318
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:50:27.804
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:50:27.810
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
+Task: EXTRACT Status: Started Time: 2017-05-01 18:50:27.810
Rows Processed: 1998
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:16:19.610
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.292
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:50:28.224
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.415
--- 1998 row(s) unloaded.
>>--sh sleep 10;
@@ -1580,7 +1579,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 /bulkload/20170406221624/
+ snapshot_temp_location /user/trafodion/bulkload/20170501185033/
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;
@@ -1664,7 +1663,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 /bulkload/20170406221732/
+ snapshot_temp_location /user/trafodion/bulkload/20170501185041/
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;
@@ -1759,12 +1758,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 /bulkload/20170406221755/
+ snapshot_temp_location /user/trafodion/bulkload/20170501185103/
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 /bulkload/20170406221755/
+ snapshot_temp_location /user/trafodion/bulkload/20170501185103/
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;
@@ -1860,7 +1859,7 @@ C_CUSTOMER_SK C_CUSTOMER_ID C_CURRENT_CDEMO_SK C_CURRENT_HDEMO_SK C_CURRE
--- SQL operation complete.
>> -- allow the extract syntax
>>explain options 'f'
-+>UNLOAD EXTRACT TO '/bulkload/customer_address'
++>UNLOAD EXTRACT TO '/user/trafodion/bulkload/customer_address'
+>select * from trafodion.hbase.customer_address <<+ cardinality 10e10 >>;
LC RC OP OPERATOR OPT DESCRIPTION CARD
@@ -1878,21 +1877,21 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
+> EXISTING SNAPSHOT HAVING SUFFIX 'SNAP111'
-+>INTO '/user/hive/exttables/unload_customer_address'
++>INTO '/user/trafodion/hive/exttables/unload_customer_address'
+>select * from customer_address
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
-Task: EMPTY TARGET Status: Started Time: 2017-04-06 22:20:33.855
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:20:33.860
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.004
-Task: VERIFY SNAPSHO Status: Started Time: 2017-04-06 22:20:33.860
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:52:43.214
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:52:43.224
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.009
+Task: VERIFY SNAPSHO Status: Started Time: 2017-05-01 18:52:43.224
Snapshots verified: 1
-Task: VERIFY SNAPSHO Status: Ended Time: 2017-04-06 22:20:34.402
-Task: VERIFY SNAPSHO Status: Ended Elapsed Time: 00:00:00.543
-Task: EXTRACT Status: Started Time: 2017-04-06 22:20:34.403
+Task: VERIFY SNAPSHO Status: Ended Time: 2017-05-01 18:52:43.607
+Task: VERIFY SNAPSHO Status: Ended Elapsed Time: 00:00:00.383
+Task: EXTRACT Status: Started Time: 2017-05-01 18:52:43.607
Rows Processed: 50000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:20:35.493
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.091
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:52:44.813
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.206
--- 50000 row(s) unloaded.
>>
@@ -1941,7 +1940,7 @@ CA_ADDRESS_SK CA_ADDRESS_ID
--- SQL operation complete.
>> -- allow the extract syntax
>>explain options 'f'
-+>UNLOAD EXTRACT TO '/user/hive/exttables/unload_customer_demographics'
++>UNLOAD EXTRACT TO '/user/trafodion/hive/exttables/unload_customer_demographics'
+>select * from trafodion.hbase.customer_demographics_salt <<+ cardinality 10e10 >>;
LC RC OP OPERATOR OPT DESCRIPTION CARD
@@ -1960,20 +1959,20 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
+> EXISTING SNAPSHOT HAVING SUFFIX 'SNAP111'
-+>INTO '/user/hive/exttables/unload_customer_demographics'
++>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: 2017-04-06 22:20:39.602
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:20:39.628
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.003
-Task: VERIFY SNAPSHO Status: Started Time: 2017-04-06 22:20:39.629
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:52:48.844
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:52:48.846
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.002
+Task: VERIFY SNAPSHO Status: Started Time: 2017-05-01 18:52:48.846
Snapshots verified: 1
-Task: VERIFY SNAPSHO Status: Ended Time: 2017-04-06 22:20:39.506
-Task: VERIFY SNAPSHO Status: Ended Elapsed Time: 00:00:00.444
-Task: EXTRACT Status: Started Time: 2017-04-06 22:20:39.506
+Task: VERIFY SNAPSHO Status: Ended Time: 2017-05-01 18:52:49.204
+Task: VERIFY SNAPSHO Status: Ended Elapsed Time: 00:00:00.358
+Task: EXTRACT Status: Started Time: 2017-05-01 18:52:49.204
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:20:48.647
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:09.141
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:52:57.416
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:08.211
--- 20000 row(s) unloaded.
>>
@@ -2017,24 +2016,24 @@ CD_DEMO_SK CD_GENDER
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
+> NEW SNAPSHOT HAVING SUFFIX 'SNAP112'
-+>INTO '/user/hive/exttables/unload_customer_demographics'
++>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: 2017-04-06 22:20:50.443
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:20:50.452
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.008
-Task: CREATE SNAPSHO Status: Started Time: 2017-04-06 22:20:50.452
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:52:59.366
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:52:59.377
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.011
+Task: CREATE SNAPSHO Status: Started Time: 2017-05-01 18:52:59.377
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended Time: 2017-04-06 22:20:51.116
-Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.664
-Task: EXTRACT Status: Started Time: 2017-04-06 22:20:51.116
+Task: CREATE SNAPSHO Status: Ended Time: 2017-05-01 18:53:00.390
+Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:01.013
+Task: EXTRACT Status: Started Time: 2017-05-01 18:53:00.393
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:20:52.248
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.132
-Task: DELETE SNAPSHO Status: Started Time: 2017-04-06 22:20:52.248
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:53:01.609
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.216
+Task: DELETE SNAPSHO Status: Started Time: 2017-05-01 18:53:01.609
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended Time: 2017-04-06 22:20:52.262
-Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.013
+Task: DELETE SNAPSHO Status: Ended Time: 2017-05-01 18:53:01.627
+Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.018
--- 20000 row(s) unloaded.
>>
@@ -2042,7 +2041,7 @@ Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.013
*** 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 = 1491517248, failedModTS = 1491517251, failedLoc = hdfs://localhost:30200/user/hive/exttables/unload_customer_demographics
+*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1493664777, failedModTS = 1493664780, failedLoc = hdfs://localhost:25600/user/trafodion/hive/exttables/unload_customer_demographics
(EXPR)
--------------------
@@ -2082,24 +2081,24 @@ CD_DEMO_SK CD_GENDER
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
+> NEW SNAPSHOT HAVING SUFFIX 'SNAP'
-+>INTO '/user/hive/exttables/unload_customer_demographics'
++>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: 2017-04-06 22:20:54.745
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:20:54.756
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.011
-Task: CREATE SNAPSHO Status: Started Time: 2017-04-06 22:20:54.756
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:53:04.714
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:53:04.726
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.012
+Task: CREATE SNAPSHO Status: Started Time: 2017-05-01 18:53:04.726
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended Time: 2017-04-06 22:20:56.343
-Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:01.587
-Task: EXTRACT Status: Started Time: 2017-04-06 22:20:56.343
+Task: CREATE SNAPSHO Status: Ended Time: 2017-05-01 18:53:06.337
+Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:01.611
+Task: EXTRACT Status: Started Time: 2017-05-01 18:53:06.337
Rows Processed: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:20:57.250
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.907
-Task: DELETE SNAPSHO Status: Started Time: 2017-04-06 22:20:57.250
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:53:07.193
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.856
+Task: DELETE SNAPSHO Status: Started Time: 2017-05-01 18:53:07.193
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended Time: 2017-04-06 22:20:57.256
-Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.006
+Task: DELETE SNAPSHO Status: Ended Time: 2017-05-01 18:53:07.204
+Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.011
--- 20000 row(s) unloaded.
>>
@@ -2115,7 +2114,7 @@ Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.006
*** 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 = 1491517252, failedModTS = 1491517256, failedLoc = hdfs://localhost:30200/user/hive/exttables/unload_customer_demographics
+*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1493664781, failedModTS = 1493664786, failedLoc = hdfs://localhost:25600/user/trafodion/hive/exttables/unload_customer_demographics
CD_DEMO_SK CD_GENDER CD_MARITAL_STATUS CD_EDUCATION_STATUS CD_PURCHASE_ESTIMATE CD_CREDIT_RATING CD_DEP_COUNT CD_DEP_EMPLOYED_COUNT CD_DEP_COLLEGE_COUNT
----------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- -------------------- ---------------------------------------------------------------------------------------------------- ------------ --------------------- --------------------
@@ -2148,24 +2147,24 @@ CD_DEMO_SK CD_GENDER
+>WITH
+> PURGEDATA FROM TARGET
+> NEW SNAPSHOT HAVING SUFFIX 'SNAP'
-+>INTO '/user/hive/exttables/unload_customer_address'
++>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: 2017-04-06 22:20:59.803
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:20:59.808
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:53:10.415
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:53:10.420
Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.005
-Task: CREATE SNAPSHO Status: Started Time: 2017-04-06 22:20:59.808
+Task: CREATE SNAPSHO Status: Started Time: 2017-05-01 18:53:10.420
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended Time: 2017-04-06 22:21:01.106
-Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:01.298
-Task: EXTRACT Status: Started Time: 2017-04-06 22:21:01.106
+Task: CREATE SNAPSHO Status: Ended Time: 2017-05-01 18:53:11.649
+Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:01.228
+Task: EXTRACT Status: Started Time: 2017-05-01 18:53:11.649
Rows Processed: 1998
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:21:01.858
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.751
-Task: DELETE SNAPSHO Status: Started Time: 2017-04-06 22:21:01.858
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:53:12.226
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.577
+Task: DELETE SNAPSHO Status: Started Time: 2017-05-01 18:53:12.226
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended Time: 2017-04-06 22:21:01.861
-Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.004
+Task: DELETE SNAPSHO Status: Ended Time: 2017-05-01 18:53:12.234
+Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.008
--- 1998 row(s) unloaded.
>>
@@ -2236,24 +2235,24 @@ CA_ADDRESS_SK CA_ADDRESS_ID
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
+> NEW SNAPSHOT HAVING SUFFIX 'SNAP'
-+>INTO '/user/hive/exttables/unload_customer_and_address'
++>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: 2017-04-06 22:21:03.814
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:21:03.821
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.008
-Task: CREATE SNAPSHO Status: Started Time: 2017-04-06 22:21:03.821
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:53:14.484
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:53:14.491
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.007
+Task: CREATE SNAPSHO Status: Started Time: 2017-05-01 18:53:14.491
Snapshots created: 2
-Task: CREATE SNAPSHO Status: Ended Time: 2017-04-06 22:21:06.616
-Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:02.795
-Task: EXTRACT Status: Started Time: 2017-04-06 22:21:06.616
+Task: CREATE SNAPSHO Status: Ended Time: 2017-05-01 18:53:17.824
+Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:03.333
+Task: EXTRACT Status: Started Time: 2017-05-01 18:53:17.824
Rows Processed: 100000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:21:10.370
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:03.754
-Task: DELETE SNAPSHO Status: Started Time: 2017-04-06 22:21:10.370
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:53:22.629
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:04.176
+Task: DELETE SNAPSHO Status: Started Time: 2017-05-01 18:53:22.736
Snapshots deleted: 2
-Task: DELETE SNAPSHO Status: Ended Time: 2017-04-06 22:21:10.388
-Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.017
+Task: DELETE SNAPSHO Status: Ended Time: 2017-05-01 18:53:22.197
+Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.019
--- 100000 row(s) unloaded.
>>--sh sleep 10;
@@ -2299,7 +2298,7 @@ C_CUSTOMER_SK C_CUSTOMER_ID
--- SQL operation complete.
>> -- allow the extract syntax
>>explain options 'f'
-+>UNLOAD EXTRACT TO '/bulkload/customer_name'
++>UNLOAD EXTRACT TO '/user/trafodion/bulkload/customer_name'
+>select c_first_name,c_last_name from trafodion.hbase.customer_salt;
LC RC OP OPERATOR OPT DESCRIPTION CARD
@@ -2317,24 +2316,24 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
+> NEW SNAPSHOT HAVING SUFFIX 'SNAP111'
-+>INTO '/user/hive/exttables/unload_customer_name'
++>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: 2017-04-06 22:21:13.583
-Task: EMPTY TARGET Status: Ended Time: 2017-04-06 22:21:13.603
-Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.020
-Task: CREATE SNAPSHO Status: Started Time: 2017-04-06 22:21:13.603
+Task: EMPTY TARGET Status: Started Time: 2017-05-01 18:53:25.364
+Task: EMPTY TARGET Status: Ended Time: 2017-05-01 18:53:25.366
+Task: EMPTY TARGET Status: Ended Elapsed Time: 00:00:00.002
+Task: CREATE SNAPSHO Status: Started Time: 2017-05-01 18:53:25.366
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended Time: 2017-04-06 22:21:14.362
-Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.759
-Task: EXTRACT Status: Started Time: 2017-04-06 22:21:14.362
+Task: CREATE SNAPSHO Status: Ended Time: 2017-05-01 18:53:26.197
+Task: CREATE SNAPSHO Status: Ended Elapsed Time: 00:00:00.653
+Task: EXTRACT Status: Started Time: 2017-05-01 18:53:26.198
Rows Processed: 100000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:21:16.999
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.737
-Task: DELETE SNAPSHO Status: Started Time: 2017-04-06 22:21:16.100
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:53:27.567
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:01.548
+Task: DELETE SNAPSHO Status: Started Time: 2017-05-01 18:53:27.567
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended Time: 2017-04-06 22:21:16.105
-Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.006
+Task: DELETE SNAPSHO Status: Ended Time: 2017-05-01 18:53:27.576
+Task: DELETE SNAPSHO Status: Ended Elapsed Time: 00:00:00.009
--- 100000 row(s) unloaded.
>>--sh sleep 10;
@@ -2378,31 +2377,31 @@ 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: 2017-04-06 22:21:19.554
+Task: EXTRACT Status: Started Time: 2017-05-01 18:53:31.145
*** ERROR[8447] An error occurred during hdfs access. Error Detail: Java exception in hdfsCreate(). java.io.IOException: No FileSystem for scheme: null
-org.apache.hadoop.fs.FileSystem.getFileSystemClass(FileSystem.java:2584)
-org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:2591)
-org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:91)
-org.apache.hadoop.fs.FileSystem$Cache.getInternal(FileSystem.java:2630)
-org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:2612)
-org.apache.hadoop.fs.FileSystem.get(FileSystem.java:370)
+org.apache.hadoop.fs.FileSystem.getFileSystemClass(FileSystem.java:2676)
+org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:2690)
+org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:94)
+org.apache.hadoop.fs.FileSystem$Cache.getInternal(FileSystem.java:2733)
+org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:2715)
+org.apache.hadoop.fs.FileSystem.get(FileSystem.java:382)
org.trafodion.sql.SequenceFileWriter.hdfsCreate(SequenceFileWriter.java:155)
--- 0 row(s) unloaded.
>>
>>--unload 101 --should give syntax error
->>unload with delimiter 0 into '/bulkload/test' select * from CUSTOMER_ADDRESS;
+>>unload with delimiter 0 into '/user/trafodion/bulkload/test' select * from CUSTOMER_ADDRESS;
*** ERROR[15001] A syntax error occurred at or before:
-unload with delimiter 0 into '/bulkload/test' select * from CUSTOMER_ADDRESS;
+unload with delimiter 0 into '/user/trafodion/bulkload/test' select * from CUST
^ (23 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
>>
>>--unload 102 --should give an error
->>unload with MERGE FILE 'folder/cust_addr' into '/bulkload/test' select * from customer_address;
+>>unload with MERGE FILE 'folder/cust_addr' into '/user/trafodion/bulkload/test' select * from customer_address;
*** ERROR[4487] Invalid Path: MERGE FILE 'folder/cust_addr' cannot contain the '/' character.
@@ -2410,16 +2409,16 @@ unload with delimiter 0 into '/bulkload/test' select * from CUSTOMER_ADDRESS;
>>
>>--unload 103 -- should not give an error
->>unload with delimiter '\a' into '/bulkload/test' select * from customer_address;
+>>unload with delimiter '\a' into '/user/trafodion/bulkload/test' select * from customer_address;
Task: UNLOAD Status: Started
-Task: EXTRACT Status: Started Time: 2017-04-06 22:21:20.555
+Task: EXTRACT Status: Started Time: 2017-05-01 18:53:31.774
Rows Processed: 50000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:21:20.962
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.906
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:53:32.634
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.860
--- 50000 row(s) unloaded.
>>--unload 24 -- should give an error
->>unload with delimiter 'abca' into '/bulkload/test' select * from customer_address;
+>>unload with delimiter 'abca' into '/user/trafodion/bulkload/test' select * from customer_address;
*** ERROR[4379] Invalid BULK UNLOAD field delimiter or record separator. A valid field delimiter or record separator must be a single character or an integer between 1 and 255.
@@ -2427,25 +2426,26 @@ Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.906
>>
>>--unload 104 -- should give an error
->>unload with record_separator '\abca' into '/bulkload/test' select * from customer_address;
+>>unload with record_separator '\abca' into '/user/trafodion/bulkload/test' select * from customer_address;
*** ERROR[4374] Invalid escape sequence specified as BULK UNLOAD field delimiter or record separator. Only the following escape sequences are allowed: \a, \b, \f, \n, \r, \t, or \v.
*** ERROR[8822] The statement was not prepared.
>>--unload 105 -- should give an error
->>unload with record_separator '\z' into '/bulkload/test' select * from customer_address;
+>>unload with record_separator '\z' into '/user/trafodion/bulkload/test' select * from customer_address;
*** ERROR[4374] Invalid escape sequence specified as BULK UNLOAD field delimiter or record separator. Only the following escape sequences are allowed: \a, \b, \f, \n, \r, \t, or \v.
*** ERROR[8822] The statement was not prepared.
>>--unload 106 --should give error
->>unload into '/bulkload/test' select * from customer_address order by ca_address_id;
+>>unload into '/user/trafodion/bulkload/test' select * from customer_address order by ca_address_id;
*** ERROR[15001] A syntax error occurred at or before:
-unload into '/bulkload/test' select * from customer_address order by ca_addres
- ^ (66 characters from start of SQL statement)
+unload into '/user/trafodion/bulkload/test' select * from customer_address ord
+er by ca_address_id;
+ ^ (81 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
@@ -2453,11 +2453,12 @@ unload into '/bulkload/test' select * from customer_address order by ca_addres
>>cqd comp_bool_226 'on';
--- SQL operation complete.
->>unload extract to '/bulkload/test' select * from customer_address order by ca_address_id;
+>>unload extract to '/user/trafodion/bulkload/test' select * from customer_address order by ca_address_id;
*** ERROR[15001] A syntax error occurred at or before:
-unload extract to '/bulkload/test' select * from customer_address order by ca_
- ^ (72 characters from start of SQL statement)
+unload extract to '/user/trafodion/bulkload/test' select * from customer_addre
+ss order by ca_address_id;
+ ^ (87 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
@@ -2468,20 +2469,20 @@ unload extract to '/bulkload/test' select * from customer_address order by ca_
>>--unload 150
>>
>>log;
-regrhadoop.ksh fs -rm /user/hive/exttables/unload_customer_demographics/*
+regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/unload_customer_demographics/*
>>
>>CQD TRAF_UNLOAD_SKIP_WRITING_TO_FILES 'ON';
--- SQL operation complete.
>>UNLOAD
+>WITH PURGEDATA FROM TARGET
-+>INTO '/user/hive/exttables/unload_customer_demographics'
++>INTO '/user/trafodion/hive/exttables/unload_customer_demographics'
+>(select * from trafodion.hbase.customer_demographics_salt) ;
Task: UNLOAD Status: Started
-Task: EXTRACT Status: Started Time: 2017-04-06 22:21:24.484
+Task: EXTRACT Status: Started Time: 2017-05-01 18:53:36.154
Rows Processed but NOT Written to Disk: 20000
-Task: EXTRACT Status: Ended Time: 2017-04-06 22:21:24.849
-Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.365
+Task: EXTRACT Status: Ended Time: 2017-05-01 18:53:36.660
+Task: EXTRACT Status: Ended Elapsed Time: 00:00:00.506
--- 20000 row(s) unloaded.
>>--sh sleep 10;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f094aa0d/core/sql/regress/hive/FILTER005
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/FILTER005 b/core/sql/regress/hive/FILTER005
index dc462ef..b128157 100755
--- a/core/sql/regress/hive/FILTER005
+++ b/core/sql/regress/hive/FILTER005
@@ -28,7 +28,7 @@ if [ "$fil" = "" ]; then
fi
sed "
-s/Logging Location: \/bulkload\/logs\/ERR.*/Logging Location:@loggingLocation@/
-s/Logging Location: \/bulkload\/logs\/TEST005\/ERR.*/Logging Location:@TEST005LoggingLocation@/
+s/Logging Location: \/user\/trafodion\/bulkload\/logs\/ERR.*/Logging Location:@loggingLocation@/
+s/Logging Location: \/user\/trafodion\/bulkload\/logs\/TEST005\/ERR.*/Logging Location:@TEST005LoggingLocation@/
s/Time:.*/Time:@time@/
" $fil
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f094aa0d/core/sql/regress/hive/TEST003
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/TEST003 b/core/sql/regress/hive/TEST003
index 78d74a9..a2144f5 100644
--- a/core/sql/regress/hive/TEST003
+++ b/core/sql/regress/hive/TEST003
@@ -23,31 +23,31 @@
-- @@@ END COPYRIGHT @@@
--if dirs exist belo will fail
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_customer;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_promotion;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_customer_address;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_store;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_store_sales;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_customer_demographics;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_date_dim;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_time_dim;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_item;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_household_demographics;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_customerNaddress;
-sh regrhadoop.ksh fs -mkdir /user/hive/exttables/ins_store_sales_summary;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_customer;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_promotion;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_customer_address;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_store;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_store_sales;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_customer_demographics;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_date_dim;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_time_dim;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_item;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_household_demographics;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_customerNaddress;
+sh regrhadoop.ksh fs -mkdir /user/trafodion/hive/exttables/ins_store_sales_summary;
--empty folders
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_customer/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_promotion/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_customer_address/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_store/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_store_sales/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_customer_demographics/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_date_dim/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_time_dim/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_item/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_household_demographics/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_customerNaddress/*;
-sh regrhadoop.ksh fs -rm /user/hive/exttables/ins_store_sales_summary/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_customer/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_promotion/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_customer_address/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_store/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_store_sales/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_customer_demographics/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_date_dim/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_time_dim/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_item/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_household_demographics/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_customerNaddress/*;
+sh regrhadoop.ksh fs -rm /user/trafodion/hive/exttables/ins_store_sales_summary/*;
--- setup tabkles to insert into
@@ -176,9 +176,9 @@ control query shape cut;
select [first 12] 'test lp bug # 1355477' from ins_store_sales_summary;
-- hadoop ls should return 2 files
--- sh regrhadoop.ksh fs -ls /user/hive/exttables/ins_store_sales_summary/* | grep ins_store_sales_summary | wc -l | tee -a LOG003;
+-- sh regrhadoop.ksh fs -ls /user/trafodion/hive/exttables/ins_store_sales_summary/* | grep ins_store_sales_summary | wc -l | tee -a LOG003;
log;
-sh regrhadoop.ksh fs -ls /user/hive/exttables/ins_store_sales_summary/* | grep ins_store_sales_summary | wc -l | tee -a LOG003;
+sh regrhadoop.ksh fs -ls /user/trafodion/hive/exttables/ins_store_sales_summary/* | grep ins_store_sales_summary | wc -l | tee -a LOG003;
log LOG003_orig_store_sales_summary.dat clear;
select ss_sold_date_sk,ss_store_sk, sum (ss_quantity) from store_sales group by ss_sold_date_sk ,ss_store_sk order by ss_sold_date_sk,ss_store_sk;
log;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f094aa0d/core/sql/regress/hive/TEST003_create_hive_tables.hive
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/TEST003_create_hive_tables.hive b/core/sql/regress/hive/TEST003_create_hive_tables.hive
index a7edb76..aa2db88 100644
--- a/core/sql/regress/hive/TEST003_create_hive_tables.hive
+++ b/core/sql/regress/hive/TEST003_create_hive_tables.hive
@@ -42,7 +42,7 @@ create external table ins_customer
c_last_review_date string
)
row format delimited fields terminated by '|' LINES TERMINATED BY '\n'
-location '/user/hive/exttables/ins_customer';
+location '/user/trafodion/hive/exttables/ins_customer';
drop table ins_promotion;
@@ -69,7 +69,7 @@ create external table ins_promotion
p_discount_active string
)
row format delimited fields terminated by '|' LINES TERMINATED BY '\n'
-location '/user/hive/exttables/ins_promotion';
+location '/user/trafodion/hive/exttables/ins_promotion';
drop table ins_customer_address;
create external table ins_customer_address
@@ -89,7 +89,7 @@ create external table ins_customer_address
ca_location_type string
)
row format delimited fields terminated by '|'
-location '/user/hive/exttables/ins_customer_address';
+location '/user/trafodion/hive/exttables/ins_customer_address';
@@ -127,7 +127,7 @@ create external table ins_store
s_tax_precentage float
)
row format delimited fields terminated by '|'
-location '/user/hive/exttables/ins_store';
+location '/user/trafodion/hive/exttables/ins_store';
@@ -159,7 +159,7 @@ create external table ins_store_sales
ss_net_profit float
)
row format delimited fields terminated by '|'
-location '/user/hive/exttables/ins_store_sales';
+location '/user/trafodion/hive/exttables/ins_store_sales';
drop table ins_customer_demographics;
@@ -176,7 +176,7 @@ create external table ins_customer_demographics
cd_dep_college_count int
)
row format delimited fields terminated by '|'
-location '/user/hive/exttables/ins_customer_demographics';
+location '/user/trafodion/hive/exttables/ins_customer_demographics';
drop table ins_date_dim;
create external table ins_date_dim
@@ -211,7 +211,7 @@ create external table ins_date_dim
d_current_year string
)
row format delimited fields terminated by '|'
-location '/user/hive/exttables/ins_date_dim';
+location '/user/trafodion/hive/exttables/ins_date_dim';
drop table ins_time_dim;
create external table ins_time_dim
@@ -228,7 +228,7 @@ create external table ins_time_dim
t_meal_time string
)
row format delimited fields terminated by '|'
-location '/user/hive/exttables/ins_time_dim';
+location '/user/trafodion/hive/exttables/ins_time_dim';
drop table ins_item;
create external table ins_item
@@ -257,7 +257,7 @@ create external table ins_item
i_product_name string
)
row format delimited fields terminated by '|'
-location '/user/hive/exttables/ins_item';
+location '/user/trafodion/hive/exttables/ins_item';
drop table ins_household_demographics;
create external table ins_household_demographics
@@ -269,7 +269,7 @@ create external table ins_household_demographics
hd_vehicle_count int
)
row format delimited fields terminated by '|'
-location '/user/hive/exttables/ins_household_demographics';
+location '/user/trafodion/hive/exttables/ins_household_demographics';
drop table ins_customerNaddress;
create external table ins_customerNaddress
@@ -292,7 +292,7 @@ create external table ins_customerNaddress
)
row format delimited fields terminated by '|'
-location '/user/hive/exttables/ins_customerNaddress';
+location '/user/trafodion/hive/exttables/ins_customerNaddress';
drop table ins_store_sales_summary;
@@ -305,7 +305,7 @@ create external table ins_store_sales_summary
ss_quantity int
)
row format delimited fields terminated by '|'
-location '/user/hive/exttables/ins_store_sales_summary';
+location '/user/trafodion/hive/exttables/ins_store_sales_summary';
quit;