| >> |
| >>set schema hive.hive; |
| |
| --- SQL operation complete. |
| >>cqd attempt_esp_parallelism 'off'; |
| |
| --- SQL operation complete. |
| >> |
| >>cqd hive_max_esps '1'; |
| |
| --- SQL operation complete. |
| >>cqd PARALLEL_NUM_ESPS '1'; |
| |
| --- SQL operation complete. |
| >>cqd parallel_num_esps '1'; |
| |
| --- SQL operation complete. |
| >> |
| >>cqd HIVE_MAX_STRING_LENGTH_IN_BYTES '25' ; |
| |
| --- SQL operation complete. |
| >>cqd mode_seahive 'ON'; |
| |
| --- SQL operation complete. |
| >> |
| >>select [first 100] * from hive.ins_customer order by c_customer_sk; |
| |
| 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ÔTE 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ÔTE 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; |
| |
| P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK P_COST P_RESPONSE_TARGET P_PROMO_NAME P_CHANNEL_DMAIL P_CHANNEL_EMAIL P_CHANNEL_CATALOG P_CHANNEL_TV P_CHANNEL_RADIO P_CHANNEL_PRESS P_CHANNEL_EVENT P_CHANNEL_DEMO P_CHANNEL_DETAILS P_PURPOSE P_DISCOUNT_ACTIVE |
| ----------- ------------------------- --------------- ------------- ----------- --------------- ----------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- |
| |
| 1 AAAAAAAABAAAAAAA 2450164 2450185 10022 1.0000000E+003 1 ought Y N N N N N N N Men will not say merely. Unknown N |
| 2 AAAAAAAACAAAAAAA 2450118 2450150 2410 1.0000000E+003 1 able Y N N N N N N N So willing buildings coul Unknown N |
| 3 AAAAAAAADAAAAAAA 2450675 2450712 10843 1.0000000E+003 1 pri Y N N N N N N N Companies shall not pr Unknown N |
| 4 AAAAAAAAEAAAAAAA 2450633 2450646 9794 1.0000000E+003 1 ese N N N N N N N N High, good shoulders can Unknown N |
| 5 AAAAAAAAFAAAAAAA 2450347 2450357 6655 1.0000000E+003 1 anti N N N N N N N N Huge, competent structure Unknown N |
| 6 AAAAAAAAGAAAAAAA 2450516 2450561 9464 1.0000000E+003 1 cally N N N N N N N N Boards might not reverse Unknown N |
| 7 AAAAAAAAHAAAAAAA 2450123 2450132 14527 1.0000000E+003 1 ation N N N N N N N N Effects used to prefer ho Unknown N |
| 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 |
| 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 |
| 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 |
| 19 AAAAAAAADBAAAAAA 2450623 2450640 5185 1.0000000E+003 1 n st N N N N N N N N Young families act. Most Unknown N |
| 20 AAAAAAAAEBAAAAAA 2450531 2450545 17860 1.0000000E+003 1 bar Y N N N N N N N Usually common courses fi Unknown N |
| 21 AAAAAAAAFBAAAAAA 2450895 2450904 3632 1.0000000E+003 1 ought N N N N N N N N British tensions should n Unknown N |
| 22 AAAAAAAAGBAAAAAA 2450596 2450629 8044 1.0000000E+003 1 able Y N N N N N N N Powers ought to allow to Unknown N |
| 23 AAAAAAAAHBAAAAAA 2450478 2450493 4321 1.0000000E+003 1 pri N N N N N N N N As main privileges cannot Unknown N |
| 24 AAAAAAAAIBAAAAAA 2450719 2450773 12004 1.0000000E+003 1 ese Y N N N N N N N Words appear technical, c Unknown N |
| 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 |
| 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 |
| 32 AAAAAAAAACAAAAAA 2450132 2450178 4184 1.0000000E+003 1 able Y N N N N N N N Bad matters offer und Unknown N |
| 33 AAAAAAAABCAAAAAA 2450483 2450485 9607 1.0000000E+003 1 pri N N N N N N N N Post-war subjects add pos Unknown N |
| 34 AAAAAAAACCAAAAAA 2450584 2450610 1652 1.0000000E+003 1 ese N N N N N N N N Strong cells could dis Unknown N |
| 35 AAAAAAAADCAAAAAA 2450890 2450912 15751 1.0000000E+003 1 anti Y N N N N N N N Ideas register hence used Unknown N |
| 36 AAAAAAAAECAAAAAA 2450577 2450605 1418 1.0000000E+003 1 cally N N N N N N N N Companies might stay Unknown N |
| 37 AAAAAAAAFCAAAAAA 2450609 2450669 4202 1.0000000E+003 1 ation Y N N N N N N N Studies make little just Unknown N |
| 38 AAAAAAAAGCAAAAAA 2450542 2450593 4222 1.0000000E+003 1 eing Y N N N N N N N Exercises would not conta Unknown N |
| 39 AAAAAAAAHCAAAAAA 2450575 2450580 14990 1.0000000E+003 1 n st N N N N N N N N Further final words must Unknown N |
| 40 AAAAAAAAICAAAAAA 2450125 2450158 17209 1.0000000E+003 1 bar N N N N N N N N Deaf, tall members create Unknown N |
| 41 AAAAAAAAJCAAAAAA 2450694 2450719 17384 1.0000000E+003 1 ought Y N N N N N N N There main cards try resu Unknown N |
| 42 AAAAAAAAKCAAAAAA 2450320 2450334 4166 1.0000000E+003 1 able Y N N N N N N N Good, very problems might Unknown N |
| 43 AAAAAAAALCAAAAAA 2450704 2450738 10000 1.0000000E+003 1 pri N N N N N N N N Probably typical eyes mig Unknown N |
| 44 AAAAAAAAMCAAAAAA 2450469 2450481 14440 1.0000000E+003 1 ese N N N N N N N N Roads would not grasp vit Unknown N |
| 45 AAAAAAAANCAAAAAA 2450327 2450360 5660 1.0000000E+003 1 anti N N N N N N N N Wrong, popular issues oug Unknown N |
| 46 AAAAAAAAOCAAAAAA 2450776 2450828 3271 1.0000000E+003 1 cally Y N N N N N N N Warm decisions could not Unknown N |
| 47 AAAAAAAAPCAAAAAA 2450196 2450200 5689 1.0000000E+003 1 ation N N N N N N N N Large, general points des Unknown N |
| 48 AAAAAAAAADAAAAAA 2450783 2450807 3955 1.0000000E+003 1 eing N N N N N N N N Losses must suspect fu Unknown N |
| 49 AAAAAAAABDAAAAAA 2450254 2450289 16123 1.0000000E+003 1 n st N N N N N N N N Then particular farms att Unknown N |
| 50 AAAAAAAACDAAAAAA 2450799 2450806 8722 1.0000000E+003 1 bar Y N N N N N N N Favorite, united sales ca Unknown N |
| 51 AAAAAAAADDAAAAAA 2450401 2450438 11288 1.0000000E+003 1 ought Y N N N N N N N Now liberal characteristi Unknown N |
| 52 AAAAAAAAEDAAAAAA 2450272 2450320 3280 1.0000000E+003 1 able Y N N N N N N N Authorities must pursue f Unknown N |
| 53 AAAAAAAAFDAAAAAA 2450794 2450798 13370 1.0000000E+003 1 pri N N N N N N N N Free hospitals cannot giv Unknown N |
| 54 AAAAAAAAGDAAAAAA 2450687 2450702 17707 1.0000000E+003 1 ese N N N N N N N N Claims would not avoid. A Unknown N |
| 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 |
| 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 |
| 62 AAAAAAAAODAAAAAA 2450296 2450342 356 1.0000000E+003 1 able Y N N N N N N N Only prepared minutes see Unknown N |
| 63 AAAAAAAAPDAAAAAA 2450248 2450295 3715 1.0000000E+003 1 pri Y N N N N N N N Likely, permanent rights Unknown N |
| 64 AAAAAAAAAEAAAAAA 2450498 2450519 1867 1.0000000E+003 1 ese N N N N N N N N Costs would not operate; Unknown N |
| 65 AAAAAAAABEAAAAAA 2450775 2450816 3740 1.0000000E+003 1 anti Y N N N N N N N Usually local days beg Unknown N |
| 66 AAAAAAAACEAAAAAA 2450486 2450504 4886 1.0000000E+003 1 cally Y N N N N N N N Yet unaware methods used Unknown N |
| 67 AAAAAAAADEAAAAAA 2450262 2450314 6724 1.0000000E+003 1 ation Y N N N N N N N Statutory states will not Unknown N |
| 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 |
| 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 |
| 75 AAAAAAAALEAAAAAA 2450241 2450257 7630 1.0000000E+003 1 anti Y N N N N N N N Sudden weeks dwell for in Unknown N |
| 76 AAAAAAAAMEAAAAAA 2450363 2450381 295 1.0000000E+003 1 cally Y N N N N N N N Other, secondary interest Unknown N |
| 77 AAAAAAAANEAAAAAA 2450711 2450736 3343 1.0000000E+003 1 ation Y N N N N N N N Characters translate hith Unknown N |
| 78 AAAAAAAAOEAAAAAA 2450454 2450513 5356 1.0000000E+003 1 eing Y N N N N N N N Standard studies arise as Unknown N |
| 79 AAAAAAAAPEAAAAAA 2450474 2450497 3736 1.0000000E+003 1 n st N N N N N N N N Devices might not produce Unknown N |
| 80 AAAAAAAAAFAAAAAA 2450891 2450910 4148 1.0000000E+003 1 bar N N N N N N N N Roles might not seem ever Unknown N |
| 81 AAAAAAAABFAAAAAA 2450235 2450283 4010 1.0000000E+003 1 ought N N N N N N N N Accused, dual women must Unknown N |
| 82 AAAAAAAACFAAAAAA 2450685 2450718 12373 1.0000000E+003 1 able Y N N N N N N N Economic, subject matters Unknown N |
| 83 AAAAAAAADFAAAAAA 2450175 2450235 10738 1.0000000E+003 1 pri N N N N N N N N Original, huge projects Unknown N |
| 84 AAAAAAAAEFAAAAAA 2450900 2450954 16621 1.0000000E+003 1 ese Y N N N N N N N Houses watch machine Unknown N |
| 85 AAAAAAAAFFAAAAAA 2450696 2450706 16894 1.0000000E+003 1 anti Y N N N N N N N Only red systems ring rig Unknown N |
| 86 AAAAAAAAGFAAAAAA 2450745 2450787 11761 1.0000000E+003 1 cally Y N N N N N N N Incentives could not look Unknown N |
| 87 AAAAAAAAHFAAAAAA 2450712 2450730 16600 1.0000000E+003 1 ation N N N N N N N N Numbers drive however. Ye Unknown N |
| 88 AAAAAAAAIFAAAAAA 2450102 2450151 12728 1.0000000E+003 1 eing N N N N N N N N Chosen players try foreig Unknown N |
| 89 AAAAAAAAJFAAAAAA 2450649 2450658 8566 1.0000000E+003 1 n st Y N N N N N N N Cultural, obvious constra Unknown N |
| 90 AAAAAAAAKFAAAAAA 2450587 2450615 8527 1.0000000E+003 1 bar Y N N N N N N N Labour children replace t Unknown N |
| 91 AAAAAAAALFAAAAAA 2450723 2450742 2326 1.0000000E+003 1 ought Y N N N N N N N Other, standard pupils go Unknown N |
| 92 AAAAAAAAMFAAAAAA 2450737 2450748 13580 1.0000000E+003 1 able N N N N N N N N Jobs may not train equall Unknown N |
| 93 AAAAAAAANFAAAAAA 2450125 2450154 4790 1.0000000E+003 1 pri Y N N N N N N N Monthly ambitions convey Unknown N |
| 94 AAAAAAAAOFAAAAAA 2450567 2450598 28 1.0000000E+003 1 ese N N N N N N N N Small ladies shall wear s Unknown N |
| 95 AAAAAAAAPFAAAAAA 2450370 2450397 199 1.0000000E+003 1 anti N N N N N N N N Long travellers ought to Unknown N |
| 96 AAAAAAAAAGAAAAAA 2450710 2450752 16226 1.0000000E+003 1 cally Y N N N N N N N Little new boys wear only Unknown N |
| 97 AAAAAAAABGAAAAAA 2450660 2450685 16952 1.0000000E+003 1 ation Y N N N N N N N New, severe employee Unknown N |
| 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 |
| 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 |
| 105 AAAAAAAAJGAAAAAA 2450873 2450912 14182 1.0000000E+003 1 anti Y N N N N N N N Other definitions prevent Unknown N |
| 106 AAAAAAAAKGAAAAAA 2450858 2450872 3754 1.0000000E+003 1 cally N N N N N N N N Long large problems shoul Unknown N |
| 107 AAAAAAAALGAAAAAA 2450749 2450758 10574 1.0000000E+003 1 ation Y N N N N N N N Good, foreign problems wi Unknown N |
| 108 AAAAAAAAMGAAAAAA 2450224 2450257 274 1.0000000E+003 1 eing Y N N N N N N N High, tiny sides may pay Unknown N |
| 109 AAAAAAAANGAAAAAA 2450455 2450467 8302 1.0000000E+003 1 n st Y N N N N N N N Reasonable posts become f Unknown N |
| 110 AAAAAAAAOGAAAAAA 2450852 2450905 15568 1.0000000E+003 1 bar N N N N N N N N Huge, european users reve Unknown N |
| 111 AAAAAAAAPGAAAAAA 2450758 2450816 2462 1.0000000E+003 1 ought Y N N N N N N N Huge, early keys come gre Unknown N |
| 112 AAAAAAAAAHAAAAAA 2450870 2450916 7640 1.0000000E+003 1 able N N N N N N N N Greek, young minutes will Unknown N |
| 113 AAAAAAAABHAAAAAA 2450226 2450276 13916 1.0000000E+003 1 pri Y N N N N N N N Warm hands know as much s Unknown N |
| 114 AAAAAAAACHAAAAAA 2450687 2450720 13507 1.0000000E+003 1 ese N N N N N N N N New, necessary kilometres Unknown N |
| 115 AAAAAAAADHAAAAAA 2450727 2450751 15002 1.0000000E+003 1 anti N N N N N N N N Personal wounds see sec Unknown N |
| 116 AAAAAAAAEHAAAAAA 2450352 2450361 9187 1.0000000E+003 1 cally N N N N N N N N Bad, close tories could n Unknown N |
| 117 AAAAAAAAFHAAAAAA 2450285 2450308 8854 1.0000000E+003 1 ation Y N N N N N N N Extreme centres will lear Unknown N |
| 118 AAAAAAAAGHAAAAAA 2450460 2450471 7183 1.0000000E+003 1 eing N N N N N N N N Very proposed pressures s Unknown N |
| 119 AAAAAAAAHHAAAAAA 2450224 2450236 13903 1.0000000E+003 1 n st Y N N N N N N N Similar ideas go origin Unknown N |
| 120 AAAAAAAAIHAAAAAA 2450302 2450341 5578 1.0000000E+003 1 bar N N N N N N N N Children shall come Unknown N |
| 121 AAAAAAAAJHAAAAAA 2450752 2450769 1648 1.0000000E+003 1 ought N N N N N N N N Essentially nervous cells Unknown N |
| 122 AAAAAAAAKHAAAAAA 2450422 2450452 6778 1.0000000E+003 1 able Y N N N N N N N In order certain estates Unknown N |
| 123 AAAAAAAALHAAAAAA 2450628 2450673 2132 1.0000000E+003 1 pri N N N N N N N N English, other followers Unknown N |
| 124 AAAAAAAAMHAAAAAA 2450517 2450565 7051 1.0000000E+003 1 ese Y N N N N N N N Institutional, new men us Unknown N |
| 125 AAAAAAAANHAAAAAA 2450704 2450719 6439 1.0000000E+003 1 anti N N N N N N N N Societies would justify t Unknown N |
| 126 AAAAAAAAOHAAAAAA 2450840 2450852 7039 1.0000000E+003 1 cally Y N N N N N N N Drivers could overcome mo Unknown N |
| 127 AAAAAAAAPHAAAAAA 2450802 2450836 13510 1.0000000E+003 1 ation N N N N N N N N Now obvious players make Unknown N |
| 128 AAAAAAAAAIAAAAAA 2450373 2450398 9080 1.0000000E+003 1 eing N N N N N N N N Too possible curtains sto Unknown N |
| 129 AAAAAAAABIAAAAAA 2450357 2450373 614 1.0000000E+003 1 n st Y N N N N N N N Comments can release stil Unknown N |
| 130 AAAAAAAACIAAAAAA 2450219 2450236 13598 1.0000000E+003 1 bar Y N N N N N N N Years arrange just to the Unknown N |
| 131 AAAAAAAADIAAAAAA 2450305 2450313 3793 1.0000000E+003 1 ought Y N N N N N N N Unable children cannot an Unknown N |
| 132 AAAAAAAAEIAAAAAA 2450231 2450240 4219 1.0000000E+003 1 able N N N N N N N N Warm, blue officers s Unknown N |
| 133 AAAAAAAAFIAAAAAA 2450587 2450593 854 1.0000000E+003 1 pri Y N N N N N N N Charming, negative houses Unknown N |
| 134 AAAAAAAAGIAAAAAA 2450479 2450501 10922 1.0000000E+003 1 ese N N N N N N N N Skills can say very days. Unknown N |
| 135 AAAAAAAAHIAAAAAA 2450607 2450624 9748 1.0000000E+003 1 anti N N N N N N N N Officers will allow sig Unknown N |
| 136 AAAAAAAAIIAAAAAA 2450701 2450710 13849 1.0000000E+003 1 cally N N N N N N N N Mountains would want just Unknown N |
| 137 AAAAAAAAJIAAAAAA 2450123 2450177 15872 1.0000000E+003 1 ation N N N N N N N N Finally capable rates wil Unknown N |
| 138 AAAAAAAAKIAAAAAA 2450758 2450760 12814 1.0000000E+003 1 eing Y N N N N N N N So reasonable wages know Unknown N |
| 139 AAAAAAAALIAAAAAA 2450365 2450383 5882 1.0000000E+003 1 n st N N N N N N N N Then relevant changes tak Unknown N |
| 140 AAAAAAAAMIAAAAAA 2450655 2450708 12968 1.0000000E+003 1 bar N N N N N N N N Tiny days must feel kinds Unknown N |
| 141 AAAAAAAANIAAAAAA 2450301 2450353 13100 1.0000000E+003 1 ought Y N N N N N N N As political structures Unknown N |
| 142 AAAAAAAAOIAAAAAA 2450358 2450385 12956 1.0000000E+003 1 able Y N N N N N N N Well female movements wan Unknown N |
| 143 AAAAAAAAPIAAAAAA 2450828 2450854 13006 1.0000000E+003 1 pri N N N N N N N N Hands sink good social ne Unknown N |
| 144 AAAAAAAAAJAAAAAA 2450780 2450830 15688 1.0000000E+003 1 ese N N N N N N N N Reasonably social imports Unknown N |
| 145 AAAAAAAABJAAAAAA 2450715 2450756 10406 1.0000000E+003 1 anti N N N N N N N N Sorry, unlikely practitio Unknown N |
| 146 AAAAAAAACJAAAAAA 2450200 2450236 8119 1.0000000E+003 1 cally Y N N N N N N N Direct, added regions cou Unknown N |
| 147 AAAAAAAADJAAAAAA 2450767 2450827 15925 1.0000000E+003 1 ation N N N N N N N N Years project groups; soc Unknown N |
| 148 AAAAAAAAEJAAAAAA 2450291 2450345 11275 1.0000000E+003 1 eing Y N N N N N N N Just wrong samples streng Unknown N |
| 149 AAAAAAAAFJAAAAAA 2450739 2450797 17719 1.0000000E+003 1 n st Y N N N N N N N Public fields may clear. Unknown N |
| 150 AAAAAAAAGJAAAAAA 2450860 2450915 9578 1.0000000E+003 1 bar Y N N N N N N N Nearby figures would run Unknown N |
| 151 AAAAAAAAHJAAAAAA 2450707 2450751 4408 1.0000000E+003 1 ought N N N N N N N N Much financial centuries Unknown N |
| 152 AAAAAAAAIJAAAAAA 2450564 2450573 2314 1.0000000E+003 1 able N N N N N N N N Over dependent topics mus Unknown N |
| 153 AAAAAAAAJJAAAAAA 2450712 2450725 16514 1.0000000E+003 1 pri N N N N N N N N Organisations make altoge Unknown N |
| 154 AAAAAAAAKJAAAAAA 2450869 2450898 2674 1.0000000E+003 1 ese Y N N N N N N N Following, current matter Unknown N |
| 155 AAAAAAAALJAAAAAA 2450409 2450419 202 1.0000000E+003 1 anti N N N N N N N N Expectations stop exactly Unknown N |
| 156 AAAAAAAAMJAAAAAA 2450681 2450732 7975 1.0000000E+003 1 cally Y N N N N N N N Executive, poor jobs look Unknown N |
| 157 AAAAAAAANJAAAAAA 2450389 2450445 6079 1.0000000E+003 1 ation Y N N N N N N N Certainly pleasant featur Unknown N |
| 158 AAAAAAAAOJAAAAAA 2450350 2450390 17863 1.0000000E+003 1 eing N N N N N N N N Levels must not trans Unknown N |
| 159 AAAAAAAAPJAAAAAA 2450682 2450700 58 1.0000000E+003 1 n st Y N N N N N N N Regional schemes would de Unknown N |
| 160 AAAAAAAAAKAAAAAA 2450583 2450642 13144 1.0000000E+003 1 bar N N N N N N N N Blocks generate still on Unknown N |
| 161 AAAAAAAABKAAAAAA 2450900 2450955 680 1.0000000E+003 1 ought Y N N N N N N N Concepts might live of co Unknown N |
| 162 AAAAAAAACKAAAAAA 2450532 2450557 11194 1.0000000E+003 1 able N N N N N N N N Once short boots please; Unknown N |
| 163 AAAAAAAADKAAAAAA 2450102 2450142 5038 1.0000000E+003 1 pri Y N N N N N N N Glasses tell even as tigh Unknown N |
| 164 AAAAAAAAEKAAAAAA 2450423 2450453 17593 1.0000000E+003 1 ese Y N N N N N N N Available, blue hours exp Unknown N |
| 165 AAAAAAAAFKAAAAAA 2450854 2450894 3166 1.0000000E+003 1 anti Y N N N N N N N Over responsible demonstr Unknown N |
| 166 AAAAAAAAGKAAAAAA 2450365 2450383 6652 1.0000000E+003 1 cally N N N N N N N N Others matter serious cat Unknown N |
| 167 AAAAAAAAHKAAAAAA 2450648 2450651 3922 1.0000000E+003 1 ation Y N N N N N N N Urban abilities would Unknown N |
| 168 AAAAAAAAIKAAAAAA 2450271 2450331 17422 1.0000000E+003 1 eing N N N N N N N N Slightly technical dut Unknown N |
| 169 AAAAAAAAJKAAAAAA 2450716 2450774 1726 1.0000000E+003 1 n st Y N N N N N N N Great chapters would move Unknown N |
| 170 AAAAAAAAKKAAAAAA 2450702 2450724 17498 1.0000000E+003 1 bar Y N N N N N N N Alternatives induce very Unknown N |
| 171 AAAAAAAALKAAAAAA 2450635 2450642 5383 1.0000000E+003 1 ought N N N N N N N N Needs count from a se Unknown N |
| 172 AAAAAAAAMKAAAAAA 2450735 2450785 10030 1.0000000E+003 1 able Y N N N N N N N Complete decisions would Unknown N |
| 173 AAAAAAAANKAAAAAA 2450172 2450199 12698 1.0000000E+003 1 pri N N N N N N N N Constitutional materials Unknown N |
| 174 AAAAAAAAOKAAAAAA 2450463 2450474 17428 1.0000000E+003 1 ese Y N N N N N N N Young, funny lines shall Unknown N |
| 175 AAAAAAAAPKAAAAAA 2450675 2450704 6982 1.0000000E+003 1 anti Y N N N N N N N Signs hear moreover natio Unknown N |
| 176 AAAAAAAAALAAAAAA 2450487 2450498 16496 1.0000000E+003 1 cally N N N N N N N N Only british areas unders Unknown N |
| 177 AAAAAAAABLAAAAAA 2450729 2450733 4483 1.0000000E+003 1 ation N N N N N N N N Models would love high t Unknown N |
| 178 AAAAAAAACLAAAAAA 2450345 2450392 15134 1.0000000E+003 1 eing Y N N N N N N N Right obvious pounds coul Unknown N |
| 179 AAAAAAAADLAAAAAA 2450230 2450281 12496 1.0000000E+003 1 n st Y N N N N N N N Left, encouraging bi Unknown N |
| 180 AAAAAAAAELAAAAAA 2450471 2450484 12517 1.0000000E+003 1 bar Y N N N N N N N Significant children se Unknown N |
| 181 AAAAAAAAFLAAAAAA 2450649 2450673 11653 1.0000000E+003 1 ought Y N N N N N N N Away due moments will not Unknown N |
| 182 AAAAAAAAGLAAAAAA 2450703 2450731 2734 1.0000000E+003 1 able Y N N N N N N N Other, full members fin Unknown N |
| 183 AAAAAAAAHLAAAAAA 2450777 2450824 2420 1.0000000E+003 1 pri N N N N N N N N Increases could not buy s Unknown N |
| 184 AAAAAAAAILAAAAAA 2450241 2450300 12238 1.0000000E+003 1 ese N N N N N N N N Favourably visible childr Unknown N |
| 185 AAAAAAAAJLAAAAAA 2450688 2450702 15091 1.0000000E+003 1 anti N N N N N N N N Fingers help monthly, onl Unknown N |
| 186 AAAAAAAAKLAAAAAA 2450627 2450643 5512 1.0000000E+003 1 cally N N N N N N N N Effectively appropriate e Unknown N |
| 187 AAAAAAAALLAAAAAA 2450484 2450530 4798 1.0000000E+003 1 ation Y N N N N N N N Enough detailed months tr Unknown N |
| 188 AAAAAAAAMLAAAAAA 2450385 2450413 14246 1.0000000E+003 1 eing Y N N N N N N N Machines open only unique Unknown N |
| 189 AAAAAAAANLAAAAAA 2450420 2450456 12550 1.0000000E+003 1 n st N N N N N N N N Junior activities discove Unknown N |
| 190 AAAAAAAAOLAAAAAA 2450512 2450563 15151 1.0000000E+003 1 bar Y N N N N N N N Customers live now. Syste Unknown N |
| 191 AAAAAAAAPLAAAAAA 2450126 2450160 7993 1.0000000E+003 1 ought Y N N N N N N N Experiences must not win Unknown N |
| 192 AAAAAAAAAMAAAAAA 2450556 2450573 3026 1.0000000E+003 1 able N N N N N N N N Days come for a quarters. Unknown N |
| 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 |
| 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 |
| 200 AAAAAAAAIMAAAAAA 2450215 2450237 12784 1.0000000E+003 1 bar N N N N N N N N Arts attend. Further iris Unknown N |
| 201 AAAAAAAAJMAAAAAA 2450464 2450499 3445 1.0000000E+003 1 ought N N N N N N N N Square, unusual years ere Unknown N |
| 202 AAAAAAAAKMAAAAAA 2450913 2450922 3883 1.0000000E+003 1 able Y N N N N N N N Strong, traditional paren Unknown N |
| 203 AAAAAAAALMAAAAAA 2450337 2450365 17569 1.0000000E+003 1 pri Y N N N N N N N Completely brave charges Unknown N |
| 204 AAAAAAAAMMAAAAAA 2450692 2450736 1564 1.0000000E+003 1 ese Y N N N N N N N Sideways numerous departm Unknown N |
| 205 AAAAAAAANMAAAAAA 2450133 2450160 9889 1.0000000E+003 1 anti Y N N N N N N N Little hot conditions loo Unknown N |
| 206 AAAAAAAAOMAAAAAA 2450715 2450733 9829 1.0000000E+003 1 cally Y N N N N N N N Final workers resign. Now Unknown N |
| 207 AAAAAAAAPMAAAAAA 2450699 2450704 4273 1.0000000E+003 1 ation Y N N N N N N N Economic, professional mo Unknown N |
| 208 AAAAAAAAANAAAAAA 2450420 2450464 5348 1.0000000E+003 1 eing Y N N N N N N N Heavy, main circumstances Unknown N |
| 209 AAAAAAAABNAAAAAA 2450563 2450580 3430 1.0000000E+003 1 n st N N N N N N N N Hours open similarly inte Unknown N |
| 210 AAAAAAAACNAAAAAA 2450847 2450892 7411 1.0000000E+003 1 bar Y N N N N N N N So new sports will not di Unknown N |
| 211 AAAAAAAADNAAAAAA 2450646 2450649 7508 1.0000000E+003 1 ought Y N N N N N N N Public, running ladies l Unknown N |
| 212 AAAAAAAAENAAAAAA 2450781 2450834 10768 1.0000000E+003 1 able N N N N N N N N Good decades take. Proper Unknown N |
| 213 AAAAAAAAFNAAAAAA 2450403 2450415 6350 1.0000000E+003 1 pri Y N N N N N N N However powerful critics Unknown N |
| 214 AAAAAAAAGNAAAAAA ? 2450779 ? 1.0000000E+003 ? N N N Pupils will meet military Unknown N |
| 215 AAAAAAAAHNAAAAAA 2450235 2450252 5840 1.0000000E+003 1 anti Y N N N N N N N Apparent, experienced bom Unknown N |
| 216 AAAAAAAAINAAAAAA 2450885 2450898 13504 1.0000000E+003 1 cally N N N N N N N N Large, necessary cars sup Unknown N |
| 217 AAAAAAAAJNAAAAAA 2450265 2450316 466 1.0000000E+003 1 ation N N N N N N N N Also splendid terms enter Unknown N |
| 218 AAAAAAAAKNAAAAAA 2450443 2450490 17338 1.0000000E+003 1 eing N N N N N N N N Great texts will blow; mo Unknown N |
| 219 AAAAAAAALNAAAAAA 2450821 2450859 12662 1.0000000E+003 1 n st N N N N N N N N Briefly old records must Unknown N |
| 220 AAAAAAAAMNAAAAAA 2450857 2450907 17108 1.0000000E+003 1 bar N N N N N N N N Also long refugees interp Unknown N |
| 221 AAAAAAAANNAAAAAA 2450134 2450182 2863 1.0000000E+003 1 ought N N N N N N N N Probable, available categ Unknown N |
| 222 AAAAAAAAONAAAAAA 2450336 2450378 122 1.0000000E+003 1 able Y N N N N N N N Ways help. Everywhere ma Unknown N |
| 223 AAAAAAAAPNAAAAAA 2450671 2450721 11452 1.0000000E+003 1 pri N N N N N N N N Earlier traditional group Unknown N |
| 224 AAAAAAAAAOAAAAAA 2450135 2450140 13534 1.0000000E+003 1 ese Y N N N N N N N Then general preferences Unknown N |
| 225 AAAAAAAABOAAAAAA ? 2450434 6514 1.0000000E+003 ? anti N N Actual, very words used t |
| 226 AAAAAAAACOAAAAAA 2450436 2450468 2848 1.0000000E+003 1 cally N N N N N N N N Signs must drink certainl Unknown N |
| 227 AAAAAAAADOAAAAAA 2450751 2450794 3697 1.0000000E+003 1 ation N N N N N N N N Arms can find social, gre Unknown N |
| 228 AAAAAAAAEOAAAAAA 2450337 2450354 11678 1.0000000E+003 1 eing Y N N N N N N N Most basic walls used to Unknown N |
| 229 AAAAAAAAFOAAAAAA 2450146 2450188 10486 1.0000000E+003 1 n st N N N N N N N N Ships make never netwo Unknown N |
| 230 AAAAAAAAGOAAAAAA 2450741 2450758 17480 1.0000000E+003 1 bar Y N N N N N N N References remember ago o Unknown N |
| 231 AAAAAAAAHOAAAAAA 2450177 2450186 13843 1.0000000E+003 1 ought Y N N N N N N N Christians used to arr Unknown N |
| 232 AAAAAAAAIOAAAAAA 2450769 2450822 15055 1.0000000E+003 1 able N N N N N N N N Travellers soak very cont Unknown N |
| 233 AAAAAAAAJOAAAAAA 2450318 2450369 1094 1.0000000E+003 1 pri Y N N N N N N N Young, valuable companies Unknown N |
| 234 AAAAAAAAKOAAAAAA 2450299 2450354 15476 1.0000000E+003 1 ese Y N N N N N N N Inadequate christians can Unknown N |
| 235 AAAAAAAALOAAAAAA 2450877 2450918 4910 1.0000000E+003 1 anti Y N N N N N N N Bloody, useful universiti Unknown N |
| 236 AAAAAAAAMOAAAAAA 2450438 2450468 8095 1.0000000E+003 1 cally N N N N N N N N Months may not enjoy thin Unknown N |
| 237 AAAAAAAANOAAAAAA 2450731 2450791 6722 1.0000000E+003 1 ation Y N N N N N N N True, major criteria must Unknown N |
| 238 AAAAAAAAOOAAAAAA 2450498 2450510 10280 1.0000000E+003 1 eing N N N N N N N N Others deal both companie Unknown N |
| 239 AAAAAAAAPOAAAAAA 2450627 2450680 17362 1.0000000E+003 1 n st Y N N N N N N N Almost following strategi Unknown N |
| 240 AAAAAAAAAPAAAAAA 2450764 2450815 4874 1.0000000E+003 1 bar Y N N N N N N N Young, present friends ba Unknown N |
| 241 AAAAAAAABPAAAAAA 2450580 2450596 3916 1.0000000E+003 1 ought N N N N N N N N Other years support then Unknown N |
| 242 AAAAAAAACPAAAAAA 2450393 2450396 5467 1.0000000E+003 1 able Y N N N N N N N Just victorian flowers co Unknown N |
| 243 AAAAAAAADPAAAAAA 2450809 2450865 1576 1.0000000E+003 1 pri Y N N N N N N N Boys shall not rest meanw Unknown N |
| 244 AAAAAAAAEPAAAAAA 2450536 2450583 11725 1.0000000E+003 1 ese Y N N N N N N N Unusual, key areas might Unknown N |
| 245 AAAAAAAAFPAAAAAA 2450578 2450621 16075 1.0000000E+003 1 anti N N N N N N N N Alive substances can deci Unknown N |
| 246 AAAAAAAAGPAAAAAA 2450452 2450463 13315 1.0000000E+003 1 cally Y N N N N N N N However warm countries co Unknown N |
| 247 AAAAAAAAHPAAAAAA 2450100 2450145 12976 1.0000000E+003 1 ation Y N N N N N N N Therefore distinguished s Unknown N |
| 248 AAAAAAAAIPAAAAAA 2450824 2450853 12451 1.0000000E+003 1 eing N N N N N N N N Other facts ensure large Unknown N |
| 249 AAAAAAAAJPAAAAAA 2450467 2450523 4195 1.0000000E+003 1 n st Y N N N N N N N Wrong materials should no Unknown N |
| 250 AAAAAAAAKPAAAAAA 2450606 ? ? ? 1 N N N N Private, political materi Unknown |
| 251 AAAAAAAALPAAAAAA 2450150 2450181 9187 1.0000000E+003 1 ought N N N N N N N N Other quarters used to ke Unknown N |
| 252 AAAAAAAAMPAAAAAA 2450290 2450319 1292 1.0000000E+003 1 able N N N N N N N N Small characters could no Unknown N |
| 253 AAAAAAAANPAAAAAA 2450337 2450364 13351 1.0000000E+003 1 pri Y N N N N N N N Similar, true friends oug Unknown N |
| 254 AAAAAAAAOPAAAAAA 2450673 2450717 11371 1.0000000E+003 1 ese Y N N N N N N N Main designers will quali Unknown N |
| 255 AAAAAAAAPPAAAAAA 2450738 2450795 10129 1.0000000E+003 1 anti N N N N N N N N Welsh, distinct penalties Unknown N |
| 256 AAAAAAAAAABAAAAA 2450265 2450303 3058 1.0000000E+003 1 cally N N N N N N N N Police shall put seats. B Unknown N |
| 257 AAAAAAAABABAAAAA 2450789 2450821 8486 1.0000000E+003 1 ation N N N N N N N N Books expect internationa Unknown N |
| 258 AAAAAAAACABAAAAA 2450687 2450732 16892 1.0000000E+003 1 eing N N N N N N N N Uncomfortable, total righ Unknown N |
| 259 AAAAAAAADABAAAAA 2450293 2450335 11440 1.0000000E+003 1 n st Y N N N N N N N United rules recognise ac Unknown N |
| 260 AAAAAAAAEABAAAAA 2450430 2450485 13129 1.0000000E+003 1 bar Y N N N N N N N Phrases must wish just mo Unknown N |
| 261 AAAAAAAAFABAAAAA 2450243 2450268 14677 1.0000000E+003 1 ought N N N N N N N N Respectively similar chil Unknown N |
| 262 AAAAAAAAGABAAAAA 2450849 2450868 2876 1.0000000E+003 1 able N N N N N N N N Thus early wheels keep mo Unknown N |
| 263 AAAAAAAAHABAAAAA 2450383 2450396 2116 1.0000000E+003 1 pri Y N N N N N N N Public, old systems can p Unknown N |
| 264 AAAAAAAAIABAAAAA 2450311 2450352 16609 1.0000000E+003 1 ese Y N N N N N N N Other parts appear regul Unknown N |
| 265 AAAAAAAAJABAAAAA 2450225 2450236 8414 1.0000000E+003 1 anti Y N N N N N N N Ideal camps cannot stop f Unknown N |
| 266 AAAAAAAAKABAAAAA 2450408 2450412 6524 1.0000000E+003 1 cally N N N N N N N N Common changes assure gol Unknown N |
| 267 AAAAAAAALABAAAAA 2450750 2450776 17926 1.0000000E+003 1 ation Y N N N N N N N Premises sit in a terms. Unknown N |
| 268 AAAAAAAAMABAAAAA 2450424 2450445 7258 1.0000000E+003 1 eing N N N N N N N N Rather average details mu Unknown N |
| 269 AAAAAAAANABAAAAA 2450256 2450283 10297 1.0000000E+003 1 n st Y N N N N N N N Wide original seeds might Unknown N |
| 270 AAAAAAAAOABAAAAA 2450527 2450562 9244 1.0000000E+003 1 bar N N N N N N N N Adequate, able eyes shoul Unknown N |
| 271 AAAAAAAAPABAAAAA 2450356 2450378 12736 1.0000000E+003 1 ought Y N N N N N N N Never big houses should n Unknown N |
| 272 AAAAAAAAABBAAAAA 2450377 2450380 14524 1.0000000E+003 1 able N N N N N N N N British leaders could not Unknown N |
| 273 AAAAAAAABBBAAAAA 2450803 2450818 5138 1.0000000E+003 1 pri Y N N N N N N N Pupils take only years. C Unknown N |
| 274 AAAAAAAACBBAAAAA 2450649 2450705 3856 1.0000000E+003 1 ese Y N N N N N N N Little, other visits migh Unknown N |
| 275 AAAAAAAADBBAAAAA 2450853 2450861 2798 1.0000000E+003 1 anti N N N N N N N N Accountants reach especia Unknown N |
| 276 AAAAAAAAEBBAAAAA 2450196 2450210 5113 1.0000000E+003 1 cally N N N N N N N N Positive individuals may Unknown N |
| 277 AAAAAAAAFBBAAAAA 2450223 2450253 2581 1.0000000E+003 1 ation Y N N N N N N N Large, dead miles appear Unknown N |
| 278 AAAAAAAAGBBAAAAA 2450730 2450738 2842 1.0000000E+003 1 eing Y N N N N N N N Again bad tickets may fix Unknown N |
| 279 AAAAAAAAHBBAAAAA 2450609 2450642 10910 1.0000000E+003 1 n st N N N N N N N N Effectively related obser Unknown N |
| 280 AAAAAAAAIBBAAAAA 2450475 2450513 16424 1.0000000E+003 1 bar Y N N N N N N N Mutual tourists let so lo Unknown N |
| 281 AAAAAAAAJBBAAAAA 2450740 2450746 4213 1.0000000E+003 1 ought N N N N N N N N Crucial cars ought to hap Unknown N |
| 282 AAAAAAAAKBBAAAAA 2450659 2450702 11851 1.0000000E+003 1 able N N N N N N N N Inc, superior teeth avoid Unknown N |
| 283 AAAAAAAALBBAAAAA 2450757 2450786 2870 1.0000000E+003 1 pri N N N N N N N N Recent, able boys might t Unknown N |
| 284 AAAAAAAAMBBAAAAA 2450239 2450267 7066 1.0000000E+003 1 ese N N N N N N N N Over stupid guidelines kn Unknown N |
| 285 AAAAAAAANBBAAAAA 2450370 2450402 10982 1.0000000E+003 1 anti Y N N N N N N N Perhaps real customers sh Unknown N |
| 286 AAAAAAAAOBBAAAAA 2450728 2450747 17779 1.0000000E+003 1 cally N N N N N N N N Finally glad reasons mobi Unknown N |
| 287 AAAAAAAAPBBAAAAA 2450574 2450591 4568 1.0000000E+003 1 ation Y N N N N N N N Rules say well-known memb Unknown N |
| 288 AAAAAAAAACBAAAAA 2450539 2450578 1018 1.0000000E+003 1 eing N N N N N N N N Lively colleagues avoid o Unknown N |
| 289 AAAAAAAABCBAAAAA 2450415 2450423 9037 1.0000000E+003 1 n st N N N N N N N N Ways prevent at all used Unknown N |
| 290 AAAAAAAACCBAAAAA 2450375 2450415 16634 1.0000000E+003 1 bar N N N N N N N N In order industrial examp Unknown N |
| 291 AAAAAAAADCBAAAAA 2450646 2450653 10424 1.0000000E+003 1 ought N N N N N N N N Fresh, slow benefits hous Unknown N |
| 292 AAAAAAAAECBAAAAA 2450308 2450329 6548 1.0000000E+003 1 able Y N N N N N N N Sources discover words. T Unknown N |
| 293 AAAAAAAAFCBAAAAA 2450569 2450616 13009 1.0000000E+003 1 pri N N N N N N N N Miles might pay. Average, Unknown N |
| 294 AAAAAAAAGCBAAAAA 2450759 2450762 11704 1.0000000E+003 1 ese Y N N N N N N N Requests reappear as info Unknown N |
| 295 AAAAAAAAHCBAAAAA 2450889 2450944 8272 1.0000000E+003 1 anti Y N N N N N N N Safe women change old, Unknown N |
| 296 AAAAAAAAICBAAAAA 2450631 2450637 15518 1.0000000E+003 1 cally N N N N N N N N Loose, extensive bodies c Unknown N |
| 297 AAAAAAAAJCBAAAAA 2450217 2450250 5887 1.0000000E+003 1 ation Y N N N N N N N Eventually general women Unknown N |
| 298 AAAAAAAAKCBAAAAA 2450809 2450858 17287 1.0000000E+003 1 eing Y N N N N N N N Teeth could go standards. Unknown N |
| 299 AAAAAAAALCBAAAAA 2450783 2450836 1292 1.0000000E+003 1 n st Y N N N N N N N Women contrast never dear Unknown N |
| 300 AAAAAAAAMCBAAAAA 2450488 2450522 16879 1.0000000E+003 1 bar Y N N N N N N N Fine, british schools ple Unknown N |
| |
| --- 300 row(s) selected. |
| >>select [first 100] * from hive.ins_customer_address order by CA_ADDRESS_SK; |
| |
| CA_ADDRESS_SK CA_ADDRESS_ID CA_STREET_NUMBER CA_STREET_NAME CA_STREET_TYPE CA_SUITE_NUMBER CA_CITY CA_COUNTY CA_STATE CA_ZIP CA_COUNTRY CA_GMT_OFFSET CA_LOCATION_TYPE |
| ------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- --------------- ------------------------- |
| |
| 1 AAAAAAAABAAAAAAA 18 Jackson Parkway Suite 280 Fairfield Maricopa County AZ 86192 United States -7.0000000E+000 condo |
| 2 AAAAAAAACAAAAAAA 362 Washington 6th RD Suite 80 Fairview Taos County NM 85709 United States -7.0000000E+000 condo |
| 3 AAAAAAAADAAAAAAA 585 Dogwood Washington Circle Suite Q Pleasant Valley York County PA 12477 United States -5.0000000E+000 single family |
| 4 AAAAAAAAEAAAAAAA 111 Smith Wy Suite A Oak Ridge Kit Carson County CO 88371 United States -7.0000000E+000 condo |
| 5 AAAAAAAAFAAAAAAA 31 College Blvd Suite 180 Glendale Barry County MO 63951 United States -6.0000000E+000 single family |
| 6 AAAAAAAAGAAAAAAA 59 Williams Sixth Parkway Suite 100 Lakeview Chelan County WA 98579 United States -8.0000000E+000 single family |
| 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.0000000E+000 apartment |
| 9 AAAAAAAAJAAAAAAA 819 1st Laurel Ave Suite 70 New Hope Perry County AL 39431 United States -6.0000000E+000 condo |
| 10 AAAAAAAAKAAAAAAA 851 Woodland Poplar ST Suite Y Martinsville Haines Borough AK 90419 United States -9.0000000E+000 condo |
| 11 AAAAAAAALAAAAAAA 189 13th 2nd Street Suite 470 Maple Grove Madison County MT 68252 United States -7.0000000E+000 single family |
| 12 AAAAAAAAMAAAAAAA 76 Ash 8th Ct. Suite O Edgewood Mifflin County PA 10069 United States -5.0000000E+000 apartment |
| 13 AAAAAAAANAAAAAAA 424 Main Second Ln Suite 130 Greenville Noxubee County MS 51387 United States -6.0000000E+000 single family |
| 14 AAAAAAAAOAAAAAAA 923 Pine Oak Dr. Suite 100 Lipscomb County TX 77752 -6.0000000E+000 |
| 15 AAAAAAAAPAAAAAAA 314 Spring Ct. Suite B Oakland Washington County OH 49843 United States -5.0000000E+000 apartment |
| 16 AAAAAAAAABAAAAAA 576 Adams Center Street Suite J Valley View Oldham County TX 75124 United States -6.0000000E+000 condo |
| 17 AAAAAAAABBAAAAAA 801 Green Dr. Suite 0 Montpelier Richland County OH 48930 United States -5.0000000E+000 single family |
| 18 AAAAAAAACBAAAAAA 460 Maple Spruce Court Suite 480 Somerville Potter County SD 57783 United States -7.0000000E+000 condo |
| 19 AAAAAAAADBAAAAAA 611 Wilson Way Suite O Oakdale Tangipahoa Parish LA 79584 United States -6.0000000E+000 apartment |
| 20 AAAAAAAAEBAAAAAA 675 Elm Wilson Street Suite I Hopewell Williams County OH 40587 United States -5.0000000E+000 condo |
| 21 AAAAAAAAFBAAAAAA 294 Jefferson Smith Ave Suite 390 Springfield Marshall County SD 59303 United States -7.0000000E+000 condo |
| 22 AAAAAAAAGBAAAAAA 874 Park Second Avenue Suite N Green Acres Perkins County NE 67683 United States -7.0000000E+000 single family |
| 23 AAAAAAAAHBAAAAAA 230 6th Spring Drive Suite U Newtown Jewell County KS 61749 United States -6.0000000E+000 single family |
| 24 AAAAAAAAIBAAAAAA 837 4th Street Suite 200 Fairfield Marin County CA 96192 United States -8.0000000E+000 single family |
| 25 AAAAAAAAJBAAAAAA 986 West East Blvd Suite F Pleasant Grove Coweta County GA 34136 United States -5.0000000E+000 apartment |
| 26 AAAAAAAAKBAAAAAA 809 Central Springdale Forsyth County 28883 -5.0000000E+000 |
| 27 AAAAAAAALBAAAAAA 649 Williams Ct. Suite 400 Cedar Utah County UT 81229 United States -7.0000000E+000 condo |
| 28 AAAAAAAAMBAAAAAA 992 Birch Avenue Suite N Oak Hill Montrose County CO 87838 United States -7.0000000E+000 condo |
| 29 AAAAAAAANBAAAAAA 572 First Elevnth Pkwy Suite 160 Newport Richland County IL 61521 United States -6.0000000E+000 single family |
| 30 AAAAAAAAOBAAAAAA 748 Oak Avenue Suite M Wildwood Clark County MO 66871 United States -6.0000000E+000 apartment |
| 31 AAAAAAAAPBAAAAAA 291 East Lane Suite A Forestville Walworth County SD 53027 United States -7.0000000E+000 condo |
| 32 AAAAAAAAACAAAAAA 243 8th Lake Wy Suite G Oakland Madison County NC 29843 United States -5.0000000E+000 condo |
| 33 AAAAAAAABCAAAAAA 711 3rd 4th Ave Suite 10 Pine Grove Sumter County GA 34593 United States -5.0000000E+000 apartment |
| 34 AAAAAAAACCAAAAAA 785 1st Cedar Ave Suite 40 Greenville Russell County VA 21387 United States -5.0000000E+000 condo |
| 35 AAAAAAAADCAAAAAA 814 Washington Main Drive Suite C Waterloo Henry County VA 21675 United States -5.0000000E+000 single family |
| 36 AAAAAAAAECAAAAAA 648 South 15th Court Suite 410 Lakeview Lewis County TN 38579 United States -6.0000000E+000 condo |
| 37 AAAAAAAAFCAAAAAA 999 4th Ct. Suite 250 Sumner Greenville County SC 20519 United States -5.0000000E+000 single family |
| 38 AAAAAAAAGCAAAAAA 912 Second Hickory Drive Suite 190 Plainview Baca County CO 83683 United States -7.0000000E+000 condo |
| 39 AAAAAAAAHCAAAAAA 13 10th Ct. Suite 280 Hamilton Lee County IA 52808 United States -6.0000000E+000 apartment |
| 40 AAAAAAAAICAAAAAA 369 2nd Maple Pkwy Suite H Bridgeport Ferry County WA 95817 United States -8.0000000E+000 single family |
| 41 AAAAAAAAJCAAAAAA 198 Washington RD Suite S Oakland Ouray County CO 89843 United States -7.0000000E+000 apartment |
| 42 AAAAAAAAKCAAAAAA 884 Oak Court Suite F Riverside Scott County MS 59231 United States -6.0000000E+000 single family |
| 43 AAAAAAAALCAAAAAA 762 Spring Dr. Suite F Sulphur Springs Jefferson County IL 68354 United States -6.0000000E+000 condo |
| 44 AAAAAAAAMCAAAAAA Suite 490 O-Brien County 58721 United States -6.0000000E+000 |
| 45 AAAAAAAANCAAAAAA 206 4th Street Suite 120 Union Washington County ME 09321 United States -5.0000000E+000 apartment |
| 46 AAAAAAAAOCAAAAAA 995 Oak Boulevard Suite 120 Union Hill Forrest County MS 57746 United States -6.0000000E+000 single family |
| 47 AAAAAAAAPCAAAAAA 776 Washington View Wy Suite 60 Pleasant Grove Mercer County KY 44136 United States -5.0000000E+000 apartment |
| 48 AAAAAAAAADAAAAAA 895 Valley Lane Suite 480 Salem James City County VA 28048 United States -5.0000000E+000 condo |
| 49 AAAAAAAABDAAAAAA 583 Highland 2nd Street Suite 90 Fairfield York County ME 06792 United States -5.0000000E+000 apartment |
| 50 AAAAAAAACDAAAAAA 190 7th Wy Suite D Enterprise Gray County KS 61757 United States -6.0000000E+000 single family |
| 51 AAAAAAAADDAAAAAA 845 5th Pkwy Suite F Green Acres Hamblen County TN 37683 United States -5.0000000E+000 single family |
| 52 AAAAAAAAEDAAAAAA 472 Ridge Park ST Suite 60 Oakdale Muskingum County OH 49584 United States -5.0000000E+000 single family |
| 53 AAAAAAAAFDAAAAAA 884 College Franklin Boulevard Suite 440 Riverview McPherson County SD 59003 United States -7.0000000E+000 single family |
| 54 AAAAAAAAGDAAAAAA 857 10th 10th Boulevard Suite V Oak Hill Martin County NC 27838 United States -5.0000000E+000 single family |
| 55 AAAAAAAAHDAAAAAA 177 Lee Adams Way Suite S Ashland Macomb County MI 44244 United States -5.0000000E+000 condo |
| 56 AAAAAAAAIDAAAAAA 49 Valley 14th Wy Suite V Woodland Goodhue County MN 54854 United States -6.0000000E+000 condo |
| 57 AAAAAAAAJDAAAAAA 625 10th Oak RD Suite J Enterprise Bottineau County ND 51757 United States -6.0000000E+000 single family |
| 58 AAAAAAAAKDAAAAAA 917 Miller 15th Parkway Suite 230 Union Hill Canyon County ID 87746 United States -7.0000000E+000 single family |
| 59 AAAAAAAALDAAAAAA Court Newtown Valley County MT United States -7.0000000E+000 condo |
| 60 AAAAAAAAMDAAAAAA Lee Forest Hills Green County KY 49237 ? apartment |
| 61 AAAAAAAANDAAAAAA 159 Ridge Boulevard Suite 20 Sulphur Springs Laurel County KY 48354 United States -5.0000000E+000 single family |
| 62 AAAAAAAAODAAAAAA 925 Lincoln Lane Suite 90 Riverdale Lewis County WV 29391 United States -5.0000000E+000 condo |
| 63 AAAAAAAAPDAAAAAA 416 Elevnth Green Drive Suite A Midway Jewell County KS 61904 United States -6.0000000E+000 single family |
| 64 AAAAAAAAAEAAAAAA 546 Meadow Circle Suite 90 Macedonia Trousdale County TN 31087 United States -6.0000000E+000 apartment |
| 65 AAAAAAAABEAAAAAA 147 Fourth Lake RD Suite 460 Bethel Iowa County IA 55281 United States -6.0000000E+000 single family |
| 66 AAAAAAAACEAAAAAA 238 Pine Road Suite 470 Crossroads Sioux County NE 60534 United States -7.0000000E+000 single family |
| 67 AAAAAAAADEAAAAAA 896 11th Street Suite B Flint Van Buren County IA 58909 United States -6.0000000E+000 single family |
| 68 AAAAAAAAEEAAAAAA 240 Laurel Forest Street Suite H Summit Bledsoe County TN 30499 United States -5.0000000E+000 single family |
| 69 AAAAAAAAFEAAAAAA 37 Pine Drive Suite H Glendale Scott County KY 43951 United States -5.0000000E+000 single family |
| 70 AAAAAAAAGEAAAAAA 511 14th Sycamore Parkway Suite 210 White Oak Union County OH 46668 United States -5.0000000E+000 condo |
| 71 AAAAAAAAHEAAAAAA 38 Ridge Cir. Suite 370 Lakeview Nottoway County VA 28579 United States -5.0000000E+000 apartment |
| 72 AAAAAAAAIEAAAAAA 982 Willow Blvd Suite 20 Richville Cascade County MT 65945 United States -7.0000000E+000 single family |
| 73 AAAAAAAAJEAAAAAA 158 Green Broadway Road Suite B Cedar Grove Kingman County KS 60411 United States -6.0000000E+000 apartment |
| 74 AAAAAAAAKEAAAAAA 723 Sycamore Boulevard Suite C Spring Hill Wapello County IA 56787 United States -6.0000000E+000 condo |
| 75 AAAAAAAALEAAAAAA 32 Pine Wy Suite 480 Valley View Cleburne County AL 35124 United States -6.0000000E+000 single family |
| 76 AAAAAAAAMEAAAAAA 257 Walnut South Drive Suite 420 Shiloh Menominee County MI 49275 United States -5.0000000E+000 single family |
| 77 AAAAAAAANEAAAAAA 151 Hill Wy Suite U Oak Grove Thomas County GA 38370 United States -5.0000000E+000 single family |
| 78 AAAAAAAAOEAAAAAA 857 Railroad Boulevard Suite 140 Green Acres Potter County SD 57683 United States -7.0000000E+000 single family |
| 79 AAAAAAAAPEAAAAAA 409 Park 7th Cir. Suite U Farmington Wayne County TN 39145 United States -6.0000000E+000 condo |
| 80 AAAAAAAAAFAAAAAA 298 12th Way Suite J Oakland Grant County KY 49843 United States -6.0000000E+000 condo |
| 81 AAAAAAAABFAAAAAA 953 River Spruce Pkwy Suite 0 Union Hill Brown County TX 77746 United States -6.0000000E+000 condo |
| 82 AAAAAAAACFAAAAAA 97 River Main Ln Suite L Buena Vista Santa Clara County CA 95752 United States -8.0000000E+000 single family |
| 83 AAAAAAAADFAAAAAA 410 Spring Poplar Drive Suite 20 Bethel Nueces County TX 75281 United States -6.0000000E+000 condo |
| 84 AAAAAAAAEFAAAAAA 886 Sunset Circle Suite T Warwick Itawamba County MS 51398 United States -6.0000000E+000 apartment |
| 85 AAAAAAAAFFAAAAAA 476 Willow Avenue Suite R Five Points Crawford County PA 16098 United States -5.0000000E+000 single family |
| 86 AAAAAAAAGFAAAAAA 699 11th 14th ST Suite O Five Points Pike County KY 46098 United States -5.0000000E+000 single family |
| 87 AAAAAAAAHFAAAAAA 6th Lane Maple Grove Claiborne County 58252 ? apartment |
| 88 AAAAAAAAIFAAAAAA 104 9th RD Suite W Frogtown Bay County MI 48784 United States -5.0000000E+000 single family |
| 89 AAAAAAAAJFAAAAAA 440 Church 7th Ave Suite 200 Lakeside Solano County CA 99532 United States -8.0000000E+000 apartment |
| 90 AAAAAAAAKFAAAAAA 892 North East Drive Suite U Centerville Hettinger County ND 50059 United States -6.0000000E+000 condo |
| 91 AAAAAAAALFAAAAAA 936 Wy Riverside Murray County United States ? |
| 92 AAAAAAAAMFAAAAAA 734 Ash Wilson Boulevard Suite V Newtown Boise County ID 81749 United States -7.0000000E+000 condo |
| 93 AAAAAAAANFAAAAAA 755 Washington Sunset RD Suite Q Walnut Grove Greenup County KY 47752 United States -6.0000000E+000 apartment |
| 94 AAAAAAAAOFAAAAAA Lakeside Washington County GA ? |
| 95 AAAAAAAAPFAAAAAA 571 Hickory River Ln Suite M Woodland Thayer County NE 64854 United States -7.0000000E+000 condo |
| 96 AAAAAAAAAGAAAAAA 246 Cedar Franklin RD Suite A Oakdale Fulton County KY 49584 United States -6.0000000E+000 condo |
| 97 AAAAAAAABGAAAAAA 858 Sunset Main Way Suite 320 Enterprise Hardin County TX 71757 United States -6.0000000E+000 single family |
| 98 AAAAAAAACGAAAAAA 346 Walnut Road Suite 370 Spring Hill Labette County KS 66787 United States -6.0000000E+000 condo |
| 99 AAAAAAAADGAAAAAA 222 Park View Drive Suite U Wilson Dickinson County MI 46971 United States -5.0000000E+000 apartment |
| 100 AAAAAAAAEGAAAAAA 127 Railroad Court Suite 170 Oakland Perry County TN 39843 United States -6.0000000E+000 apartment |
| |
| --- 100 row(s) selected. |
| >>select * from hive.ins_store order by S_STORE_SK; |
| |
| S_STORE_SK S_STORE_ID S_REC_START_DATE S_REC_END_DATE S_CLOSED_DATE_SK S_STORE_NAME S_NUMBER_EMPLOYEES S_FLOOR_SPACE S_HOURS S_MANAGER S_MARKET_ID S_GEOGRAPHY_CLASS S_MARKET_DESC S_MARKET_MANAGER S_DIVISION_ID S_DIVISION_NAME S_COMPANY_ID S_COMPANY_NAME S_STREET_NUMBER S_STREET_NAME S_STREET_TYPE S_SUITE_NUMBER S_CITY S_COUNTY S_STATE S_ZIP S_COUNTRY S_GMT_OFFSET S_TAX_PRECENTAGE |
| ----------- ------------------------- -------------------------- -------------------------- ---------------- ------------------------- ------------------ ------------- ------------------------- ------------------------- ----------- ------------------------- ------------------------- ------------------------- ------------- ------------------------- ------------ ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- --------------- ---------------- |
| |
| 1 AAAAAAAABAAAAAAA 1997-03-13 00:00:00.000000 ? 2451189 ought 245 5250760 8AM-4PM William Ward 2 Unknown Enough high areas stop ex Charles Bartley 1 Unknown 1 Unknown 767 Spring Wy Suite 250 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 |
| 2 AAAAAAAACAAAAAAA 1997-03-13 00:00:00.000000 2000-03-12 00:00:00.000000 ? able 236 5285950 8AM-4PM Scott Smith 8 Unknown Parliamentary candidates David Lamontagne 1 Unknown 1 Unknown 255 Sycamore Dr. Suite 410 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 |
| 3 AAAAAAAACAAAAAAA 2000-03-13 00:00:00.000000 ? ? able 236 7557959 8AM-4PM Scott Smith 7 Unknown Impossible, true arms can David Lamontagne 1 Unknown 1 Unknown 877 Park Laurel Road Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 |
| 4 AAAAAAAAEAAAAAAA 1997-03-13 00:00:00.000000 1999-03-13 00:00:00.000000 2451044 ese 218 9341467 8AM-4PM Edwin Adams 4 Unknown Events would achieve othe Thomas Pollack 1 Unknown 1 Unknown 27 Lake Ln Suite 260 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 |
| 5 AAAAAAAAEAAAAAAA 1999-03-14 00:00:00.000000 2001-03-12 00:00:00.000000 2450910 anti 288 9078805 8AM-4PM Edwin Adams 8 Unknown Events would achieve othe Thomas Pollack 1 Unknown 1 Unknown 27 Lee 6th Court Suite 80 Fairview Williamson County TN 35709 United States -5.0000000E+000 2.9999999E-002 |
| 6 AAAAAAAAEAAAAAAA 2001-03-13 00:00:00.000000 ? ? cally 229 9026222 8AM-4PM Edwin Adams 10 Unknown Events would achieve othe Thomas Pollack 1 Unknown 1 Unknown 220 6th Lane Suite 140 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 |
| 7 AAAAAAAAHAAAAAAA 1997-03-13 00:00:00.000000 ? ? ation 297 8954883 8AM-4PM David Thomas 9 Unknown Architects coul Thomas Benton 1 Unknown 1 Unknown 811 Lee Circle Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 |
| 8 AAAAAAAAIAAAAAAA 1997-03-13 00:00:00.000000 2000-03-12 00:00:00.000000 ? eing 278 6995995 8AM-4PM Brett Yates 2 Unknown Various bars make most. D Dean Morrison 1 Unknown 1 Unknown 226 12th Lane Suite D Fairview Williamson County TN 35709 United States -5.0000000E+000 7.9999998E-002 |
| 9 AAAAAAAAIAAAAAAA 2000-03-13 00:00:00.000000 ? ? eing 271 6995995 8AM-4PM Brett Yates 2 Unknown Formal, psychological pou Dean Morrison 1 Unknown 1 Unknown 226 Hill Boulevard Suite 190 Midway Williamson County TN 31904 United States -5.0000000E+000 7.9999998E-002 |
| 10 AAAAAAAAKAAAAAAA 1997-03-13 00:00:00.000000 1999-03-13 00:00:00.000000 ? bar 294 9294113 8AM-4PM Raymond Jacobs 8 Unknown Little expectations inclu Michael Wilson 1 Unknown 1 Unknown 175 4th Court Suite C Midway Williamson County TN 31904 United States -5.0000000E+000 5.9999998E-002 |
| 11 AAAAAAAAKAAAAAAA 1999-03-14 00:00:00.000000 2001-03-12 00:00:00.000000 ? ought 294 9294113 8AM-4PM Raymond Jacobs 6 Unknown Mysterious employe Michael Wilson 1 Unknown 1 Unknown 175 Park Green Court Suite 160 Midway Williamson County TN 31904 United States -5.0000000E+000 1.0999999E-002 |
| 12 AAAAAAAAKAAAAAAA 2001-03-13 00:00:00.000000 ? ? ought 294 5219562 8AM-12AM Robert Thompson 6 Unknown Events develop i Dustin Kelly 1 Unknown 1 Unknown 337 College Boulevard Suite 100 Fairview Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 |
| |
| --- 12 row(s) selected. |
| >>log; |
| 1c1 |
| < >>select [first 1000] * from hive.customer order by c_customer_sk; |
| --- |
| > >>select [first 1000] * from hive.ins_customer order by c_customer_sk; |
| 1c1 |
| < >>select * from hive.promotion order by P_PROMO_SK; |
| --- |
| > >>select * from hive.ins_promotion order by P_PROMO_SK; |
| 1c1 |
| < >>select [first 1000] * from hive.customer_address order by CA_ADDRESS_SK; |
| --- |
| > >>select [first 1000] * from hive.ins_customer_address order by CA_ADDRESS_SK; |
| 1c1 |
| < >>select * from hive.store order by S_STORE_SK; |
| --- |
| > >>select * from hive.ins_store order by S_STORE_SK; |
| 17c17 |
| < +>from hive.store_sales order by ss_sold_date_sk,ss_sold_time_sk, ss_item_sk, ss_customer_sk, ss_cdemo_sk,ss_hdemo_sk,ss_addr_sk ,ss_store_sk, ss_promo_sk; |
| --- |
| > +>from hive.ins_store_sales order by ss_sold_date_sk,ss_sold_time_sk, ss_item_sk, ss_customer_sk, ss_cdemo_sk,ss_hdemo_sk,ss_addr_sk ,ss_store_sk, ss_promo_sk; |
| 1c1 |
| < >>select [first 500] * from hive.customer_demographics order by cd_demo_sk ; |
| --- |
| > >>select [first 500] * from hive.ins_customer_demographics order by cd_demo_sk; |
| 1c1 |
| < >>select [first 500] * from hive.date_dim ; |
| --- |
| > >>select [first 500] * from hive.ins_date_dim; |
| 1c1 |
| < >>select [first 500] * from hive.time_dim ; |
| --- |
| > >>select [first 500] * from hive.ins_time_dim; |
| 2c2 |
| < +>from hive.item order by i_item_sk, i_item_id ; |
| --- |
| > +>from hive.ins_item order by i_item_sk, i_item_id; |
| 1c1 |
| < >>select [first 500] * from hive.household_demographics order by hd_demo_sk ; |
| --- |
| > >>select [first 500] * from hive.ins_household_demographics order by hd_demo_sk; |
