You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by su...@apache.org on 2015/11/03 04:20:31 UTC
[1/2] incubator-trafodion git commit: update expected file for
HIVE/TEST018
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 55d6526ff -> 9ce518c76
update expected file for HIVE/TEST018
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/664218e3
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/664218e3
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/664218e3
Branch: refs/heads/master
Commit: 664218e3696cd13f36f11d3ac297c62866a9e26f
Parents: 1aafdd3
Author: Qifan Chen <qf...@dev02.trafodion.org>
Authored: Sun Nov 1 13:36:58 2015 +0000
Committer: Qifan Chen <qf...@dev02.trafodion.org>
Committed: Sun Nov 1 13:36:58 2015 +0000
----------------------------------------------------------------------
core/sql/regress/hive/EXPECTED018 | 172 +++++++++++++++++----------------
1 file changed, 87 insertions(+), 85 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/664218e3/core/sql/regress/hive/EXPECTED018
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED018 b/core/sql/regress/hive/EXPECTED018
index 65ea210..1279f3c 100644
--- a/core/sql/regress/hive/EXPECTED018
+++ b/core/sql/regress/hive/EXPECTED018
@@ -140,9 +140,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRE
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.CUSTOMER_ADDRESS
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRESS
Rows Processed: 50000
-Task: PREPARATION Status: Ended ET: 00:00:09.002
+Task: PREPARATION Status: Ended ET: 00:00:09.186
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRESS
-Task: COMPLETION Status: Ended ET: 00:00:00.276
+Task: COMPLETION Status: Ended ET: 00:00:00.247
--- 50000 row(s) loaded.
>>--
@@ -171,9 +171,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOG
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS
Rows Processed: 20000
-Task: PREPARATION Status: Ended ET: 00:00:14.699
+Task: PREPARATION Status: Ended ET: 00:00:14.900
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS
-Task: COMPLETION Status: Ended ET: 00:00:00.331
+Task: COMPLETION Status: Ended ET: 00:00:00.277
--- 20000 row(s) loaded.
>>--
@@ -203,9 +203,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOG
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT
Rows Processed: 20000
-Task: PREPARATION Status: Ended ET: 00:00:09.416
+Task: PREPARATION Status: Ended ET: 00:00:07.686
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT
-Task: COMPLETION Status: Ended ET: 00:00:00.288
+Task: COMPLETION Status: Ended ET: 00:00:00.271
--- 20000 row(s) loaded.
>>--
@@ -225,9 +225,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.CUSTOMER_SALT
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.CUSTOMER_SALT
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_SALT
Rows Processed: 100000
-Task: PREPARATION Status: Ended ET: 00:00:12.736
+Task: PREPARATION Status: Ended ET: 00:00:11.309
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_SALT
-Task: COMPLETION Status: Ended ET: 00:00:00.309
+Task: COMPLETION Status: Ended ET: 00:00:00.281
--- 100000 row(s) loaded.
>>--
@@ -256,9 +256,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.STORE_SALES_SA
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.STORE_SALES_SALT
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.STORE_SALES_SALT
Rows Processed: 160756
-Task: PREPARATION Status: Ended ET: 00:00:23.570
+Task: PREPARATION Status: Ended ET: 00:00:13.015
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.STORE_SALES_SALT
-Task: COMPLETION Status: Ended ET: 00:00:00.264
+Task: COMPLETION Status: Ended ET: 00:00:00.289
--- 160756 row(s) loaded.
>>--
@@ -304,10 +304,10 @@ aaa5 ?
+> select * from nulls;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.042
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.008
Task: EXTRACT Status: Started
Rows Processed: 6
-Task: EXTRACT Status: Ended ET: 00:00:00.692
+Task: EXTRACT Status: Ended ET: 00:00:00.259
--- 6 row(s) unloaded.
>>select * from hive.hive.nulls order by a,b;
@@ -349,12 +349,12 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.002
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
Task: EXTRACT Status: Started
Rows Processed: 50000
-Task: EXTRACT Status: Ended ET: 00:00:03.020
+Task: EXTRACT Status: Ended ET: 00:00:03.068
Task: MERGE FILES Status: Started
-Task: MERGE FILES Status: Ended ET: 00:00:00.082
+Task: MERGE FILES Status: Ended ET: 00:00:00.037
--- 50000 row(s) unloaded.
>>log;
@@ -387,12 +387,12 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.002
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.011
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.018
+Task: EXTRACT Status: Ended ET: 00:00:00.931
Task: MERGE FILES Status: Started
-Task: MERGE FILES Status: Ended ET: 00:00:00.436
+Task: MERGE FILES Status: Ended ET: 00:00:00.025
--- 20000 row(s) unloaded.
>>log;
@@ -414,9 +414,9 @@ Task: EMPTY TARGET Status: Started
Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:00.909
+Task: EXTRACT Status: Ended ET: 00:00:00.967
Task: MERGE FILES Status: Started
-Task: MERGE FILES Status: Ended ET: 00:00:00.025
+Task: MERGE FILES Status: Ended ET: 00:00:00.072
--- 20000 row(s) unloaded.
>>log;
@@ -448,12 +448,12 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.002
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.008
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.537
+Task: EXTRACT Status: Ended ET: 00:00:01.354
Task: MERGE FILES Status: Started
-Task: MERGE FILES Status: Ended ET: 00:00:00.045
+Task: MERGE FILES Status: Ended ET: 00:00:00.050
--- 20000 row(s) unloaded.
>>
@@ -471,12 +471,12 @@ regrhadoop.ksh fs -du -s /bulkload/customer_demographics_salt/merged_customer_de
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.005
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.007
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.076
+Task: EXTRACT Status: Ended ET: 00:00:01.301
Task: MERGE FILES Status: Started
-Task: MERGE FILES Status: Ended ET: 00:00:00.048
+Task: MERGE FILES Status: Ended ET: 00:00:00.049
--- 20000 row(s) unloaded.
>>
@@ -509,10 +509,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.009
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.563
+Task: EXTRACT Status: Ended ET: 00:00:01.076
--- 20000 row(s) unloaded.
>>
@@ -532,12 +532,12 @@ regrhadoop.ksh fs -ls /bulkload/customer_demographics_salt/file* | grep file |
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.009
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.011
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.368
+Task: EXTRACT Status: Ended ET: 00:00:00.906
Task: MERGE FILES Status: Started
-Task: MERGE FILES Status: Ended ET: 00:00:00.040
+Task: MERGE FILES Status: Ended ET: 00:00:00.041
--- 20000 row(s) unloaded.
>>
@@ -670,12 +670,12 @@ CD_DEMO_SK CD_GENDER
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.009
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.352
+Task: EXTRACT Status: Ended ET: 00:00:01.150
Task: MERGE FILES Status: Started
-Task: MERGE FILES Status: Ended ET: 00:00:00.036
+Task: MERGE FILES Status: Ended ET: 00:00:00.046
--- 20000 row(s) unloaded.
>>log;
@@ -713,9 +713,9 @@ Task: EMPTY TARGET Status: Started
Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.356
+Task: EXTRACT Status: Ended ET: 00:00:01.176
Task: MERGE FILES Status: Started
-Task: MERGE FILES Status: Ended ET: 00:00:00.045
+Task: MERGE FILES Status: Ended ET: 00:00:00.054
--- 20000 row(s) unloaded.
>>
@@ -765,10 +765,10 @@ CD_DEMO_SK CD_GENDER
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.007
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.288
+Task: EXTRACT Status: Ended ET: 00:00:01.320
--- 20000 row(s) unloaded.
>>
@@ -815,10 +815,10 @@ CD_DEMO_SK CD_GENDER
+>select * from trafodion.hbase.customer_address ;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.002
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
Task: EXTRACT Status: Started
Rows Processed: 50000
-Task: EXTRACT Status: Ended ET: 00:00:02.101
+Task: EXTRACT Status: Ended ET: 00:00:02.420
--- 50000 row(s) unloaded.
>>
@@ -868,10 +868,10 @@ CA_ADDRESS_SK CA_ADDRESS_ID
+>select * from trafodion.hbase.customer_address ;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.007
Task: EXTRACT Status: Started
Rows Processed: 50000
-Task: EXTRACT Status: Ended ET: 00:00:02.239
+Task: EXTRACT Status: Ended ET: 00:00:02.294
--- 50000 row(s) unloaded.
>>
@@ -930,10 +930,10 @@ CA_ADDRESS_SK CA_ADDRESS_ID
+>select * from trafodion.hbase.customer_salt;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.004
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.005
Task: EXTRACT Status: Started
Rows Processed: 100000
-Task: EXTRACT Status: Ended ET: 00:00:06.196
+Task: EXTRACT Status: Ended ET: 00:00:06.344
--- 100000 row(s) unloaded.
>>select count(*) from hive.hive.unload_customer;
@@ -983,10 +983,10 @@ C_CUSTOMER_SK C_CUSTOMER_ID
+>select * from trafodion.hbase.customer_demographics_salt;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.009
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.011
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:00.915
+Task: EXTRACT Status: Ended ET: 00:00:00.864
--- 20000 row(s) unloaded.
>>
@@ -1036,12 +1036,12 @@ CD_DEMO_SK CD_GENDER
+>select * from trafodion.hbase.customer_address where ca_address_sk < 100;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.005
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
Task: EXTRACT Status: Started
Rows Processed: 99
-Task: EXTRACT Status: Ended ET: 00:00:00.233
+Task: EXTRACT Status: Ended ET: 00:00:00.211
Task: MERGE FILES Status: Started
-Task: MERGE FILES Status: Ended ET: 00:00:00.025
+Task: MERGE FILES Status: Ended ET: 00:00:00.024
--- 99 row(s) unloaded.
>>
@@ -1077,10 +1077,10 @@ regrhadoop.ksh fs -rm /user/hive/exttables/unload_customer_demographics/*
+>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
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.004
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
Task: EXTRACT Status: Started
Rows Processed: 12349
-Task: EXTRACT Status: Ended ET: 00:00:06.595
+Task: EXTRACT Status: Ended ET: 00:00:06.234
--- 12349 row(s) unloaded.
>>
@@ -1199,10 +1199,10 @@ SS_SOLD_DATE_SK SS_STORE_SK SS_QUANTITY
+>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
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.002
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.005
Task: EXTRACT Status: Started
Rows Processed: 100000
-Task: EXTRACT Status: Ended ET: 00:00:08.539
+Task: EXTRACT Status: Ended ET: 00:00:07.489
--- 100000 row(s) unloaded.
>>
@@ -1250,10 +1250,10 @@ C_CUSTOMER_SK C_CUSTOMER_ID
+>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
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.007
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.012
Task: EXTRACT Status: Started
Rows Processed: 1998
-Task: EXTRACT Status: Ended ET: 00:00:01.029
+Task: EXTRACT Status: Ended ET: 00:00:00.794
--- 1998 row(s) unloaded.
>>
@@ -1364,7 +1364,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/20151029081911/
+ snapshot_temp_location /bulkload/20151101132150/
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;
@@ -1444,7 +1444,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/20151029082021/
+ snapshot_temp_location /bulkload/20151101132159/
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;
@@ -1526,11 +1526,11 @@ 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_SALT
snapshot_name .......... TRAFODION.HBASE.CUSTOMER_SALT_SNAP111
- snapshot_temp_location /bulkload/20151029082045/
+ snapshot_temp_location /bulkload/20151101132221/
use_snapshot_scan ...... TRUE
full_table_name ........ TRAFODION.HBASE.CUSTOMER_ADDRESS
snapshot_name .......... TRAFODION.HBASE.CUSTOMER_ADDRESS_SNAP111
- snapshot_temp_location /bulkload/20151029082045/
+ snapshot_temp_location /bulkload/20151101132221/
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;
@@ -1636,13 +1636,13 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+><<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.005
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
Task: VERIFY SNAPSHO Status: Started
Snapshots verified: 1
-Task: VERIFY SNAPSHO Status: Ended ET: 00:00:00.331
+Task: VERIFY SNAPSHO Status: Ended ET: 00:00:00.346
Task: EXTRACT Status: Started
Rows Processed: 50000
-Task: EXTRACT Status: Ended ET: 00:00:03.160
+Task: EXTRACT Status: Ended ET: 00:00:03.382
--- 50000 row(s) unloaded.
>>
@@ -1656,6 +1656,8 @@ Task: EXTRACT Status: Ended ET: 00:00:03.160
--- 1 row(s) selected.
>>select [first 20] * from hive.hive.unload_customer_address where ca_address_sk < 100 order by ca_address_sk;
+*** WARNING[6008] Statistics for column (CA_ADDRESS_SK) from table HIVE.HIVE.UNLOAD_CUSTOMER_ADDRESS were not available. As a result, the access path chosen might not be the best possible.
+
CA_ADDRESS_SK CA_ADDRESS_ID CA_STREET_NUMBER CA_STREET_NAME CA_STREET_TYPE CA_SUITE_NUMBER CA_CITY CA_COUNTY CA_STATE CA_ZIP CA_COUNTRY
CA_GMT_OFFSET CA_LOCATION_TYPE
------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
------------------------------------ --------------- ----------------------------------------------------------------------------------------------------
@@ -1705,13 +1707,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
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.002
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.003
Task: VERIFY SNAPSHO Status: Started
Snapshots verified: 1
-Task: VERIFY SNAPSHO Status: Ended ET: 00:00:00.323
+Task: VERIFY SNAPSHO Status: Ended ET: 00:00:00.316
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:02.389
+Task: EXTRACT Status: Ended ET: 00:00:02.630
--- 20000 row(s) unloaded.
>>
@@ -1759,16 +1761,16 @@ CD_DEMO_SK CD_GENDER
+>select * from trafodion.hbase.customer_demographics_salt <<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.007
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.008
Task: CREATE SNAPSHO Status: Started
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended ET: 00:00:00.671
+Task: CREATE SNAPSHO Status: Ended ET: 00:00:00.919
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.856
+Task: EXTRACT Status: Ended ET: 00:00:01.959
Task: DELETE SNAPSHO Status: Started
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended ET: 00:00:00.016
+Task: DELETE SNAPSHO Status: Ended ET: 00:00:00.012
--- 20000 row(s) unloaded.
>>
@@ -1816,16 +1818,16 @@ CD_DEMO_SK CD_GENDER
+>select * from trafodion.hbase.customer_demographics_salt <<+ cardinality 10e10 >>;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.011
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.008
Task: CREATE SNAPSHO Status: Started
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended ET: 00:00:01.767
+Task: CREATE SNAPSHO Status: Ended ET: 00:00:00.620
Task: EXTRACT Status: Started
Rows Processed: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.408
+Task: EXTRACT Status: Ended ET: 00:00:01.852
Task: DELETE SNAPSHO Status: Started
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended ET: 00:00:00.006
+Task: DELETE SNAPSHO Status: Ended ET: 00:00:00.005
--- 20000 row(s) unloaded.
>>
@@ -1874,13 +1876,13 @@ CD_DEMO_SK CD_GENDER
+>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
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.004
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
Task: CREATE SNAPSHO Status: Started
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended ET: 00:00:00.581
+Task: CREATE SNAPSHO Status: Ended ET: 00:00:01.010
Task: EXTRACT Status: Started
Rows Processed: 1998
-Task: EXTRACT Status: Ended ET: 00:00:01.470
+Task: EXTRACT Status: Ended ET: 00:00:00.742
Task: DELETE SNAPSHO Status: Started
Snapshots deleted: 1
Task: DELETE SNAPSHO Status: Ended ET: 00:00:00.005
@@ -1958,13 +1960,13 @@ CA_ADDRESS_SK CA_ADDRESS_ID
+>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
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.005
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.006
Task: CREATE SNAPSHO Status: Started
Snapshots created: 2
-Task: CREATE SNAPSHO Status: Ended ET: 00:00:02.995
+Task: CREATE SNAPSHO Status: Ended ET: 00:00:02.525
Task: EXTRACT Status: Started
Rows Processed: 100000
-Task: EXTRACT Status: Ended ET: 00:00:10.049
+Task: EXTRACT Status: Ended ET: 00:00:10.505
Task: DELETE SNAPSHO Status: Started
Snapshots deleted: 2
Task: DELETE SNAPSHO Status: Ended ET: 00:00:00.009
@@ -2028,16 +2030,16 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
+>select c_first_name,c_last_name from trafodion.hbase.customer_salt;
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
-Task: EMPTY TARGET Status: Ended ET: 00:00:00.008
+Task: EMPTY TARGET Status: Ended ET: 00:00:00.010
Task: CREATE SNAPSHO Status: Started
Snapshots created: 1
-Task: CREATE SNAPSHO Status: Ended ET: 00:00:00.637
+Task: CREATE SNAPSHO Status: Ended ET: 00:00:00.375
Task: EXTRACT Status: Started
Rows Processed: 100000
-Task: EXTRACT Status: Ended ET: 00:00:03.948
+Task: EXTRACT Status: Ended ET: 00:00:03.885
Task: DELETE SNAPSHO Status: Started
Snapshots deleted: 1
-Task: DELETE SNAPSHO Status: Ended ET: 00:00:00.007
+Task: DELETE SNAPSHO Status: Ended ET: 00:00:00.005
--- 100000 row(s) unloaded.
>>
@@ -2110,7 +2112,7 @@ unload with delimiter 0 into '/bulkload/test' select * from CUSTOMER_ADDRESS;
Task: UNLOAD Status: Started
Task: EXTRACT Status: Started
Rows Processed: 50000
-Task: EXTRACT Status: Ended ET: 00:00:02.385
+Task: EXTRACT Status: Ended ET: 00:00:02.002
--- 50000 row(s) unloaded.
>>--unload 24 -- should give an error
@@ -2175,7 +2177,7 @@ regrhadoop.ksh fs -rm /user/hive/exttables/unload_customer_demographics/*
Task: UNLOAD Status: Started
Task: EXTRACT Status: Started
Rows Processed but NOT Written to Disk: 20000
-Task: EXTRACT Status: Ended ET: 00:00:01.063
+Task: EXTRACT Status: Ended ET: 00:00:00.722
--- 20000 row(s) unloaded.
>>select count(*) from hive.hive.unload_customer_demographics;
[2/2] incubator-trafodion git commit: Merge remote branch
'origin/pr/155/head' into mrg_76
Posted by su...@apache.org.
Merge remote branch 'origin/pr/155/head' into mrg_76
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/9ce518c7
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/9ce518c7
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/9ce518c7
Branch: refs/heads/master
Commit: 9ce518c76bc56af1be5dff7075a6e22d16a20185
Parents: 55d6526 664218e
Author: Suresh Subbiah <su...@apache.org>
Authored: Tue Nov 3 03:20:09 2015 +0000
Committer: Suresh Subbiah <su...@apache.org>
Committed: Tue Nov 3 03:20:09 2015 +0000
----------------------------------------------------------------------
core/sql/regress/hive/EXPECTED018 | 172 +++++++++++++++++----------------
1 file changed, 87 insertions(+), 85 deletions(-)
----------------------------------------------------------------------