sql-tests.testcases.tpcds.q34.result Maven / Gradle / Ivy
-- delimiter: |; types: CHAR|CHAR|CHAR|CHAR|BIGINT|BIGINT
Abbott |Harriet |Ms. |N|195008|15|
Acosta |Victor |Mr. |N|156807|15|
Adams |Jerry |Sir |N|216653|15|
Adams |Willie |Sir |N|88285|15|
Alford |Deborah |Miss |N|97678|15|
Allen |Marty |Sir |N|63646|15|
Anderson |Cindy |Miss |N|90504|15|
Anderson |Eloise |Mrs. |Y|59994|16|
Anderson |Marta |Dr. |N|176320|15|
Anderson |Martha |Mrs. |N|74295|15|
Anderson |Norma |Miss |Y|132983|16|
Anderson |Rosemarie |Mrs. |N|178489|15|
Andrews |Cindy |Miss |Y|132595|16|
Andrews |Michael |Sir |N|135694|15|
Andrews |Robert |Sir |Y|30467|15|
Appleton |Gary |Dr. |N|58554|16|
Archibald |Cindy |Miss |Y|87178|16|
Arredondo |Phyllis |Ms. |Y|226220|16|
Arsenault |Janet |Mrs. |N|169973|16|
Ashton |Irma |Mrs. |Y|99233|15|
Bailey |Lucille |Mrs. |N|2490|15|
Baker |Erik |Sir |Y|69511|15|
Barba |William |Sir |Y|102719|15|
Barnes |John |Dr. |N|74071|15|
Barnes |Michael |Mr. |N|168802|15|
Bear |Tommy |Sir |Y|27468|15|
Beasley |Joshua |Dr. |Y|32731|15|
Bell |William |Mr. |Y|82227|15|
Bender |Grover |Dr. |N|152239|15|
Benedict |Bridget |Dr. |N|16544|15|
Benson |Mike |Sir |Y|53219|16|
Berry |Theresa |Ms. |Y|77257|15|
Bilodeau |Norma |Ms. |Y|136244|15|
Blake |John |Mr. |N|193896|15|
Blanchard |Joanne |Dr. |N|5917|15|
Boles |George |Sir |N|64282|15|
Bolin |Yolanda |Dr. |N|13057|16|
Bowden |Kathleen |Ms. |N|106265|15|
Box |Eric |Dr. |N|79283|16|
Boyd |Mildred |Miss |N|190083|15|
Boyer |Betty |Mrs. |Y|171238|16|
Boyle |Timothy |Dr. |N|21865|16|
Brandt |James |Sir |Y|60562|15|
Brantley |Frank |Dr. |N|66867|15|
Brewer |Lynne |Ms. |N|77584|15|
Broughton |Doretta |Ms. |Y|206939|16|
Brower |Donald |Dr. |N|163579|15|
Brown |David |Mr. |N|162755|16|
Brown |Frederick |Mr. |N|120037|15|
Brown |Janette |Dr. |Y|7269|16|
Brown |Janice |Ms. |Y|138617|15|
Brown |Raymond |Mr. |Y|212279|15|
Brown |Roderick |Mr. |N|221290|16|
Brown |Will |Mr. |Y|147392|15|
Buck |Andrew |Dr. |N|128839|15|
Burch |Diana |Mrs. |Y|115522|15|
Burdette |Ronald |Mr. |Y|118097|15|
Butcher |Francine |Mrs. |N|112093|15|
Butcher |Thomas |Mr. |N|213918|15|
Butler |Amos |Dr. |N|7184|15|
Butler |Nicole |Dr. |N|214214|16|
Byrd |Stephanie |Miss |Y|24803|15|
Byrd |Wanda |Ms. |Y|155385|15|
Campbell |Gordon |Mr. |N|196090|15|
Campbell |William |Mr. |N|95665|15|
Carlson |Gwendolyn |Dr. |Y|88472|15|
Carpenter |Stephen |Mr. |Y|174519|16|
Carroll |Frederick |Mr. |Y|56635|15|
Carter |Cecil |Dr. |Y|34336|16|
Carter |Eddie |Dr. |N|226103|16|
Carter |Olga |Mrs. |N|84776|15|
Casey |Darrell |Sir |N|181470|15|
Castro |Sandra |Ms. |N|87567|15|
Chandler |Lisa |Dr. |N|102461|16|
Chang |Bradley |Sir |Y|53396|15|
Chang |Erik |Sir |Y|140138|15|
Chase |Daniel |Dr. |Y|129179|15|
Cheek |Rebecca |Mrs. |Y|82193|15|
Chen |Brett |Mr. |N|7880|15|
Christenson |Steven |Mr. |Y|156157|15|
Clark |Elisa |Mrs. |Y|234445|15|
Clark |Elizabeth |Dr. |Y|58831|15|
Clark |Meredith |Dr. |N|229216|16|
Clark |Rosemary |Miss |Y|31542|15|
Clayton |Michael |Mr. |N|69714|16|
Clemente |Patrick |Sir |Y|179702|15|
Clifford |Bessie |Dr. |N|61376|16|
Clifford |John |Sir |Y|12960|15|
Cochran |Dennis |Sir |Y|94375|15|
Coker |John |Mr. |N|2730|15|
Cole |Amanda |Dr. |Y|92994|15|
Cole |Gretchen |Dr. |N|191039|15|
Cole |June |Miss |N|206225|16|
Cole |Melanie |Mrs. |Y|208547|15|
Coleman |Nancy |Ms. |N|39446|16|
Collier |null|Mr. |Y|179488|15|
Collins |Patsy |Ms. |N|13775|15|
Conner |Sondra |Miss |N|191684|15|
Conrad |Jason |Mr. |N|166289|15|
Cook |John |Mr. |N|237195|15|
Cook |null|Sir |null|81755|15|
Cope |Felicia |Dr. |Y|195003|15|
Cordero |Dwight |Sir |Y|147038|15|
Cota |Jorge |Mr. |N|3324|15|
Crouch |Roberto |Dr. |Y|160826|15|
Cruz |Donna |Ms. |N|180864|15|
Cruz |Tamara |Ms. |N|112086|16|
Dalton |Dorthea |Dr. |Y|37698|15|
David |Timothy |Mr. |Y|20342|16|
Davis |Donya |Miss |N|31118|15|
Davis |Jess |Sir |Y|197947|15|
Davis |Sandra |Ms. |N|141249|15|
Davis |Vickie |Miss |Y|35264|15|
Davison |Jeffrey |Mr. |Y|81413|16|
Dejesus |Lorena |Dr. |null|157934|15|
Delacruz |Brenton |Mr. |Y|96016|15|
Delagarza |John |Mr. |N|62980|15|
Diaz |Brian |Mr. |N|73210|15|
Dietrich |Tammy |Dr. |N|114650|15|
Dorsey |Lisa |Dr. |Y|5587|15|
Dorsey |Melvin |Mr. |Y|231758|15|
Dunn |Stephen |Sir |N|32455|15|
Eason |Mario |Sir |N|174089|15|
Easton |Christopher |Sir |Y|10691|15|
Elliot |Mark |Mr. |Y|35782|16|
Esquivel |Hee |Mrs. |Y|42741|15|
Evans |April |Dr. |Y|41310|15|
Faison |Roy |Sir |Y|147757|15|
Farnsworth |Danny |Mr. |Y|29979|15|
Ferrell |Roy |Mr. |N|139997|15|
Ferris |William |Sir |Y|12536|15|
Fields |Philomena |Dr. |N|217374|15|
Fife |Terry |Dr. |N|81012|15|
Finn |Margaret |Dr. |N|207070|15|
Fitzgerald |Thomas |Mr. |Y|2698|15|
Floyd |Lillian |Dr. |Y|84374|16|
Flynn |Rhonda |Miss |N|96322|15|
Forney |Christopher |Sir |N|175230|15|
Franklin |Dorothy |Miss |Y|210152|15|
Franklin |Eileen |Miss |Y|88556|15|
Franklin |Judy |Ms. |Y|27813|15|
Freeman |Rayford |Dr. |N|36115|15|
Freeman |null|Mrs. |Y|175123|15|
Fuqua |Harvey |Mr. |N|130609|16|
Galindo |Karen |Dr. |N|100437|15|
Galloway |Betty |Mrs. |Y|10097|15|
Garcia |Kenny |Dr. |N|197122|16|
Garrison |Robert |Sir |Y|40421|15|
Garza |William |Sir |N|43273|15|
German |Katie |Dr. |N|33536|16|
Gibbons |Christopher |Sir |Y|237265|16|
Gibbons |Vivian |Mrs. |Y|95173|16|
Gibson |Agnes |Miss |N|228161|15|
Gil |Yvette |Mrs. |Y|86699|15|
Gill |Joshua |Sir |Y|230910|16|
Glass |Jorge |Sir |N|137536|15|
Gomez |Brandon |Sir |Y|160457|15|
Gonzales |Cindy |Dr. |Y|96495|15|
Gonzales |Edgar |Sir |N|153714|15|
Gonzalez |Ruby |Mrs. |Y|228694|15|
Gordon |Larry |Sir |Y|99782|15|
Graham |Brian |Mr. |N|13629|15|
Graham |Jerry |Sir |null|152656|15|
Gray |Jeffery |Mr. |Y|154258|15|
Grayson |Carolyn |Mrs. |N|69374|16|
Grayson |Terry |Mr. |N|130480|16|
Green |Cynthia |Mrs. |Y|141374|15|
Green |Robert |Mr. |N|73965|15|
Griffin |Martha |Dr. |N|82841|16|
Grubbs |Florence |Mrs. |N|47930|15|
Gulley |Daniel |Sir |Y|37484|16|
Gutierrez |Ashley |Dr. |N|209948|16|
Guzman |Mason |Mr. |Y|235019|16|
Haley |Henry |Sir |Y|141619|15|
Hall |Roger |Mr. |N|136216|15|
Hamilton |Alex |Mrs. |N|23084|15|
Hammonds |Richelle |Dr. |Y|135423|15|
Hampton |null|null|N|11567|15|
Hardy |Inez |Ms. |Y|104878|15|
Harris |Charles |Dr. |Y|61618|15|
Harris |Ezekiel |Sir |N|142043|15|
Harrison |Jennifer |Ms. |Y|63097|15|
Harrison |Michal |Mr. |Y|209687|15|
Harrison |Qiana |Dr. |Y|10522|15|
Hawkins |Clyde |Dr. |Y|236510|15|
Hayes |Elizabeth |Mrs. |N|213826|15|
Hayes |Johnnie |Sir |N|57732|15|
Hayes |William |Sir |Y|223946|15|
Haynes |Jennifer |Dr. |N|203136|15|
Haywood |Judy |Mrs. |N|167146|15|
Hernandez |Paul |Dr. |N|190691|15|
Hernandez |Sandra |Dr. |Y|14252|16|
Hewitt |Michelle |Dr. |N|155492|15|
Hill |Barbara |Ms. |Y|88890|15|
Hill |Julia |Dr. |N|191695|16|
Horton |Michelle |Ms. |Y|112716|16|
Howell |Katherine |Dr. |N|147571|16|
Huffman |Beverly |Ms. |Y|166660|16|
Hughes |Martin |Dr. |Y|178631|15|
Ivey |John |Mr. |N|189224|15|
Jackman |Ida |Dr. |Y|11753|15|
Jackson |Kathy |Ms. |N|233945|15|
Johnson |Lottie |Ms. |N|131031|15|
Johnson |Olen |Mr. |N|12862|15|
Johnson |Richard |Dr. |N|52256|15|
Johnston |Walter |Mr. |Y|219689|15|
Jones |Austin |Dr. |Y|57009|15|
Jones |Eleanor |Ms. |N|27477|16|
Jones |Jarvis |Sir |Y|74474|16|
Jones |Rebecca |Dr. |Y|187035|16|
Jones |Richard |Dr. |Y|232872|15|
Joseph |Ramon |Mr. |N|7856|15|
Joyce |null|Ms. |null|154184|16|
Keaton |Lacey |Mrs. |N|133023|15|
Keith |Bruce |Dr. |Y|24541|15|
Kelly |Betty |Dr. |Y|151468|16|
Kim |Bridget |Mrs. |Y|62861|15|
King |Thomas |Sir |N|62796|15|
Kinney |Angelica |Mrs. |N|192978|16|
Kline |Donald |Mr. |Y|161957|15|
Knight |Terence |Dr. |N|176372|16|
Kraus |Roger |Dr. |Y|117604|16|
Kruse |Jose |Dr. |N|114533|15|
Lacy |Mina |Miss |N|227155|15|
Ladner |Lisa |Dr. |Y|213223|15|
Laird |Mark |Mr. |N|65882|15|
Lavender |Robert |Sir |Y|3754|15|
Lawson |Amanda |Ms. |Y|61212|16|
Lawson |Kelly |Mr. |Y|64975|15|
Le |Rodney |Dr. |Y|79356|16|
Leigh |Abraham |Mr. |N|10283|15|
Lewis |Annie |Ms. |Y|131418|15|
Lewis |Bradley |Sir |N|182566|16|
Lewis |Jerry |Mr. |Y|233447|15|
Light |Robert |Mr. |Y|90021|15|
Lin |Robert |Dr. |Y|236887|15|
Lopez |Randee |Miss |N|9979|15|
Lopez |Theresa |Miss |Y|169110|15|
Lott |Ronald |Sir |N|79453|15|
Love |Sean |Mr. |N|196652|15|
Lowe |Elmer |Sir |N|133003|16|
Lozano |Charlotte |Mrs. |Y|31661|15|
Macias |Roger |Sir |N|82746|15|
Mansfield |Paul |Dr. |Y|5723|15|
Manuel |Doris |Mrs. |Y|148847|15|
Marks |Duane |Dr. |Y|34432|15|
Marsh |Gary |Sir |Y|6580|15|
Martin |Donald |Dr. |N|238840|16|
Martin |Steve |Mr. |N|72094|16|
Mason |Richard |Sir |Y|27500|16|
Mast |Catalina |Miss |Y|178574|15|
Matos |Josephine |Ms. |N|128283|16|
Maxey |Sharon |Ms. |N|74649|16|
Mccallister |Andrew |Ms. |Y|122178|15|
Mccloud |Nicholas |Mr. |Y|28001|15|
Mcconnell |Scott |Mr. |Y|78305|15|
Mccormick |Joanne |Ms. |N|236985|15|
Mcdaniel |Brian |Sir |N|217760|15|
Mcdonald |Araceli |Ms. |Y|121343|15|
Mcewen |Barbara |Mrs. |N|179491|15|
Mckenzie |Ana |Ms. |N|201062|16|
Mcnamara |Joann |Mrs. |Y|229870|15|
Mcswain |Virgil |Mr. |N|71937|16|
Melton |Monique |Ms. |Y|177605|15|
Miller |Brian |Dr. |N|203465|16|
Miller |Dennis |Dr. |N|137781|15|
Miller |Edward |Sir |N|64767|16|
Miller |Georgia |Ms. |N|40740|16|
Miller |Karrie |Dr. |N|170750|15|
Miller |Nancy |Mrs. |N|82671|16|
Montgomery |Julie |Miss |N|17471|15|
Moore |Barbara |Dr. |N|69608|15|
Moore |Jeffrey |Sir |Y|155931|15|
Moore |Lorena |Mrs. |Y|47752|15|
Moore |Peggy |Miss |Y|191466|15|
Morgan |Betty |Dr. |N|90306|15|
Morgan |Latricia |Mrs. |N|216137|15|
Morris |John |Dr. |Y|214378|15|
Morris |Martina |Miss |N|32596|15|
Morris |Meghan |Mrs. |Y|127565|15|
Moses |Amy |Dr. |Y|182188|15|
Moss |Michael |null|null|137243|15|
Moultrie |Martin |Dr. |N|215102|15|
Mulligan |Mark |Sir |Y|184598|16|
Mullins |Vicki |Dr. |Y|162762|15|
Murphy |Michael |Sir |Y|210567|15|
Neeley |Stephanie |Mrs. |N|216299|15|
Nelson |Everette |Dr. |N|80821|15|
Nesbitt |Andrew |Miss |N|185257|15|
Norfleet |Ethel |Miss |N|14366|15|
Olds |Stephen |Dr. |N|206275|16|
Olson |David |Dr. |Y|87821|16|
Oneill |Thomas |Mr. |N|93473|16|
Oneill |Thomas |Mr. |N|188154|15|
Osborn |Lena |Miss |Y|226949|16|
Outlaw |Dennis |Sir |N|115215|16|
Owens |Terry |Dr. |N|144931|15|
Page |Elizabeth |Ms. |N|146879|15|
Page |James |Dr. |Y|214208|16|
Palacios |Amber |Dr. |Y|225723|15|
Palmer |Debbie |Dr. |Y|121860|15|
Park |Jerry |Dr. |N|73028|15|
Peace |Carlos |Sir |N|203823|15|
Perez |Harold |Mr. |Y|6311|15|
Perez |Sheri |Ms. |N|157585|15|
Perry |Sarah |Ms. |N|100885|15|
Perry |Valeria |Mrs. |N|64861|15|
Phelps |Marco |Dr. |Y|86494|16|
Powell |Robert |Sir |Y|185862|15|
Price |Florence |Ms. |Y|17220|15|
Price |Gloria |Mrs. |Y|22568|15|
Price |Marguerite |Mrs. |N|134265|16|
Price |Marie |Ms. |N|88963|15|
Price |Paul |Sir |N|103985|16|
Price |Reginald |Sir |Y|123793|15|
Price |null|Sir |N|55817|15|
Pridgen |Hans |Dr. |N|207216|15|
Ramirez |Lee |Sir |N|234584|15|
Ramos |David |Dr. |Y|189463|16|
Reece |Jimmy |Sir |N|166493|16|
Reyes |Frank |null|null|84620|15|
Reyna |Rod |Sir |N|46248|16|
Reynolds |Oscar |Sir |Y|222749|15|
Richardson |Alice |Ms. |N|43255|16|
Riddle |John |Sir |Y|83916|15|
Riddle |Marcelino |Dr. |N|60749|15|
Rivera |Kate |Ms. |Y|204524|15|
Robb |Laura |Miss |null|173667|15|
Roberts |Candice |Dr. |Y|111855|16|
Roberts |Dorothy |Ms. |N|183154|15|
Roberts |Jennifer |Miss |Y|141296|15|
Robinson |Gary |Mr. |Y|87081|15|
Robinson |Sara |Mrs. |N|190406|15|
Roldan |Dorothy |Mrs. |N|9370|15|
Roman |Jimmie |Dr. |Y|221049|15|
Ross |Rachael |Mrs. |N|106042|16|
Ross |Robert |Mr. |Y|165295|15|
Russ |Amber |Mrs. |N|225981|15|
Russell |Larry |Dr. |Y|15209|16|
Russell |Mark |Dr. |N|126453|15|
Sacco |Brian |Sir |N|124398|16|
Saddler |Robert |Mr. |Y|74571|15|
Salinas |Kenneth |Dr. |Y|167446|15|
Salter |Antonio |Miss |N|27497|16|
Sanders |Dustin |Mr. |N|20319|15|
Sandoval |Vincent |Mr. |N|140438|16|
Sanford |Ronald |Sir |N|211947|15|
Saunders |Mae |Miss |N|108927|15|
Scott |Adam |Mrs. |N|13944|15|
Scott |Ethel |Dr. |N|112707|15|
Scott |Michael |Mr. |Y|104162|15|
Self |Harry |Sir |Y|102208|16|
Shaffer |Richard |Dr. |N|190775|16|
Shuler |Joseph |Sir |N|57224|16|
Sims |Fern |Dr. |Y|175233|15|
Sims |John |Dr. |Y|113923|15|
Smalls |Celeste |Ms. |Y|168837|15|
Smith |Dalene |Ms. |Y|143125|16|
Smith |Herbert |Dr. |Y|238646|15|
Smith |John |Mr. |N|93525|16|
Smith |Marion |Mr. |Y|65393|15|
Smith |Ralph |Sir |N|87132|16|
Smith |Terry |Dr. |Y|16945|15|
Smith |Toni |Miss |N|50011|15|
Smith |Wendell |Sir |N|85496|15|
Soares |Sally |Ms. |Y|203554|16|
Sparks |Michael |Mr. |Y|23696|15|
Spears |Edith |Ms. |Y|223566|15|
Spencer |Alfred |Mr. |Y|159308|15|
Spencer |Teri |Mrs. |N|28551|16|
Stafford |Jerry |Mr. |Y|230470|15|
Stamper |Rebekah |Dr. |N|235329|15|
Stephens |Donna |Ms. |N|151844|15|
Stevens |Mattie |Ms. |N|202640|15|
Stevens |Micheal |Dr. |Y|38659|16|
Stewart |Amanda |Mrs. |Y|145235|15|
Stewart |Gilbert |Mr. |Y|217862|15|
Stewart |Kendra |Mrs. |Y|16423|15|
Stewart |Pamela |Mrs. |Y|88160|16|
Straub |Lowell |Dr. |Y|215956|16|
Street |Lee |Mr. |N|171013|15|
Sullivan |Amy |Dr. |N|166225|15|
Swain |Laura |Ms. |Y|36774|16|
Swisher |Brian |Mr. |Y|53341|15|
Taylor |Arlene |Dr. |Y|71934|15|
Taylor |Jacqueline |Mrs. |Y|89977|16|
Taylor |Karen |Dr. |N|29777|15|
Taylor |Robert |Dr. |N|37700|15|
Thomas |Barbara |Dr. |N|172596|15|
Thomas |Christel |Dr. |Y|34579|15|
Thomas |Jeffrey |Dr. |Y|115846|15|
Thomas |Nichole |Miss |N|200721|16|
Thomas |Rebecca |Mrs. |N|80953|15|
Thompson |Brenda |Dr. |N|171735|15|
Thompson |Melissa |Dr. |N|162831|15|
Tidwell |Phyllis |null|null|234037|16|
Tilley |Jane |Mrs. |Y|45378|15|
Tinsley |Charlie |Dr. |N|23881|16|
Tolbert |Emily |Miss |Y|40132|15|
Tompkins |Charlotte |null|null|197857|15|
Torres |Jason |Dr. |N|224|16|
Torres |Roberta |Ms. |N|29436|15|
Townsend |Michelle |Mrs. |N|39872|15|
Turner |Kerry |Dr. |Y|23710|16|
Turner |Marjorie |Mrs. |N|65289|15|
Valenzuela |Bryan |Sir |Y|221858|16|
Vance |Josefina |Mrs. |N|147148|15|
Vargas |Charles |Dr. |Y|79536|15|
Vogel |Leroy |Sir |Y|29032|15|
Walker |Jim |Sir |N|46947|15|
Walker |Jose |Sir |Y|189670|16|
Walker |Richard |Sir |null|226475|15|
Wall |Russell |Sir |N|17231|16|
Wallace |Joseph |Sir |N|27193|15|
Walsh |Javier |Sir |Y|211987|16|
Warren |Brian |Dr. |N|15877|15|
Watson |Tina |Ms. |Y|120030|16|
Webb |Gloria |Ms. |N|65663|15|
Welch |Pauline |Mrs. |Y|47529|15|
West |Carman |Ms. |null|237594|15|
West |Rachel |Dr. |Y|138384|15|
Wetzel |Bebe |Dr. |N|82518|15|
White |Diane |Dr. |Y|82960|16|
White |Johnny |Dr. |N|204026|16|
Whitehead |Magan |Dr. |N|192159|16|
Wiggins |Kermit |Sir |N|112643|15|
Wilbur |Terry |Sir |N|200312|15|
Williams |Archie |Mr. |N|113007|15|
Williams |Karen |Ms. |Y|140802|15|
Williams |Scott |null|null|136844|16|
Willis |Amber |Ms. |N|53815|15|
Willis |Michael |Sir |Y|207326|15|
Wilson |Charles |Mr. |Y|60|15|
Wood |Mark |Dr. |N|4376|15|
Woody |Philip |Mr. |N|211173|16|
Wright |Amanda |null|Y|105395|15|
Yates |Kimberly |Ms. |Y|220849|15|
null|Grace |null|null|147095|16|
null|Joshua |Sir |N|108357|15|
null|Judy |Dr. |null|234350|16|
null|Roy |null|null|200033|15|
null|null|Mr. |Y|214003|15|
null|null|Ms. |null|54536|16|
null|null|null|Y|16278|15|
null|null|null|Y|146557|16|
null|null|null|N|55640|15|
null|null|null|N|58614|15|
null|null|null|N|96514|15|
null|null|null|N|220211|15|
null|null|null|null|148695|16|
null|null|null|null|151297|15|