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 ? [email protected] 2452318 - 3 AAAAAAAADAAAAAAA 1473522 6247 48572 2449130 2449100 Miss Latisha Hamilton N 18 9 1979 NIUE ? [email protected] 2452313 - 4 AAAAAAAAEAAAAAAA 1703214 3986 39558 2450030 2450000 Dr. Michael White N 7 6 1983 MEXICO ? [email protected] 2452361 - 5 AAAAAAAAFAAAAAAA 953372 4470 36368 2449438 2449408 Sir Robert Moran N 8 5 1956 FIJI ? [email protected] 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 ? [email protected] 2452360 - 8 AAAAAAAAIAAAAAAA 1215897 2471 16598 2449406 2449376 Sir Ollie Shipman N 26 12 1938 KOREA, REPUBLIC OF ? [email protected] 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 ? [email protected] 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 ? [email protected] 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 ? [email protected] 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 ? [email protected] 2452454 - 18 AAAAAAAACBAAAAAA 1361151 6580 18456 2450041 2450011 Sir Brad Lynch Y 1 9 1950 URUGUAY ? [email protected] 2452549 - 19 AAAAAAAADBAAAAAA 1161742 4238 45581 2449580 2449550 Dr. Andre Moore N 20 10 1978 NICARAGUA ? [email protected] 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 ? [email protected] 2452529 - 23 AAAAAAAAHBAAAAAA ? 2107 686 2451012 2450982 Sir ? Garrison N ? 5 ? ? ? [email protected] ? - 24 AAAAAAAAIBAAAAAA 17113 1102 14291 2450098 2450068 Dr. Paul Morris Y 6 6 1951 GUINEA-BISSAU ? [email protected] 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 ? [email protected] 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�TE D'IVOIRE ? [email protected] 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 ? [email protected] 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 ? [email protected] 2452510 - 33 AAAAAAAABCAAAAAA 1680761 5823 32438 2451572 2451542 Mrs. Donna Betts Y 25 3 1958 FRANCE ? [email protected] 2452455 - 34 AAAAAAAACCAAAAAA ? ? 37501 2452192 2452162 ? ? Woods ? ? ? ? ? ? [email protected] 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 ? [email protected] 2452351 - 39 AAAAAAAAHCAAAAAA 1617182 4013 22844 2452131 2452101 Sir Neil Cox N 14 12 1951 ECUADOR ? [email protected] 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 ? [email protected] 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 ? [email protected] 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 ? [email protected] 2452586 - 48 AAAAAAAAADAAAAAA 8817 311 38252 2449531 2449501 Ms. Jill Jackson N 15 9 1961 LUXEMBOURG ? [email protected] 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 ? [email protected] 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 ? [email protected] 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 ? [email protected] 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 ? [email protected] 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 ? [email protected] 2452462 - 62 AAAAAAAAODAAAAAA 821787 4700 28413 2451854 2451824 Mr. Matthew Brown Y 1 6 1973 KOREA, REPUBLIC OF ? [email protected] 2452319 - 63 AAAAAAAAPDAAAAAA 1790374 2445 9716 2450179 2450149 Dr. Frank Morton N 26 4 1943 EGYPT ? [email protected] 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. ? [email protected] 2452353 - 66 AAAAAAAACEAAAAAA 747190 6036 42882 2449294 2449264 Ms. Julie Chester N 8 9 1950 HONG KONG ? [email protected] 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 ? [email protected] 2452342 - 71 AAAAAAAAHEAAAAAA 1292064 2257 42450 2450248 2450218 Mr. Roderick Rogers N 4 11 1967 OMAN ? [email protected] 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 ? [email protected] 2452489 - 74 AAAAAAAAKEAAAAAA 1434225 347 15269 2452641 2452611 Sir Eric Woods Y 19 2 1953 SAINT LUCIA ? [email protected] 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 ? [email protected] 2452430 - 77 AAAAAAAANEAAAAAA 915180 2167 37154 2451632 2451602 Dr. Darrin Smith N 30 5 1931 UNITED STATES ? [email protected] 2452355 - 78 AAAAAAAAOEAAAAAA 1092537 3677 7264 2449388 2449358 Ms. Wanda Davis N 11 5 1940 NETHERLANDS ANTILLES ? [email protected] 2452339 - 79 AAAAAAAAPEAAAAAA 389494 3493 9539 2450863 2450833 Miss Sandi Tran Y 10 6 1937 FRENCH GUIANA ? [email protected] 2452644 - 80 AAAAAAAAAFAAAAAA 1499808 3891 44727 2450558 2450528 Mrs. Eleanor Evans N 21 12 1948 C�TE D'IVOIRE ? [email protected] 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 ? [email protected] 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 ? [email protected] 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 ? [email protected] 2452403 - 89 AAAAAAAAJFAAAAAA 694848 5383 26318 2451425 2451395 Mrs. Helen Macdonald Y 15 3 1981 DOMINICA ? [email protected] 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 ? [email protected] 2452294 - 93 AAAAAAAANFAAAAAA 647375 6229 35836 2449341 2449311 Sir Clyde Williams N 6 10 1927 FRENCH POLYNESIA ? [email protected] 2452510 - 94 AAAAAAAAOFAAAAAA 451893 1990 33287 2449553 2449523 Mr. Craig Byrd Y 14 5 1982 FRENCH POLYNESIA ? [email protected] 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 ? [email protected] 2452395 - 97 AAAAAAAABGAAAAAA 418763 102 49041 2452467 2452437 Mr. Stewart Ruffin Y 19 5 1971 MYANMAR ? [email protected] 2452528 - 98 AAAAAAAACGAAAAAA 574977 1615 43853 2450894 2450864 Dr. David Lewis N 23 6 1965 KIRIBATI ? [email protected] 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 [email protected] 2452318 + 3 AAAAAAAADAAAAAAA 1473522 6247 48572 2449130 2449100 Miss Latisha Hamilton N 18 9 1979 NIUE [email protected] 2452313 + 4 AAAAAAAAEAAAAAAA 1703214 3986 39558 2450030 2450000 Dr. Michael White N 7 6 1983 MEXICO [email protected] 2452361 + 5 AAAAAAAAFAAAAAAA 953372 4470 36368 2449438 2449408 Sir Robert Moran N 8 5 1956 FIJI [email protected] 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 [email protected] 2452360 + 8 AAAAAAAAIAAAAAAA 1215897 2471 16598 2449406 2449376 Sir Ollie Shipman N 26 12 1938 KOREA, REPUBLIC OF [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 2452454 + 18 AAAAAAAACBAAAAAA 1361151 6580 18456 2450041 2450011 Sir Brad Lynch Y 1 9 1950 URUGUAY [email protected] 2452549 + 19 AAAAAAAADBAAAAAA 1161742 4238 45581 2449580 2449550 Dr. Andre Moore N 20 10 1978 NICARAGUA [email protected] 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 [email protected] 2452529 + 23 AAAAAAAAHBAAAAAA ? 2107 686 2451012 2450982 Sir Garrison N ? 5 ? [email protected] + 24 AAAAAAAAIBAAAAAA 17113 1102 14291 2450098 2450068 Dr. Paul Morris Y 6 6 1951 GUINEA-BISSAU [email protected] 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 [email protected] 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�TE D'IVOIRE [email protected] 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 [email protected] 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 [email protected] 2452510 + 33 AAAAAAAABCAAAAAA 1680761 5823 32438 2451572 2451542 Mrs. Donna Betts Y 25 3 1958 FRANCE [email protected] 2452455 + 34 AAAAAAAACCAAAAAA ? ? 37501 2452192 2452162 Woods ? ? ? [email protected] 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 [email protected] 2452351 + 39 AAAAAAAAHCAAAAAA 1617182 4013 22844 2452131 2452101 Sir Neil Cox N 14 12 1951 ECUADOR [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 2452586 + 48 AAAAAAAAADAAAAAA 8817 311 38252 2449531 2449501 Ms. Jill Jackson N 15 9 1961 LUXEMBOURG [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 2452462 + 62 AAAAAAAAODAAAAAA 821787 4700 28413 2451854 2451824 Mr. Matthew Brown Y 1 6 1973 KOREA, REPUBLIC OF [email protected] 2452319 + 63 AAAAAAAAPDAAAAAA 1790374 2445 9716 2450179 2450149 Dr. Frank Morton N 26 4 1943 EGYPT [email protected] 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. [email protected] 2452353 + 66 AAAAAAAACEAAAAAA 747190 6036 42882 2449294 2449264 Ms. Julie Chester N 8 9 1950 HONG KONG [email protected] 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 [email protected] 2452342 + 71 AAAAAAAAHEAAAAAA 1292064 2257 42450 2450248 2450218 Mr. Roderick Rogers N 4 11 1967 OMAN [email protected] 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 [email protected] 2452489 + 74 AAAAAAAAKEAAAAAA 1434225 347 15269 2452641 2452611 Sir Eric Woods Y 19 2 1953 SAINT LUCIA [email protected] 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 [email protected] 2452430 + 77 AAAAAAAANEAAAAAA 915180 2167 37154 2451632 2451602 Dr. Darrin Smith N 30 5 1931 UNITED STATES [email protected] 2452355 + 78 AAAAAAAAOEAAAAAA 1092537 3677 7264 2449388 2449358 Ms. Wanda Davis N 11 5 1940 NETHERLANDS ANTILLES [email protected] 2452339 + 79 AAAAAAAAPEAAAAAA 389494 3493 9539 2450863 2450833 Miss Sandi Tran Y 10 6 1937 FRENCH GUIANA [email protected] 2452644 + 80 AAAAAAAAAFAAAAAA 1499808 3891 44727 2450558 2450528 Mrs. Eleanor Evans N 21 12 1948 C�TE D'IVOIRE [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 2452403 + 89 AAAAAAAAJFAAAAAA 694848 5383 26318 2451425 2451395 Mrs. Helen Macdonald Y 15 3 1981 DOMINICA [email protected] 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 [email protected] 2452294 + 93 AAAAAAAANFAAAAAA 647375 6229 35836 2449341 2449311 Sir Clyde Williams N 6 10 1927 FRENCH POLYNESIA [email protected] 2452510 + 94 AAAAAAAAOFAAAAAA 451893 1990 33287 2449553 2449523 Mr. Craig Byrd Y 14 5 1982 FRENCH POLYNESIA [email protected] 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 [email protected] 2452395 + 97 AAAAAAAABGAAAAAA 418763 102 49041 2452467 2452437 Mr. Stewart Ruffin Y 19 5 1971 MYANMAR [email protected] 2452528 + 98 AAAAAAAACGAAAAAA 574977 1615 43853 2450894 2450864 Dr. David Lewis N 23 6 1965 KIRIBATI [email protected] 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>
