http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/d385ac72/testdata/data/mstr/eatwh1/csv/LU_CUSTOMER.TXT ---------------------------------------------------------------------- diff --git a/testdata/data/mstr/eatwh1/csv/LU_CUSTOMER.TXT b/testdata/data/mstr/eatwh1/csv/LU_CUSTOMER.TXT deleted file mode 100644 index 5dc1c50..0000000 --- a/testdata/data/mstr/eatwh1/csv/LU_CUSTOMER.TXT +++ /dev/null @@ -1,679 +0,0 @@ -1,Maxwell,Aaronson,7/11/1960,9865 Marion Place Apt.,6,,24 -2,Hugh,Abarca,9/17/1933,1660 Park Ave.,3,,252 -3,Hazel,Abelson,4/8/1942,1882 St. Johns,3,,111 -4,Brooks,Abern,12/5/1936,245 Eastwood,3,,135 -5,Ross,Abram,2/28/1938,45 South Deer Creek Drive,3,,236 -6,Wylie,Abrams,1/1/1968,5628 Orwenstensia,5,,123 -7,Don,Addison,1/3/1950,9433 Burton Ave.,2,,160 -8,Merrell,Adess,12/5/1950,310 Marquette Rd.,3,,215 -9,Keith,Adler,1/12/1965,150 Harding Ave.,6,,112 -10,Daniel,Aguilar,2/24/1966,125 Eastwood,3,,227 -11,Deborah,Aguirre,11/13/1949,4259 W. Lake Ave.,7,,72 -12,Dean,Ahern,10/15/1948,33 University Ave.,5,,235 -13,Elton,Al-Timinu,9/10/1947,22 Ashland Ave.,7,,212 -14,Dorthy,Alcaraz,3/7/1967,54 Lakeview Terrace,3,,241 -15,Sarah,Aldo,3/29/1970,3901 Chester Ave. Apt. 3C,5,,232 -16,Peggy,Alein,7/31/1931,1029 Marvel Way,2,,182 -17,Maxwell,Alexander,8/30/1946,175 Lily Court,5,,161 -18,Selene,Allen,1/1/1961,152 Clinton Ave.,2,,103 -19,Mario,Alonso,4/30/1968,1815 Judson Rd.,9,,147 -20,Calbert,Alvarado,2/7/1962,3618 Woodland Rd.,3,,251 -21,Xavier,Alyea-Burkell,2/16/1951,1109 Marvel Way,8,,74 -22,Belinda,Amsov,3/4/1963,17 Cavell Ave.,7,,47 -23,Kent,Angelina,4/24/1964,4530 Oakland Drive,9,,117 -24,Brent,Anovitz,5/12/1969,222 Clay Rd.,5,,251 -25,Nicholas,Anthony,6/18/1970,1539 Bay Colony Dr.,3,,98 -26,Jules,Apert,5/15/1965,1215 Judson Rd.,4,,280 -27,Brock,Applebaum,6/13/1966,6228 Orwenstensia,2,,56 -28,Laurell,Ardini,1/31/1949,644 Princeton Ln.,6,,97 -29,Saul,Arenburg,3/4/1952,171 Clifton Rd.,7,,216 -30,Jean,Armstrong,6/8/1959,1365 Hillcrest Circle,7,,80 -31,Tess,Aronoff,6/12/1972,551 Madison St.,5,,67 -32,Veda,Arrezola,7/3/1973,7261 White Oaks Ave.,6,,85 -33,Sue,Artemis,10/3/1979,34 Lynn Terrace,4,suebaby@aol,76 -34,Mara,Ascher,1/8/1942,1750 Lily Court,4,,206 -35,Gilbert,Astorino,4/25/1953,1701 W. Mellody Rd.,8,,207 -36,Roger,Aufox,8/12/1937,1585 County line Rd.,4,,270 -37,Rebecca,Aya,5/17/1954,224 Sherman Rd.,10,,12 -38,Stacy,Azzi,10/1/1961,9365 Marion Place Apt.,6,,55 -39,Sherwood,Bagleman,6/12/1955,763 Blackhawk Rd.,9,,76 -40,Isaiah,Bahr,7/8/1971,1233 Arbor Rd.,4,,16 -41,Mario,Baker,1/17/1932,1858 Balsam Way,1,,18 -42,Dolly,Bakhitari,6/23/1967,8542 Sumac Rd.,6,,129 -43,Wenda,Bales,7/18/1956,202 St.Johns Ave.,6,,196 -44,Eli,Ball,10/2/1939,1839 McCraren Rd.,2,,65 -45,Wylie,Ballatini,8/14/1937,3255 Golf Rd.,6,,237 -46,Stephen,Ballin,8/23/1957,12 Eastwood,3,,245 -47,Bridget,Bao,9/14/1958,1714 Clifton Rd.,1,,135 -48,Ruby,Barack,8/31/1972,1715 Chicago Ave.,5,,190 -49,Luther,Barcani,9/2/1973,8172 Virginia Rd.,5,,248 -50,Tabitha,Barker,10/22/1974,922 Twin Oaks Drive,7,[email protected],170 -51,Patty,Barlow,10/2/1959,280 Skokie Rd.,4,,198 -52,John,Barnett,12/6/1975,191 Old Briar Lane,2,,84 -53,Ralph,Baron,7/31/1956,335 University Ave.,3,,188 -54,Deborah,Barris,11/13/1975,190 Sunnyside Ave.,6,debbi@aol,69 -55,Jonathon,Barrow,8/22/1957,8122 North Ave.,4,,46 -56,Barry,Baruffi,6/24/1968,539 Cordon Terr.,4,,102 -57,Nell,Basillos,10/10/1959,456 Groverland Ave.,4,,193 -58,Pamela,Bauden,1/31/1950,2644 Princeton Ln.,3,,114 -59,Louis,Baum,12/26/1961,25 Oakridge Ave.,1,,187 -60,Milton,Baumrick,4/17/1961,594 Cordon Terr.,9,,232 -61,Alan,Bayanie,11/7/1960,1787 Balsamic Ave.,7,,119 -62,Serge,Bayer,4/19/1965,1752 Clinton Ave.,3,,76 -63,Randolph,Bazzoni,2/1/1953,2878 Sheridan Rd.,5,,80 -64,Dwight,Bear,12/5/1951,224 Highwood Ave.,7,,237 -65,Regan,Becerra,12/5/1961,2148 Oakridge Ave.,3,,4 -66,Carrie,Becker,3/29/1942,2378 Sheridan Rd.,6,,71 -67,Theo,Bederman,12/5/1965,171 Chicago Ave.,6,,11 -68,Carey,Belmonti,4/16/1943,4586 Groverland Ave.,4,,271 -69,Pierre,Belster,5/12/1944,550 Sheridan,6,,211 -70,Trent,Benbaum,1/29/1962,3970 Vilas Circle,5,,57 -71,Nathan,Benberg,6/11/1945,24 Ashland Ave.,4,,35 -72,Ben,Benjamin,2/13/1963,2219 Hillcrest Ave,10,,260 -73,Mercedes,Berber,8/19/1947,77 Blackhawk Rd,3,,92 -74,Marcus,Berhoff,1/16/1966,2188 Oakridge Ave.,5,,84 -75,Galvin,Beris,2/9/1959,67 Sheridan Rd.,9,,169 -76,Clarinda,Berk,3/14/1936,6626 Lyons Circle,6,,14 -77,Christie,Berkenhiemer,9/18/1942,154 Vine,2,,270 -78,Reed,Berkson,6/18/1951,5212 Hill,1,,50 -79,Max,Berman,9/11/1954,302-A Crestwood Village Rd.,4,,32 -80,Fletcher,bernadi,2/13/1967,8599 Harvard Ct,6,,128 -81,Jonathon,Berrity,3/26/1964,9187 Fairview Ave.,3,,175 -82,Jonathon,Bertam,3/6/1960,872 Virginia Rd.,3,,236 -83,Merrell,Bickmore,4/21/1965,7530 Homewood Ave.,4,,152 -84,Zabrina,Biley,1/9/1952,267 Anderson Lane,2,,271 -85,Geoffery,Birkenstein,2/28/1967,195 First St.,4,,173 -86,Abner,Bishop,5/31/1968,22 Vine Ave.,4,,74 -87,Elaine,Bishop,5/6/1950,222 Sherman Rd.,5,,145 -88,Bartlett,Black,9/14/1960,3513 Grove Ave.,5,,228 -89,Craig,Black,11/13/1960,54 Chicago Ave.,3,,59 -90,Libby,Black,6/18/1951,629 Kincaid Ave.,6,,22 -91,Amber,Blackard,11/12/1942,251 Crain,3,,2 -92,Megan,Blair,7/8/1970,1393 Bay Colony Dr.,8,,6 -93,Stefan,Blair,3/9/1968,3565 Golf Rd.,2,,96 -94,Ted,Blechman,8/13/1951,1126 Hillcrest Ave,4,,130 -95,Taylor,Blitstein,12/13/1941,1556 Ridge Rd.,3,,270 -96,Jacob,Blondi,4/10/1969,4343 Burton Ave.,6,,153 -97,Jed,Bloomberg,10/3/1976,1715 Judson Rd.,9,[email protected],123 -98,Jed,Bloomgarden,7/22/1950,442 Valley Rd.,10,,13 -99,Darrick,Blum,11/6/1930,899 Harvard Ct,2,,109 -100,regan,Bolender,9/24/1964,262 Prarie Ln.,2,,103 -101,Selene,Bommario,2/13/1945,3367 Bluebird Terr.,2,,3 -102,Eugene,Bonelli,3/15/1958,770 Exmoor Rd.,5,,281 -103,Waldo,Borden,11/13/1954,377 Blackhawk Rd,9,,28 -104,Cary,Bowden,10/16/1953,2479 Woodridge Drive,8,,159 -105,Fernanda,Bowden,9/20/1952,715 Chicago Ave.,3,,231 -106,Erwin,Brickstone,5/20/1970,4635 Stratford Rd.,4,,167 -107,Moses,Brickstone,5/12/1966,662 Lyons Circle,5,,234 -108,Wendy,Brinkman,7/14/1952,169 Judson Ave.,1,,77 -109,Daphne,Brooks,2/9/1963,2445 Oakridge Ave.,4,,129 -110,Jessica,Brooks,8/29/1953,33976 Forest View Rd.,4,,17 -111,Otto,Brown,1/18/1962,1455 Ridgewood Drive,6,,199 -112,Rita,Brown,6/27/1955,311 Barkwood Ct.,6,,164 -113,Judy,Brugioni,6/12/1971,1957 Huntington Ave.,3,,215 -114,Iona,Bruns,5/12/1954,3555 Golf Rd.,5,,130 -115,Mercedes,Bush,9/9/1954,600 Winsor Mall,3,,107 -116,Clarinda,Butler,4/18/1953,318 Barkwood Ct.,5,,62 -117,George,Butler,3/16/1952,614 Green bay Rd.,4,,271 -118,Harvey,Campaigni,7/14/1972,475 Roger Williams Ave.,2,,57 -119,Dion,Candeni,4/16/1947,124 Eastwood,5,,75 -120,Jesse,Canel,8/26/1973,6843 De Temple Rd.,4,,69 -121,Judith,Cao,9/11/1958,2870 Skokie Rd.,2,,280 -122,Serge,Cao,10/20/1955,8441 Spruce St.,3,,90 -123,Nevin,Capian,9/14/1974,795 Lake Cook Rd.,8,,53 -124,Leroy,Carani,5/23/1948,8615 Old Tall Tree Lane,3,,260 -125,Zabrina,Carmel,11/12/1961,31976 Forest View Rd.,3,,178 -126,Blossom,Carper,10/5/1975,632 Prarie Ln.,6,,22 -127,Felix,Cawn,2/3/1952,6433 De Temple Rd.,2,,74 -128,Frances,Chi-Lin,9/30/1959,292 Twin Oaks Drive,1,,39 -129,Julie,Chio,5/2/1967,445 Park Ave.,6,,123 -130,Weston,Christopher,6/20/1956,6004 Central Ave.,3,,115 -131,Spencer,Chubin,4/17/1954,9065 Marion Place Apt.,4,,163 -132,Ira,Churchill,6/19/1949,22 Clay Rd.,6,,251 -133,Darcy,Cohen,10/11/1960,486 Old Deerfield Rd.,5,,86 -134,Stanley,Coretti,12/9/1955,129 Broadview Lane,1,,171 -135,Forrest,Crane,6/21/1961,1375 Beech St.,9,,226 -136,Cherry,Cross,8/19/1963,422 Valley Rd.,8,,7 -137,Aldora,Dahl,12/13/1941,4335 Burton Ave.,3,,66 -138,Lilly,Davis,6/12/1944,2922 Twin Oaks Drive,9,,77 -139,Travis,De Bolsky,11/12/1956,120 Linden Ave.,4,,214 -140,Nelson,DeFillipos,12/13/1957,1859 Green Bay Rd.,6,,38 -141,Perry,Delrahim,8/25/1958,1355 Ridgewood Drive,3,,156 -142,Gerald,Denver,6/15/1932,507 S. Prospect Ave.,5,,44 -143,Leslie,Deutsch,1/16/1958,45 Oakridge Ave.,3,,226 -144,Abner,Devora,2/13/1959,225 Jeffrys Place,4,,143 -145,Lynn,Diaz,3/23/1960,2015 Pleasent Ave.,8,,81 -146,Aldora,Dim,4/27/1930,5518 Madison St.,2,,159 -147,Barrett,DiVenanzo,11/17/1965,175 Roger Williams Ave.,4,,151 -148,Margaret,Divinci,5/25/1961,1954 First St.,5,,176 -149,Alexandria,Dixon,3/14/1939,3455 Golf Rd.,4,,30 -150,Amber,Dixon,4/15/1961,387 Green Bay Rd.,3,,281 -151,Lester,Donovan,6/4/1930,4750 Homewood Ave.,5,,137 -152,Wenda,Dranove,12/7/1966,4304 Oakland Drive,6,,245 -153,Edana,Duenow,9/4/1935,4656 Grossman Ln.,1,,59 -154,Alison,Eichner,4/5/1960,263 Prarie Ln.,8,,90 -155,Natalie,Ellman,10/13/1965,9167 Fairview Ave.,3,,125 -156,Jason,Erwin,9/7/1964,146 Old Deerfield Rd.,3,,34 -157,Paul,Evans,8/3/1963,110 Marquette Rd.,5,,56 -158,Taylor,Evans,5/27/1962,1704 Ridgelee Rd,3,,261 -159,Libby,Ewing,1/3/1967,185 Balsam Way,8,,251 -160,James,Extov,3/3/1958,9291 Brittany Ave.,8,,281 -161,Marilyn,Fabbi,12/13/1955,564 Lakeview Terrace,7,,205 -162,Jules,Feight,11/25/1954,264 Princeton Ln.,4,,193 -163,Gladys,Feldman,4/27/1968,158 Balsam Way,9,,26 -164,Jules,Ferratti,2/23/1957,406 Trinity Ct.,5,,230 -165,Brett,Fieldman,6/14/1963,76 Judson Place,5,,247 -166,Emily,Filipowski,7/18/1964,643 De Temple Rd.,1,,90 -167,Prior,Finger,4/4/1959,2220 Grant Blvd.,3,,63 -168,Cecelia,Fish,3/26/1956,119 Twin Oaks Place,4,,25 -169,Tara,Fish,2/22/1955,3575 Golf Rd.,2,,87 -170,Travis,Fish,12/7/1953,157 Oakwood Ave.,3,,175 -171,Ross,Fisher,11/18/1952,347 Green Bay Rd.,3,,80 -172,Stacy,Fleishman,11/12/1940,671 Blackstone Ave.,5,,10 -173,Marcus,Fligel,5/27/1946,135 Lakewood place,4,,39 -174,Colby,Flinn,8/19/1974,15 Chicago Ave.,2,[email protected],60 -175,Katharine,Flinn,2/14/1968,3644 Princeton Ln.,4,,19 -176,Abraham,Flore,10/3/1934,1658 Second St.,5,,101 -177,Ara,Foreman,12/3/1967,310-C Crestwood Village Rd.,6,,33 -178,Dalton,Foreman,3/18/1969,518 Madison St.,2,,189 -179,Ted,Fox,5/3/1969,21 Callan Rd.,4,,86 -180,Ward,Fox,4/15/1970,385 University Ave.,4,,65 -181,Dustin,Frump,8/7/1965,1619 Judson Ave. Apt #34B,6,,192 -182,Henry,Funk,6/27/1959,122 Fort Sheriden Ave.,5,,27 -183,Lucy,Furgatch,3/14/1967,2345 Oakridge Ave.,4,,145 -184,Tabitha,Furla,5/27/1971,214 Eastview Dr.,6,,270 -185,Nelson,Furner,6/14/1972,160 Park Ave.,6,,280 -186,Selby,Fyk,9/22/1950,425 Lake Ave.,9,,131 -187,Laggie,Galassani,7/23/1973,1550 Ridge Rd.,3,[email protected],271 -188,Susan,Gallen,2/13/1969,917 Fairview Ave. Apt. 982,5,,93 -189,Connie,Gant,11/25/1964,1515 Judson Rd.,4,,97 -190,Stacy,Gant,10/13/1951,6716 Cobblestone Cir.,5,,142 -191,Brandon,Garland,8/14/1961,467 Sheridan Rd.,3,,53 -192,Tara,Garland,11/12/1952,310 Summit Ave.,8,,182 -193,Morris,Gellar,7/19/1967,3876 Forest View Rd.,4,,52 -194,Roxanne,Gelling,8/21/1968,6218 Sheriden Rd.,4,,147 -195,Agna,Gerdes,9/23/1969,185 Green Bay Rd.,6,,32 -196,Meryl,Gertler,10/28/1970,487 Green Bay Rd.,5,,111 -197,Vern,Gill,7/29/1945,886 Yale Lane,9,,270 -198,Douglas,Gimelferd,8/11/1974,4536 Grossman Ln.,4,,65 -199,Bartlett,Ginnely,9/5/1975,3181 Barkwood Ct.,6,,271 -200,Val,Ginrich,10/19/1936,18 Madison St.,5,,147 -201,Marilyn,Glantz,5/24/1943,901 Chester Ave. Apt.,6,,106 -202,Mario,Glazier,11/13/1959,267 Sheridan Rd.,10,,237 -203,Elena,Glenwood,1/7/1951,135 Knollwood Drive,1,,281 -204,Rosalie,Glenwood,12/27/1953,6020 Central Ave,6,,202 -205,Ray,Gluterman,3/14/1941,8812 North Ave.,7,,189 -206,Blair,Goldstein,2/11/1940,1155 Ridgewood Drive,4,,280 -207,Jennifer,Gould,1/31/1954,12 Craven Way,3,,281 -208,Ira,Graham,1/9/1939,42 Valley Rd.,6,,175 -209,Don,Gray,9/11/1962,9270 Vilas Circle,2,,99 -210,Laura,Gray,2/28/1955,239 Sheriden Rd.,5,,191 -211,Corey,Greco,3/10/1956,660 Park Ave.,6,,195 -212,Jonathon,Grey,10/6/1965,175 Lake Cook Rd.,4,,179 -213,Charles,Gross,4/18/1969,1575 Oakwood Ave.,3,,112 -214,Wane,Guzman,12/10/1938,852 Sumac Rd.,2,,53 -215,Timothy,Haines,2/23/1967,268 Sheridan Rd.,2,,120 -216,Conroy,Hallsten,1/12/1966,122 Craven Way,5,,163 -217,Caesar,Halverson,12/10/1965,432 Valley Rd.,1,,113 -218,Quinn,Hambrick,11/29/1964,42 Ashland Ave.,8,,204 -219,Yvonne,Happ,11/4/1966,232 Northbrook Ct.,2,,120 -220,Claude,Hardy,4/1/1957,8126 North Ave.,2,,33 -221,Newton,Harris,5/8/1958,177 Balsamic Ave.,10,,202 -222,Barry,Hartman,12/25/1967,12 Broadview Lane,5,,60 -223,Moses,Hearn,1/16/1968,24 Briar Ln,6,,12 -224,Juliet,Hehner,11/23/1966,170 Linden Ave.,7,,92 -225,Deloris,Heller,3/14/1968,6700 Central Ave.,9,,82 -226,Harry,Heller,6/16/1959,4836 W. River Oaks Dr.,2,,116 -227,Priscilla,Heritage,2/15/1969,139 Bay Colony Dr.,5,,66 -228,Kay,Hershenson,8/19/1961,1920 Sunnyside Ave.,5,,85 -229,Theo,Heyman,7/7/1960,38 University Ave.,6,,155 -230,Wayne,Highlander,5/20/1970,3487 Green Bay Rd. ,3,,117 -231,Carla,Hill,3/28/1970,2313 Grove Ave.,5,,228 -232,Rebecca,Hill,9/20/1962,168 Second St.,8,,280 -233,Wade,Hirsh,7/2/1931,35 University Ave.,6,,220 -234,Judy,Hoffmann,7/12/1969,244 Briar Ln,2,,72 -235,Dale,Holmes,10/28/1965,8244 Spruce St.,6,,143 -236,Perry,Holmes,4/13/1971,1077 Court Ave.,3,,62 -237,Homer,Holstein,7/13/1962,316 Summit Ave.,1,,231 -238,Bela,Howard,5/12/1972,147 Vine,6,,185 -239,Hans,Hurst,10/2/1963,750 Lily Court,6,,151 -240,Eunice,Husher,5/12/1960,1912 Old Briar Lane #2,6,,116 -241,Tilda,Ingres,2/4/1955,1253 Arbor Rd.,10,,140 -242,Shirley,Irvince,9/23/1945,1220 Heather Lane,2,,235 -243,Frank,Isacc,7/18/1943,1420 High St.,2,,168 -244,Daniel,Isenberg,1/3/1956,4564 Grossman Ln.,3,,8 -245,Pedro,Isreal,8/3/1932,232 Clay Rd.,6,,154 -246,James,Izotafor,9/14/1933,4633 Burton Ave.,7,,86 -247,Cherry,Jackson,11/2/1964,2148 Eastview Dr.,6,,70 -248,Douglas,Johnson,12/16/1965,174 Ridgelee Rd,4,,1 -249,Peter,Johnson,10/9/1934,812 North Ave.,4,,215 -250,Emmanual,Joseph,11/13/1935,10 Crain,2,,96 -251,Darnell,Juul,12/18/1936,43 Blackhawk Rd.,6,,188 -252,Sloan,kafenshock,6/26/1973,101 W. Mellody Rd.,2,,79 -253,Hilary,Kagan,1/9/1944,32 Northbrook Ct.,6,,58 -254,Jordan,Kahn,2/13/1931,338 University Ave.,6,,91 -255,Irvin,Kallick,10/17/1963,4763 Blackhawk Rd.,9,,112 -256,Curt,Kane,2/13/1933,1949 Cloverdale Rd.,5,,90 -257,Reuben,Kane,1/16/1932,452 Valley Rd.,3,,165 -258,Sophia,Kanter,7/7/1950,107 S. Prospect Ave.,3,,281 -259,Diana,Kaplan,12/14/1931,232 Prarie Ln.,4,,89 -387,Gregory,Palmero,12/5/1962,1279 McCraren,3,,233 -388,Abigail,Paoletti,7/21/1958,146 Oakwood,3,,260 -389,Wanda,Pappolone,6/20/1957,154 Knolwood Rd.,2,,168 -390,Ella,Parsons,5/17/1956,678 Sheridan Rd.,5,,93 -391,Aaron,Paschen,4/4/1955,459 W. Lake Ave.,2,,82 -392,Priscilla,Pasieka,3/14/1954,43078 Kennedy Dr.,4,,154 -393,Alisa,Passis,1/4/1946,1450 Harding Ave.,5,,105 -394,Brad,Patrick,2/3/1947,450 Harding Ave.,9,,7 -395,Miles,Paulessian,4/8/1948,616 Cobblestone Cir.,8,,111 -396,Bradford,Pauly,1/15/1963,1950 Sunnyside Ave.,2,,140 -397,Kent,Pauly,2/13/1964,6500 Central Ave.,2,,87 -398,Belinda,Pawkov,5/3/1949,2718 Oakridge Ave.,8,,125 -399,May,Pawsquesi,3/1/1950,35 Glenlake Dr.,6,,168 -400,Sanders,Pederson,1/7/1940,81 Hill St. Apt.,4,,9 -401,Virgil,Pederson,11/23/1969,1639 Bay Colony Dr.,4,,39 -402,Emeline,Perkins,7/18/1936,390 Chester Ave. Apt.,8,,72 -403,Mary,Perlstein,3/28/1965,310 Walker Ave.,3,,66 -404,Vivian,Perlstein,7/15/1952,306 Lindenwood Ln.,5,,181 -405,Edward,Perryman,12/8/1970,204 St.Johns Ave.,3,,95 -406,Corey,Pestine,12/7/1945,4830 Oakland Drive,7,,88 -407,Frances,Peters,1/6/1971,547 Vine,2,,138 -408,Jean,Pettorelli,2/19/1972,1185 County line Rd.,5,,247 -409,Don,Phillips,10/10/1955,30 Walker Ave.,10,,224 -410,Maxwell,Pieracci,11/15/1956,58 Madison St.,5,,180 -411,Dora,Pierce,12/1/1957,774 Blackhawk Rd,3,,129 -412,Murray,Plathe,1/2/1958,293 Arlington Ave.,9,,109 -413,Ellis,Podolony,9/1/1930,1255 Ridgewood Drive,6,,227 -414,Rebecca,Pomerantz,8/14/1953,937 Judson Ave.,9,,243 -415,Wendell,Porges,3/9/1973,1120 Heather Lane,9,,270 -416,Alexis,Powell,10/2/1943,1385 County line Rd.,4,,252 -417,Kurt,Pratt,4/22/1974,1420 Sunnyside Ave.,2,,58 -418,Anna,Prior,8/14/1941,8512 North Ave.,5,,142 -419,Clara,Pristav,3/17/1934,119 Judson Ave.,4,,240 -420,Malcolm,Prokos,7/31/1940,1245 Eastwood,3,,241 -421,Nina,Pulver,6/30/1939,511 Maple Ave. Apt. 1B,4,,224 -422,Susan,Pyster,4/30/1950,245 Oakridge Ave.,5,,208 -423,Jane,Queary,5/21/1938,123 Broadview Lane,9,,42 -424,Julie,Quillman,4/9/1937,752 Clinton Ave.,5,,49 -425,Sabrina,Quintos,5/11/1975,6100 Central Ave,3,[email protected],252 -426,Calvin,Quirk,2/16/1935,807 Old Trail Rd.,3,,281 -427,Heather,Rabatinni,1/4/1934,154 First St.,4,,98 -428,Kara,Rabin,12/18/1933,545 Lakeview Terrace,2,,104 -429,Charis,Rackland,11/6/1932,673 Calais Drive,2,,232 -430,Violette,Raden,6/7/1965,788 Tennyson Ave.,2,,120 -431,John,Radke,5/20/1951,1485 County line Rd.,2,,168 -432,Trent,Rafferty,10/5/1931,210 Crain,5,,260 -433,Alisa,Raisman,5/14/1962,227 Anderson Lane,6,,106 -434,Megan,Rapaport,2/10/1965,8939 Harvard Ct,7,,222 -435,Micah,Rapaport,6/7/1952,1860 Parkside Ln.,6,,176 -436,Emmanual,Raupp,7/8/1953,1486 Oakwood,3,,251 -437,Tess,Redeemer,7/19/1966,2267 Anderson Lane,5,,214 -438,Alanzo,Redman,9/12/1962,3515 Golf Rd.,10,,5 -439,Rita,Reed,10/4/1963,3150 Skokie Valley Rd.,5,,194 -440,Stewart,Reeder,8/19/1954,4126 Hillcrest Ave,3,,149 -441,Charlton,Reese,12/26/1965,619 Judson Ave.,4,,210 -442,Cherry,Reese,1/5/1966,785 Highland place,5,,244 -443,Louis,Reich,9/22/1955,750 Homewood Ave.,2,,70 -444,Ivy,Reidda,12/19/1960,6259 Kincaid Ave.,5,,261 -445,Audrey,Reinhold,8/23/1967,4458 Park Ave.,2,,68 -446,Bradford,Reinhold,10/11/1956,9470 Vilas Circle,2,,150 -447,Hans,Reinhold,6/9/1970,10 Walker Ave.,5,,226 -448,Ursula,Rich,8/21/1951,9137 Judson Ave.,4,,20 -449,Ula,Richards,11/6/1950,24 Oakridge Ave.,2,,168 -450,Nola,Richmond,9/25/1968,47 Vine,6,,121 -451,Seth,Rickey,11/15/1957,6345 St. Johns Ave.,3,,144 -452,Accalia,Rifkin,10/2/1949,35 Lakewood place,5,,221 -453,Pedro,Rifkin,9/10/1948,1270 Linden Ave.,7,,251 -454,Samson,Ritter,8/2/1949,3100 Trailer Way,3,,114 -455,Willis,Ritter,6/7/1947,4567 Grossman Ln.,4,,78 -456,Laurell,Rivi,2/12/1967,1221 Marvel Way,5,,207 -457,Allister,Robbins,1/26/1942,57 Chicago Ave.,1,,77 -458,Elaine,Rodin,2/26/1943,142 Broadview Lane,5,,44 -459,Beth,Roener,12/27/1958,179 Rosemary Way,3,,156 -460,Wayne,Roener,3/25/1944,4465 Stratford Rd.,5,,18 -461,Isaac,Roenick,4/12/1945,38976 Forest View Rd.,2,,130 -462,Faith,Rogalsky,10/31/1969,133 Cavell Ave.,1,,195 -463,Rosanna,Rogers,5/16/1958,45 Eastwood,9,,240 -464,Dorthy,Rojas,7/19/1948,7815 Highland place,3,,87 -465,Lester,Root,1/20/1959,1547 Knolwood Rd.,5,,95 -466,Desma,Rosenbrack,9/2/1950,2937 Judson Ave.,3,,242 -467,Jean,Rosendo,10/14/1951,150 Lily Court,6,,128 -468,Sarah,Rosenzweig,11/12/1970,1320 Heather Lane,5,,244 -469,Nell,Rosie,2/3/1960,175 Clinton Ave.,5,,147 -470,Nina,Roth,1/18/1954,350 Skokie Valley Rd.,4,,280 -471,Darrell,Rothman,3/14/1961,1915 Pleasent Ave.,1,,230 -472,Kara,Rowe,12/13/1971,235 Easton Rd.,2,,82 -473,Evan,Rozenfeld,4/21/1957,302 Lindenwood Ln.,6,,61 -474,Tyson,Rozino,4/25/1962,381 Barkwood Ct.,2,,80 -475,Brice,Rozoff,5/5/1963,181 Beverly Place,7,,87 -476,Quincy,Rubens,1/3/1972,1577 Balsamic Ave.,6,,74 -477,Arthur,Rubenstein,7/13/1946,446 Sheridan Rd.,9,,154 -478,Avery,Rubinoff,9/20/1952,1267 Balsamic Ave.,3,,57 -479,Brad,Rudman,10/11/1953,296 Arlington Ave.,8,,142 -480,Lucy,Ruffer,2/4/1973,79 McCraren,4,,204 -481,Darrick,Ruken,6/27/1964,218 Eastview Dr.,2,,18 -482,Mac,Runn,1/17/1956,360 Summit Ave.,9,,167 -483,Clarinda,Rusnack,12/12/1967,5126 Hill,6,,155 -484,Kimberly,Russell,3/17/1974,1415 Judson Rd.,6,,178 -485,Ariana,Russian,7/7/1950,2698 Sheridan Rd.,7,,151 -486,Neville,Ruth,5/5/1960,2678 Sheridan Rd. ,7,,95 -487,Priscilla,Rychel,6/6/1961,5131 Hill,5,,167 -488,Jason,Rynor,7/7/1962,875 Roger Williams Ave.,3,,184 -489,Molly,Saalfield,8/8/1963,5412 Hill,3,,98 -490,Jessica,Sachman,9/9/1964,473 Blackhawk Rd.,5,,99 -491,page,Sachnoff,10/10/1965,38476 Forest View Rd.,10,,60 -492,Henry,Sachs,11/11/1966,1754 Beech St.,5,,62 -493,Oakey,Sadowsky,7/18/1965,1065 Hillcrest Circle,9,,81 -494,Emerson,Saed,7/22/1962,9117 Fairview Ave.,10,,189 -495,Yvonne,Saigh,4/20/1975,169 McCraren,1,yvi@aol,260 -496,Shaw,Salelli,8/3/1950,4516 Grossman Ln.,4,,225 -497,Celena,Saliba,9/14/1951,309 Priscilla Court,6,,217 -498,Bert,Salomon,11/17/1966,2032 Northbrook Ct.,3,,96 -499,Samuel,Saltpeper,8/13/1932,558 Madison St.,3,,226 -500,Kirby,Saltzman,1/7/1968,4467 Sheridan Rd.,9,,136 -501,Judy,Samson,10/12/1952,52 Clinton Ave.,3,,252 -502,Kelsey,Samuelson,3/7/1970,6431 De Temple Rd.,6,,176 -503,Stanley,Sanderas,11/17/1953,6136 Cobblestone Cir.,10,,153 -504,Pierre,Santucci,11/8/1935,15 Lakewood place,1,,173 -505,Shelby,Santucci,5/30/1965,254 Highwood Ave.,4,,82 -506,Amber,Sass,1/12/1937,120 Heather Lane,4,,163 -507,Peter,Sass,12/22/1954,1201 Deerfield Place,4,,67 -508,Cornelius,Savin,1/20/1955,6423 De Temple Rd.,1,,154 -509,Alan,Savocci,2/13/1956,18 St. Johns,8,,202 -510,Deborah,Scava,5/17/1931,175 Elmwood Circle,5,,158 -511,Wayne,Schack,6/27/1966,535 Knollwood Drive,5,,251 -512,Gail,Schad,7/31/1933,4233 Burton Ave.,7,,167 -513,Jules,Schalfer,8/1/1934,8393 Burton Ave,4,,64 -514,Duke,Schalps,4/17/1957,6443 De Temple Rd.,4,,25 -515,Alexandria,Schanks,3/31/1946,55 Madison St.,4,,189 -516,Jasper,Schecherman,5/15/1958,269 Winsor Mall,4,,63 -517,Tabitha,Schectman,8/15/1970,125 Broadview Lane,6,,63 -518,Milton,Scheff,6/21/1959,5311 Maple Ave. Apt.,2,,260 -519,Madeline,Schelbas,12/16/1969,50 Sheridan,2,,55 -520,Dean,Schelenger,10/31/1967,362 Lindenwood Ln.,4,,91 -521,Hector,Schessel,3/18/1966,212 Clay Rd.,4,,133 -522,Kerry,Scheurzer,7/17/1967,2183 Oakridge Ave.,4,,92 -523,Jason,Schilling,6/22/1963,3267 Bluebird Terr.,3,,141 -524,Hal,Schmidt,7/25/1964,179 Lake Cook Rd.,4,,158 -525,Duke,Schneider,8/23/1965,63 Blackhawk Rd.,5,,164 -526,Lara,Schoenberg,9/28/1966,73 Calais Drive,4,,142 -527,Earl,Schoenfeld,2/19/1965,1101 Deerfield Place,10,,79 -528,Stacy,Schuman,8/28/1968,545 St. Johns Ave.,8,,122 -529,Martin,Schwartz,11/12/1968,1799 Rosemary Way,2,,93 -530,Darrell,Scoravacco,9/2/1969,436 Waverly Rd.,9,,261 -531,Oakey,Scotten,10/4/1970,120 Sunnyside Ave.,1,,49 -532,Leroy,Sedgewick,2/2/1969,3344 Beachwood Ln.,2,,115 -533,Patty,Segel ,1/3/1964,120 High St.,4,,49 -534,Minnie,Seibold,3/8/1953,148 Eastview Dr.,2,,199 -535,Robin,Selan,11/1/1950,231 Sheriden Rd.,1,,175 -536,Trude,Seligman,5/18/1955,669 Kikaid,6,,248 -537,Rodman,Sennett,12/31/1951,157 Vine,3,,227 -538,Clifford,Shafer,7/21/1957,131 Beverly Place,9,,69 -539,Eve,Shafer,8/23/1968,6008 Central Ave.,7,,121 -540,Ruby,Shafer,1/5/1952,547 Knolwood Rd.,6,,205 -541,Cecelia,Shah,2/3/1953,194 First St.,3,,249 -542,Nicolette,Shallow,3/14/1954,8439 Burton Ave,4,,136 -543,Crsby,Shelton,12/14/1962,4256 Grossman Ln.,3,,122 -544,Ferris,Sher,1/9/1963,337 Cavell Ave.,4,,73 -545,Enos,Shorr,2/17/1964,30 Priscilla Court,3,,189 -546,Timothy,Shutan,3/19/1965,9417 Fairview Ave.,1,,281 -547,Dwight,Siber,4/18/1966,8139 Burton Ave,8,,86 -548,Ivan,Siegal,11/20/1937,1231 Hillcrest Ave,4,,221 -549,Wade,Silberman,12/9/1963,6144 Green bay Rd.,5,,174 -550,Ward,Silverman,11/8/1962,2518 Oakridge Ave.,4,,270 -551,Carla,Simon,11/6/1944,224 St.Johns Ave.,4,,77 -552,Dustin,Simon,2/14/1951,8949 Harvard Ct,6,,169 -553,Libby,Siskel,9/14/1969,175 Oakwood Ave.,7,,188 -554,Betsy,Sizemore,4/16/1955,155 Knollwood Drive,4,,28 -555,Byron,Skae,5/13/1956,59 Priscilla Court,6,,260 -556,Elijah,Skikelmire,3/14/1966,4730 Oakland Drive,3,,108 -557,Sabrina,sklyes,10/22/1970,14 Ridgelee Rd,2,,19 -558,Fred,Small,3/14/1964,4777 Balsamic Ave.,3,,180 -559,Roger,Small,11/12/1971,186 Parkside Ln.,3,,13 -560,Stephen,Small,6/17/1957,234 Devonshire Court,2,,101 -561,Adela,Smalls,12/7/1972,161 Judson Ave.,3,,180 -562,Gabe,Smiley,11/28/1974,355 Golf Rd.,4,,204 -563,Rosanna,Smiley,10/30/1973,3412 Hillcrest Ave,10,[email protected],280 -564,Laurell,Smith,9/29/1972,6 Cobblestone Cir.,6,,95 -565,Sarah,Smith,8/13/1971,201-C Frontage Rd.,6,,197 -566,Gail,Solomon,7/1/1970,312-A Crestwood Village Rd.,8,,76 -567,Johanna,Somner,6/14/1969,172 Clinton Ave.,1,,44 -568,Rachel,Soth,7/12/1958,4333 Burton Ave.,2,,184 -569,Hubert,Soto,1/18/1973,112 Old Briar Lane,2,,251 -570,Ray,Spanier,2/13/1974,43588 Kennedy Dr.,6,,69 -571,Chandler,Sporadin,5/19/1968,136 Waverly Rd.,8,,218 -572,Cecil,Sproat,4/18/1967,135 Easton Rd.,4,,119 -573,Kermit,Sraneck,8/14/1959,145 Eastwood,3,,194 -574,Adam,Srungin,1/9/1964,14836 W. River Oaks Dr.,7,,54 -575,Elaine,Starr,1/9/1968,278 Sheridan Rd.,6,,1 -576,Wendy,Stefani,3/19/1975,425 W. Lake Ave.,2,[email protected],224 -577,George,Steibel,4/8/1965,1615 Judson Rd.,4,,192 -578,Frederick,Steiger,4/12/1967,6703 Calais Drive,4,,250 -579,Felix,Stein,6/4/1969,2844 Princeton Ln.,2,,155 -580,Jessica,Stein,2/4/1933,3134 Grove Ave.,4,,187 -581,Dara,Steinberg,4/5/1959,6435 De Temple Rd.,5,,186 -582,Umma,Stickdale,9/10/1960,227 Clay Rd.,3,,152 -583,Moses,Stine,2/7/1957,4 Lakeview Terrace,7,,209 -584,Christie,Stirrat,5/6/1966,315 Skokie Valley Rd.,3,,93 -585,Lena,Stone,10/3/1961,522 N. Greenview Apt.,10,,61 -586,Chenet,Storck,3/8/1932,31876 Forest View Rd.,4,,51 -587,Nathan,Stuart,6/27/1967,1315 Judson Rd.,4,,251 -588,Charles,Stukkle,11/2/1962,510 Crain,3,,18 -589,Sheldon,Sutherland,7/30/1969,9173 Fairview Ave.,5,,225 -590,Prescott,Swanson,7/13/1968,62 Lindenwood Ln.,2,,60 -591,Stacy,Swanson,4/7/1933,6743 De Temple Rd.,4,,84 -592,Carter,Sweig,5/16/1934,12 Walker Ave.,7,,96 -593,Susan,Swislow,4/8/1970,3844 Spruce St.,4,,163 -594,Brad,Szanto,12/16/1963,839 Burton Ave,6,,1 -595,Ted,Szokol,6/19/1935,202 Northbrook Ct.,4,,164 -596,Holly,Talman,7/1/1933,1679 McCraren,10,,37 -597,Violette,Taubner,8/3/1969,1836 W. River Oaks Dr.,2,,187 -598,Katharine,Taxy,1/12/1964,32 Prarie Ln.,4,,111 -599,Mara,Teitbaum,9/30/1938,74 Judson Place,4,,85 -600,Elbert,Terry,9/24/1970,452 N. Greenview Apt.,8,,25 -601,Edward,Thomas,8/17/1970,965 Marion Place Apt. 65C,3,,15 -602,Isaac,Thuente,2/13/1965,1287 Glencoe Ave.,3,,187 -603,Aaron,Tilmon,10/26/1971,6652 Lyons Circle,2,,38 -604,Amber,Timber,1/6/1944,175 Chicago Ave.,3,,105 -605,Chloris,Timber,11/23/1972,21 Lakeview Terrace #2312,10,,158 -606,Hugh,Tiran,12/16/1973,1040 Marvel Way,4,,114 -607,Lucy,Tisch,3/14/1950,6783 Calais Drive,4,,21 -608,Brice,Tobiason,1/7/1930,8433 Burton Ave.,6,,9 -609,Merrell,Tobin,1/7/1974,1875 Roger Williams Ave.,5,toby@aol,83 -610,Forrest,Tomei,4/17/1951,4522 N. Greenview Apt. 1B ,8,,176 -611,Connie,Tondi,3/7/1934,4628 Orwenstensia,4,,205 -612,Wendell,Towain,4/16/1935,2936 Arlington Ave.,7,,1 -613,Harry,Treviarius,5/25/1952,1547 Vine,1,,251 -614,Ivan,Triefu,5/17/1936,21 Twin Oaks Place,4,,271 -615,Gabrielle,Triffler,6/19/1937,205 St. Johns Ave.,6,,85 -261,Mercedes,Kay,9/26/1952,3059 Priscilla Court,2,,250 -262,Alexis,Kellner,7/18/1974,67 Calais Drive,5,,24 -263,Claarence,Kelly,11/30/1930,6070 Central Ave.,3,,29 -264,Roger,Kelly,10/4/1939,171 W. Mellody Rd.,3,,108 -265,Curt,Kern,1/17/1930,2510 Crain,5,,224 -266,Dallas,Kern,8/15/1937,541 Callan Rd.,9,,270 -267,Eugene,Kern,4/19/1935,391 Chester Ave. Apt.,5,,222 -268,Val,Kessler,10/12/1953,1019 Deerfield Rd.,5,,190 -269,Colin,Kestin,6/27/1935,426 Valley Rd.,3,,196 -270,Edana,Kim,5/14/1934,170 Ridgelee Rd,2,,142 -271,Johanna,Kite,11/18/1954,192 Sunnyside Ave.,9,,51 -272,Kenneth,Kivi,4/30/1933,954 First St.,8,,56 -273,Charles,Klein,8/23/1975,20 Vine Ave.,3,,103 -274,Norman,Klein,9/17/1965,1777 Balsamic Ave.,7,,70 -275,Alexandria,Klipowiski,10/12/1966,185 Roger Williams Ave.,3,,226 -276,Adam,Knaff,11/14/1967,8999 Harvard Ct,8,,7 -277,Clara,Koplec,3/26/1932,511 Hill,4,,161 -278,Brooks,Kordick,12/18/1955,458 Balsam Way,3,,117 -279,Turk,Kowalski,11/4/1942,5161 Maple Ave. Apt.,8,,69 -280,Celena,Kraut,1/15/1956,969 Saxony Drive,5,,56 -281,Norma,Kropp,2/13/1957,9710 Vilas Circle,6,,210 -282,Franklin,Krunbein,12/18/1968,1975 Elmwood Circle,3,,271 -283,Allister,Kurtz,1/1/1969,175 Beech St.,9,,213 -284,Elaine,Kurtz,3/17/1958,180 Parkside Ln.,6,,51 -285,Elena,Kust,7/2/1936,287 Glencoe Ave.,9,,270 -286,Peggy,Kuznowicz,2/14/1970,8352 Sumac Rd.,1,,62 -287,Ara,Ladin,9/11/1938,222 Twin Oaks Drive,6,,213 -288,Nicolette,Lamer,7/9/1960,75 Elmwood Circle,3,,13 -316,Ida,Lynman,4/19/1940,4345 Park Ave.,4,,212 -317,Rex,Magani,5/8/1941,186 Oakwood,3,,94 -318,Dion,Mahoney,10/26/1967,920 Sunnyside Ave.,5,,237 -319,Dana,Maki,8/31/1963,206-A Frontage Rd.,2,,53 -320,Jill,Maletsky,9/3/1964,600 Central Ave,5,,202 -321,Jeffrey,Malick,9/6/1964,704 Ridgelee Rd,2,,102 -322,Wendy,Malone,10/12/1965,21 Frontage Rd.,10,,251 -323,Hilary,Mandel,11/27/1965,844 Spruce St.,7,,270 -324,Mario,Manfredini,11/30/1968,313 Grove Ave.,2,,113 -325,Christie,Mantle,6/13/1942,2664 Princeton Ln.,2,,26 -326,Milton,Margolis,12/13/1950,746 Judson Place,1,,261 -327,Shelby,Marko,10/2/1958,574 Chicago Ave.,5,,175 -328,Blake,Marks,8/22/1944,2505 Allison ct.,5,,136 -329,Cecil,Marshall,6/30/1930,1819 Deerfield Rd.,4,,6 -330,Hazel,Mason,1/13/1951,1923 Sunnyside Ave.,3,,235 -331,Fred,Matensky,12/31/1969,359 Priscilla Court,3,,251 -332,Ben,McCarthy,1/18/1970,1320 High St.,2,,23 -333,Dalton,McColley,2/24/1952,1220 High St.,1,,190 -334,Sherlock,McMillan,2/18/1971,85 University Ave.,6,,21 -335,Daryl,Medici,10/30/1946,3355 Golf Rd.,3,,219 -336,Joy,Menaker,11/29/1947,5456 Grossman Ln.,1,,108 -337,Lynn,Mendoza,12/30/1948,1633 McGovern place,6,,46 -338,Betsy,Merritt,3/4/1972,44 Briar Ln,3,,203 -339,Joshua,Meyers,2/26/1950,3478 Bryn Mawr St.,6,,100 -340,Christopher,Michaels,4/9/1973,5053 N. Frances St.,3,,103 -341,Edwin,Michalek,6/13/1968,127 Glencoe Ave.,4,,231 -342,Ferris,Miligori,3/17/1951,255 Allison ct.,4,,70 -369,Laura,Oberman,4/20/1945,1486 W. River Oaks Dr.,4,,57 -370,Robert,Oberman,10/26/1951,104 Ridgelee Rd,8,,261 -371,Grant,Ocampo,11/27/1952,186 Old Deerfield Rd.,2,,181 -372,Cathleen,Olderman,9/3/1967,2224 Sherman Rd.,3,,183 -373,Leslie,Olderman,9/10/1959,305-D Crestwood Village Rd.,4,,124 -374,Rita,Olderman,10/9/1960,144 Chantilly Ln.,5,,15 -375,Trude,Olin,12/28/1953,8655 Old Tall Tree Lane,6,,173 -376,Jordan,Olson,1/7/1954,262 Clay Rd.,5,,234 -377,Newton,Olson,9/14/1967,195 Elmwood Circle,1,,60 -378,Nicholas,Olson,2/3/1941,245 St. Johns Ave.,3,,166 -379,Phoebe,Olson,9/18/1938,1486 Old Deerfield Rd.,6,,280 -380,Tara,Orsini,11/12/1961,3148 cottonwood Ct.,2,,98 -381,Kevin,Ortega,12/7/1963,4733 Burton Ave.,5,,47 -382,Morgan,Ortega,11/2/1962,430 Oakland Drive,4,,80 -383,Sophia,Ortiz,10/28/1968,147 Knolwood Rd.,3,,161 -384,Yvonne,Otiri,10/8/1961,4630 Oakland Drive,9,,199 -385,Randall,Pagali,9/25/1960,2045 St. Johns Ave.,4,,78 -386,Chad,Palmero,8/31/1959,275 Jeffrys Place,6,,46 -642,Katharine,Vanni,10/12/1939,5152 Hill,5,,179 -643,Julie,Vanonni,7/5/1933,5141 Hill,6,,95 -644,Curt,Varon,6/17/1968,45 St. Johns Ave.,4,,195 -645,Newton,Velk,3/19/1944,929 Brittany Ave.,9,,181 -646,Garrett,Vena,7/12/1969,6281 Orwenstensia,3,,99 -647,Avery,Venturi,5/17/1934,220 Vine Ave.,2,,114 -648,Natalie,Venturini,4/12/1933,260 Winsor Mall,3,,202 -649,Connie,Vickman,3/8/1932,80 Old Trail Rd.,4,,55 -650,Leslie,Vignocchi,2/6/1931,1770 First St.,4,,21 -678,Miles,Whittenberg,11/5/1973,115 Chicago Ave.,7,,281 -679,Jill,Widen,12/3/1974,187 Roger Williams Ave.,6,[email protected],78 -616,Murray,Troji,7/22/1938,25 Jeffrys Place,8,,94 -617,Joshua,Trudell,8/25/1939,60 Central Ave.,8,,84 -618,Charlton,Trull,9/13/1940,183 McCraren Rd.,4,,270 -619,Agatha,Trunbar,10/16/1941,8329 Burton Ave,4,,112 -620,Jean,Tschudy,6/26/1953,199 Rosemary Way,6,,260 -621,Tyler,Tunick,2/4/1975,125 Easton Rd.,1,,54 -622,Prescott,Turban,3/8/1965,1383 Cavell Ave.,3,,252 -623,Crystal,Turner,7/8/1954,476 Blackhawk Rd.,4,,261 -624,Margaret,Turner,4/8/1966,17 Chicago Ave.,6,,91 -625,Harris,Uhlman,1/5/1944,241 Callan Rd.,9,,226 -626,Lynn,Umbach,12/13/1931,403 Marquette Rd.,6,,123 -627,Chloris,Underwood,9/25/1950,87 Old Trail Rd.,9,,181 -628,Conroy,Underwood,5/19/1967,201 Callan Rd.,5,,157 -629,Bruce,Urban,8/23/1955,1520 Heather Lane,3,,216 -630,Grace,Ury,8/24/1949,199 Cloverdale Rd.,1,,249 -631,Daphne,Utep,9/10/1956,155 Oakwood Ave.,4,,260 -632,Brandon,Utler,7/23/1948,244 Princeton Ln.,4,,197 -633,Vern,Vahlcamp,6/22/1947,6118 Sheriden Rd.,8,,245 -634,Jordan,Vai,5/21/1946,250 Crain,5,,167 -635,Dominico,Valdez,11/17/1957,368 Woodland Rd.,9,,149 -636,Malcolm,Vale,1/4/1930,2917 Fairview Ave.,3,,239 -637,Sherlock,Vale,12/13/1958,522 Clay Rd.,7,,194 -638,Randall,Valia,2/7/1943,334 Lynn Terrace,4,,211 -639,Gertrude,Van Ellen,7/3/1956,356 Glenlake Dr.,6,,85 -640,Calvin,Van Epps,1/7/1959,204 St. Johns Ave.,4,,4 -641,Norris,Vanderflute,2/18/1960,1349 Bay Colony Dr.,8,,280 -260,Rosa,Karen,8/14/1951,44 Chantilly Ln.,5,,164 -289,Dara,Lang,3/17/1971,632 Florence Dr.,4,,56 -290,Jerome,Langer,6/3/1959,5917 Fairview Ave.,3,,104 -291,Phillip,Langerman,5/30/1958,301 Chester Ave. Apt.,5,,171 -292,Sarah,Lantz,4/17/1959,6741 Blackstone Ave.,6,,55 -293,Brenda,Larson,4/27/1957,1433 Arbor Rd.,4,,58 -294,Pierre,LaRussa,3/30/1946,132 Fort Sheriden Ave.,8,,260 -295,Darnell,Lasky,2/16/1945,4 Kikaid,6,,218 -296,Chad,Laurie,4/20/1972,24 St.Johns Ave.,7,,260 -297,Richard,Lawerence,5/12/1973,124 Devonshire Court,4,,139 -298,Caesar,Leech,5/22/1936,2189 Oakridge Ave.,9,,252 -299,Graham,Lencinoni,12/6/1943,7250 Homewood Ave.,2,,52 -300,Daryl,Lenzi,5/6/1960,248 Eastview Dr.,3,,280 -301,Parker,Leonard,8/9/1961,188 Balsam Way,4,,99 -302,Isaiah,Less,10/2/1941,59 Cordon Terr.,3,,68 -303,Arthur,Levin,9/29/1940,3900 Chester Ave. Apt.,8,,71 -304,Jared,Lewitz,8/21/1939,1831 Beverly Place #9D,2,,227 -305,Derrick,Lidholm,6/18/1961,925 Jeffrys Place,2,,72 -306,Leroy,Lieber,7/13/1938,505 N. Frances St.,2,,149 -307,Veronica,Lieber,6/12/1974,3062 Lindenwood Ln.,1,,8 -308,Hal,Lipper,6/28/1937,6218 Oakridge Ave.,4,,207 -309,Rosalie,Liska,7/8/1975,701 W. Mellody Rd.,5,[email protected],252 -310,Fiona,Lissner,8/7/1965,134 Devonshire Court,5,,93 -311,Kate,Littleman,1/4/1937,236 Arlington Ave.,3,,111 -312,Homer,Lucas,2/9/1938,7450 Homewood Ave.,2,,212 -313,June,Ludwig,3/13/1939,4206 Trinity Ct.,8,,102 -314,Peter,Luke,9/17/1966,220 Grant Blvd.,4,,23 -315,Weston,Lurie,7/26/1962,3618 Sheriden Rd.,2,,193 -343,Barry,Miltenberg,4/20/1952,12 Fort Sheriden Ave.,4,,281 -344,Conroy,Mintz,5/21/1953,799 Rosemary Way,6,,79 -345,Brett,Morales,6/28/1954,19 Judson Ave.,6,,32 -346,Faith,Moreno,3/30/1953,1734 Balsamic Ave.,9,,271 -347,Lynn,Morin,5/10/1974,1535 Knollwood Drive,7,[email protected],8 -348,Louis,Moss,7/17/1955,463 Blackhawk Rd.,3,,43 -349,Cynthia,Muchin,8/12/1956,44 Sheridan Rd.,6,,160 -350,Oliver,Mullen,4/25/1954,1436 W. River Oaks Dr.,2,,246 -351,Benjamin,Mullick,9/16/1957,2632 Prarie Ln.,2,,197 -352,Johanna,Munski,12/12/1967,1575 Oak Ave. Apt. 2C,10,,190 -353,Taylor,Nachenberg,2/3/1969,3385 University Ave.,3,,211 -354,Walt,Nastier,5/26/1955,347 Bryn Mawr St.,10,,219 -355,Molly,Nathan,6/28/1956,137 Cavell Ave.,4,,270 -356,Micah,Navarro,2/4/1931,447 Sheridan Rd.,6,,84 -357,Emily,Nedved,6/6/1975,155 Oak Ave. Apt. 2C,2,,217 -358,Dominico,Noonan,7/1/1965,194 Cloverdale Rd.,8,,260 -359,Calvin,Nowacku,12/16/1943,8545 Woodbine,3,,271 -360,Rosanna,Nyberg,9/4/1956,726 White Oaks Ave.,7,,18 -361,Palmer,Nye,8/7/1974,6793 Calais Drive,2,laurap@aol,219 -362,Grace,O' Malley,7/12/1957,226 Anderson Lane,10,,260 -363,Jane,O'Campo,11/8/1978,854 Woodbine,2,[email protected],249 -364,Erin,O'Rourke,12/8/1979,175 Oak Ave. Apt. 2C,4,[email protected],33 -365,Karl,O'Rourke,6/23/1935,581 Hill St. Apt. 234,3,,84 -366,Libby,O'Toole,8/21/1958,6516 Cobblestone Cir.,6,,233 -367,Hugh,Oakey,11/17/1940,320 Vine Ave.,3,,173 -368,Judy,Oakey,8/2/1966,865 Old Tall Tree Lane,3,,97 -651,Sherlock,Vingrad,8/17/1970,7510 Homewood Ave.,6,,57 -652,Carrie,Vista,1/12/1970,2872 Virginia Rd.,5,,115 -653,Kevin,Vista,1/15/1950,249 Woodridge Drive,4,,143 -654,Phillip,Viti,2/13/1951,195 Lake Cook Rd.,5,,238 -655,Tara,Vognaroli,3/26/1952,345 Glenlake Dr.,1,,260 -656,Garrett,Vole,7/18/1969,1907 S. Prospect Ave.,3,,261 -657,Roy,Volpe,1/12/1978,4930 Oakland Drive,5,[email protected],61 -658,Molly,Vyas,4/29/1953,210 Cresant Rd.,3,,73 -659,Calbert,Wade,5/6/1954,465 Stratford Rd.,2,,251 -660,Kerry,Wagner,3/6/1980,6146 Cobblestone Cir.,4,,270 -661,Jay,Walich,1/1/1977,7828 Tennyson Ave.,4,[email protected],148 -662,Charis,Walker,12/9/1977,12 Twin Oaks Place,2,,240 -663,Mirian,Waller,6/7/1955,422 Clay Rd.,3,,83 -664,Rupert,Waller,11/12/1977,30 Lindenwood Ln.,7,,150 -665,Bradford,Walters,7/24/1956,1795 Lake Cook Rd.,3,,39 -666,Isaac,Walters,9/12/1975,6600 Central Ave.,3,[email protected],77 -667,Leslie,Walters,8/3/1957,109 Marquette Rd.,4,,172 -668,Dustin,Wanger,8/8/1970,395 Lake Cook Rd.,5,,98 -669,Hubert,Waxews,9/3/1971,305 Priscilla Court,3,,88 -670,Wilson,Wayne,3/5/1971,6328 Orwenstensia,4,,250 -671,Kelsey,Weicker,3/9/1956,277 Balsamic Ave.,7,,246 -672,Katharine,Weinstein,10/5/1958,1915 Lewis Ln. Apt 13,4,,223 -673,Gabe,Weintraub,10/2/1972,149 Cloverdale Rd.,5,,104 -674,Orville,Weisel,3/12/1959,3647 Bluebird Terr.,4,,41 -675,Alvin,Wender,11/1/1959,170 Lily Court,2,,100 -676,Tyler,Wender,5/19/1958,3160 Summit Ave.,9,,162 -677,Crsby,West,4/13/1957,266 Green Bay Rd.,4,,88
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/d385ac72/testdata/data/mstr/eatwh1/csv/LU_CUST_CITY.TXT ---------------------------------------------------------------------- diff --git a/testdata/data/mstr/eatwh1/csv/LU_CUST_CITY.TXT b/testdata/data/mstr/eatwh1/csv/LU_CUST_CITY.TXT deleted file mode 100644 index 6b9b064..0000000 --- a/testdata/data/mstr/eatwh1/csv/LU_CUST_CITY.TXT +++ /dev/null @@ -1,258 +0,0 @@ -1,Arlin,5 -2,San Pedro,7 -3,Springfield,1 -4,Chappel Hill,3 -5,Scranburg,4 -6,Pebble Beach,3 -7,Martinsville,2 -8,Maddon,5 -9,Peoria,4 -10,Pecos,5 -11,Lake Barkley,2 -12,Alcameda,4 -13,Fingers Lake,5 -14,Scranton,4 -15,Bobstown,7 -16,Blue River,4 -17,Alka,7 -18,Lahiana,5 -19,Glen Canyon,2 -20,Brookline,5 -21,Zelston,5 -22,Tolston,2 -23,Lane,6 -24,Beckford,1 -25,Camdon,2 -26,Yellow Springs,5 -27,Arlington Heights,6 -28,Fort Mirth,1 -29,Joliet,3 -30,Panama City,3 -31,Wheeling,6 -32,Chiappas,5 -33,Iowa City,4 -34,Lake Chamberlain,4 -35,Newport,1 -36,Orlando,3 -37,Grierville,2 -38,Alta,6 -39,Santa Fe,5 -40,Janesville,7 -41,Arcadia,4 -42,Jamestown,2 -43,Warsaw,5 -44,Hongston,7 -45,Memorial,4 -46,Washville,2 -47,Valencia,5 -48,Amelia Island,6 -49,Fort Legion,1 -50,Middleton,3 -51,La Paz,6 -52,Brownsville,6 -53,Birmingham,4 -54,Edgartown,2 -55,Rapid City,1 -56,Black Earth,7 -57,Rockford,1 -58,Bothe,4 -59,Lahanta,3 -60,Cape Blanco,5 -61,Blue Hills,2 -62,Beaver Heights,2 -63,Astron,1 -64,Tinley Park,4 -65,Tahoe City,6 -66,Sterling,2 -67,St. Martinsville,7 -68,Mint Beach,3 -69,Armstrong,6 -70,Kingston,2 -71,Columbus,4 -72,Madrid Heights,5 -73,Santa Cruz,7 -74,White Cape,1 -75,Pilloville,1 -76,Philadelphia,2 -77,Newburg,5 -78,Cincinnatti,4 -79,Keystone,4 -80,Afton,5 -81,Annapolis,2 -82,Kohler,3 -83,Castle Rock,1 -84,Beaver Lake,6 -85,Emerald Bay,4 -86,Baton Rouge,5 -87,Gold Beach,6 -88,Warren,2 -89,Brusselsburg,6 -90,Breckenridge,7 -91,Canyon Village,2 -92,Stowe,1 -93,New Cannan,7 -94,Catskill,1 -95,Guatamala City,7 -96,Burrus,7 -97,Bolton Valley,6 -98,Avery Heights,6 -99,Batesville,3 -100,Wickenburg,4 -101,Milltown,5 -102,Willderville,6 -103,Forest,2 -104,Newport Heights,6 -105,Sipperville,3 -106,Burnt Harbor,3 -107,Lancaster,2 -108,Rockport,1 -109,Nashville,3 -110,Kolesville,1 -111,Fort Lauderdale,3 -112,Altoola,6 -113,Budston,5 -114,Columbia,4 -115,Antietam Creek,2 -116,Labiansa,3 -117,Lake Arrowhead,2 -118,Earlesville,6 -119,Telluride,7 -120,Block Island,2 -121,Warrenton,2 -122,Los Alamos,1 -123,Caracton,5 -124,Vaughter,2 -125,Miaville,1 -126,West Ambler,1 -127,Moreno Valley,5 -128,Lake Forest,2 -129,Mt. Hood,6 -130,Teton Village,1 -131,Waupaca,5 -132,Diamond Lake,4 -133,West Point,1 -134,Front Royal,2 -135,Glen Rose,1 -136,Eggleston,2 -137,Valley Forge,2 -138,Chelsea,7 -139,Mt. Washington,6 -140,Lake Wachuka,3 -141,Pritchard,5 -142,Havana,5 -143,Capeton,7 -144,Pyongyang,7 -145,Mt. Rose,4 -146,West Bloomfield Hills,4 -147,Blue Hill ,6 -148,Fort Sumter,3 -149,Prockton,1 -150,Kettle Falls,5 -151,Springfield,4 -152,Albon,7 -153,Des Plaines,5 -154,Bethel,4 -155,Michiana,2 -156,Quito,3 -157,Bloomington,7 -158,Grafton,3 -159,Stirling,6 -160,Canton,4 -161,Camden,4 -162,San Antonio,5 -163,Kent,3 -164,Janesville,6 -165,Chelston,5 -166,Marionne,3 -167,Buenos Aires,6 -168,Mannatowa,1 -169,Virginia Beach,2 -170,Aspen,7 -171,Moorestown,7 -172,Snake River,7 -173,Scranton Heights,6 -174,Marion,6 -175,Tokosburg,5 -176,Zurstown,2 -177,Stratton,1 -178,Montrose,2 -179,Mt. Everest,6 -180,Valley Heights,4 -181,Tucson,6 -182,Arpin,6 -183,Dynatown,2 -184,Bucrest,6 -185,Jersey City,2 -186,Moscow,3 -187,Breckford,7 -188,St. Paul,4 -189,Middleton,1 -190,New Haven,1 -191,Miami,3 -192,Castle,2 -193,Arcala,3 -194,Gainsville,3 -195,Baine,6 -196,Burton,4 -197,Lane Heights,5 -198,La Quinta,3 -199,Bruceville,1 -200,Morro Bay,5 -201,Indianapolis,4 -202,West Dover,1 -203,Vicksburg,1 -204,Allagash,4 -205,Kobe,6 -206,Lake George,3 -207,Garrison,1 -208,Pradington,2 -209,Derring,5 -210,Fall River,2 -211,Riverwoods,7 -212,Lafayettee,1 -213,Bagad,4 -214,Juneau,6 -215,Vinton,3 -216,Cripple Creek,4 -217,Woodstock,2 -218,St. Edward,3 -219,Waikkiki,7 -220,Forest Heights,3 -221,Telosiv,4 -222,Crystal Mountain,1 -223,Brooklyn,1 -224,Phoenix,7 -225,Akron,4 -226,Amestra,1 -227,Rackton,3 -228,Williamsburg,2 -229,Camden Heights,1 -230,Williamstown,7 -231,Arch Cape,1 -232,Eagle River,4 -233,Miliville,3 -234,Andersonville,6 -235,Bandon,3 -236,Lima,6 -237,Westin,3 -238,Arlington Springs,6 -239,Madula,5 -240,Waukegan,7 -241,Martinville,3 -242,Blockton,4 -243,Amsterdam,7 -244,Des Moines,4 -245,San Fransisco,6 -246,Avery Island,7 -247,Naples,3 -248,Prince Williams ,3 -249,Valdena,2 -250,Knoxville,3 -251,London,8 -252,Bath,8 -260,Paris,9 -261,Lyons,9 -270,Berlin,10 -271,Mainz,10 -280,Toronto,11 -281,Montreal,11 http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/d385ac72/testdata/data/mstr/eatwh1/csv/LU_CUST_REGION.TXT ---------------------------------------------------------------------- diff --git a/testdata/data/mstr/eatwh1/csv/LU_CUST_REGION.TXT b/testdata/data/mstr/eatwh1/csv/LU_CUST_REGION.TXT deleted file mode 100644 index 0d4b2ef..0000000 --- a/testdata/data/mstr/eatwh1/csv/LU_CUST_REGION.TXT +++ /dev/null @@ -1,11 +0,0 @@ -1,North-East -2,Mid-Atlantic -3,South-East -4,Central -5,South -6,North-West -7,South-West -8,England -9,France -10,Germany -11,Canada http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/d385ac72/testdata/data/mstr/eatwh1/csv/LU_DATE.TXT ---------------------------------------------------------------------- diff --git a/testdata/data/mstr/eatwh1/csv/LU_DATE.TXT b/testdata/data/mstr/eatwh1/csv/LU_DATE.TXT deleted file mode 100644 index 2b608db..0000000 --- a/testdata/data/mstr/eatwh1/csv/LU_DATE.TXT +++ /dev/null @@ -1,730 +0,0 @@ -12/13/1997,199712,199704,1997 -12/14/1997,199712,199704,1997 -12/15/1997,199712,199704,1997 -12/16/1997,199712,199704,1997 -12/17/1997,199712,199704,1997 -12/18/1997,199712,199704,1997 -12/19/1997,199712,199704,1997 -12/20/1997,199712,199704,1997 -12/21/1997,199712,199704,1997 -12/22/1997,199712,199704,1997 -12/23/1997,199712,199704,1997 -12/24/1997,199712,199704,1997 -12/25/1997,199712,199704,1997 -12/26/1997,199712,199704,1997 -12/27/1997,199712,199704,1997 -12/28/1997,199712,199704,1997 -12/29/1997,199712,199704,1997 -12/30/1997,199712,199704,1997 -12/31/1997,199712,199704,1997 -1/1/1998,199801,199801,1998 -1/2/1998,199801,199801,1998 -1/3/1998,199801,199801,1998 -1/4/1998,199801,199801,1998 -1/5/1998,199801,199801,1998 -1/6/1998,199801,199801,1998 -1/7/1998,199801,199801,1998 -1/8/1998,199801,199801,1998 -1/9/1998,199801,199801,1998 -1/10/1998,199801,199801,1998 -1/11/1998,199801,199801,1998 -1/12/1998,199801,199801,1998 -1/13/1998,199801,199801,1998 -1/14/1998,199801,199801,1998 -1/15/1998,199801,199801,1998 -1/16/1998,199801,199801,1998 -1/17/1998,199801,199801,1998 -1/18/1998,199801,199801,1998 -1/19/1998,199801,199801,1998 -1/20/1998,199801,199801,1998 -1/21/1998,199801,199801,1998 -1/22/1998,199801,199801,1998 -1/23/1998,199801,199801,1998 -1/24/1998,199801,199801,1998 -1/25/1998,199801,199801,1998 -1/26/1998,199801,199801,1998 -1/27/1998,199801,199801,1998 -1/28/1998,199801,199801,1998 -1/29/1998,199801,199801,1998 -1/30/1998,199801,199801,1998 -1/31/1998,199801,199801,1998 -2/1/1998,199802,199801,1998 -2/2/1998,199802,199801,1998 -2/3/1998,199802,199801,1998 -2/4/1998,199802,199801,1998 -2/5/1998,199802,199801,1998 -2/6/1998,199802,199801,1998 -2/7/1998,199802,199801,1998 -2/8/1998,199802,199801,1998 -2/9/1998,199802,199801,1998 -2/10/1998,199802,199801,1998 -2/11/1998,199802,199801,1998 -2/12/1998,199802,199801,1998 -2/13/1998,199802,199801,1998 -2/14/1998,199802,199801,1998 -2/15/1998,199802,199801,1998 -2/16/1998,199802,199801,1998 -2/17/1998,199802,199801,1998 -2/18/1998,199802,199801,1998 -2/19/1998,199802,199801,1998 -2/20/1998,199802,199801,1998 -2/21/1998,199802,199801,1998 -2/22/1998,199802,199801,1998 -2/23/1998,199802,199801,1998 -2/24/1998,199802,199801,1998 -2/25/1998,199802,199801,1998 -2/26/1998,199802,199801,1998 -2/27/1998,199802,199801,1998 -2/28/1998,199802,199801,1998 -3/1/1998,199803,199801,1998 -3/2/1998,199803,199801,1998 -3/3/1998,199803,199801,1998 -3/4/1998,199803,199801,1998 -3/5/1998,199803,199801,1998 -3/6/1998,199803,199801,1998 -3/7/1998,199803,199801,1998 -3/8/1998,199803,199801,1998 -3/9/1998,199803,199801,1998 -3/10/1998,199803,199801,1998 -3/11/1998,199803,199801,1998 -3/12/1998,199803,199801,1998 -3/13/1998,199803,199801,1998 -3/14/1998,199803,199801,1998 -3/15/1998,199803,199801,1998 -3/16/1998,199803,199801,1998 -3/17/1998,199803,199801,1998 -3/18/1998,199803,199801,1998 -3/19/1998,199803,199801,1998 -3/20/1998,199803,199801,1998 -3/21/1998,199803,199801,1998 -3/22/1998,199803,199801,1998 -3/23/1998,199803,199801,1998 -3/24/1998,199803,199801,1998 -3/25/1998,199803,199801,1998 -3/26/1998,199803,199801,1998 -3/27/1998,199803,199801,1998 -3/28/1998,199803,199801,1998 -3/29/1998,199803,199801,1998 -3/30/1998,199803,199801,1998 -3/31/1998,199803,199801,1998 -4/1/1998,199804,199802,1998 -4/2/1998,199804,199802,1998 -4/3/1998,199804,199802,1998 -4/4/1998,199804,199802,1998 -4/5/1998,199804,199802,1998 -4/6/1998,199804,199802,1998 -4/7/1998,199804,199802,1998 -4/8/1998,199804,199802,1998 -4/9/1998,199804,199802,1998 -4/10/1998,199804,199802,1998 -4/11/1998,199804,199802,1998 -4/12/1998,199804,199802,1998 -4/13/1998,199804,199802,1998 -4/14/1998,199804,199802,1998 -4/15/1998,199804,199802,1998 -4/16/1998,199804,199802,1998 -4/17/1998,199804,199802,1998 -4/18/1998,199804,199802,1998 -4/19/1998,199804,199802,1998 -4/20/1998,199804,199802,1998 -4/21/1998,199804,199802,1998 -4/22/1998,199804,199802,1998 -4/23/1998,199804,199802,1998 -4/24/1998,199804,199802,1998 -4/25/1998,199804,199802,1998 -4/26/1998,199804,199802,1998 -4/27/1998,199804,199802,1998 -4/28/1998,199804,199802,1998 -4/29/1998,199804,199802,1998 -4/30/1998,199804,199802,1998 -5/1/1998,199805,199802,1998 -5/2/1998,199805,199802,1998 -5/3/1998,199805,199802,1998 -5/4/1998,199805,199802,1998 -5/5/1998,199805,199802,1998 -5/6/1998,199805,199802,1998 -5/7/1998,199805,199802,1998 -5/8/1998,199805,199802,1998 -5/9/1998,199805,199802,1998 -5/10/1998,199805,199802,1998 -5/11/1998,199805,199802,1998 -5/12/1998,199805,199802,1998 -5/13/1998,199805,199802,1998 -5/14/1998,199805,199802,1998 -5/15/1998,199805,199802,1998 -5/16/1998,199805,199802,1998 -5/17/1998,199805,199802,1998 -5/18/1998,199805,199802,1998 -5/19/1998,199805,199802,1998 -5/20/1998,199805,199802,1998 -5/21/1998,199805,199802,1998 -5/22/1998,199805,199802,1998 -5/23/1998,199805,199802,1998 -5/24/1998,199805,199802,1998 -5/25/1998,199805,199802,1998 -5/26/1998,199805,199802,1998 -5/27/1998,199805,199802,1998 -5/28/1998,199805,199802,1998 -5/29/1998,199805,199802,1998 -5/30/1998,199805,199802,1998 -5/31/1998,199805,199802,1998 -6/1/1998,199806,199802,1998 -6/2/1998,199806,199802,1998 -6/3/1998,199806,199802,1998 -6/4/1998,199806,199802,1998 -6/5/1998,199806,199802,1998 -6/6/1998,199806,199802,1998 -6/7/1998,199806,199802,1998 -6/8/1998,199806,199802,1998 -6/9/1998,199806,199802,1998 -6/10/1998,199806,199802,1998 -6/11/1998,199806,199802,1998 -6/12/1998,199806,199802,1998 -6/13/1998,199806,199802,1998 -6/14/1998,199806,199802,1998 -6/15/1998,199806,199802,1998 -6/16/1998,199806,199802,1998 -6/17/1998,199806,199802,1998 -6/18/1998,199806,199802,1998 -6/19/1998,199806,199802,1998 -6/20/1998,199806,199802,1998 -6/21/1998,199806,199802,1998 -6/22/1998,199806,199802,1998 -6/23/1998,199806,199802,1998 -6/24/1998,199806,199802,1998 -6/25/1998,199806,199802,1998 -6/26/1998,199806,199802,1998 -6/27/1998,199806,199802,1998 -6/28/1998,199806,199802,1998 -6/29/1998,199806,199802,1998 -6/30/1998,199806,199802,1998 -7/1/1998,199807,199803,1998 -7/2/1998,199807,199803,1998 -7/3/1998,199807,199803,1998 -7/4/1998,199807,199803,1998 -7/5/1998,199807,199803,1998 -7/6/1998,199807,199803,1998 -7/7/1998,199807,199803,1998 -7/8/1998,199807,199803,1998 -7/9/1998,199807,199803,1998 -7/10/1998,199807,199803,1998 -7/11/1998,199807,199803,1998 -7/12/1998,199807,199803,1998 -7/13/1998,199807,199803,1998 -7/14/1998,199807,199803,1998 -7/15/1998,199807,199803,1998 -7/16/1998,199807,199803,1998 -7/17/1998,199807,199803,1998 -7/18/1998,199807,199803,1998 -7/19/1998,199807,199803,1998 -7/20/1998,199807,199803,1998 -7/21/1998,199807,199803,1998 -7/22/1998,199807,199803,1998 -7/23/1998,199807,199803,1998 -7/24/1998,199807,199803,1998 -7/25/1998,199807,199803,1998 -7/26/1998,199807,199803,1998 -7/27/1998,199807,199803,1998 -7/28/1998,199807,199803,1998 -7/29/1998,199807,199803,1998 -7/30/1998,199807,199803,1998 -7/31/1998,199807,199803,1998 -8/1/1998,199808,199803,1998 -8/2/1998,199808,199803,1998 -8/3/1998,199808,199803,1998 -8/4/1998,199808,199803,1998 -8/5/1998,199808,199803,1998 -8/6/1998,199808,199803,1998 -8/7/1998,199808,199803,1998 -8/8/1998,199808,199803,1998 -8/9/1998,199808,199803,1998 -8/10/1998,199808,199803,1998 -8/11/1998,199808,199803,1998 -8/12/1998,199808,199803,1998 -8/13/1998,199808,199803,1998 -8/14/1998,199808,199803,1998 -8/15/1998,199808,199803,1998 -8/16/1998,199808,199803,1998 -8/17/1998,199808,199803,1998 -8/18/1998,199808,199803,1998 -8/19/1998,199808,199803,1998 -8/20/1998,199808,199803,1998 -8/21/1998,199808,199803,1998 -8/22/1998,199808,199803,1998 -8/23/1998,199808,199803,1998 -8/24/1998,199808,199803,1998 -8/25/1998,199808,199803,1998 -8/26/1998,199808,199803,1998 -8/27/1998,199808,199803,1998 -8/28/1998,199808,199803,1998 -8/29/1998,199808,199803,1998 -8/30/1998,199808,199803,1998 -8/31/1998,199808,199803,1998 -9/1/1998,199809,199803,1998 -9/2/1998,199809,199803,1998 -9/3/1998,199809,199803,1998 -9/4/1998,199809,199803,1998 -9/5/1998,199809,199803,1998 -9/6/1998,199809,199803,1998 -9/7/1998,199809,199803,1998 -9/8/1998,199809,199803,1998 -9/9/1998,199809,199803,1998 -9/10/1998,199809,199803,1998 -9/11/1998,199809,199803,1998 -9/12/1998,199809,199803,1998 -9/13/1998,199809,199803,1998 -9/14/1998,199809,199803,1998 -9/15/1998,199809,199803,1998 -9/16/1998,199809,199803,1998 -9/17/1998,199809,199803,1998 -9/18/1998,199809,199803,1998 -9/19/1998,199809,199803,1998 -9/20/1998,199809,199803,1998 -9/21/1998,199809,199803,1998 -9/22/1998,199809,199803,1998 -9/23/1998,199809,199803,1998 -9/24/1998,199809,199803,1998 -9/25/1998,199809,199803,1998 -9/26/1998,199809,199803,1998 -9/27/1998,199809,199803,1998 -9/28/1998,199809,199803,1998 -9/29/1998,199809,199803,1998 -9/30/1998,199809,199803,1998 -10/1/1998,199810,199804,1998 -10/2/1998,199810,199804,1998 -10/3/1998,199810,199804,1998 -10/4/1998,199810,199804,1998 -10/5/1998,199810,199804,1998 -10/6/1998,199810,199804,1998 -10/7/1998,199810,199804,1998 -10/8/1998,199810,199804,1998 -10/9/1998,199810,199804,1998 -10/10/1998,199810,199804,1998 -10/11/1998,199810,199804,1998 -10/12/1998,199810,199804,1998 -10/13/1998,199810,199804,1998 -10/14/1998,199810,199804,1998 -10/15/1998,199810,199804,1998 -10/16/1998,199810,199804,1998 -10/17/1998,199810,199804,1998 -10/18/1998,199810,199804,1998 -10/19/1998,199810,199804,1998 -10/20/1998,199810,199804,1998 -10/21/1998,199810,199804,1998 -10/22/1998,199810,199804,1998 -10/23/1998,199810,199804,1998 -10/24/1998,199810,199804,1998 -10/25/1998,199810,199804,1998 -10/26/1998,199810,199804,1998 -10/27/1998,199810,199804,1998 -10/28/1998,199810,199804,1998 -10/29/1998,199810,199804,1998 -10/30/1998,199810,199804,1998 -10/31/1998,199810,199804,1998 -11/1/1998,199811,199804,1998 -11/2/1998,199811,199804,1998 -11/3/1998,199811,199804,1998 -11/4/1998,199811,199804,1998 -11/5/1998,199811,199804,1998 -11/6/1998,199811,199804,1998 -11/7/1998,199811,199804,1998 -11/8/1998,199811,199804,1998 -11/9/1998,199811,199804,1998 -11/10/1998,199811,199804,1998 -11/11/1998,199811,199804,1998 -11/12/1998,199811,199804,1998 -11/13/1998,199811,199804,1998 -11/14/1998,199811,199804,1998 -11/15/1998,199811,199804,1998 -11/16/1998,199811,199804,1998 -11/17/1998,199811,199804,1998 -11/18/1998,199811,199804,1998 -11/19/1998,199811,199804,1998 -11/20/1998,199811,199804,1998 -11/21/1998,199811,199804,1998 -11/22/1998,199811,199804,1998 -11/23/1998,199811,199804,1998 -11/24/1998,199811,199804,1998 -11/25/1998,199811,199804,1998 -11/26/1998,199811,199804,1998 -11/27/1998,199811,199804,1998 -11/28/1998,199811,199804,1998 -11/29/1998,199811,199804,1998 -11/30/1998,199811,199804,1998 -12/1/1998,199812,199804,1998 -12/2/1998,199812,199804,1998 -12/3/1998,199812,199804,1998 -12/4/1998,199812,199804,1998 -12/5/1998,199812,199804,1998 -12/6/1998,199812,199804,1998 -12/7/1998,199812,199804,1998 -12/8/1998,199812,199804,1998 -12/9/1998,199812,199804,1998 -12/10/1998,199812,199804,1998 -12/11/1998,199812,199804,1998 -12/12/1998,199812,199804,1998 -12/13/1998,199812,199804,1998 -12/14/1998,199812,199804,1998 -12/15/1998,199812,199804,1998 -12/16/1998,199812,199804,1998 -12/17/1998,199812,199804,1998 -12/18/1998,199812,199804,1998 -12/19/1998,199812,199804,1998 -12/20/1998,199812,199804,1998 -12/21/1998,199812,199804,1998 -12/22/1998,199812,199804,1998 -12/23/1998,199812,199804,1998 -12/24/1998,199812,199804,1998 -12/25/1998,199812,199804,1998 -12/26/1998,199812,199804,1998 -12/27/1998,199812,199804,1998 -12/28/1998,199812,199804,1998 -12/29/1998,199812,199804,1998 -12/30/1998,199812,199804,1998 -12/31/1998,199812,199804,1998 -1/1/1997,199701,199701,1997 -1/2/1997,199701,199701,1997 -1/3/1997,199701,199701,1997 -1/4/1997,199701,199701,1997 -1/5/1997,199701,199701,1997 -1/6/1997,199701,199701,1997 -1/7/1997,199701,199701,1997 -1/8/1997,199701,199701,1997 -1/9/1997,199701,199701,1997 -1/10/1997,199701,199701,1997 -1/11/1997,199701,199701,1997 -1/12/1997,199701,199701,1997 -1/13/1997,199701,199701,1997 -1/14/1997,199701,199701,1997 -1/15/1997,199701,199701,1997 -1/16/1997,199701,199701,1997 -1/17/1997,199701,199701,1997 -1/18/1997,199701,199701,1997 -1/19/1997,199701,199701,1997 -1/20/1997,199701,199701,1997 -1/21/1997,199701,199701,1997 -1/22/1997,199701,199701,1997 -1/23/1997,199701,199701,1997 -1/24/1997,199701,199701,1997 -1/25/1997,199701,199701,1997 -1/26/1997,199701,199701,1997 -1/27/1997,199701,199701,1997 -1/28/1997,199701,199701,1997 -1/29/1997,199701,199701,1997 -1/30/1997,199701,199701,1997 -1/31/1997,199701,199701,1997 -2/1/1997,199702,199701,1997 -2/2/1997,199702,199701,1997 -2/3/1997,199702,199701,1997 -2/4/1997,199702,199701,1997 -2/5/1997,199702,199701,1997 -2/6/1997,199702,199701,1997 -2/7/1997,199702,199701,1997 -2/8/1997,199702,199701,1997 -2/9/1997,199702,199701,1997 -2/10/1997,199702,199701,1997 -2/11/1997,199702,199701,1997 -2/12/1997,199702,199701,1997 -2/13/1997,199702,199701,1997 -2/14/1997,199702,199701,1997 -2/15/1997,199702,199701,1997 -2/16/1997,199702,199701,1997 -2/17/1997,199702,199701,1997 -2/18/1997,199702,199701,1997 -2/19/1997,199702,199701,1997 -2/20/1997,199702,199701,1997 -2/21/1997,199702,199701,1997 -2/22/1997,199702,199701,1997 -2/23/1997,199702,199701,1997 -2/24/1997,199702,199701,1997 -2/25/1997,199702,199701,1997 -2/26/1997,199702,199701,1997 -2/27/1997,199702,199701,1997 -2/28/1997,199702,199701,1997 -3/1/1997,199703,199701,1997 -3/2/1997,199703,199701,1997 -3/3/1997,199703,199701,1997 -3/4/1997,199703,199701,1997 -3/5/1997,199703,199701,1997 -3/6/1997,199703,199701,1997 -3/7/1997,199703,199701,1997 -3/8/1997,199703,199701,1997 -3/9/1997,199703,199701,1997 -3/10/1997,199703,199701,1997 -3/11/1997,199703,199701,1997 -3/12/1997,199703,199701,1997 -3/13/1997,199703,199701,1997 -3/14/1997,199703,199701,1997 -3/15/1997,199703,199701,1997 -3/16/1997,199703,199701,1997 -3/17/1997,199703,199701,1997 -3/18/1997,199703,199701,1997 -3/19/1997,199703,199701,1997 -3/20/1997,199703,199701,1997 -3/21/1997,199703,199701,1997 -3/22/1997,199703,199701,1997 -3/23/1997,199703,199701,1997 -3/24/1997,199703,199701,1997 -3/25/1997,199703,199701,1997 -3/26/1997,199703,199701,1997 -3/27/1997,199703,199701,1997 -3/28/1997,199703,199701,1997 -3/29/1997,199703,199701,1997 -3/30/1997,199703,199701,1997 -3/31/1997,199703,199701,1997 -4/1/1997,199704,199702,1997 -4/2/1997,199704,199702,1997 -4/3/1997,199704,199702,1997 -4/4/1997,199704,199702,1997 -4/5/1997,199704,199702,1997 -4/6/1997,199704,199702,1997 -4/7/1997,199704,199702,1997 -4/8/1997,199704,199702,1997 -4/9/1997,199704,199702,1997 -4/10/1997,199704,199702,1997 -4/11/1997,199704,199702,1997 -4/12/1997,199704,199702,1997 -4/13/1997,199704,199702,1997 -4/14/1997,199704,199702,1997 -4/15/1997,199704,199702,1997 -4/16/1997,199704,199702,1997 -4/17/1997,199704,199702,1997 -4/18/1997,199704,199702,1997 -4/19/1997,199704,199702,1997 -4/20/1997,199704,199702,1997 -4/21/1997,199704,199702,1997 -4/22/1997,199704,199702,1997 -4/23/1997,199704,199702,1997 -4/24/1997,199704,199702,1997 -4/25/1997,199704,199702,1997 -4/26/1997,199704,199702,1997 -4/27/1997,199704,199702,1997 -4/28/1997,199704,199702,1997 -4/29/1997,199704,199702,1997 -4/30/1997,199704,199702,1997 -5/1/1997,199705,199702,1997 -5/2/1997,199705,199702,1997 -5/3/1997,199705,199702,1997 -5/4/1997,199705,199702,1997 -5/5/1997,199705,199702,1997 -5/6/1997,199705,199702,1997 -5/7/1997,199705,199702,1997 -5/8/1997,199705,199702,1997 -5/9/1997,199705,199702,1997 -5/10/1997,199705,199702,1997 -5/11/1997,199705,199702,1997 -5/12/1997,199705,199702,1997 -5/13/1997,199705,199702,1997 -5/14/1997,199705,199702,1997 -5/15/1997,199705,199702,1997 -5/16/1997,199705,199702,1997 -5/17/1997,199705,199702,1997 -5/18/1997,199705,199702,1997 -5/19/1997,199705,199702,1997 -5/20/1997,199705,199702,1997 -5/21/1997,199705,199702,1997 -5/22/1997,199705,199702,1997 -5/23/1997,199705,199702,1997 -5/24/1997,199705,199702,1997 -5/25/1997,199705,199702,1997 -5/26/1997,199705,199702,1997 -5/27/1997,199705,199702,1997 -5/28/1997,199705,199702,1997 -5/29/1997,199705,199702,1997 -5/30/1997,199705,199702,1997 -5/31/1997,199705,199702,1997 -6/1/1997,199706,199702,1997 -6/2/1997,199706,199702,1997 -6/3/1997,199706,199702,1997 -6/4/1997,199706,199702,1997 -6/5/1997,199706,199702,1997 -6/6/1997,199706,199702,1997 -6/7/1997,199706,199702,1997 -6/8/1997,199706,199702,1997 -6/9/1997,199706,199702,1997 -6/10/1997,199706,199702,1997 -6/11/1997,199706,199702,1997 -6/12/1997,199706,199702,1997 -6/13/1997,199706,199702,1997 -6/14/1997,199706,199702,1997 -6/15/1997,199706,199702,1997 -6/16/1997,199706,199702,1997 -6/17/1997,199706,199702,1997 -6/18/1997,199706,199702,1997 -6/19/1997,199706,199702,1997 -6/20/1997,199706,199702,1997 -6/21/1997,199706,199702,1997 -6/22/1997,199706,199702,1997 -6/23/1997,199706,199702,1997 -6/24/1997,199706,199702,1997 -6/25/1997,199706,199702,1997 -6/26/1997,199706,199702,1997 -6/27/1997,199706,199702,1997 -6/28/1997,199706,199702,1997 -6/29/1997,199706,199702,1997 -6/30/1997,199706,199702,1997 -7/1/1997,199707,199703,1997 -7/2/1997,199707,199703,1997 -7/3/1997,199707,199703,1997 -7/4/1997,199707,199703,1997 -7/5/1997,199707,199703,1997 -7/6/1997,199707,199703,1997 -7/7/1997,199707,199703,1997 -7/8/1997,199707,199703,1997 -7/9/1997,199707,199703,1997 -7/10/1997,199707,199703,1997 -7/11/1997,199707,199703,1997 -7/12/1997,199707,199703,1997 -7/13/1997,199707,199703,1997 -7/14/1997,199707,199703,1997 -7/15/1997,199707,199703,1997 -7/16/1997,199707,199703,1997 -7/17/1997,199707,199703,1997 -7/18/1997,199707,199703,1997 -7/19/1997,199707,199703,1997 -7/20/1997,199707,199703,1997 -7/21/1997,199707,199703,1997 -7/22/1997,199707,199703,1997 -7/23/1997,199707,199703,1997 -7/24/1997,199707,199703,1997 -7/25/1997,199707,199703,1997 -7/26/1997,199707,199703,1997 -7/27/1997,199707,199703,1997 -7/28/1997,199707,199703,1997 -7/29/1997,199707,199703,1997 -7/30/1997,199707,199703,1997 -7/31/1997,199707,199703,1997 -8/1/1997,199708,199703,1997 -8/2/1997,199708,199703,1997 -8/3/1997,199708,199703,1997 -8/4/1997,199708,199703,1997 -8/5/1997,199708,199703,1997 -8/6/1997,199708,199703,1997 -8/7/1997,199708,199703,1997 -8/8/1997,199708,199703,1997 -8/9/1997,199708,199703,1997 -8/10/1997,199708,199703,1997 -8/11/1997,199708,199703,1997 -8/12/1997,199708,199703,1997 -8/13/1997,199708,199703,1997 -8/14/1997,199708,199703,1997 -8/15/1997,199708,199703,1997 -8/16/1997,199708,199703,1997 -8/17/1997,199708,199703,1997 -8/18/1997,199708,199703,1997 -8/19/1997,199708,199703,1997 -8/20/1997,199708,199703,1997 -8/21/1997,199708,199703,1997 -8/22/1997,199708,199703,1997 -8/23/1997,199708,199703,1997 -8/24/1997,199708,199703,1997 -8/25/1997,199708,199703,1997 -8/26/1997,199708,199703,1997 -8/27/1997,199708,199703,1997 -8/28/1997,199708,199703,1997 -8/29/1997,199708,199703,1997 -8/30/1997,199708,199703,1997 -8/31/1997,199708,199703,1997 -9/1/1997,199709,199703,1997 -9/2/1997,199709,199703,1997 -9/3/1997,199709,199703,1997 -9/4/1997,199709,199703,1997 -9/5/1997,199709,199703,1997 -9/6/1997,199709,199703,1997 -9/7/1997,199709,199703,1997 -9/8/1997,199709,199703,1997 -9/9/1997,199709,199703,1997 -9/10/1997,199709,199703,1997 -9/11/1997,199709,199703,1997 -9/12/1997,199709,199703,1997 -9/13/1997,199709,199703,1997 -9/14/1997,199709,199703,1997 -9/15/1997,199709,199703,1997 -9/16/1997,199709,199703,1997 -9/17/1997,199709,199703,1997 -9/18/1997,199709,199703,1997 -9/19/1997,199709,199703,1997 -9/20/1997,199709,199703,1997 -9/21/1997,199709,199703,1997 -9/22/1997,199709,199703,1997 -9/23/1997,199709,199703,1997 -9/24/1997,199709,199703,1997 -9/25/1997,199709,199703,1997 -9/26/1997,199709,199703,1997 -9/27/1997,199709,199703,1997 -9/28/1997,199709,199703,1997 -9/29/1997,199709,199703,1997 -9/30/1997,199709,199703,1997 -10/1/1997,199710,199704,1997 -10/2/1997,199710,199704,1997 -10/3/1997,199710,199704,1997 -10/4/1997,199710,199704,1997 -10/5/1997,199710,199704,1997 -10/6/1997,199710,199704,1997 -10/7/1997,199710,199704,1997 -10/8/1997,199710,199704,1997 -10/9/1997,199710,199704,1997 -10/10/1997,199710,199704,1997 -10/11/1997,199710,199704,1997 -10/12/1997,199710,199704,1997 -10/13/1997,199710,199704,1997 -10/14/1997,199710,199704,1997 -10/15/1997,199710,199704,1997 -10/16/1997,199710,199704,1997 -10/17/1997,199710,199704,1997 -10/18/1997,199710,199704,1997 -10/19/1997,199710,199704,1997 -10/20/1997,199710,199704,1997 -10/21/1997,199710,199704,1997 -10/22/1997,199710,199704,1997 -10/23/1997,199710,199704,1997 -10/24/1997,199710,199704,1997 -10/25/1997,199710,199704,1997 -10/26/1997,199710,199704,1997 -10/27/1997,199710,199704,1997 -10/28/1997,199710,199704,1997 -10/29/1997,199710,199704,1997 -10/30/1997,199710,199704,1997 -10/31/1997,199710,199704,1997 -11/1/1997,199711,199704,1997 -11/2/1997,199711,199704,1997 -11/3/1997,199711,199704,1997 -11/4/1997,199711,199704,1997 -11/5/1997,199711,199704,1997 -11/6/1997,199711,199704,1997 -11/7/1997,199711,199704,1997 -11/8/1997,199711,199704,1997 -11/9/1997,199711,199704,1997 -11/10/1997,199711,199704,1997 -11/11/1997,199711,199704,1997 -11/12/1997,199711,199704,1997 -11/13/1997,199711,199704,1997 -11/14/1997,199711,199704,1997 -11/15/1997,199711,199704,1997 -11/16/1997,199711,199704,1997 -11/17/1997,199711,199704,1997 -11/18/1997,199711,199704,1997 -11/19/1997,199711,199704,1997 -11/20/1997,199711,199704,1997 -11/21/1997,199711,199704,1997 -11/22/1997,199711,199704,1997 -11/23/1997,199711,199704,1997 -11/24/1997,199711,199704,1997 -11/25/1997,199711,199704,1997 -11/26/1997,199711,199704,1997 -11/27/1997,199711,199704,1997 -11/28/1997,199711,199704,1997 -11/29/1997,199711,199704,1997 -11/30/1997,199711,199704,1997 -12/1/1997,199712,199704,1997 -12/2/1997,199712,199704,1997 -12/3/1997,199712,199704,1997 -12/4/1997,199712,199704,1997 -12/5/1997,199712,199704,1997 -12/6/1997,199712,199704,1997 -12/7/1997,199712,199704,1997 -12/8/1997,199712,199704,1997 -12/9/1997,199712,199704,1997 -12/10/1997,199712,199704,1997 -12/11/1997,199712,199704,1997 -12/12/1997,199712,199704,1997 http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/d385ac72/testdata/data/mstr/eatwh1/csv/LU_DIST_CTR.TXT ---------------------------------------------------------------------- diff --git a/testdata/data/mstr/eatwh1/csv/LU_DIST_CTR.TXT b/testdata/data/mstr/eatwh1/csv/LU_DIST_CTR.TXT deleted file mode 100644 index d971fa4..0000000 --- a/testdata/data/mstr/eatwh1/csv/LU_DIST_CTR.TXT +++ /dev/null @@ -1,17 +0,0 @@ -1,London,3 -1,Paris,4 -1,Berlin,5 -2,Seattle,1 -3,Washington, DC,1 -4,San Diego,1 -5,Miami,1 -6,Boston,1 -8,New York,1 -9,Salt Lake City,1 -10,Atlanta,1 -11,San Francisco,1 -12,New Orleans,1 -13,Memphis,1 -14,Fargo,1 -15,Charleston,1 -16,Milwaukee,1 http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/d385ac72/testdata/data/mstr/eatwh1/csv/LU_EMPLOYEE.TXT ---------------------------------------------------------------------- diff --git a/testdata/data/mstr/eatwh1/csv/LU_EMPLOYEE.TXT b/testdata/data/mstr/eatwh1/csv/LU_EMPLOYEE.TXT deleted file mode 100644 index 96ef2be..0000000 --- a/testdata/data/mstr/eatwh1/csv/LU_EMPLOYEE.TXT +++ /dev/null @@ -1,38 +0,0 @@ -1,Bates,Michael,89118610,2,4,1,16,31000,8/29/1974,4/23/1997 -2,Becker,Kyle,71084558,4,11,1,14,22000,8/15/1977,5/2/1996 -3,Bell,Caitlin,37206702,2,4,1,16,35000,2/8/1953,8/27/1995 -4,Benner,Ian,10816565,1,10,1,8,24000,10/23/1951,1/26/1997 -5,Bernstein,Lawrence,28772433,5,3,1,6,31000,6/8/1966,1/15/1997 -6,Bogus,Dirk,27323213,3,1,5,5,27000,12/25/1969,2/28/1995 -7,Brown,Vernon,23062336,17,15,1,4,40000,11/14/1945,2/18/1997 -8,Conner,Beatrice,46751529,9,12,1,13,24000,2/23/1958,5/8/1997 -9,Corcoran,Peter,52823374,17,15,1,4,27000,9/9/1959,5/17/1997 -10,De Le Torre,Sandra,14680504,11,6,1,1,31000,1/26/1954,2/25/1997 -11,Ellerkamp,Nancy,29059128,14,14,1,10,40000,11/28/1965,2/14/1997 -12,Folks,Adrienne,11688912,5,3,1,6,24000,6/19/1972,7/12/1997 -13,Gale,Loren,96830288,8,16,1,9,35000,6/25/1968,1/11/1997 -14,Gedot,Harriet,56850444,10,2,1,15,27000,7/16/1960,1/31/1997 -15,Hall,David,38014900,4,11,1,14,31000,3/24/1948,11/30/1996 -16,Hollywood,Robert,15934022,5,3,1,6,40000,8/2/1944,4/28/1997 -17,Hunt,Matthew,37511734,6,9,1,17,22000,7/8/1972,4/18/1997 -18,Ingles,Walter,21584881,17,15,1,4,22000,9/14/1951,9/13/1996 -19,Johnson,Andrew,65643500,2,4,1,16,27000,1/9/1964,7/8/1997 -20,Kelly,Laura,19490286,12,8,1,2,35000,4/10/1971,5/19/1997 -21,Kieferson,Jack,13485556,11,6,1,1,22000,2/14/1961,6/6/1996 -22,Lee,Jennifer,56581000,13,1,3,3,35000,8/2/1950,2/5/1997 -23,Lundergard,Kari,15222580,16,1,4,12,27000,7/29/1973,3/15/1996 -24,Lynch,Sam,57541342,7,5,1,7,22000,7/4/1966,2/25/1997 -25,McClain,Sean,34298754,1,10,1,8,42000,11/14/1951,4/26/1995 -26,Miner,Henry,11539992,13,1,3,3,22000,6/19/1972,5/27/1997 -27,Nelson,Arthur,11333746,9,12,1,13,27000,5/22/1959,7/17/1996 -28,Pierce,Charles,62464249,15,13,1,11,35000,2/12/1972,3/14/1997 -29,Sable,Ellen,69122896,3,1,5,5,24000,4/7/1954,8/9/1996 -30,Sawyer,Leanne,48990070,12,8,1,2,24000,12/9/1952,4/27/1997 -31,Schafer,Rose,52488020,2,4,1,16,24000,10/31/1959,2/16/1997 -32,Smith,Thomas,22071808,17,15,1,4,35000,10/26/1956,2/26/1997 -33,Sonder,Melanie,32897728,11,6,1,1,24000,3/30/1966,2/17/1997 -34,Strome,Fred,73263480,7,5,1,7,31000,5/6/1956,8/29/1995 -35,Torrison,Mary,60749910,8,16,1,9,42000,6/22/1945,2/20/1997 -36,Yager,Beth,29301277,12,8,1,2,27000,12/7/1968,3/6/1997 -37,Young,Sarah,70341381,17,15,1,4,27000,8/24/1952,3/1/1997 -38,Zemlicka,George,38373564,8,16,1,9,31000,6/29/1970,1/19/1996 http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/d385ac72/testdata/data/mstr/eatwh1/csv/LU_INCOME.TXT ---------------------------------------------------------------------- diff --git a/testdata/data/mstr/eatwh1/csv/LU_INCOME.TXT b/testdata/data/mstr/eatwh1/csv/LU_INCOME.TXT deleted file mode 100644 index bf39279..0000000 --- a/testdata/data/mstr/eatwh1/csv/LU_INCOME.TXT +++ /dev/null @@ -1,10 +0,0 @@ -1,< 21K -2,21-30K -3,31-40K -4,41-50K -5,51-60K -6,61-70K -7,71-80K -8,81-90K -9,91-100K -10,>100K http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/d385ac72/testdata/data/mstr/eatwh1/csv/LU_ITEM.TXT ---------------------------------------------------------------------- diff --git a/testdata/data/mstr/eatwh1/csv/LU_ITEM.TXT b/testdata/data/mstr/eatwh1/csv/LU_ITEM.TXT deleted file mode 100644 index 5a4f169..0000000 --- a/testdata/data/mstr/eatwh1/csv/LU_ITEM.TXT +++ /dev/null @@ -1,213 +0,0 @@ -14,Bed Lounge,5,,prodimages/generic.gif,19,1,Ergonomically correct foam & featherdown pillow wi,No,130 -15,Beer-Making Kit,151,Bierbastelset,prodimages/generic.gif,15,1,Produce 6 gallons at a time.,Yes,45 -16,Big Thanks Flower Bouquet,36,,prodimages/generic.gif,22,1,Send a live calling card to let friends know you l,No,60 -17,Bison Burgers & Steak,129,,prodimages/generic.gif,18,0,Low calorie, low cholesterol, high protein,No,125 -18,Bon Appetite,166,,prodimages/generic.gif,11,1,Yours to send with the ultimate gourmet treats.,No,57 -19,Bone-In Vermont Dinner Ham,129,,prodimages/generic.gif,18,0,,No,40 -20,Bonsai Gift Set,36,,prodimages/generic.gif,16,0,Bamboo box with cotton gloves, fragrent bee & flow,No,48 -21,Boomerang,14,,prodimages/generic.gif,5,0,Laminated wood,No,25 -22,Bougainvilla Bonsai,36,,prodimages/generic.gif,16,1,,No,34 -23,Brass Cigar Cutter,179,,prodimages/generic.gif,26,1,,No,29 -24,Brass Match Holder,5,,prodimages/generic.gif,13,0,Shiny brass holder comes with 50 extra-long safety,No,15 -25,Bubble Gum Kit,121,,prodimages/generic.gif,17,1,,No,12 -26,Butterly Hutch,97,Schmetterlingshaus,prodimages/generic.gif,16,1,Red ceder box provides a safehaven to hibernating ,No,30 -27,Candle-powered Boat,130,,prodimages/generic.gif,5,0,Tin boat propelled by real steam power,No,13 -28,Candlelit Forest Screen,5,,prodimages/generic.gif,4,1,Four tea lights in glass bowls shine through perfo,No,25 -29,Car Diffuser,172,,prodimages/generic.gif,20,0,Aromatherapy in your car -- plugs into the cirgare,No,15 -30,Car-Shaped Glasses Case,179,,prodimages/generic.gif,26,1,For everyone who always wanted a Porshe,No,12 -31,Carnivorous Plant Collection,36,autofoermiges Glasregal,prodimages/generic.gif,17,0,Includes venus flytrap, sundew, butterwort, and pi,No,20 -32,Casablanca,129,,prodimages/generic.gif,11,1,A basket full of delicious delectables. Play it ag,No,55 -96,Guardian Plus Purifier,142,,prodimages/generic.gif,23,1,Removes bacteria, protozoa, and viruses from drink,Yes,90 -34,Cascade Travel Pillow,14,,prodimages/generic.gif,25,0,Polyester fill, 7.5 oz,No,18 -35,Cashmire Blend Espresso,129,,prodimages/generic.gif,6,0,The original espresso blend,No,9 -36,Cat's Dream Kit,164,,prodimages/generic.gif,21,1,One-level playland for cats,No,34 -37,Cat's Palace,164,,prodimages/generic.gif,21,0,Multi-level dream playland for cats,No,68 -38,Cedar Buccaneer Chest,171,,prodimages/generic.gif,8,1,,Yes,15 -39,Cedar Hope Chest,171,,prodimages/generic.gif,8,0,,Yes,25 -40,Celebration,166,,prodimages/generic.gif,11,0,This stately and dramatic basket is the favorite o,No,74 -41,Ceramic Mixing Bowls,151,Tazon de ceramica,prodimages/generic.gif,15,1,Set of 5 heavy ceramix bowls with rich glazes in s,Yes,40 -42,Champagne and Truffles,166,Champagne et truffes,prodimages/generic.gif,11,0,,No,52 -43,Champagne Opener,151,,prodimages/generic.gif,15,0,Opens the bottle safely every time,Yes,14 -44,Cheese Board,166,,prodimages/generic.gif,11,1,Everyone will love this combination filled with a ,No,48 -45,Cherry Linen Chest,44,,prodimages/generic.gif,8,1,,Yes,485 -46,Chinese Survival Tool,73,,prodimages/generic.gif,23,1,1 oz: knife, can opener, wrench, screwdriver, file,Yes,8 -47,Chocolate Buttercrunch,166,,prodimages/generic.gif,3,1,Melt-in-your mouth buttercrunch from finest Vermon,No,22 -48,Chocolate Roses,166,Rosas de chocolate,prodimages/generic.gif,3,0,,No,36 -49,Chocolate Spoons,166,Cuillieres en chocolat,prodimages/generic.gif,3,0,European chocolate hand-dipped spoons (.5 oz. each,No,30 -50,Chocolate-covered Oreos,166,,prodimages/generic.gif,3,0,,No,20 -51,Classic Pink Flamingos,73,,prodimages/generic.gif,16,1,A pair of fabulous pink birds,No,15 -52,Cocoa Mug,129,,prodimages/generic.gif,11,0,Send someone special this Latte cup filled with sw,No,20 -53,Come Hither Flower Basket,36,,prodimages/generic.gif,22,1,Soothe the senses with this abundance of heather h,No,65 -54,Copper Snow Gauge,136,,prodimages/generic.gif,16,0,Rustic verdigris copper with handcut numbers measu,No,60 -55,Cork Board,151,,prodimages/generic.gif,15,1,Make your own personal bulliten board with the cor,Yes,25 -56,Credit Card Companion,73,,prodimages/generic.gif,23,1,1.3 oz: can opener, awl, tweezers, toothpick, lany,Yes,25 -57,Crema Rica Blend Espresso,129,,prodimages/generic.gif,6,1,Full-bodied and nutty with natural sweetness,No,9 -58,Crystal Keepsake Flowers and Vase,36,,prodimages/generic.gif,22,1,For those special times when you want to give a li,No,60 -59,Custom Celler Plaque,136,,prodimages/generic.gif,15,0,Embellish your personal collection of wine with a ,Yes,55 -60,Dartmeet Bird Feeder,5,,prodimages/generic.gif,16,0,Thatched bird feeder with nesting compartments,No,100 -61,Decadent Chocolate Torte,166,,prodimages/generic.gif,3,0,,No,32 -62,Digital Golf Score Card,73,,prodimages/generic.gif,12,1,,No,25 -2,A Gardener's Journal,91,un journal de jardinier,prodimages/generic.gif,16,0,Hardbound diary for the reflective gardener,No,20 -3,A Moveable Feast,166,,prodimages/generic.gif,11,1,This magnificent basket is sure to please. Loaded ,No,120 -4,Amish Children Silhouettes,44,,prodimages/generic.gif,16,0,,No,75 -5,Amish Heritage Armoire,44,,prodimages/generic.gif,8,1,,Yes,625 -6,Amish Horse Pull-toy,130,,prodimages/generic.gif,5,0,With the pull of a string, this cuddly horse trave,No,30 -7,Amish Pine Napkin Holder,5,,prodimages/generic.gif,15,0,,Yes,25 -8,Annie's Zoo Doo,97,,prodimages/generic.gif,16,0,Animal-Shaped Fertilizer,No,6 -9,Aroma Wrap,172,,prodimages/generic.gif,20,1,Warmed in the microwave, lavender, rosemary and cl,No,17 -10,Aromatherapy Clove Candle,172,,prodimages/generic.gif,20,1,Soothing scents in a ruby-red pot,No,20 -11,Australia Sampler,129,,prodimages/generic.gif,18,0,Kangaroo, Ostrich, Quail,No,95 -12,Barking Treat Jar,162,,prodimages/generic.gif,21,0,,No,30 -13,Bay Rum Shaving Kit,73,,prodimages/generic.gif,24,1,Top quality, "turning a mundane chore into a pleas,No,22 -97,Hadley's Blend Coffee,166,,prodimages/generic.gif,6,1,Full-bodied and lively,No,9 -98,Hand Boilers,73,,prodimages/generic.gif,17,1,Compatible with most wooden railway systems -,No,4 -99,Handsfree Head Massage,81,,prodimages/generic.gif,7,0,,Yes,59 -100,Headlamp,14,,prodimages/generic.gif,23,0,waterproof to 2000 feet, 4.5 oz,,Yes,30 -101,Hoberman Sphere,130,,prodimages/generic.gif,17,0,goes from 6 to 30 inches with the pull of a string,No,40 -102,House Blend Coffee,129,,prodimages/generic.gif,6,0,Medium dark standard,No,9 -103,Ice Cream Parlor,129,,prodimages/generic.gif,11,1,The ice cream lover will remember your thoughtfuln,No,38 -104,In Living Color Flower Arrangement,36,,prodimages/generic.gif,22,0,Light up their eyes with this all natural basket, ,No,60 -105,Incredible Chiller,151,,prodimages/generic.gif,15,1,no ice, no mess, no wet label to fall off. Keeps ,Yes,17 -107,Invisible Wreath Hanger,136,,prodimages/generic.gif,4,1,mount wreaths on glass or metal doors without nail,No,15 -106,Invigorating Tub Tonic,81,,prodimages/generic.gif,20,0,Naturally invigorating with soothing plant and her,No,12 -108,Italian Herb Garden,36,,prodimages/generic.gif,15,0,Window box for year-round fresh herbs,Yes,24 -109,Italian Trattoria,129,,prodimages/generic.gif,11,1,Flavors of the earth are featured - tomatoes, garl,No,60 -110,Jolly Ball Horse Toy,164,,prodimages/generic.gif,21,1,Durable and fun,No,13 -111,Joseph Schmidt Truffles,166,,prodimages/generic.gif,3,0,,No,20 -112,Juniper Bonsai,36,,prodimages/generic.gif,22,1,Hardy, beautiful tree comes preplanted in a cerami,No,35 -113,Keytog Laser Pointer,51,,prodimages/generic.gif,9,0,,Yes,79 -114,Kissing Ball,36,,prodimages/generic.gif,4,1,Decorative ball of fresh mistletoe,No,33 -115,Label Saver (box of 20),136,,prodimages/generic.gif,15,0,removes and laminates wine and beer labels quickly,Yes,15 -116,Ladybug Hutch,97,,prodimages/generic.gif,16,0,Solid white pine box comes with patented ladybug a,No,38 -117,Language Master,73,,prodimages/generic.gif,9,1,Talking dictionary and thesaurus,Yes,199 -118,Leaning Man Silhouette,44,,prodimages/generic.gif,16,1,,No,60 -119,Levitron,179,,prodimages/generic.gif,26,1,amazing anti-gravity top,No,40 -120,LitterMaid,164,,prodimages/generic.gif,21,0,electronic cat box,No,179 -121,Log and Kindling Rack,136,,prodimages/generic.gif,13,0,Ingenius space-saving double rack. Constructed of,No,100 -122,Lone Star Fiesta,166,,prodimages/generic.gif,11,1,Give them the flavors of the Southwest in this del,No,70 -123,Love Potion Amulet,172,,prodimages/generic.gif,14,0,Jasmin oil fills this glass and pewter amulet to a,Yes,18 -124,Lucious Nuggets,166,,prodimages/generic.gif,3,1,A delicious blend of the finest and freshest crush,No,22 -125,Lucky Golden Clover,161,,prodimages/generic.gif,14,1,A real four-leaf clover preserved in 24 kt gold,Yes,15 -126,Luxurious Bath Pack,81,,prodimages/generic.gif,24,0,Choose forest, rain, garden, island,No,22 -187,St. Basil's 3-D Puzzle,130,,prodimages/Item187.gif,10,1,For patient eyes, the images in this 3-D puzzle ap,No,45 -188,Star Gazer Flower Basket,36,,prodimages/generic.gif,22,0,Let your thoughtfulness shine through.,No,70 -189,Stoneware Garlic Roaster,151,Grille-ail en pierre,prodimages/generic.gif,15,1,Room for 5-6 heads,Yes,21 -190,Superb Bacon,129,,prodimages/Item190.jpg,18,0,From the finest pork, sold per pound.,No,15 -191,Swiss Army Watch,14,,prodimages/Item191.gif,14,0,Authentic Swiss Army watch. Available with a leat,Yes,150 -192,Thermal Lumbar Support,73,,prodimages/Item192.jpg,26,0,Developed by NASA, this heat-activated foam confor,No,45 -193,Tiverton Wren House,97,,prodimages/Item193.jpg,16,1,thatched bird house,No,41 -194,Travel Companion,51,,prodimages/Item194.gif,23,1,Contains an alarm clock, flashlight, smoke detecto,Yes,69 -195,Travelling Cigar Humidor,73,Humidificateur a cigares de voyage,prodimages/Item195.jpg,26,0,Beautiful wood-lined humidor will keep your cigars,No,225 -196,Tree Frog Fountain,73,,prodimages/generic.gif,19,1,Delicate sculpture and the refreshing sound of fal,No,139 -197,Truth Seeker,130,,prodimages/Item197.jpg,9,1,Can detect human lying voice modulations to 80% ac,Yes,149 -198,Two-Level Cat Condo,164,,prodimages/Item198.jpg,21,0,Purrfect for sleeping & playing, this wooden cat h,No,32 -199,Vermont Breakfast,157,,prodimages/Item199.jpg,11,0,A basket full of Vermont breakfast goodies.,No,28 -200,Vintage Collection: 100% Wool Carpet,171,,prodimages/Item200.jpg,19,1,Hand-woven Persian rug brightens any room.,No,993 -201,Virtual Reality Vest,51,,prodimages/Item201.jpg,9,1,Feel the hits, slams, and punches of video games w,Yes,100 -202,Volcano Kit,121,,prodimages/Item202.jpg,17,0,Make learning science fun! Your child will love s,No,10 -204,Whirlagig Pig,136,,prodimages/Item204.jpg,16,0,Friendly pig weathervane in copper or steel.,No,40 -205,Wine Country Sampler,166,,prodimages/Item205.jpg,11,1,Nappa Valley assorted reds, whites, and spumante.,No,43 -203,Weather Alert Radio,5,,prodimages/Item203.jpg,9,1,This radio automatically switches on during Emerge,Yes,55 -206,Winged Fairy,136,,prodimages/Item206.jpg,16,0,Hand-carved porcelin fairy for both indoors and ou,No,40 -207,Winter Relief Pack,81,,prodimages/Item207.jpg,24,1,Remedy dry, aching winter skin with lavender scent,No,20 -208,WWI Trench Lighter,73,,prodimages/Item208.jpg,26,1,An antique lighter for the discerning smoker.,No,19 -209,Zelco's Lock-Up,51,,prodimages/Item209.jpg,23,1,Ease safety worries with this portable door lock f,Yes,20 -210,Zephyr Blend Espresso,129,,prodimages/Item210.gif,6,1,Blended from sweet Italian dark roast beans.,No,9 -211,Zither in Mahagony Case,44,,prodimages/Item211.jpg,5,0,Beautiful carved case makes this the perfect decor,No,69 -212,Zoo Friends,164,,prodimages/Item212.jpg,21,0,Support our fuzzy friends! Sponsor a wild animal ,No,50 -127,Madison Blend Espresso,166,,prodimages/generic.gif,6,1,Straight from Seattle's Capitol Hill district,No,9 -128,Mahogany Steamer Trunk,171,,prodimages/generic.gif,8,0,,Yes,525 -129,Majestic Truffle Collection,166,,prodimages/Item129.bmp,3,1,A beautiful collection of 15 delicately-crafted Eu,No,20 -130,Mancala,130,,prodimages/generic.gif,10,0,ancient strategy game,No,17 -131,Micro FM Radio,51,,prodimages/generic.gif,1,1,Water resistant, tiny radio for the active person,Yes,19 -132,Microbrew Gift Basket,166,,prodimages/generic.gif,11,0,,No,59 -133,Mocha Java Blend Coffee,166,,prodimages/Item133.gif,6,0,A Blend of Guatemalan and French Roast beans, flav,No,11 -134,Model of Atlantis,179,,prodimages/generic.gif,26,1,,No,55 -135,Moisturizing Lip Balms,81,,prodimages/generic.gif,20,1,Set of 4 creamy all-natural lip balms in four mout,No,12 -136,Mr. Snippet,36,,prodimages/generic.gif,17,0,Grow a hilarious shock of grass "hair" with just s,No,8 -138,Navy SEAL Watch,179,,prodimages/generic.gif,14,1,,Yes,189 -139,Not Tonight Deer Repellent,97,,prodimages/generic.gif,16,0,,No,10 -140,Nothing But Roses,36,,prodimages/generic.gif,22,1,Send a live calling card to let friends know you l,No,65 -141,Notre Dame 3-D Puzzle,130,,prodimages/generic.gif,10,0,,No,45 -142,Oak Steamer Trunk,5,,prodimages/generic.gif,8,1,,Yes,475 -137,Natual Cold Defense Kit,172,,prodimages/generic.gif,20,1,Elderberry to ward off viruses, Echinacea to boost,No,25 -143,Office Goody Basket,166,,prodimages/generic.gif,11,0,enough to share,No,108 -144,Office Party,129,,prodimages/generic.gif,11,0,The lucky person receiving this grand basket will ,No,84 -145,Pedaling Pachyderm,130,,prodimages/generic.gif,5,1,Wind-up cycling elephant,No,13 -146,Peppermint Foot Lotion,81,,prodimages/generic.gif,24,0,,No,12 -147,Peppermint Pig,129,,prodimages/generic.gif,4,1,Traditional pink peppermint pig comes with a hamme,No,15 -148,Peppermint Twist Candle,172,,prodimages/Item149.gif,4,0,Fragrent pedastal candle burns for 96 hours,No,17 -149,Personal Air Purifier,142,,prodimages/generic.gif,7,1,Just 8 oz, hardly noticable as it hangs from your ,Yes,100 -150,Personalized Sundial,136,Reloj de sol personalizado,prodimages/generic.gif,16,0,copper-verdigris patina, up to 14 letters,No,75 -151,Pet Portrait,89,,prodimages/generic.gif,21,1,hand-drawn portraits from slides or photos,No,100 -152,Pewter Cat Frame,89,,prodimages/generic.gif,26,1,,No,24 -153,Plant Sitter,5,,prodimages/generic.gif,16,0,waters plants automatically during vacations,No,69 -154,Pocket Pillow,14,,prodimages/generic.gif,25,0,Flannel stuff-sack,No,5 -155,Portable 12 volt cooler/warmer,51,,prodimages/generic.gif,2,1,cools to 40 F, heats to 125 F; holds 20 quarts; pl,Yes,130 -156,Portable Beverage cooler/warmer,51,,prodimages/Item156.jpg,2,1,Keeps your beverages cold or hot for 5 hours.,Yes,190 -63,Dog Biker Jacket,164,,prodimages/generic.gif,21,1,Black "leather" with buckles and snaps,No,15 -64,Dog Bomber Jacket,164,,prodimages/generic.gif,21,0,Brown "leather" with a fleese collar,No,15 -65,Dog Letter Jacket,164,,prodimages/generic.gif,21,0,Gold and Blue,No,15 -66,Dog Ski Jacket,164,,prodimages/generic.gif,21,1,Head for the slopes!,No,15 -67,Dragonfly Pin,161,,prodimages/generic.gif,14,0,Handcrafted in pewter, 1" wingspan,Yes,8 -68,Earth Orbiter with Stack,179,,prodimages/generic.gif,26,1,,No,80 -69,Earthy Delights Flower Basket,36,,prodimages/generic.gif,22,0,This collection of gem like African violets will b,No,50 -70,Elegant Writing Set,73,elegantes Schreibset,prodimages/generic.gif,26,1,,No,28 -71,Elmo Market Basket,162,,prodimages/generic.gif,17,1,Red and yellow cart with Elmo recordings, encourag,No,25 -72,Executive Massage Chair,81,,prodimages/generic.gif,7,1,Black leather, ergonomic design,Yes,1495 -73,Executive Yo Yo,73,,prodimages/generic.gif,26,1,Tarnish-proof nickel plating,No,18 -74,Exotic Meat Lover,129,,prodimages/generic.gif,18,0,Buffalo, Ostrich, Quail, Alligator,No,135 -75,F/X Shuttle,179,,prodimages/generic.gif,26,0,,No,70 -76,Fiber Optics Kit,121,,prodimages/generic.gif,17,0,,No,8 -77,Fire Cone Trees,136,,prodimages/generic.gif,13,1,Pinecones imbedded in a resin base burns for 20-30,No,15 -78,Fireside Inn,129,,prodimages/generic.gif,11,1,Wonderful flavors of Ghirardelli chocolates blend ,No,48 -79,Fish Bottle Opener,151,,prodimages/generic.gif,15,0,Essential tackle box item,Yes,17 -80,Fisherman's Reel Clock,73,,prodimages/generic.gif,26,1,,No,185 -81,Flex-neck Halogen Floor Lamp,5,,prodimages/generic.gif,19,0,34" flexible neck curves & loops to any position,No,200 -82,Floral Collection: 100% Wool Carpet,171,,prodimages/generic.gif,19,0,3 patterns, 8x12,No,585 -83,Freeplay Solar Radio,14,,prodimages/generic.gif,1,1,Crank-up radio never needs batteries -- runs for a,Yes,85 -84,French Bucket Vase Pin,36,,prodimages/generic.gif,14,1,Holds enough water for one perfect blossom,Yes,24 -85,Fresh and Fragrant Flower Arrangement,36,,prodimages/generic.gif,22,1,Take a fresh approach to the classic "all-around" ,No,55 -86,Fruit Collection Christmas Ornaments,89,,prodimages/generic.gif,4,1,,No,18 -87,Garden Fairy,136,Hada de jadin,prodimages/generic.gif,16,0,Enchanting fairy dreamily reads her book while per,No,90 -88,Ghirardelli Square,129,,prodimages/generic.gif,11,0,Everyone's favorite flavors are perfectly paired i,No,53 -89,Gift of Kings,172,,prodimages/generic.gif,4,1,Teak chest with nuggets of frankincense and myrrh,No,30 -90,Godiva Christmas Ballotin,166,,prodimages/generic.gif,3,1,1 lb/ 33 pieces,No,35 -91,Godiva Halloween Ballotin,166,,prodimages/generic.gif,3,0,1 lb/ 33 pieces,No,35 -92,Golf Ball Monogrammer,73,,prodimages/generic.gif,12,1,No more lost balls,No,16 -93,Golf Club Cleaner,73,,prodimages/generic.gif,12,0,,No,20 -94,Golfer's Mousepad,73,,prodimages/generic.gif,12,0,shaped like a green,No,14 -95,Great Skin Pack,81,,prodimages/generic.gif,24,1,,No,34 -1,3 lb Sharp Vermont Cheddar,129,,prodimages/generic.gif,18,0,,No,20 -157,Portable Light Box,51,,prodimages/generic.gif,7,0,Duplicates sunlight to combat Seasonal Affective D,Yes,299 -158,Pot Feet,97,,prodimages/generic.gif,16,1,Tiny terra cotta animals lift pots and troughs off,No,7 -159,Promise Ring,161,,prodimages/Item159.gif,14,0,Show her you care with this sterling silver and on,Yes,92 -160,Queen Double Irish Chain Quilt,136,,prodimages/generic.gif,19,1,,No,110 -161,Queen Fencerail Quilt,136,,prodimages/generic.gif,19,0,,No,150 -162,Queen Log Cabin Quilt,136,,prodimages/Item162.jpg,19,0,,No,175 -163,Reading Light for the Car,51,,prodimages/Item163.jpg,2,0,For the road traveller, this reading light plus in,Yes,30 -164,Relaxing Eye Pillow,172,,prodimages/Item164.jpg,20,1,Silky smooth rayon contains soothing flax seeds wi,No,13 -165,Rocket Racer,130,,prodimages/generic.gif,5,1,Collectible tin rocket propelled by a friction mot,No,10 -166,Root Beer Kit,121,,prodimages/generic.gif,17,1,,No,12 -167,Root Beer Lovers Basket,129,,prodimages/generic.gif,11,0,,No,46 -168,Safari Helmet,97,,prodimages/generic.gif,16,0,fully-vented tropical sun hat,No,15 -169,San Francisco Trolley,157,,prodimages/generic.gif,11,1,This stately and dramatic basket is the favorite o,No,90 -170,Seal Pack,14,,prodimages/Item170.jpg,23,0,Keep your valuables dry while hiking and camping w,Yes,22 -171,Shiitake Mushroom Kit,36,,prodimages/generic.gif,15,1,Produces up to 2 lbs of mushrooms,Yes,27 -172,Shower Companion,51,,prodimages/Item172.jpg,1,0,Waterproof radio, receives AM/FM/TV/ European rece,Yes,79 -173,Silver Locket and Chain,161,,prodimages/Item173.jpg,14,1,Keep memories close with this sterling silver lock,Yes,36 -174,Silverplated Hip Flask,44,,prodimages/generic.gif,26,0,can be monogrammed,No,24 -175,Simply the Best Flower Arrangement,36,,prodimages/generic.gif,22,1,There' no better way to say "you're the best" than,No,65 -176,Singing Bird Clock,162,,prodimages/generic.gif,19,0,a different bird for each hour in a genuine cherry,No,50 -177,Slate Tranquility Fountain,73,Fuente de tranquilidad,prodimages/generic.gif,19,0,Water cascades endlessly over a layers of slate to,No,115 -178,Sleigh Bells Doorknob,136,,prodimages/generic.gif,4,0,three brass bells ring in the season hanging from ,No,15 -179,Slimline Laser Pointer,73,,prodimages/Item179.jpg,9,1,The laser shines up to 700 yards, and is only 1/4",Yes,199 -180,Slinky,130,,prodimages/generic.gif,5,1,50th anniversary collectible edition in original b,No,7 -181,Smoked Vermont Turkey Breast,129,,prodimages/Item181.jpg,18,0,Honey smoked for four hours, sold whole or sliced.,No,25 -182,Solar Power Kit,121,,prodimages/Item182.gif,17,1,Save energy with this solar kit. The solar panel ,No,12 -183,Sonic Molechaser,97,,prodimages/generic.gif,16,1,,No,40 -184,Space Shuttle Pewter Letter Opener,179,,prodimages/Item184.jpg,26,0,,No,13 -185,Spicy Delights,157,,prodimages/Item185.gif,11,1,,No,46 -186,Spud Shooter,130,,prodimages/Item186.jpg,5,0,Just like the original, this spud shooter uses com,No,6 -33,Cascade Travel Mattress,14,,prodimages/generic.gif,25,1,Self-inflating, 15 oz.,No,60
