sql-tests.testcases.tpcds.q55.result Maven / Gradle / Ivy
-- delimiter: |; types: INTEGER|CHAR|DECIMAL
2001001|amalgimporto #1 |128393.59|
5001001|amalgscholar #1 |114563.05|
1001001|amalgamalg #1 |106541.65|
5003001|exportischolar #1 |104481.32|
1002001|importoamalg #1 |98315.70|
5002001|importoscholar #1 |81980.18|
4001001|amalgedu pack #1 |75471.82|
5004001|edu packscholar #1 |73945.27|
1004002|edu packamalg #2 |66973.45|
3003001|exportiexporti #1 |65256.40|
4003001|exportiedu pack #1 |58980.05|
4002001|importoedu pack #1 |52314.09|
5001002|amalgscholar #2 |50720.91|
1001002|amalgamalg #2 |48363.52|
1004001|edu packamalg #1 |46127.07|
9013009|exportiunivamalg #9 |44895.45|
2004001|edu packimporto #1 |44063.02|
2002001|importoimporto #1 |43360.76|
4001002|amalgedu pack #2 |41578.64|
5002002|importoscholar #2 |40981.69|
2004002|edu packimporto #2 |37031.29|
10015011|scholaramalgamalg #11 |36984.49|
5003002|exportischolar #2 |36835.57|
1003001|exportiamalg #1 |36391.68|
7009005|maxibrand #5 |35893.23|
3001001|amalgexporti #1 |34860.20|
6002002|importocorp #2 |34241.20|
10014016|edu packamalgamalg #16 |33635.08|
6005001|scholarcorp #1 |33315.76|
8001003|amalgnameless #3 |32795.69|
3001002|amalgexporti #2 |32035.45|
7003005|exportibrand #5 |30027.76|
8005010|scholarnameless #10 |28072.90|
3004001|edu packexporti #1 |27273.13|
4004002|edu packedu pack #2 |27176.70|
9011009|amalgunivamalg #9 |26702.81|
6011001|amalgbrand #1 |26270.95|
9009002|maximaxi #2 |25941.37|
8011009|amalgmaxi #9 |24766.62|
6014007|edu packbrand #7 |24592.55|
10016003|corpamalgamalg #3 |24575.24|
3002001|importoexporti #1 |24004.65|
3003002|exportiexporti #2 |23607.27|
10005001|scholarunivamalg #1 |22468.38|
6014001|edu packbrand #1 |22383.40|
6006002|corpcorp #2 |22325.52|
9003003|exportimaxi #3 |21996.83|
8009003|maxinameless #3 |21849.29|
8004009|edu packnameless #9 |21775.18|
8006008|corpnameless #8 |20393.22|
3002002|importoexporti #2 |20292.13|
10004001|edu packunivamalg #1 |20237.13|
8006005|corpnameless #5 |19946.01|
2003001|exportiimporto #1 |19467.87|
8010006|univmaxi #6 |19389.31|
2001002|amalgimporto #2 |19388.05|
6015001|scholarbrand #1 |19136.97|
10015001|scholaramalgamalg #1 |18789.40|
9016009|corpunivamalg #9 |18671.29|
8009007|maxinameless #7 |18581.52|
6002001|importocorp #1 |18495.43|
6013005|exportibrand #5 |18356.01|
7002004|importobrand #4 |18040.61|
6008001|namelesscorp #1 |17727.46|
9008008|namelessmaxi #8 |17517.04|
8002010|importonameless #10 |16810.57|
6013007|exportibrand #7 |16727.14|
7015003|scholarnameless #3 |16482.66|
4002002|importoedu pack #2 |16426.77|
10006001|corpunivamalg #1 |15835.02|
7006010|corpbrand #10 |15745.12|
8013007|exportimaxi #7 |15718.95|
9005011|scholarmaxi #11 |15426.87|
7011009|amalgnameless #9 |15381.64|
6009008|maxicorp #8 |15232.66|
10012012|importoamalgamalg #12 |14995.50|
10006017|corpunivamalg #17 |14040.95|
9016003|corpunivamalg #3 |13412.20|
6015005|scholarbrand #5 |13026.37|
8004003|edu packnameless #3 |12978.96|
1003002|exportiamalg #2 |12479.78|
7015007|scholarnameless #7 |11804.43|
6014008|edu packbrand #8 |11413.01|
6015003|scholarbrand #3 |11218.72|
6009003|maxicorp #3 |11124.10|
2003002|exportiimporto #2 |10938.52|
6011006|amalgbrand #6 |10284.31|
6008008|namelesscorp #8 |10056.32|
6001005|amalgcorp #5 |9749.25|
9004008|edu packmaxi #8 |9443.32|
6003006|exporticorp #6 |9165.48|
10011013|amalgamalgamalg #13 |8336.80|
10013009|exportiamalgamalg #9 |8324.62|
6006006|corpcorp #6 |8284.80|
8013006|exportimaxi #6 |7794.40|
8012005|importomaxi #5 |7777.35|
9011003|amalgunivamalg #3 |7703.20|
6005003|scholarcorp #3 |6941.66|
9011008|amalgunivamalg #8 |6554.12|
9005002|scholarmaxi #2 |5871.46|