sql-tests.testcases.tpcds.q30.result Maven / Gradle / Ivy
-- delimiter: |; types: CHAR|CHAR|CHAR|CHAR|CHAR|INTEGER|INTEGER|INTEGER|VARCHAR|CHAR|CHAR|BIGINT|DECIMAL
AAAAAAAAAAAIBAAA|Mr. |Eduardo |Goodwin |Y|24|11|1950|GHANA|null|[email protected] |2452312|3838.00|
AAAAAAAAABHAAAAA|Sir |Robert |Thornton |Y|24|5|1924|HONG KONG|null|[email protected] |2452431|2434.58|
AAAAAAAAABPNAAAA|Mr. |Alonzo |Huddleston |Y|19|4|1957|FAROE ISLANDS|null|[email protected] |2452289|2813.00|
AAAAAAAAAFCGBAAA|Ms. |Pamela |Slater |Y|2|6|1931|GAMBIA|null|[email protected] |2452613|1746.58|
AAAAAAAAAFLBAAAA|Sir |Keith |Stern |N|18|2|1925|ICELAND|null|[email protected] |2452549|1850.70|
AAAAAAAAAFLBAAAA|Sir |Keith |Stern |N|18|2|1925|ICELAND|null|[email protected] |2452549|10898.40|
AAAAAAAAAFOEBAAA|Dr. |Trevor |Battle |N|12|8|1953|THAILAND|null|[email protected] |2452643|3556.00|
AAAAAAAAAIKEAAAA|Dr. |Joseph |Miller |N|17|12|1930|MONACO|null|[email protected] |2452332|7037.55|
AAAAAAAAAJMABAAA|Miss |Brenda |Sloan |Y|23|3|1982|MALAYSIA|null|[email protected] |2452336|1783.19|
AAAAAAAAAKDNAAAA|null|null|null|null|null|12|null|null|null|null|2452544|2448.03|
AAAAAAAAANCLAAAA|Mr. |Raymond |Dixon |N|31|12|1977|MONTENEGRO|null|[email protected] |2452514|1785.96|
AAAAAAAAANNNAAAA|Ms. |Cindy |Julian |Y|4|8|1982|UGANDA|null|[email protected] |2452368|2449.04|
AAAAAAAAAPKJAAAA|Ms. |Elizabeth |Pepper |Y|28|12|1930|NICARAGUA|null|[email protected] |2452645|1764.40|
AAAAAAAABAKCBAAA|Miss |Denise |Brock |Y|10|4|1958|JAMAICA|null|[email protected] |2452435|1618.24|
AAAAAAAABBMDAAAA|Dr. |Walter |Bernard |Y|2|10|1948|BELARUS|null|[email protected] |2452628|1755.66|
AAAAAAAABIBBBAAA|Miss |Lorene |Mayfield |N|17|12|1947|ALBANIA|null|[email protected] |2452450|3157.70|
AAAAAAAABIIDAAAA|Mr. |Paul |Stevenson |N|26|2|1953|BARBADOS|null|[email protected] |2452488|1947.77|
AAAAAAAABMJAAAAA|Dr. |Marion |Mclain |N|16|2|1931|ANGUILLA|null|[email protected] |2452382|3134.46|
AAAAAAAABNFHBAAA|Mr. |Kristofer |Payne |N|12|5|1945|SYRIAN ARAB REPUBLIC|null|[email protected] |2452436|3813.33|
AAAAAAAABOLLAAAA|Miss |Lisa |Way |N|11|1|1941|LEBANON|null|[email protected] |2452383|1829.88|
AAAAAAAABPHKAAAA|Dr. |Gabriela |Jerome |Y|9|7|1969|IRAQ|null|[email protected] |2452567|5360.55|
AAAAAAAACBAFAAAA|Dr. |Timothy |Carroll |Y|14|8|1957|UGANDA|null|[email protected] |2452535|1642.80|
AAAAAAAACBPMAAAA|Ms. |Shana |Fulton |N|10|2|1955|RWANDA|null|[email protected] |2452378|2089.36|
AAAAAAAACCFCBAAA|Mr. |Mark |Pacheco |N|9|3|1956|YEMEN|null|[email protected] |2452377|1838.48|
AAAAAAAACCMEAAAA|Dr. |Adriane |Harmon |N|1|10|1964|ARGENTINA|null|[email protected] |2452562|8986.95|
AAAAAAAACCNJAAAA|Dr. |Elizabeth |Gilbreath |Y|17|1|1985|KIRIBATI|null|[email protected] |2452485|2450.86|
AAAAAAAACDDNAAAA|Ms. |Holly |Kim |N|15|6|1941|ICELAND|null|[email protected] |2452580|2719.44|
AAAAAAAACGILAAAA|Sir |Nolan |Mosley |N|20|3|1980|KENYA|null|[email protected] |2452317|1865.64|
AAAAAAAACHFHBAAA|Mr. |Dallas |Courtney |Y|21|5|1928|CÔTE D'IVOIRE|null|[email protected] |2452496|4394.79|
AAAAAAAACKOFAAAA|Dr. |Eric |Bucher |Y|19|9|1979|ALBANIA|null|[email protected] |2452541|4662.35|
AAAAAAAACMHNAAAA|Miss |Lisa |Dukes |Y|4|3|1964|SOLOMON ISLANDS|null|[email protected] |2452303|10387.84|
AAAAAAAACNGBAAAA|Mr. |Michael |Haley |Y|10|5|1933|SWAZILAND|null|[email protected] |2452359|4187.82|
AAAAAAAACOFAAAAA|Ms. |Tammy |Searcy |N|6|5|1989|SURINAME|null|[email protected] |2452295|5091.84|
AAAAAAAADBBHAAAA|Dr. |Charles |Fernandez |N|8|12|1992|CAMBODIA|null|[email protected] |2452574|4640.37|
AAAAAAAADFCBBAAA|Dr. |Micheal |Collier |N|1|9|1934|HONDURAS|null|[email protected] |2452446|15944.40|
AAAAAAAADIHHAAAA|Miss |Vikki |Garza |Y|29|8|1950|NAMIBIA|null|[email protected] |2452608|2373.84|
AAAAAAAADJAPAAAA|Ms. |Angel |Dodd |Y|22|12|1950|TIMOR-LESTE|null|[email protected] |2452634|2227.83|
AAAAAAAADKEFAAAA|Ms. |Martha |Dillon |N|9|12|1971|VANUATU|null|[email protected] |2452404|1863.40|
AAAAAAAADKIFAAAA|Sir |Walter |Stout |Y|18|1|1970|BURUNDI|null|[email protected] |2452449|2465.55|
AAAAAAAADLHNAAAA|Mr. |Joseph |Mckinney |Y|23|3|1940|ARMENIA|null|[email protected] |2452595|1820.02|
AAAAAAAADMMDBAAA|Mr. |Darrell |Padgett |Y|17|3|1992|HONDURAS|null|[email protected] |2452554|2052.54|
AAAAAAAADNHPAAAA|Mr. |John |Mathews |N|23|2|1925|NICARAGUA|null|[email protected] |2452543|7883.40|
AAAAAAAADOCMAAAA|Dr. |Yvonne |Poirier |Y|30|1|1950|ESTONIA|null|[email protected] |2452648|4075.55|
AAAAAAAADODBAAAA|Mrs. |Elizabeth |Spalding |N|27|11|1947|KAZAKHSTAN|null|[email protected] |2452318|10349.68|
AAAAAAAAEBAOAAAA|Miss |Amy |Causey |N|21|9|1951|COMOROS|null|[email protected] |2452443|8005.40|
AAAAAAAAEBLEAAAA|Mr. |Leroy |Couture |N|7|5|1938|SWITZERLAND|null|[email protected] |2452595|1683.88|
AAAAAAAAEEADAAAA|Mr. |Robert |Donohue |Y|21|8|1938|SWAZILAND|null|[email protected] |2452436|11083.80|
AAAAAAAAEHAABAAA|Dr. |Victoria |Morgan |Y|31|5|1960|JERSEY|null|[email protected] |2452646|1712.16|
AAAAAAAAEHGOAAAA|Miss |Jillian |Nelson |Y|27|7|1978|TURKMENISTAN|null|[email protected] |2452315|4432.69|
AAAAAAAAEHPNAAAA|Dr. |Rachael |King |Y|28|11|1927|PANAMA|null|[email protected] |2452438|2251.50|
AAAAAAAAEIDHAAAA|Sir |George |Garcia |Y|21|4|1960|CROATIA|null|[email protected] |2452306|1783.12|
AAAAAAAAEIDHAAAA|Sir |George |Garcia |Y|21|4|1960|CROATIA|null|[email protected] |2452306|1857.63|
AAAAAAAAEIOBBAAA|Mr. |Gary |Davis |N|9|6|1992|KYRGYZSTAN|null|[email protected] |2452322|1652.70|
AAAAAAAAEJFNAAAA|Dr. |Chad |Baldwin |Y|11|11|1937|BULGARIA|null|[email protected] |2452560|11133.36|
AAAAAAAAEJOPAAAA|Dr. |Alexandra |Henderson |N|4|2|1986|MONTENEGRO|null|[email protected] |2452376|3426.36|
AAAAAAAAELEBAAAA|Mrs. |Dianne |Ross |Y|19|7|1949|ICELAND|null|[email protected] |2452429|4018.30|
AAAAAAAAEMDIBAAA|Sir |Scott |Obrien |Y|3|8|1926|JERSEY|null|[email protected] |2452504|1456.67|
AAAAAAAAEMIAAAAA|Dr. |Danny |Ness |Y|25|10|1955|IRAQ|null|[email protected] |2452487|5569.50|
AAAAAAAAEMNGBAAA|Mr. |Milton |Oakley |Y|10|10|1976|FINLAND|null|[email protected] |2452355|1505.16|
AAAAAAAAEMPKAAAA|Sir |Gilbert |Palmer |N|23|10|1933|BRUNEI DARUSSALAM|null|[email protected] |2452463|2391.95|
AAAAAAAAENFLAAAA|Sir |Joseph |Gaffney |N|22|1|1967|BULGARIA|null|[email protected] |2452608|6135.48|
AAAAAAAAEPELAAAA|Dr. |Emily |Thomas |Y|14|3|1981|MOZAMBIQUE|null|[email protected] |2452617|3239.04|
AAAAAAAAFBLHAAAA|Mr. |Carter |Lombardo |N|22|11|1950|MONACO|null|[email protected] |2452582|3965.43|
AAAAAAAAFHODBAAA|Ms. |Diana |Hall |N|14|7|1934|LATVIA|null|[email protected] |2452546|9391.76|
AAAAAAAAFLAJAAAA|Mr. |John |Hardy |Y|4|9|1977|ANGUILLA|null|[email protected] |2452289|1640.80|
AAAAAAAAFLDFBAAA|Mr. |Demetrius |Hunt |N|30|8|1956|ZAMBIA|null|[email protected] |2452647|3673.60|
AAAAAAAAFMCFBAAA|Mrs. |Karen |Middleton |Y|21|10|1934|GUADELOUPE|null|[email protected] |2452343|1415.70|
AAAAAAAAFMENAAAA|Ms. |Anne |Jernigan |Y|14|8|1952|ITALY|null|[email protected] |2452612|1735.14|
AAAAAAAAFMLEAAAA|Mr. |Gavin |null|null|21|null|1933|BRAZIL|null|[email protected] |null|4882.15|
AAAAAAAAFMPMAAAA|Sir |Jack |Thomas |Y|12|1|1971|ARMENIA|null|[email protected] |2452409|2501.94|
AAAAAAAAFNHBBAAA|Miss |Jennifer |Long |Y|12|6|1984|VENEZUELA|null|[email protected] |2452285|4430.88|
AAAAAAAAGAGEAAAA|Sir |Jeffrey |Cleveland |N|2|8|1974|GUADELOUPE|null|[email protected] |2452380|4215.15|
AAAAAAAAGCNPAAAA|Sir |Jack |Stewart |N|19|12|1926|SAN MARINO|null|[email protected] |2452618|2859.50|
AAAAAAAAGFKEAAAA|Dr. |null|Brown |null|null|4|1933|ROMANIA|null|null|null|11364.32|
AAAAAAAAGGBIBAAA|Dr. |Michael |Christiansen |Y|4|3|1947|ISRAEL|null|[email protected] |2452583|1726.20|
AAAAAAAAGHHEAAAA|Sir |Jerry |Glover |Y|3|6|1942|ANTIGUA AND BARBUDA|null|[email protected] |2452645|6382.26|
AAAAAAAAGICFAAAA|Mr. |Charles |Sloan |Y|8|4|1991|KOREA, REPUBLIC OF|null|[email protected] |2452431|2793.57|
AAAAAAAAGIFHBAAA|Sir |Joe |Jackson |N|31|10|1969|FRENCH POLYNESIA|null|[email protected] |2452534|1692.69|
AAAAAAAAGJEGBAAA|Dr. |Carlos |Hampton |N|18|11|1947|DOMINICA|null|[email protected] |2452470|5556.75|
AAAAAAAAGMDJAAAA|Dr. |Christopher |Payne |Y|30|12|1958|DJIBOUTI|null|[email protected] |2452350|1638.72|
AAAAAAAAGOPMAAAA|Mrs. |Donna |West |N|2|12|1977|SOLOMON ISLANDS|null|[email protected] |2452645|1623.20|
AAAAAAAAHBBDBAAA|Mrs. |null|Henry |N|null|null|1948|ARUBA|null|null|2452337|4377.30|
AAAAAAAAHBBDBAAA|Mrs. |null|Henry |N|null|null|1948|ARUBA|null|null|2452337|5013.12|
AAAAAAAAHCJKAAAA|Ms. |Emma |Bailey |N|2|10|1935|LATVIA|null|[email protected] |2452491|5638.14|
AAAAAAAAHGCHBAAA|Dr. |Thomas |Hull |Y|24|2|1931|DENMARK|null|[email protected] |2452648|2487.60|
AAAAAAAAHGIFAAAA|Sir |James |Turner |N|25|10|1937|JERSEY|null|[email protected] |2452293|2757.44|
AAAAAAAAHIIDBAAA|Mrs. |Andrew |Barrett |Y|24|5|1992|GUERNSEY|null|[email protected] |2452319|7854.67|
AAAAAAAAHJOBAAAA|Mrs. |April |Wallace |N|19|7|1930|FIJI|null|[email protected] |2452382|4596.60|
AAAAAAAAHMEFBAAA|null|Joshua |Bruno |null|1|11|null|null|null|[email protected] |2452303|1806.33|
AAAAAAAAHMNNAAAA|Sir |Jeffery |Thomas |Y|8|3|1929|MONTSERRAT|null|[email protected] |2452598|2441.40|
AAAAAAAAICMGAAAA|Miss |Edith |Robinson |Y|11|7|1967|PUERTO RICO|null|[email protected] |2452319|7193.61|
AAAAAAAAIGLCBAAA|Miss |Erika |Edmondson |Y|1|8|1944|DJIBOUTI|null|[email protected] |2452460|2381.83|
AAAAAAAAIJGGBAAA|Ms. |Carolyn |Cardona |N|15|9|1936|BULGARIA|null|[email protected] |2452453|7659.19|
AAAAAAAAIMAHBAAA|Mrs. |Elizabeth |Guzman |Y|19|9|1950|GREECE|null|[email protected] |2452315|1856.20|
AAAAAAAAIMGFAAAA|Dr. |Paul |Powell |Y|28|11|1935|GREECE|null|[email protected] |2452320|8416.80|
AAAAAAAAIMJCBAAA|Dr. |Dennis |Brown |Y|24|10|1978|BULGARIA|null|[email protected] |2452404|1552.46|
AAAAAAAAIMJCBAAA|Dr. |Dennis |Brown |Y|24|10|1978|BULGARIA|null|[email protected] |2452404|2639.34|
AAAAAAAAIMPNAAAA|Sir |Charles |Chadwick |N|21|1|1936|ALAND ISLANDS|null|[email protected] |2452414|4241.44|
AAAAAAAAIPHCAAAA|Mr. |Robert |Parham |Y|9|2|1967|ETHIOPIA|null|[email protected] |2452519|4317.18|
AAAAAAAAJABDBAAA|null|null|null|null|9|6|1972|TIMOR-LESTE|null|null|null|2387.28|