>>
>>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  CTE 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  CTE 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;
