sql-tests.testcases.tpcds.q14_1.result Maven / Gradle / Ivy
-- delimiter: |; types: VARCHAR|INTEGER|INTEGER|INTEGER|DECIMAL|BIGINT
catalog|1001001|1|1|115019.61|20|
catalog|1001001|1|2|146344.47|27|
catalog|1001001|1|3|22597.19|3|
catalog|1001001|1|4|107555.43|23|
catalog|1001001|1|5|122521.31|25|
catalog|1001001|1|6|16883.97|3|
catalog|1001001|1|7|46329.78|9|
catalog|1001001|1|8|77861.85|13|
catalog|1001001|1|9|99985.35|21|
catalog|1001001|1|10|100105.28|23|
catalog|1001001|1|null|855204.24|167|
catalog|1001001|2|2|43967.97|7|
catalog|1001001|2|3|68565.38|14|
catalog|1001001|2|5|12633.87|3|
catalog|1001001|2|null|125167.22|24|
catalog|1001001|3|1|11100.79|5|
catalog|1001001|3|2|60551.64|14|
catalog|1001001|3|4|28455.23|4|
catalog|1001001|3|6|36821.61|7|
catalog|1001001|3|7|17250.82|6|
catalog|1001001|3|8|14426.92|4|
catalog|1001001|3|9|30078.07|3|
catalog|1001001|3|null|198685.08|43|
catalog|1001001|4|2|45473.85|13|
catalog|1001001|4|3|16558.92|8|
catalog|1001001|4|4|47553.20|10|
catalog|1001001|4|null|109585.97|31|
catalog|1001001|5|9|30112.11|12|
catalog|1001001|5|10|29678.50|5|
catalog|1001001|5|null|59790.61|17|
catalog|1001001|6|9|10261.82|3|
catalog|1001001|6|null|10261.82|3|
catalog|1001001|7|7|18244.94|3|
catalog|1001001|7|null|18244.94|3|
catalog|1001001|8|7|28872.49|7|
catalog|1001001|8|10|26895.97|6|
catalog|1001001|8|null|55768.46|13|
catalog|1001001|9|6|30944.19|5|
catalog|1001001|9|null|30944.19|5|
catalog|1001001|11|9|82810.87|12|
catalog|1001001|11|null|82810.87|12|
catalog|1001001|12|10|38427.52|9|
catalog|1001001|12|null|38427.52|9|
catalog|1001001|15|9|53508.79|7|
catalog|1001001|15|10|59329.31|13|
catalog|1001001|15|null|112838.10|20|
catalog|1001001|null|null|1697729.02|347|
catalog|1001002|1|1|2673969.89|530|
catalog|1001002|1|null|2673969.89|530|
catalog|1001002|2|1|140831.91|29|
catalog|1001002|2|null|140831.91|29|
catalog|1001002|3|1|320175.87|67|
catalog|1001002|3|null|320175.87|67|
catalog|1001002|4|1|133287.96|21|
catalog|1001002|4|null|133287.96|21|
catalog|1001002|5|1|16606.90|9|
catalog|1001002|5|null|16606.90|9|
catalog|1001002|6|1|15133.01|4|
catalog|1001002|6|null|15133.01|4|
catalog|1001002|7|1|24471.26|10|
catalog|1001002|7|null|24471.26|10|
catalog|1001002|8|1|63773.05|12|
catalog|1001002|8|null|63773.05|12|
catalog|1001002|9|1|9167.19|3|
catalog|1001002|9|null|9167.19|3|
catalog|1001002|12|1|29108.42|7|
catalog|1001002|12|null|29108.42|7|
catalog|1001002|15|1|31143.45|6|
catalog|1001002|15|null|31143.45|6|
catalog|1001002|16|1|70162.42|8|
catalog|1001002|16|null|70162.42|8|
catalog|1001002|null|null|3527831.33|706|
catalog|1002001|1|1|76392.13|14|
catalog|1002001|1|2|118394.33|21|
catalog|1002001|1|4|29395.79|5|
catalog|1002001|1|5|35541.97|4|
catalog|1002001|1|6|26104.36|3|
catalog|1002001|1|9|18793.97|4|
catalog|1002001|1|10|44071.42|4|
catalog|1002001|1|null|348693.97|55|
catalog|1002001|2|1|239511.02|51|
catalog|1002001|2|2|147993.14|26|
catalog|1002001|2|3|100086.93|17|
catalog|1002001|2|4|53524.42|13|
catalog|1002001|2|5|48494.06|10|
catalog|1002001|2|6|142857.04|20|
catalog|1002001|2|7|116557.98|16|
catalog|1002001|2|8|92743.93|24|
catalog|1002001|2|9|203943.99|38|
catalog|1002001|2|10|88249.19|10|
catalog|1002001|2|null|1233961.70|225|
catalog|1002001|3|2|25171.13|6|
catalog|1002001|3|7|27766.70|3|
catalog|1002001|3|8|38116.49|8|
catalog|1002001|3|null|91054.32|17|
catalog|1002001|4|1|66896.68|15|
catalog|1002001|4|3|43672.63|7|
catalog|1002001|4|4|41393.52|6|
catalog|1002001|4|5|30464.86|4|
catalog|1002001|4|null|182427.69|32|