You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by an...@apache.org on 2016/05/28 01:12:58 UTC
[3/9] incubator-trafodion git commit: JIRA TRAFODION-2013 Hive null
values are now handled correctly.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1a549e0e/core/sql/regress/hive/EXPECTED005
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED005 b/core/sql/regress/hive/EXPECTED005
index eff0c42..28d4f37 100644
--- a/core/sql/regress/hive/EXPECTED005
+++ b/core/sql/regress/hive/EXPECTED005
@@ -75,9 +75,9 @@
C_PREFERRED_CUST_FLAG (EXPR)
------------------------- --------------------
+ 685
N 9789
Y 9525
-? 685
--- 3 row(s) selected.
>>
@@ -113,9 +113,9 @@ Y 9525
C_PREFERRED_CUST_FLAG (EXPR)
------------------------- --------------------
+ 685
N 9789
Y 9525
-? 685
--- 3 row(s) selected.
>>-- should get an NATable cache
@@ -221,9 +221,9 @@ xyz
C_PREFERRED_CUST_FLAG (EXPR)
------------------------- --------------------
+ 685
N 9789
Y 9525
-? 685
--- 3 row(s) selected.
>>execute s3;
@@ -307,9 +307,9 @@ A B
C_PREFERRED_CUST_FLAG (EXPR)
------------------------- --------------------
+ 685
N 9789
Y 9525
-? 685
--- 3 row(s) selected.
>>execute s4;
@@ -317,9 +317,9 @@ Y 9525
C_PREFERRED_CUST_FLAG (EXPR)
------------------------- --------------------
+ 1384
N 19631
Y 18984
-? 1384
--- 3 row(s) selected.
>>execute s2part;
@@ -453,21 +453,21 @@ TINT SM I BIG STR F
--- SQL operation complete.
>>select c1, CONVERTTOHEX(c2) from tbl_gbk;
-C1 (EXPR)
+C1 (EXPR)
----------- --------------------------------------------------
- 3 EC8B90EC978E
- 5 EC8B90EC978E
- 2 EC8B90EC978E
- 4 EC8B90EC978E
- 6 EC8B90EC978E
- 7 EC8B90EC978E
- 8 EC8B90EC978E
- 3 ECBB93EB9F8FECAB97EB9B91
- 2 ECBB93EB9F8FECAB97EB9B91
- 6 ECBB93EB9F8FECAB97EB9B91
- 19 ECBB93EB9F8FECAB97EB9B91
- 8 ECBB93EB9F8FECAB97EB9B91
+ 3 EC8B90EC978E
+ 5 EC8B90EC978E
+ 2 EC8B90EC978E
+ 4 EC8B90EC978E
+ 6 EC8B90EC978E
+ 7 EC8B90EC978E
+ 8 EC8B90EC978E
+ 3 ECBB93EB9F8FECAB97EB9B91
+ 2 ECBB93EB9F8FECAB97EB9B91
+ 6 ECBB93EB9F8FECAB97EB9B91
+ 19 ECBB93EB9F8FECAB97EB9B91
+ 8 ECBB93EB9F8FECAB97EB9B91
--- 12 row(s) selected.
>>cqd HIVE_FILE_CHARSET reset;
@@ -516,7 +516,7 @@ C1 C2 C3 C4
--- 10 row(s) loaded.
>>select * from trafodion.seabase.tbl_dos_num;
-C1 C2
+C1 C2
----------- -----------
0 39478
@@ -544,16 +544,16 @@ C1 C2
--- SQL operation complete.
>>select * from tbl_bad;
-C1 C2 C3 C4 C5 C6 C7 C8
------------ -------------------- ------------------------- --------------- ------ -------------------------- ------------------------- ------
+C1 C2 C3 C4 C5 C6 C7 C8
+----------- -------------------- ------------------------- --------------- ------ -------------------------- ------------------------- ------
- ? ? c ? ? ? ? ?
- ? ? c ? ? 2017-01-01 10:10:10.000000 1.01000000000000000E+000 1
- ? ? ? ? ? ? ?
- 1 1 averylongstring -1.0000000E+000 0 2017-01-01 10:10:10.000000 1.00010000000000000E+002 1
- 2 2 good 1.1000000E+000 2 2017-01-01 10:10:10.000000 2.00000000000000000E+002 1000
- 3 3 good 1.0000000E+000 2 2017-01-01 10:10:10.000000 2.10000000000000000E+002 10
- ? 4294967295 good 3.3999999E+038 ? 2017-01-01 10:10:10.000000 1.69999999999999968E+308 10
+ ? ? c ? ? ? ? ?
+ ? ? c ? ? 2017-01-01 10:10:10.000000 1.01000000000000000E+000 1
+ ? ? ? ? ? ? ?
+ 1 1 averylongstring -1.0000000E+000 0 2017-01-01 10:10:10.000000 1.00010000000000000E+002 1
+ 2 2 good 1.1000000E+000 2 2017-01-01 10:10:10.000000 2.00000000000000000E+002 1000
+ 3 3 good 1.0000000E+000 2 2017-01-01 10:10:10.000000 2.10000000000000000E+002 10
+ ? 4294967295 good 3.3999999E+038 ? 2017-01-01 10:10:10.000000 1.69999999999999968E+308 10
0 9999999999 bad ? ? ? ? ?
--- 8 row(s) selected.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1a549e0e/core/sql/regress/hive/EXPECTED006
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED006 b/core/sql/regress/hive/EXPECTED006
index 15539d2..645cca9 100644
--- a/core/sql/regress/hive/EXPECTED006
+++ b/core/sql/regress/hive/EXPECTED006
@@ -55,11 +55,11 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_S
8 AAAAAAAAIAAAAAAA 2450350 2450409 304 1.0000000E+003 1 eing Y N N N N N N N Offences feel only on a f Unknown N
9 AAAAAAAAJAAAAAAA 2450192 2450248 3439 1.0000000E+003 1 n st Y N N N N N N N External forces shall com Unknown N
10 AAAAAAAAKAAAAAAA 2450324 2450365 3314 1.0000000E+003 1 bar N N N N N N N N Only local achievements u Unknown N
- 11 AAAAAAAALAAAAAAA ? ? ? 1.0000000E+003 ? ought ? ? ? ? N ? N N Teachers shall not make u Unknown N
+ 11 AAAAAAAALAAAAAAA ? ? ? 1.0000000E+003 ? ought N N N Teachers shall not make u Unknown N
12 AAAAAAAAMAAAAAAA 2450153 2450169 6688 1.0000000E+003 1 able N N N N N N N N Also only times would com Unknown N
13 AAAAAAAANAAAAAAA 2450316 2450365 11354 1.0000000E+003 1 pri N N N N N N N N Years shall not go later Unknown N
14 AAAAAAAAOAAAAAAA 2450236 2450282 14480 1.0000000E+003 1 ese N N N N N N N N Adults would not delay ra Unknown N
- 15 AAAAAAAAPAAAAAAA ? ? ? 1.0000000E+003 ? anti Y ? N N ? N N N Old elements would shake Unknown N
+ 15 AAAAAAAAPAAAAAAA ? ? ? 1.0000000E+003 ? anti Y N N N N N Old elements would shake Unknown N
16 AAAAAAAAABAAAAAA 2450342 2450351 11899 1.0000000E+003 1 cally Y N N N N N N N Sudden, wooden theories w Unknown N
17 AAAAAAAABBAAAAAA 2450360 2450406 15529 1.0000000E+003 1 ation Y N N N N N N N Almost old churches ought Unknown N
18 AAAAAAAACBAAAAAA 2450581 2450592 8599 1.0000000E+003 1 eing Y N N N N N N N National communities use Unknown N
@@ -72,7 +72,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_S
25 AAAAAAAAJBAAAAAA 2450757 2450780 16328 1.0000000E+003 1 anti Y N N N N N N N Scenes might make high Unknown N
26 AAAAAAAAKBAAAAAA 2450528 2450545 8600 1.0000000E+003 1 cally N N N N N N N N Legal discussions must no Unknown N
27 AAAAAAAALBAAAAAA 2450849 2450879 15421 1.0000000E+003 1 ation Y N N N N N N N Mental men go british fri Unknown N
- 28 AAAAAAAAMBAAAAAA 2450816 2450856 1885 ? 1 ? N N N N N ? N N Successful opportunities Unknown ?
+ 28 AAAAAAAAMBAAAAAA 2450816 2450856 1885 ? 1 N N N N N N N Successful opportunities Unknown
29 AAAAAAAANBAAAAAA 2450696 2450732 14660 1.0000000E+003 1 n st Y N N N N N N N Residential, necessary Unknown N
30 AAAAAAAAOBAAAAAA 2450718 2450762 10987 1.0000000E+003 1 bar N N N N N N N N Flowers used to stop ther Unknown N
31 AAAAAAAAPBAAAAAA 2450848 2450880 11990 1.0000000E+003 1 ought Y N N N N N N N Broad times might satisfy Unknown N
@@ -102,7 +102,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_S
55 AAAAAAAAHDAAAAAA 2450622 2450677 12104 1.0000000E+003 1 anti N N N N N N N N Recent, southern lists go Unknown N
56 AAAAAAAAIDAAAAAA 2450838 2450888 17563 1.0000000E+003 1 cally Y N N N N N N N Procedures can call healt Unknown N
57 AAAAAAAAJDAAAAAA 2450834 2450842 12247 1.0000000E+003 1 ation Y N N N N N N N Hours discriminate tracks Unknown N
- 58 AAAAAAAAKDAAAAAA ? 2450797 12404 1.0000000E+003 ? eing Y N N N ? N ? ? ? ? ?
+ 58 AAAAAAAAKDAAAAAA ? 2450797 12404 1.0000000E+003 ? eing Y N N N N
59 AAAAAAAALDAAAAAA 2450273 2450322 5102 1.0000000E+003 1 n st N N N N N N N N Strong samples participat Unknown N
60 AAAAAAAAMDAAAAAA 2450646 2450676 12076 1.0000000E+003 1 bar Y N N N N N N N Yards write too only shap Unknown N
61 AAAAAAAANDAAAAAA 2450619 2450667 14864 1.0000000E+003 1 ought Y N N N N N N N Necessary men shall make Unknown N
@@ -115,7 +115,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_S
68 AAAAAAAAEEAAAAAA 2450851 2450893 1210 1.0000000E+003 1 eing Y N N N N N N N Reasonably additional sho Unknown N
69 AAAAAAAAFEAAAAAA 2450202 2450219 7471 1.0000000E+003 1 n st N N N N N N N N All right able intere Unknown N
70 AAAAAAAAGEAAAAAA 2450679 2450735 3571 1.0000000E+003 1 bar Y N N N N N N N Commercial, cool cells st Unknown N
- 71 AAAAAAAAHEAAAAAA 2450347 ? ? ? ? ? Y ? N ? N N N N Impossible programmes say ? ?
+ 71 AAAAAAAAHEAAAAAA 2450347 ? ? ? ? Y N N N N N Impossible programmes say
72 AAAAAAAAIEAAAAAA 2450347 2450373 6662 1.0000000E+003 1 able N N N N N N N N Beautiful, british trees Unknown N
73 AAAAAAAAJEAAAAAA 2450578 2450637 9032 1.0000000E+003 1 pri Y N N N N N N N Tremendous, social towns Unknown N
74 AAAAAAAAKEAAAAAA 2450425 2450456 13904 1.0000000E+003 1 ese N N N N N N N N Decent bodies grant overs Unknown N
@@ -145,7 +145,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_S
98 AAAAAAAACGAAAAAA 2450384 2450387 10414 1.0000000E+003 1 eing Y N N N N N N N Periods shall not need as Unknown N
99 AAAAAAAADGAAAAAA 2450742 2450799 7544 1.0000000E+003 1 n st Y N N N N N N N White, easy shoulders mig Unknown N
100 AAAAAAAAEGAAAAAA 2450508 2450562 10645 1.0000000E+003 1 bar N N N N N N N N Villages go more. Ministe Unknown N
- 101 AAAAAAAAFGAAAAAA ? 2450811 ? ? ? ? ? N N ? ? ? N N Reports would make at a w Unknown N
+ 101 AAAAAAAAFGAAAAAA ? 2450811 ? ? ? N N N N Reports would make at a w Unknown N
102 AAAAAAAAGGAAAAAA 2450608 2450614 9614 1.0000000E+003 1 able Y N N N N N N N Medieval fires may read; Unknown N
103 AAAAAAAAHGAAAAAA 2450499 2450525 12688 1.0000000E+003 1 pri N N N N N N N N Still ready eyes will cre Unknown N
104 AAAAAAAAIGAAAAAA 2450276 2450293 2461 1.0000000E+003 1 ese N N N N N N N N Years will sum always sma Unknown N
@@ -240,8 +240,8 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_S
193 AAAAAAAABMAAAAAA 2450259 2450309 8780 1.0000000E+003 1 pri Y N N N N N N N Terms should not know. Co Unknown N
194 AAAAAAAACMAAAAAA 2450664 2450723 289 1.0000000E+003 1 ese Y N N N N N N N Cultural deaths could dev Unknown N
195 AAAAAAAADMAAAAAA 2450543 2450601 5167 1.0000000E+003 1 anti N N N N N N N N Conventions make immediat Unknown N
- 196 AAAAAAAAEMAAAAAA 2450315 ? ? ? 1 ? Y ? ? N N ? ? N Able patients will lend a ? ?
- 197 AAAAAAAAFMAAAAAA 2450299 ? 10550 ? 1 ? ? N N N N ? ? ? ? Unknown ?
+ 196 AAAAAAAAEMAAAAAA 2450315 ? ? ? 1 Y N N N Able patients will lend a
+ 197 AAAAAAAAFMAAAAAA 2450299 ? 10550 ? 1 N N N N Unknown
198 AAAAAAAAGMAAAAAA 2450617 2450670 15439 1.0000000E+003 1 eing Y N N N N N N N German, crude expectation Unknown N
199 AAAAAAAAHMAAAAAA 2450772 2450825 8587 1.0000000E+003 1 n st N N N N N N N N Powerful, considerable pr Unknown N
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1a549e0e/core/sql/regress/hive/EXPECTED015
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED015 b/core/sql/regress/hive/EXPECTED015
index 09d9639..f1d6067 100644
--- a/core/sql/regress/hive/EXPECTED015
+++ b/core/sql/regress/hive/EXPECTED015
@@ -209,9 +209,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.T015T2
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.T015T2
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.T015T2
Rows Processed: 5
-Task: PREPARATION Status: Ended ET: 00:00:00.159
+Task: PREPARATION Status: Ended ET: 00:00:00.184
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.T015T2
-Task: COMPLETION Status: Ended ET: 00:00:00.530
+Task: COMPLETION Status: Ended ET: 00:00:00.359
--- 5 row(s) loaded.
>>
@@ -233,9 +233,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.T015T2
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.T015T2
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.T015T2
Rows Processed: 5
-Task: PREPARATION Status: Ended ET: 00:00:00.171
+Task: PREPARATION Status: Ended ET: 00:00:00.176
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.T015T2
-Task: COMPLETION Status: Ended ET: 00:00:00.155
+Task: COMPLETION Status: Ended ET: 00:00:00.203
--- 5 row(s) loaded.
>>
@@ -258,9 +258,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.T015T2
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.T015T2
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.T015T2
Rows Processed: 5
-Task: PREPARATION Status: Ended ET: 00:00:00.068
+Task: PREPARATION Status: Ended ET: 00:00:00.195
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.T015T2
-Task: COMPLETION Status: Ended ET: 00:00:00.826
+Task: COMPLETION Status: Ended ET: 00:00:00.318
--- 5 row(s) loaded.
>>
@@ -288,9 +288,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.T015T2
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.T015T2
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.T015T2
Rows Processed: 5
-Task: PREPARATION Status: Ended ET: 00:00:00.177
+Task: PREPARATION Status: Ended ET: 00:00:00.179
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.T015T2
-Task: COMPLETION Status: Ended ET: 00:00:00.298
+Task: COMPLETION Status: Ended ET: 00:00:00.380
--- 5 row(s) loaded.
>>
@@ -461,9 +461,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: 5000
-Task: PREPARATION Status: Ended ET: 00:00:07.610
+Task: PREPARATION Status: Ended ET: 00:00:08.673
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRESS
-Task: COMPLETION Status: Ended ET: 00:00:00.603
+Task: COMPLETION Status: Ended ET: 00:00:00.402
--- 5000 row(s) loaded.
>>
@@ -487,14 +487,14 @@ CA_ADDRESS_SK CA_ADDRESS_ID CA_STREET_NUMBER CA_STREET_NAME
4 AAAAAAAAEAAAAAAA 111 Smith Wy Suite A Oak Ridge Kit Carson County CO 88371 United States -7.00 condo
5 AAAAAAAAFAAAAAAA 31 College Blvd Suite 180 Glendale Barry County MO 63951 United States -6.00 single family
6 AAAAAAAAGAAAAAAA 59 Williams Sixth Parkway Suite 100 Lakeview Chelan County WA 98579 United States -8.00 single family
- 7 AAAAAAAAHAAAAAAA ? Hill 7th Road Suite U Farmington ? ? 39145 United States ? ?
+ 7 AAAAAAAAHAAAAAAA Hill 7th Road Suite U Farmington 39145 United States ?
8 AAAAAAAAIAAAAAAA 875 Lincoln Ct. Suite Y Union Bledsoe County TN 38721 United States -5.00 apartment
9 AAAAAAAAJAAAAAAA 819 1st Laurel Ave Suite 70 New Hope Perry County AL 39431 United States -6.00 condo
10 AAAAAAAAKAAAAAAA 851 Woodland Poplar ST Suite Y Martinsville Haines Borough AK 90419 United States -9.00 condo
11 AAAAAAAALAAAAAAA 189 13th 2nd Street Suite 470 Maple Grove Madison County MT 68252 United States -7.00 single family
12 AAAAAAAAMAAAAAAA 76 Ash 8th Ct. Suite O Edgewood Mifflin County PA 10069 United States -5.00 apartment
13 AAAAAAAANAAAAAAA 424 Main Second Ln Suite 130 Greenville Noxubee County MS 51387 United States -6.00 single family
- 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 ? Lipscomb County TX 77752 ? -6.00 ?
+ 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 Lipscomb County TX 77752 -6.00
15 AAAAAAAAPAAAAAAA 314 Spring Ct. Suite B Oakland Washington County OH 49843 United States -5.00 apartment
16 AAAAAAAAABAAAAAA 576 Adams Center Street Suite J Valley View Oldham County TX 75124 United States -6.00 condo
17 AAAAAAAABBAAAAAA 801 Green Dr. Suite 0 Montpelier Richland County OH 48930 United States -5.00 single family
@@ -543,9 +543,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRE
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE.CUSTOMER_ADDRESS_NOPK
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRESS_NOPK
Rows Processed: 5000
-Task: PREPARATION Status: Ended ET: 00:00:01.073
+Task: PREPARATION Status: Ended ET: 00:00:01.062
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_ADDRESS_NOPK
-Task: COMPLETION Status: Ended ET: 00:00:00.328
+Task: COMPLETION Status: Ended ET: 00:00:00.294
--- 5000 row(s) loaded.
>>
@@ -569,14 +569,14 @@ CA_ADDRESS_SK CA_ADDRESS_ID CA_STREET_NUMBER CA_STREET_NAME
4 AAAAAAAAEAAAAAAA 111 Smith Wy Suite A Oak Ridge Kit Carson County CO 88371 United States -7.00 condo
5 AAAAAAAAFAAAAAAA 31 College Blvd Suite 180 Glendale Barry County MO 63951 United States -6.00 single family
6 AAAAAAAAGAAAAAAA 59 Williams Sixth Parkway Suite 100 Lakeview Chelan County WA 98579 United States -8.00 single family
- 7 AAAAAAAAHAAAAAAA ? Hill 7th Road Suite U Farmington ? ? 39145 United States ? ?
+ 7 AAAAAAAAHAAAAAAA Hill 7th Road Suite U Farmington 39145 United States ?
8 AAAAAAAAIAAAAAAA 875 Lincoln Ct. Suite Y Union Bledsoe County TN 38721 United States -5.00 apartment
9 AAAAAAAAJAAAAAAA 819 1st Laurel Ave Suite 70 New Hope Perry County AL 39431 United States -6.00 condo
10 AAAAAAAAKAAAAAAA 851 Woodland Poplar ST Suite Y Martinsville Haines Borough AK 90419 United States -9.00 condo
11 AAAAAAAALAAAAAAA 189 13th 2nd Street Suite 470 Maple Grove Madison County MT 68252 United States -7.00 single family
12 AAAAAAAAMAAAAAAA 76 Ash 8th Ct. Suite O Edgewood Mifflin County PA 10069 United States -5.00 apartment
13 AAAAAAAANAAAAAAA 424 Main Second Ln Suite 130 Greenville Noxubee County MS 51387 United States -6.00 single family
- 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 ? Lipscomb County TX 77752 ? -6.00 ?
+ 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 Lipscomb County TX 77752 -6.00
15 AAAAAAAAPAAAAAAA 314 Spring Ct. Suite B Oakland Washington County OH 49843 United States -5.00 apartment
16 AAAAAAAAABAAAAAA 576 Adams Center Street Suite J Valley View Oldham County TX 75124 United States -6.00 condo
17 AAAAAAAABBAAAAAA 801 Green Dr. Suite 0 Montpelier Richland County OH 48930 United States -5.00 single family
@@ -644,9 +644,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: 5000
-Task: PREPARATION Status: Ended ET: 00:00:02.255
+Task: PREPARATION Status: Ended ET: 00:00:04.130
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS
-Task: COMPLETION Status: Ended ET: 00:00:00.421
+Task: COMPLETION Status: Ended ET: 00:00:00.631
--- 5000 row(s) loaded.
>>
@@ -750,9 +750,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: 5000
-Task: PREPARATION Status: Ended ET: 00:00:05.628
+Task: PREPARATION Status: Ended ET: 00:00:06.200
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT
-Task: COMPLETION Status: Ended ET: 00:00:03.087
+Task: COMPLETION Status: Ended ET: 00:00:01.735
--- 5000 row(s) loaded.
>>
@@ -1262,9 +1262,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: 5000
-Task: PREPARATION Status: Ended ET: 00:00:05.160
+Task: PREPARATION Status: Ended ET: 00:00:06.517
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS
-Task: COMPLETION Status: Ended ET: 00:00:02.068
+Task: COMPLETION Status: Ended ET: 00:00:02.242
--- 5000 row(s) loaded.
>>
@@ -1305,11 +1305,11 @@ Task: DISABLE INDEXE Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOG
Task: DISABLE INDEXE Status: Ended Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS
Rows Processed: 1000
-Task: PREPARATION Status: Ended ET: 00:00:04.522
+Task: PREPARATION Status: Ended ET: 00:00:04.908
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS
-Task: COMPLETION Status: Ended ET: 00:00:01.373
+Task: COMPLETION Status: Ended ET: 00:00:01.357
Task: POPULATE INDEX Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS
-Task: POPULATE INDEX Status: Ended ET: 00:00:12.646
+Task: POPULATE INDEX Status: Ended ET: 00:00:12.289
--- 1000 row(s) loaded.
>>
@@ -1354,11 +1354,11 @@ Task: DISABLE INDEXE Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOG
Task: DISABLE INDEXE Status: Ended Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT
Task: PREPARATION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT
Rows Processed: 5000
-Task: PREPARATION Status: Ended ET: 00:00:06.216
+Task: PREPARATION Status: Ended ET: 00:00:05.592
Task: COMPLETION Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT
-Task: COMPLETION Status: Ended ET: 00:00:03.356
+Task: COMPLETION Status: Ended ET: 00:00:02.018
Task: POPULATE INDEX Status: Started Object: TRAFODION.HBASE.CUSTOMER_DEMOGRAPHICS_SALT
-Task: POPULATE INDEX Status: Ended ET: 00:00:14.835
+Task: POPULATE INDEX Status: Ended ET: 00:00:14.563
--- 5000 row(s) loaded.
>>
@@ -1532,9 +1532,9 @@ Task: CLEANUP Status: Started Object: TRAFODION.HBASE."customer_addr
Task: CLEANUP Status: Ended Object: TRAFODION.HBASE."customer_address_delim"
Task: PREPARATION Status: Started Object: TRAFODION.HBASE."customer_address_delim"
Rows Processed: 5000
-Task: PREPARATION Status: Ended ET: 00:00:03.648
+Task: PREPARATION Status: Ended ET: 00:00:04.154
Task: COMPLETION Status: Started Object: TRAFODION.HBASE."customer_address_delim"
-Task: COMPLETION Status: Ended ET: 00:00:02.430
+Task: COMPLETION Status: Ended ET: 00:00:01.729
--- 5000 row(s) loaded.
>>
@@ -1558,14 +1558,14 @@ CA_ADDRESS_SK CA_ADDRESS_ID CA_STREET_NUMBER CA_STREET_NAME
4 AAAAAAAAEAAAAAAA 111 Smith Wy Suite A Oak Ridge Kit Carson County CO 88371 United States -7.00 condo
5 AAAAAAAAFAAAAAAA 31 College Blvd Suite 180 Glendale Barry County MO 63951 United States -6.00 single family
6 AAAAAAAAGAAAAAAA 59 Williams Sixth Parkway Suite 100 Lakeview Chelan County WA 98579 United States -8.00 single family
- 7 AAAAAAAAHAAAAAAA ? Hill 7th Road Suite U Farmington ? ? 39145 United States ? ?
+ 7 AAAAAAAAHAAAAAAA Hill 7th Road Suite U Farmington 39145 United States ?
8 AAAAAAAAIAAAAAAA 875 Lincoln Ct. Suite Y Union Bledsoe County TN 38721 United States -5.00 apartment
9 AAAAAAAAJAAAAAAA 819 1st Laurel Ave Suite 70 New Hope Perry County AL 39431 United States -6.00 condo
10 AAAAAAAAKAAAAAAA 851 Woodland Poplar ST Suite Y Martinsville Haines Borough AK 90419 United States -9.00 condo
11 AAAAAAAALAAAAAAA 189 13th 2nd Street Suite 470 Maple Grove Madison County MT 68252 United States -7.00 single family
12 AAAAAAAAMAAAAAAA 76 Ash 8th Ct. Suite O Edgewood Mifflin County PA 10069 United States -5.00 apartment
13 AAAAAAAANAAAAAAA 424 Main Second Ln Suite 130 Greenville Noxubee County MS 51387 United States -6.00 single family
- 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 ? Lipscomb County TX 77752 ? -6.00 ?
+ 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 Lipscomb County TX 77752 -6.00
15 AAAAAAAAPAAAAAAA 314 Spring Ct. Suite B Oakland Washington County OH 49843 United States -5.00 apartment
16 AAAAAAAAABAAAAAA 576 Adams Center Street Suite J Valley View Oldham County TX 75124 United States -6.00 condo
17 AAAAAAAABBAAAAAA 801 Green Dr. Suite 0 Montpelier Richland County OH 48930 United States -5.00 single family