All Downloads are FREE. Search and download functionalities are using the official Maven repository.

sql-tests.testcases.tpcds.q30.result Maven / Gradle / Ivy

There is a newer version: 464
Show newest version
-- 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|




© 2015 - 2024 Weber Informatics LLC | Privacy Policy