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
