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:59 UTC
[4/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/EXPECTED004
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED004 b/core/sql/regress/hive/EXPECTED004
index 08ecaff..e751b89 100644
--- a/core/sql/regress/hive/EXPECTED004
+++ b/core/sql/regress/hive/EXPECTED004
@@ -28,106 +28,106 @@
C_CUSTOMER_SK C_CUSTOMER_ID C_CURRENT_CDEMO_SK C_CURRENT_HDEMO_SK C_CURRENT_ADDR_SK C_FIRST_SHIPTO_DATE_SK C_FIRST_SALES_DATE_SK C_SALUTATION C_FIRST_NAME C_LAST_NAME C_PREFERRED_CUST_FLAG C_BIRTH_DAY C_BIRTH_MONTH C_BIRTH_YEAR C_BIRTH_COUNTRY C_LOGIN C_EMAIL_ADDRESS C_LAST_REVIEW_DATE
------------- ------------------------- ------------------ ------------------ ----------------- ---------------------- --------------------- ------------------------- ------------------------- ------------------------- ------------------------- ----------- ------------- ------------ ------------------------- ------------------------- ------------------------- -------------------------
- 1 AAAAAAAABAAAAAAA 980124 7135 32946 2452238 2452208 Mr. Javier Lewis Y 9 12 1936 CHILE ? Javier.Lewis@VFAxlnZEvOx. 2452508
- 2 AAAAAAAACAAAAAAA 819667 1461 31655 2452318 2452288 Dr. Amy Moses Y 9 4 1966 TOGO ? Amy.Moses@Ovk9KjHH.com 2452318
- 3 AAAAAAAADAAAAAAA 1473522 6247 48572 2449130 2449100 Miss Latisha Hamilton N 18 9 1979 NIUE ? Latisha.Hamilton@V.com 2452313
- 4 AAAAAAAAEAAAAAAA 1703214 3986 39558 2450030 2450000 Dr. Michael White N 7 6 1983 MEXICO ? Michael.White@i.org 2452361
- 5 AAAAAAAAFAAAAAAA 953372 4470 36368 2449438 2449408 Sir Robert Moran N 8 5 1956 FIJI ? Robert.Moran@Hh.edu 2452469
- 6 AAAAAAAAGAAAAAAA 213219 6374 27082 2451883 2451853 Ms. Brunilda Sharp N 4 12 1925 SURINAME ? Brunilda.Sharp@T3pylZEUQj 2452430
- 7 AAAAAAAAHAAAAAAA 68377 3219 44814 2451438 2451408 Ms. Fonda Wiles Y 24 4 1985 GAMBIA ? Fonda.Wiles@S9KnyEtz9hv.o 2452360
- 8 AAAAAAAAIAAAAAAA 1215897 2471 16598 2449406 2449376 Sir Ollie Shipman N 26 12 1938 KOREA, REPUBLIC OF ? Ollie.Shipman@be.org 2452334
- 9 AAAAAAAAJAAAAAAA 1168667 1404 49388 2452275 2452245 Sir Karl Gilbert N 26 10 1966 MONTSERRAT ? Karl.Gilbert@Crg5KyP2IxX9 2452454
- 10 AAAAAAAAKAAAAAAA 1207553 5143 19580 2451353 2451323 Ms. Albert Brunson N 15 10 1973 JORDAN ? Albert.Brunson@62.com 2452641
- 11 AAAAAAAALAAAAAAA 1114415 6807 47999 2452288 2452258 Ms. Betty Williams N 18 12 1963 BURKINA FASO ? Betty.Williams@xRtDqM1eLB 2452398
- 12 AAAAAAAAMAAAAAAA 502141 6577 47366 2451039 2451009 Ms. Margaret Farias N 2 6 1956 TURKMENISTAN ? Margaret.Farias@cb.edu 2452634
- 13 AAAAAAAANAAAAAAA 1128748 2777 14006 2449658 2449628 Mrs. Rosalinda Grimes N 1 3 1970 UKRAINE ? Rosalinda.Grimes@tC8pcU7L 2452616
- 14 AAAAAAAAOAAAAAAA 929344 892 6440 2450318 2450288 Mr. Jack Wilcox N 30 3 1937 SLOVENIA ? Jack.Wilcox@Y3Etqyv3.org 2452641
- 15 AAAAAAAAPAAAAAAA ? 134 30469 ? 2449010 Ms. Tonya ? ? ? 12 1969 ? ? ? 2452376
- 16 AAAAAAAAABAAAAAA 1196373 3014 29302 2451346 2451316 Dr. Margie Browning N 24 12 1933 PHILIPPINES ? Margie.Browning@LM674NrE2 2452573
- 17 AAAAAAAABBAAAAAA 707524 3876 2228 2451068 2451038 Dr. Lee Stovall N 23 12 1972 PHILIPPINES ? Lee.Stovall@fqKC83UU0f.or 2452454
- 18 AAAAAAAACBAAAAAA 1361151 6580 18456 2450041 2450011 Sir Brad Lynch Y 1 9 1950 URUGUAY ? Brad.Lynch@nAbai.edu 2452549
- 19 AAAAAAAADBAAAAAA 1161742 4238 45581 2449580 2449550 Dr. Andre Moore N 20 10 1978 NICARAGUA ? Andre.Moore@cTZLGYi1ZJi.o 2452576
- 20 AAAAAAAAEBAAAAAA 1185612 89 38966 2450965 2450935 Mr. Stanton Dallas Y 17 5 1976 SWITZERLAND ? Stanton.Dallas@DBXgl18FGo 2452334
- 21 AAAAAAAAFBAAAAAA 442697 6538 25979 2451827 2451797 Miss Naomi Barnett N 18 5 1956 BAHAMAS ? Naomi.Barnett@2T3V3OZOy4K 2452433
- 22 AAAAAAAAGBAAAAAA 490494 4504 40467 2451465 2451435 Sir Victor Martinez N 21 12 1991 CAYMAN ISLANDS ? Victor.Martinez@fC.edu 2452529
- 23 AAAAAAAAHBAAAAAA ? 2107 686 2451012 2450982 Sir ? Garrison N ? 5 ? ? ? Earl.Garrison@G3sM4P.com ?
- 24 AAAAAAAAIBAAAAAA 17113 1102 14291 2450098 2450068 Dr. Paul Morris Y 6 6 1951 GUINEA-BISSAU ? Paul.Morris@FMGalegqc3.co 2452499
- 25 AAAAAAAAJBAAAAAA 476176 3278 25933 2449246 2449216 Miss Nancy Mccormick N 6 10 1973 BAHAMAS ? Nancy.Mccormick@DA26I9ZAr 2452425
- 26 AAAAAAAAKBAAAAAA 230278 1242 28206 2449816 2449786 Ms. Monique Baker N 14 6 1991 MOROCCO ? Monique.Baker@9uEucNczY.o 2452356
- 27 AAAAAAAALBAAAAAA 111621 835 16096 2450611 2450581 Dr. Shawn Prather N 7 3 1972 PUERTO RICO ? Shawn.Prather@8BusRYegn6. 2452353
- 28 AAAAAAAAMBAAAAAA 889961 897 33480 2452615 2452585 Miss Edith Hernandez Y 17 8 1959 C\ufffdTE D'IVOIRE ? Edith.Hernandez@BNHL0k.co 2452631
- 29 AAAAAAAANBAAAAAA 1634269 1204 44139 2452216 2452186 Ms. Margaret Collins Y 25 8 1973 NETHERLANDS ANTILLES ? Margaret.Collins@9obPr3UV 2452496
- 30 AAAAAAAAOBAAAAAA 84232 5869 45459 2449916 2449886 Dr. Pamela Luna Y 4 7 1956 GUAM ? Pamela.Luna@QBGuhL36lnA.e 2452410
- 31 AAAAAAAAPBAAAAAA 1275120 5724 7128 2452054 2452024 Dr. William Craig N 13 6 1964 SPAIN ? William.Craig@prVDE1E8AHc 2452336
- 32 AAAAAAAAACAAAAAA 1369589 6163 48290 2449471 2449441 Dr. Kenneth Wood N 2 8 1927 MOLDOVA, REPUBLIC OF ? Kenneth.Wood@RIA.edu 2452510
- 33 AAAAAAAABCAAAAAA 1680761 5823 32438 2451572 2451542 Mrs. Donna Betts Y 25 3 1958 FRANCE ? Donna.Betts@YJ14k.edu 2452455
- 34 AAAAAAAACCAAAAAA ? ? 37501 2452192 2452162 ? ? Woods ? ? ? ? ? ? Brandon.Woods@hjKbf.edu 2452408
- 35 AAAAAAAADCAAAAAA 339036 2057 32231 2451937 2451907 Dr. Marie Peterson N 19 6 1953 KIRIBATI ? Marie.Peterson@1zg9tydFHa 2452581
- 36 AAAAAAAAECAAAAAA 655414 2223 26585 2449222 2449192 Dr. Anthony Fisher N 29 11 1968 KYRGYZSTAN ? Anthony.Fisher@jJrZfeDcz8 2452470
- 37 AAAAAAAAFCAAAAAA 827972 2281 12943 2449848 2449818 Dr. Dwight Schneider Y 9 1 1949 RUSSIAN FEDERATION ? Dwight.Schneider@koxO7zAy 2452293
- 38 AAAAAAAAGCAAAAAA 766645 3879 36360 2450323 2450293 Mrs. Ha Carpenter Y 30 3 1939 PARAGUAY ? Ha.Carpenter@XgcUt4svNz.c 2452351
- 39 AAAAAAAAHCAAAAAA 1617182 4013 22844 2452131 2452101 Sir Neil Cox N 14 12 1951 ECUADOR ? Neil.Cox@FRuR2bFK.com 2452586
- 40 AAAAAAAAICAAAAAA 1795301 ? 21045 2451159 ? ? Jacqueline Hatfield ? 26 ? 1942 ? ? ? ?
- 41 AAAAAAAAJCAAAAAA 941420 5068 18316 2449989 2449959 Miss Maxine Carlson N 26 6 1939 ISLE OF MAN ? Maxine.Carlson@StyP5lAokm 2452464
- 42 AAAAAAAAKCAAAAAA 1867377 3327 11277 2449869 2449839 Dr. Deborah Burton N 17 1 1950 COMOROS ? Deborah.Burton@xt.edu 2452498
- 43 AAAAAAAALCAAAAAA 385562 3676 43743 2451705 2451675 Mr. William Warner Y 5 12 1965 GUAM ? William.Warner@zegnrzurU. 2452537
- 44 AAAAAAAAMCAAAAAA 497758 5427 32296 2449750 2449720 Miss Mabel Richmond Y 7 12 1932 CAMBODIA ? Mabel.Richmond@Tkla.edu 2452333
- 45 AAAAAAAANCAAAAAA 1036174 2399 19777 2451118 2451088 ? ? Hammonds ? 5 ? ? NIGER ? ? ?
- 46 AAAAAAAAOCAAAAAA 843672 4729 21386 2451857 2451827 Mrs. Jane Stephenson Y 13 4 1990 TURKEY ? Jane.Stephenson@lq8ZQLAUM 2452301
- 47 AAAAAAAAPCAAAAAA 1634314 5368 38469 2449165 2449135 Mr. Luis Young N 3 12 1982 BRUNEI DARUSSALAM ? Luis.Young@0DmV.edu 2452586
- 48 AAAAAAAAADAAAAAA 8817 311 38252 2449531 2449501 Ms. Jill Jackson N 15 9 1961 LUXEMBOURG ? Jill.Jackson@n6I7SF.org 2452575
- 49 AAAAAAAABDAAAAAA 936800 1514 20581 2449364 2449334 Mr. Steven Venable N 13 6 1961 NETHERLANDS ANTILLES ? Steven.Venable@0hA90vhfK7 2452350
- 50 AAAAAAAACDAAAAAA 759177 72 32567 2449384 2449354 Mr. Christopher Eller N 24 11 1965 AUSTRALIA ? Christopher.Eller@gV5Ua7H 2452520
- 51 AAAAAAAADDAAAAAA 532799 6920 10688 2452390 2452360 Dr. David Nieves N 5 10 1926 CHRISTMAS ISLAND ? David.Nieves@LcDkQ.edu 2452570
- 52 AAAAAAAAEDAAAAAA 534808 4768 27128 2451421 2451391 Mrs. Wendy Colley N 1 4 1982 FRENCH GUIANA ? Wendy.Colley@qLBjqbAQQGj. 2452553
- 53 AAAAAAAAFDAAAAAA 1597348 7017 43439 2451820 2451790 Mr. Paul Higgins Y 23 9 1950 GABON ? Paul.Higgins@qG9NrSTLz9Ha 2452447
- 54 AAAAAAAAGDAAAAAA 380102 2381 40660 2449980 2449950 Ms. Donna King Y 3 2 1940 TUNISIA ? Donna.King@TEftU.com 2452446
- 55 AAAAAAAAHDAAAAAA 783093 1151 23256 2451539 2451509 Dr. Beryl Thomason N 12 8 1933 UNITED KINGDOM ? Beryl.Thomason@OeqefhtCmZ 2452380
- 56 AAAAAAAAIDAAAAAA 344460 3092 2524 2451424 2451394 Miss Pamela Delgado N 29 1 1960 GUERNSEY ? Pamela.Delgado@8OpV0Ldj8v 2452334
- 57 AAAAAAAAJDAAAAAA 752932 128 571 2449741 2449711 Mr. Travis Melendez Y 10 3 1961 AFGHANISTAN ? Travis.Melendez@344rCMk.e 2452606
- 58 AAAAAAAAKDAAAAAA 528756 6879 14155 2451386 2451356 Mr. Cecil Peterman Y 29 2 1988 ICELAND ? Cecil.Peterman@tbeqEuUvS4 2452447
- 59 AAAAAAAALDAAAAAA 1895444 4787 45683 2451157 2451127 Miss Melanie Morrison N 6 1 1947 HUNGARY ? Melanie.Morrison@F2foqn.e 2452530
- 60 AAAAAAAAMDAAAAAA 1179671 3200 44282 2449714 2449684 Ms. Dollie Thao N 15 7 1990 SWITZERLAND ? Dollie.Thao@Xead5vagsekdH 2452407
- 61 AAAAAAAANDAAAAAA 1620078 6683 11688 2451136 2451106 Sir Joseph White Y 6 5 1978 SENEGAL ? Joseph.White@c0EJ7pimuu.c 2452462
- 62 AAAAAAAAODAAAAAA 821787 4700 28413 2451854 2451824 Mr. Matthew Brown Y 1 6 1973 KOREA, REPUBLIC OF ? Matthew.Brown@F.edu 2452319
- 63 AAAAAAAAPDAAAAAA 1790374 2445 9716 2450179 2450149 Dr. Frank Morton N 26 4 1943 EGYPT ? Frank.Morton@Hd7jNaA3s.co 2452425
- 64 AAAAAAAAAEAAAAAA 1260191 6284 25930 2452379 2452349 Dr. Michael Frye N 27 6 1941 CAPE VERDE ? Michael.Frye@aM1HsbOs0smg 2452426
- 65 AAAAAAAABEAAAAAA 1778884 2234 37584 2451898 2451868 Dr. Rodney Taft N 18 9 1991 VIRGIN ISLANDS, U.S. ? Rodney.Taft@qe.com 2452353
- 66 AAAAAAAACEAAAAAA 747190 6036 42882 2449294 2449264 Ms. Julie Chester N 8 9 1950 HONG KONG ? Julie.Chester@Kv.com 2452375
- 67 AAAAAAAADEAAAAAA 1118294 2032 24970 2452033 2452003 Dr. Gerald Thomas N 27 10 1948 NORWAY ? Gerald.Thomas@zSuIGSgb6iy 2452414
- 68 AAAAAAAAEEAAAAAA 779965 6069 16126 2451936 2451906 Dr. Arthur Troy Y 20 8 1928 LUXEMBOURG ? Arthur.Troy@3VY5bV30AifrO 2452542
- 69 AAAAAAAAFEAAAAAA 971368 4167 9366 2450154 2450124 Sir Steven Mcclellan Y 15 1 1950 NEPAL ? Steven.Mcclellan@UviyOLnu 2452340
- 70 AAAAAAAAGEAAAAAA 1460929 5492 48102 2451944 2451914 Sir James Smith N 7 12 1963 KUWAIT ? James.Smith@ifJngGlNG.edu 2452342
- 71 AAAAAAAAHEAAAAAA 1292064 2257 42450 2450248 2450218 Mr. Roderick Rogers N 4 11 1967 OMAN ? Roderick.Rogers@pJdioQ.co 2452462
- 72 AAAAAAAAIEAAAAAA 1608738 6364 26390 2451700 2451670 Dr. Bradley Barry Y 21 3 1937 TAJIKISTAN ? Bradley.Barry@Kq2ONpEXU9Y 2452601
- 73 AAAAAAAAJEAAAAAA 425740 431 48369 2449133 2449103 Mr. David Vasquez N 17 4 1956 ISRAEL ? David.Vasquez@j.org 2452489
- 74 AAAAAAAAKEAAAAAA 1434225 347 15269 2452641 2452611 Sir Eric Woods Y 19 2 1953 SAINT LUCIA ? Eric.Woods@CfPzy1AUqxd2.c 2452584
- 75 AAAAAAAALEAAAAAA 1888603 143 37730 2451755 2451725 Dr. Annie Grant Y 25 5 1925 TUVALU ? Annie.Grant@tccug5KC1oT2n 2452401
- 76 AAAAAAAAMEAAAAAA 526064 2054 9691 2451760 2451730 Mr. Craig Lowry Y 7 3 1946 WALLIS AND FUTUNA ? Craig.Lowry@92zokgx8duX.o 2452430
- 77 AAAAAAAANEAAAAAA 915180 2167 37154 2451632 2451602 Dr. Darrin Smith N 30 5 1931 UNITED STATES ? Darrin.Smith@Mti.edu 2452355
- 78 AAAAAAAAOEAAAAAA 1092537 3677 7264 2449388 2449358 Ms. Wanda Davis N 11 5 1940 NETHERLANDS ANTILLES ? Wanda.Davis@I6s7DD86i6.ed 2452339
- 79 AAAAAAAAPEAAAAAA 389494 3493 9539 2450863 2450833 Miss Sandi Tran Y 10 6 1937 FRENCH GUIANA ? Sandi.Tran@myikqStif1Q.ed 2452644
- 80 AAAAAAAAAFAAAAAA 1499808 3891 44727 2450558 2450528 Mrs. Eleanor Evans N 21 12 1948 C\ufffdTE D'IVOIRE ? Eleanor.Evans@zxvr5rl.org 2452413
- 81 AAAAAAAABFAAAAAA 728917 388 48306 2452562 2452532 Ms. Jessica Levesque Y 17 7 1940 ALBANIA ? Jessica.Levesque@06mGqI9m 2452414
- 82 AAAAAAAACFAAAAAA 75627 5081 30088 2450357 2450327 Sir Max Mueller N 26 2 1947 IRAQ ? Max.Mueller@xqCZRBSrTGD6C 2452303
- 83 AAAAAAAADFAAAAAA 976724 5574 40824 2451032 2451002 Miss Daisy Flynn N 24 1 1943 NEW ZEALAND ? Daisy.Flynn@288e6Z0csxJ.c 2452338
- 84 AAAAAAAAEFAAAAAA 1250744 2821 40898 2449496 2449466 Mrs. Ami Montgomery Y 2 5 1964 JAMAICA ? Ami.Montgomery@VBSKqhL36j 2452526
- 85 AAAAAAAAFFAAAAAA 1293499 37 10575 2449868 2449838 Miss Michele Baldwin Y 30 10 1978 GEORGIA ? Michele.Baldwin@sIVO1J4U. 2452491
- 86 AAAAAAAAGFAAAAAA 1428237 6963 38442 2451560 2451530 Dr. Marvin Matlock Y 21 10 1983 BRUNEI DARUSSALAM ? Marvin.Matlock@0FXEZp.org 2452633
- 87 AAAAAAAAHFAAAAAA 1452824 1427 22030 2449404 2449374 Dr. Kevin White N 2 7 1934 BENIN ? Kevin.White@x9oTPjEI6AdDQ 2452492
- 88 AAAAAAAAIFAAAAAA 495575 131 42687 2450991 2450961 Dr. Phyllis Horner N 20 8 1965 UZBEKISTAN ? Phyllis.Horner@uQy.edu 2452403
- 89 AAAAAAAAJFAAAAAA 694848 5383 26318 2451425 2451395 Mrs. Helen Macdonald Y 15 3 1981 DOMINICA ? Helen.Macdonald@3d4.com 2452626
- 90 AAAAAAAAKFAAAAAA 417827 5083 45139 2451494 2451464 Mr. Nathan Pond Y 7 5 1985 GUYANA ? Nathan.Pond@nPh7drM687MhI 2452637
- 91 AAAAAAAALFAAAAAA 827176 2441 14906 2450406 2450376 Miss Heather White Y 28 3 1962 MARTINIQUE ? Heather.White@3JitjmxYQnX 2452295
- 92 AAAAAAAAMFAAAAAA 953084 5771 35211 2452582 2452552 Miss Crystal Ryan Y 8 2 1973 ECUADOR ? Crystal.Ryan@Ju2rO6u.com 2452294
- 93 AAAAAAAANFAAAAAA 647375 6229 35836 2449341 2449311 Sir Clyde Williams N 6 10 1927 FRENCH POLYNESIA ? Clyde.Williams@en.com 2452510
- 94 AAAAAAAAOFAAAAAA 451893 1990 33287 2449553 2449523 Mr. Craig Byrd Y 14 5 1982 FRENCH POLYNESIA ? Craig.Byrd@Dc0OEMXkvvuJ.c 2452445
- 95 AAAAAAAAPFAAAAAA 796503 1663 16023 2452468 2452438 Ms. Elizabeth Hollingsworth N 17 4 1943 GREECE ? Elizabeth.Hollingsworth@l 2452584
- 96 AAAAAAAAAGAAAAAA 1148074 6019 35611 2451505 2451475 Sir Shaun Lewis N 22 10 1955 NIGERIA ? Shaun.Lewis@MTRUPYFTXf9.c 2452395
- 97 AAAAAAAABGAAAAAA 418763 102 49041 2452467 2452437 Mr. Stewart Ruffin Y 19 5 1971 MYANMAR ? Stewart.Ruffin@R7Mrx.edu 2452528
- 98 AAAAAAAACGAAAAAA 574977 1615 43853 2450894 2450864 Dr. David Lewis N 23 6 1965 KIRIBATI ? David.Lewis@5mhvq.org 2452558
- 99 AAAAAAAADGAAAAAA 622676 2152 17228 2451687 2451657 Sir Austin Tran Y 9 12 1961 NAMIBIA ? Austin.Tran@ect7cnjLsucbd 2452437
- 100 AAAAAAAAEGAAAAAA 1254468 6370 6672 2449148 2449118 Ms. Jeannette Johnson Y 13 7 1958 BANGLADESH ? Jeannette.Johnson@8BvSqgp 2452635
+ 1 AAAAAAAABAAAAAAA 980124 7135 32946 2452238 2452208 Mr. Javier Lewis Y 9 12 1936 CHILE Javier.Lewis@VFAxlnZEvOx. 2452508
+ 2 AAAAAAAACAAAAAAA 819667 1461 31655 2452318 2452288 Dr. Amy Moses Y 9 4 1966 TOGO Amy.Moses@Ovk9KjHH.com 2452318
+ 3 AAAAAAAADAAAAAAA 1473522 6247 48572 2449130 2449100 Miss Latisha Hamilton N 18 9 1979 NIUE Latisha.Hamilton@V.com 2452313
+ 4 AAAAAAAAEAAAAAAA 1703214 3986 39558 2450030 2450000 Dr. Michael White N 7 6 1983 MEXICO Michael.White@i.org 2452361
+ 5 AAAAAAAAFAAAAAAA 953372 4470 36368 2449438 2449408 Sir Robert Moran N 8 5 1956 FIJI Robert.Moran@Hh.edu 2452469
+ 6 AAAAAAAAGAAAAAAA 213219 6374 27082 2451883 2451853 Ms. Brunilda Sharp N 4 12 1925 SURINAME Brunilda.Sharp@T3pylZEUQj 2452430
+ 7 AAAAAAAAHAAAAAAA 68377 3219 44814 2451438 2451408 Ms. Fonda Wiles Y 24 4 1985 GAMBIA Fonda.Wiles@S9KnyEtz9hv.o 2452360
+ 8 AAAAAAAAIAAAAAAA 1215897 2471 16598 2449406 2449376 Sir Ollie Shipman N 26 12 1938 KOREA, REPUBLIC OF Ollie.Shipman@be.org 2452334
+ 9 AAAAAAAAJAAAAAAA 1168667 1404 49388 2452275 2452245 Sir Karl Gilbert N 26 10 1966 MONTSERRAT Karl.Gilbert@Crg5KyP2IxX9 2452454
+ 10 AAAAAAAAKAAAAAAA 1207553 5143 19580 2451353 2451323 Ms. Albert Brunson N 15 10 1973 JORDAN Albert.Brunson@62.com 2452641
+ 11 AAAAAAAALAAAAAAA 1114415 6807 47999 2452288 2452258 Ms. Betty Williams N 18 12 1963 BURKINA FASO Betty.Williams@xRtDqM1eLB 2452398
+ 12 AAAAAAAAMAAAAAAA 502141 6577 47366 2451039 2451009 Ms. Margaret Farias N 2 6 1956 TURKMENISTAN Margaret.Farias@cb.edu 2452634
+ 13 AAAAAAAANAAAAAAA 1128748 2777 14006 2449658 2449628 Mrs. Rosalinda Grimes N 1 3 1970 UKRAINE Rosalinda.Grimes@tC8pcU7L 2452616
+ 14 AAAAAAAAOAAAAAAA 929344 892 6440 2450318 2450288 Mr. Jack Wilcox N 30 3 1937 SLOVENIA Jack.Wilcox@Y3Etqyv3.org 2452641
+ 15 AAAAAAAAPAAAAAAA ? 134 30469 ? 2449010 Ms. Tonya ? 12 1969 2452376
+ 16 AAAAAAAAABAAAAAA 1196373 3014 29302 2451346 2451316 Dr. Margie Browning N 24 12 1933 PHILIPPINES Margie.Browning@LM674NrE2 2452573
+ 17 AAAAAAAABBAAAAAA 707524 3876 2228 2451068 2451038 Dr. Lee Stovall N 23 12 1972 PHILIPPINES Lee.Stovall@fqKC83UU0f.or 2452454
+ 18 AAAAAAAACBAAAAAA 1361151 6580 18456 2450041 2450011 Sir Brad Lynch Y 1 9 1950 URUGUAY Brad.Lynch@nAbai.edu 2452549
+ 19 AAAAAAAADBAAAAAA 1161742 4238 45581 2449580 2449550 Dr. Andre Moore N 20 10 1978 NICARAGUA Andre.Moore@cTZLGYi1ZJi.o 2452576
+ 20 AAAAAAAAEBAAAAAA 1185612 89 38966 2450965 2450935 Mr. Stanton Dallas Y 17 5 1976 SWITZERLAND Stanton.Dallas@DBXgl18FGo 2452334
+ 21 AAAAAAAAFBAAAAAA 442697 6538 25979 2451827 2451797 Miss Naomi Barnett N 18 5 1956 BAHAMAS Naomi.Barnett@2T3V3OZOy4K 2452433
+ 22 AAAAAAAAGBAAAAAA 490494 4504 40467 2451465 2451435 Sir Victor Martinez N 21 12 1991 CAYMAN ISLANDS Victor.Martinez@fC.edu 2452529
+ 23 AAAAAAAAHBAAAAAA ? 2107 686 2451012 2450982 Sir Garrison N ? 5 ? Earl.Garrison@G3sM4P.com
+ 24 AAAAAAAAIBAAAAAA 17113 1102 14291 2450098 2450068 Dr. Paul Morris Y 6 6 1951 GUINEA-BISSAU Paul.Morris@FMGalegqc3.co 2452499
+ 25 AAAAAAAAJBAAAAAA 476176 3278 25933 2449246 2449216 Miss Nancy Mccormick N 6 10 1973 BAHAMAS Nancy.Mccormick@DA26I9ZAr 2452425
+ 26 AAAAAAAAKBAAAAAA 230278 1242 28206 2449816 2449786 Ms. Monique Baker N 14 6 1991 MOROCCO Monique.Baker@9uEucNczY.o 2452356
+ 27 AAAAAAAALBAAAAAA 111621 835 16096 2450611 2450581 Dr. Shawn Prather N 7 3 1972 PUERTO RICO Shawn.Prather@8BusRYegn6. 2452353
+ 28 AAAAAAAAMBAAAAAA 889961 897 33480 2452615 2452585 Miss Edith Hernandez Y 17 8 1959 C\ufffdTE D'IVOIRE Edith.Hernandez@BNHL0k.co 2452631
+ 29 AAAAAAAANBAAAAAA 1634269 1204 44139 2452216 2452186 Ms. Margaret Collins Y 25 8 1973 NETHERLANDS ANTILLES Margaret.Collins@9obPr3UV 2452496
+ 30 AAAAAAAAOBAAAAAA 84232 5869 45459 2449916 2449886 Dr. Pamela Luna Y 4 7 1956 GUAM Pamela.Luna@QBGuhL36lnA.e 2452410
+ 31 AAAAAAAAPBAAAAAA 1275120 5724 7128 2452054 2452024 Dr. William Craig N 13 6 1964 SPAIN William.Craig@prVDE1E8AHc 2452336
+ 32 AAAAAAAAACAAAAAA 1369589 6163 48290 2449471 2449441 Dr. Kenneth Wood N 2 8 1927 MOLDOVA, REPUBLIC OF Kenneth.Wood@RIA.edu 2452510
+ 33 AAAAAAAABCAAAAAA 1680761 5823 32438 2451572 2451542 Mrs. Donna Betts Y 25 3 1958 FRANCE Donna.Betts@YJ14k.edu 2452455
+ 34 AAAAAAAACCAAAAAA ? ? 37501 2452192 2452162 Woods ? ? ? Brandon.Woods@hjKbf.edu 2452408
+ 35 AAAAAAAADCAAAAAA 339036 2057 32231 2451937 2451907 Dr. Marie Peterson N 19 6 1953 KIRIBATI Marie.Peterson@1zg9tydFHa 2452581
+ 36 AAAAAAAAECAAAAAA 655414 2223 26585 2449222 2449192 Dr. Anthony Fisher N 29 11 1968 KYRGYZSTAN Anthony.Fisher@jJrZfeDcz8 2452470
+ 37 AAAAAAAAFCAAAAAA 827972 2281 12943 2449848 2449818 Dr. Dwight Schneider Y 9 1 1949 RUSSIAN FEDERATION Dwight.Schneider@koxO7zAy 2452293
+ 38 AAAAAAAAGCAAAAAA 766645 3879 36360 2450323 2450293 Mrs. Ha Carpenter Y 30 3 1939 PARAGUAY Ha.Carpenter@XgcUt4svNz.c 2452351
+ 39 AAAAAAAAHCAAAAAA 1617182 4013 22844 2452131 2452101 Sir Neil Cox N 14 12 1951 ECUADOR Neil.Cox@FRuR2bFK.com 2452586
+ 40 AAAAAAAAICAAAAAA 1795301 ? 21045 2451159 ? Jacqueline Hatfield 26 ? 1942
+ 41 AAAAAAAAJCAAAAAA 941420 5068 18316 2449989 2449959 Miss Maxine Carlson N 26 6 1939 ISLE OF MAN Maxine.Carlson@StyP5lAokm 2452464
+ 42 AAAAAAAAKCAAAAAA 1867377 3327 11277 2449869 2449839 Dr. Deborah Burton N 17 1 1950 COMOROS Deborah.Burton@xt.edu 2452498
+ 43 AAAAAAAALCAAAAAA 385562 3676 43743 2451705 2451675 Mr. William Warner Y 5 12 1965 GUAM William.Warner@zegnrzurU. 2452537
+ 44 AAAAAAAAMCAAAAAA 497758 5427 32296 2449750 2449720 Miss Mabel Richmond Y 7 12 1932 CAMBODIA Mabel.Richmond@Tkla.edu 2452333
+ 45 AAAAAAAANCAAAAAA 1036174 2399 19777 2451118 2451088 Hammonds 5 ? ? NIGER
+ 46 AAAAAAAAOCAAAAAA 843672 4729 21386 2451857 2451827 Mrs. Jane Stephenson Y 13 4 1990 TURKEY Jane.Stephenson@lq8ZQLAUM 2452301
+ 47 AAAAAAAAPCAAAAAA 1634314 5368 38469 2449165 2449135 Mr. Luis Young N 3 12 1982 BRUNEI DARUSSALAM Luis.Young@0DmV.edu 2452586
+ 48 AAAAAAAAADAAAAAA 8817 311 38252 2449531 2449501 Ms. Jill Jackson N 15 9 1961 LUXEMBOURG Jill.Jackson@n6I7SF.org 2452575
+ 49 AAAAAAAABDAAAAAA 936800 1514 20581 2449364 2449334 Mr. Steven Venable N 13 6 1961 NETHERLANDS ANTILLES Steven.Venable@0hA90vhfK7 2452350
+ 50 AAAAAAAACDAAAAAA 759177 72 32567 2449384 2449354 Mr. Christopher Eller N 24 11 1965 AUSTRALIA Christopher.Eller@gV5Ua7H 2452520
+ 51 AAAAAAAADDAAAAAA 532799 6920 10688 2452390 2452360 Dr. David Nieves N 5 10 1926 CHRISTMAS ISLAND David.Nieves@LcDkQ.edu 2452570
+ 52 AAAAAAAAEDAAAAAA 534808 4768 27128 2451421 2451391 Mrs. Wendy Colley N 1 4 1982 FRENCH GUIANA Wendy.Colley@qLBjqbAQQGj. 2452553
+ 53 AAAAAAAAFDAAAAAA 1597348 7017 43439 2451820 2451790 Mr. Paul Higgins Y 23 9 1950 GABON Paul.Higgins@qG9NrSTLz9Ha 2452447
+ 54 AAAAAAAAGDAAAAAA 380102 2381 40660 2449980 2449950 Ms. Donna King Y 3 2 1940 TUNISIA Donna.King@TEftU.com 2452446
+ 55 AAAAAAAAHDAAAAAA 783093 1151 23256 2451539 2451509 Dr. Beryl Thomason N 12 8 1933 UNITED KINGDOM Beryl.Thomason@OeqefhtCmZ 2452380
+ 56 AAAAAAAAIDAAAAAA 344460 3092 2524 2451424 2451394 Miss Pamela Delgado N 29 1 1960 GUERNSEY Pamela.Delgado@8OpV0Ldj8v 2452334
+ 57 AAAAAAAAJDAAAAAA 752932 128 571 2449741 2449711 Mr. Travis Melendez Y 10 3 1961 AFGHANISTAN Travis.Melendez@344rCMk.e 2452606
+ 58 AAAAAAAAKDAAAAAA 528756 6879 14155 2451386 2451356 Mr. Cecil Peterman Y 29 2 1988 ICELAND Cecil.Peterman@tbeqEuUvS4 2452447
+ 59 AAAAAAAALDAAAAAA 1895444 4787 45683 2451157 2451127 Miss Melanie Morrison N 6 1 1947 HUNGARY Melanie.Morrison@F2foqn.e 2452530
+ 60 AAAAAAAAMDAAAAAA 1179671 3200 44282 2449714 2449684 Ms. Dollie Thao N 15 7 1990 SWITZERLAND Dollie.Thao@Xead5vagsekdH 2452407
+ 61 AAAAAAAANDAAAAAA 1620078 6683 11688 2451136 2451106 Sir Joseph White Y 6 5 1978 SENEGAL Joseph.White@c0EJ7pimuu.c 2452462
+ 62 AAAAAAAAODAAAAAA 821787 4700 28413 2451854 2451824 Mr. Matthew Brown Y 1 6 1973 KOREA, REPUBLIC OF Matthew.Brown@F.edu 2452319
+ 63 AAAAAAAAPDAAAAAA 1790374 2445 9716 2450179 2450149 Dr. Frank Morton N 26 4 1943 EGYPT Frank.Morton@Hd7jNaA3s.co 2452425
+ 64 AAAAAAAAAEAAAAAA 1260191 6284 25930 2452379 2452349 Dr. Michael Frye N 27 6 1941 CAPE VERDE Michael.Frye@aM1HsbOs0smg 2452426
+ 65 AAAAAAAABEAAAAAA 1778884 2234 37584 2451898 2451868 Dr. Rodney Taft N 18 9 1991 VIRGIN ISLANDS, U.S. Rodney.Taft@qe.com 2452353
+ 66 AAAAAAAACEAAAAAA 747190 6036 42882 2449294 2449264 Ms. Julie Chester N 8 9 1950 HONG KONG Julie.Chester@Kv.com 2452375
+ 67 AAAAAAAADEAAAAAA 1118294 2032 24970 2452033 2452003 Dr. Gerald Thomas N 27 10 1948 NORWAY Gerald.Thomas@zSuIGSgb6iy 2452414
+ 68 AAAAAAAAEEAAAAAA 779965 6069 16126 2451936 2451906 Dr. Arthur Troy Y 20 8 1928 LUXEMBOURG Arthur.Troy@3VY5bV30AifrO 2452542
+ 69 AAAAAAAAFEAAAAAA 971368 4167 9366 2450154 2450124 Sir Steven Mcclellan Y 15 1 1950 NEPAL Steven.Mcclellan@UviyOLnu 2452340
+ 70 AAAAAAAAGEAAAAAA 1460929 5492 48102 2451944 2451914 Sir James Smith N 7 12 1963 KUWAIT James.Smith@ifJngGlNG.edu 2452342
+ 71 AAAAAAAAHEAAAAAA 1292064 2257 42450 2450248 2450218 Mr. Roderick Rogers N 4 11 1967 OMAN Roderick.Rogers@pJdioQ.co 2452462
+ 72 AAAAAAAAIEAAAAAA 1608738 6364 26390 2451700 2451670 Dr. Bradley Barry Y 21 3 1937 TAJIKISTAN Bradley.Barry@Kq2ONpEXU9Y 2452601
+ 73 AAAAAAAAJEAAAAAA 425740 431 48369 2449133 2449103 Mr. David Vasquez N 17 4 1956 ISRAEL David.Vasquez@j.org 2452489
+ 74 AAAAAAAAKEAAAAAA 1434225 347 15269 2452641 2452611 Sir Eric Woods Y 19 2 1953 SAINT LUCIA Eric.Woods@CfPzy1AUqxd2.c 2452584
+ 75 AAAAAAAALEAAAAAA 1888603 143 37730 2451755 2451725 Dr. Annie Grant Y 25 5 1925 TUVALU Annie.Grant@tccug5KC1oT2n 2452401
+ 76 AAAAAAAAMEAAAAAA 526064 2054 9691 2451760 2451730 Mr. Craig Lowry Y 7 3 1946 WALLIS AND FUTUNA Craig.Lowry@92zokgx8duX.o 2452430
+ 77 AAAAAAAANEAAAAAA 915180 2167 37154 2451632 2451602 Dr. Darrin Smith N 30 5 1931 UNITED STATES Darrin.Smith@Mti.edu 2452355
+ 78 AAAAAAAAOEAAAAAA 1092537 3677 7264 2449388 2449358 Ms. Wanda Davis N 11 5 1940 NETHERLANDS ANTILLES Wanda.Davis@I6s7DD86i6.ed 2452339
+ 79 AAAAAAAAPEAAAAAA 389494 3493 9539 2450863 2450833 Miss Sandi Tran Y 10 6 1937 FRENCH GUIANA Sandi.Tran@myikqStif1Q.ed 2452644
+ 80 AAAAAAAAAFAAAAAA 1499808 3891 44727 2450558 2450528 Mrs. Eleanor Evans N 21 12 1948 C\ufffdTE D'IVOIRE Eleanor.Evans@zxvr5rl.org 2452413
+ 81 AAAAAAAABFAAAAAA 728917 388 48306 2452562 2452532 Ms. Jessica Levesque Y 17 7 1940 ALBANIA Jessica.Levesque@06mGqI9m 2452414
+ 82 AAAAAAAACFAAAAAA 75627 5081 30088 2450357 2450327 Sir Max Mueller N 26 2 1947 IRAQ Max.Mueller@xqCZRBSrTGD6C 2452303
+ 83 AAAAAAAADFAAAAAA 976724 5574 40824 2451032 2451002 Miss Daisy Flynn N 24 1 1943 NEW ZEALAND Daisy.Flynn@288e6Z0csxJ.c 2452338
+ 84 AAAAAAAAEFAAAAAA 1250744 2821 40898 2449496 2449466 Mrs. Ami Montgomery Y 2 5 1964 JAMAICA Ami.Montgomery@VBSKqhL36j 2452526
+ 85 AAAAAAAAFFAAAAAA 1293499 37 10575 2449868 2449838 Miss Michele Baldwin Y 30 10 1978 GEORGIA Michele.Baldwin@sIVO1J4U. 2452491
+ 86 AAAAAAAAGFAAAAAA 1428237 6963 38442 2451560 2451530 Dr. Marvin Matlock Y 21 10 1983 BRUNEI DARUSSALAM Marvin.Matlock@0FXEZp.org 2452633
+ 87 AAAAAAAAHFAAAAAA 1452824 1427 22030 2449404 2449374 Dr. Kevin White N 2 7 1934 BENIN Kevin.White@x9oTPjEI6AdDQ 2452492
+ 88 AAAAAAAAIFAAAAAA 495575 131 42687 2450991 2450961 Dr. Phyllis Horner N 20 8 1965 UZBEKISTAN Phyllis.Horner@uQy.edu 2452403
+ 89 AAAAAAAAJFAAAAAA 694848 5383 26318 2451425 2451395 Mrs. Helen Macdonald Y 15 3 1981 DOMINICA Helen.Macdonald@3d4.com 2452626
+ 90 AAAAAAAAKFAAAAAA 417827 5083 45139 2451494 2451464 Mr. Nathan Pond Y 7 5 1985 GUYANA Nathan.Pond@nPh7drM687MhI 2452637
+ 91 AAAAAAAALFAAAAAA 827176 2441 14906 2450406 2450376 Miss Heather White Y 28 3 1962 MARTINIQUE Heather.White@3JitjmxYQnX 2452295
+ 92 AAAAAAAAMFAAAAAA 953084 5771 35211 2452582 2452552 Miss Crystal Ryan Y 8 2 1973 ECUADOR Crystal.Ryan@Ju2rO6u.com 2452294
+ 93 AAAAAAAANFAAAAAA 647375 6229 35836 2449341 2449311 Sir Clyde Williams N 6 10 1927 FRENCH POLYNESIA Clyde.Williams@en.com 2452510
+ 94 AAAAAAAAOFAAAAAA 451893 1990 33287 2449553 2449523 Mr. Craig Byrd Y 14 5 1982 FRENCH POLYNESIA Craig.Byrd@Dc0OEMXkvvuJ.c 2452445
+ 95 AAAAAAAAPFAAAAAA 796503 1663 16023 2452468 2452438 Ms. Elizabeth Hollingsworth N 17 4 1943 GREECE Elizabeth.Hollingsworth@l 2452584
+ 96 AAAAAAAAAGAAAAAA 1148074 6019 35611 2451505 2451475 Sir Shaun Lewis N 22 10 1955 NIGERIA Shaun.Lewis@MTRUPYFTXf9.c 2452395
+ 97 AAAAAAAABGAAAAAA 418763 102 49041 2452467 2452437 Mr. Stewart Ruffin Y 19 5 1971 MYANMAR Stewart.Ruffin@R7Mrx.edu 2452528
+ 98 AAAAAAAACGAAAAAA 574977 1615 43853 2450894 2450864 Dr. David Lewis N 23 6 1965 KIRIBATI David.Lewis@5mhvq.org 2452558
+ 99 AAAAAAAADGAAAAAA 622676 2152 17228 2451687 2451657 Sir Austin Tran Y 9 12 1961 NAMIBIA Austin.Tran@ect7cnjLsucbd 2452437
+ 100 AAAAAAAAEGAAAAAA 1254468 6370 6672 2449148 2449118 Ms. Jeannette Johnson Y 13 7 1958 BANGLADESH Jeannette.Johnson@8BvSqgp 2452635
--- 100 row(s) selected.
>>select * from hive.ins_promotion order by P_PROMO_SK;
@@ -145,11 +145,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
@@ -162,7 +162,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 at
<TRUNCATED>