sql-tests.testcases.tpcds.q40.result Maven / Gradle / Ivy
The newest version!
-- delimiter: |; types: CHAR|CHAR|DECIMAL|DECIMAL
TN|AAAAAAAAAABDAAAA|0.00|-82.10|
TN|AAAAAAAAAACDAAAA|-216.54|158.04|
TN|AAAAAAAAAAHDAAAA|186.55|0.00|
TN|AAAAAAAAAALAAAAA|0.00|48.23|
TN|AAAAAAAAABBDAAAA|98.61|332.71|
TN|AAAAAAAAABDAAAAA|0.00|213.64|
TN|AAAAAAAAACGCAAAA|63.68|0.00|
TN|AAAAAAAAACHCAAAA|102.68|51.89|
TN|AAAAAAAAACKCAAAA|128.93|44.82|
TN|AAAAAAAAACLDAAAA|205.44|-948.62|
TN|AAAAAAAAACOBAAAA|207.32|24.89|
TN|AAAAAAAAACPDAAAA|87.75|53.99|
TN|AAAAAAAAADGBAAAA|44.31|222.48|
TN|AAAAAAAAADKBAAAA|0.00|-471.87|
TN|AAAAAAAAAEADAAAA|58.24|0.00|
TN|AAAAAAAAAEOCAAAA|19.91|214.70|
TN|AAAAAAAAAFACAAAA|271.82|163.17|
TN|AAAAAAAAAFADAAAA|2.35|28.32|
TN|AAAAAAAAAFDCAAAA|-378.05|-303.27|
TN|AAAAAAAAAGIDAAAA|307.61|-19.29|
TN|AAAAAAAAAHDEAAAA|80.58|-476.72|
TN|AAAAAAAAAHHAAAAA|8.27|155.10|
TN|AAAAAAAAAHJBAAAA|39.24|0.00|
TN|AAAAAAAAAIECAAAA|82.40|3.91|
TN|AAAAAAAAAIEEAAAA|20.40|-151.09|
TN|AAAAAAAAAIMCAAAA|24.47|-150.30|
TN|AAAAAAAAAJACAAAA|49.09|82.10|
TN|AAAAAAAAAJCAAAAA|121.18|63.78|
TN|AAAAAAAAAJKBAAAA|27.94|8.97|
TN|AAAAAAAAALBEAAAA|88.26|30.23|
TN|AAAAAAAAALCEAAAA|93.52|92.02|
TN|AAAAAAAAALECAAAA|64.20|15.16|
TN|AAAAAAAAALNBAAAA|4.20|148.27|
TN|AAAAAAAAAMBEAAAA|28.44|0.00|
TN|AAAAAAAAAMPBAAAA|0.00|131.93|
TN|AAAAAAAAANFEAAAA|0.00|-137.34|
TN|AAAAAAAAAOBBAAAA|0.00|55.62|
TN|AAAAAAAAAOIBAAAA|150.41|254.28|
TN|AAAAAAAAAPBAAAAA|70.40|0.00|
TN|AAAAAAAAAPJBAAAA|45.27|334.40|
TN|AAAAAAAAAPLAAAAA|50.20|29.15|
TN|AAAAAAAAAPLDAAAA|0.00|32.39|
TN|AAAAAAAABAPDAAAA|93.42|145.87|
TN|AAAAAAAABBIDAAAA|296.77|30.96|
TN|AAAAAAAABDCEAAAA|-1771.08|-54.78|
TN|AAAAAAAABDDDAAAA|111.12|280.59|
TN|AAAAAAAABDJAAAAA|0.00|79.55|
TN|AAAAAAAABEFDAAAA|0.00|3.43|
TN|AAAAAAAABEODAAAA|269.90|297.58|
TN|AAAAAAAABFMBAAAA|110.83|-941.40|
TN|AAAAAAAABFNAAAAA|47.86|0.00|
TN|AAAAAAAABFOCAAAA|46.34|83.52|
TN|AAAAAAAABHPCAAAA|27.37|77.62|
TN|AAAAAAAABIDBAAAA|196.62|5.57|
TN|AAAAAAAABIGBAAAA|425.34|0.00|
TN|AAAAAAAABIJBAAAA|209.63|0.00|
TN|AAAAAAAABJFEAAAA|7.33|55.16|
TN|AAAAAAAABKFAAAAA|0.00|138.14|
TN|AAAAAAAABKMCAAAA|27.17|54.97|
TN|AAAAAAAABLDEAAAA|170.29|0.00|
TN|AAAAAAAABNHBAAAA|58.06|-337.89|
TN|AAAAAAAABNIDAAAA|54.40|35.02|
TN|AAAAAAAABNLAAAAA|0.00|168.38|
TN|AAAAAAAABNLDAAAA|0.00|96.41|
TN|AAAAAAAABNMCAAAA|202.41|49.53|
TN|AAAAAAAABOCCAAAA|4.73|69.84|
TN|AAAAAAAABOMBAAAA|63.67|163.49|
TN|AAAAAAAACAAAAAAA|121.91|0.00|
TN|AAAAAAAACAADAAAA|-1107.61|0.00|
TN|AAAAAAAACAJCAAAA|115.81|173.05|
TN|AAAAAAAACBCDAAAA|18.94|226.38|
TN|AAAAAAAACBFAAAAA|0.00|97.41|
TN|AAAAAAAACBIAAAAA|2.14|84.66|
TN|AAAAAAAACBPBAAAA|95.44|26.68|
TN|AAAAAAAACCABAAAA|160.43|135.86|
TN|AAAAAAAACCHDAAAA|0.00|121.62|
TN|AAAAAAAACCMDAAAA|-115.87|124.38|
TN|AAAAAAAACDBCAAAA|16.62|3.40|
TN|AAAAAAAACDECAAAA|-3114.60|0.00|
TN|AAAAAAAACEEAAAAA|34.68|26.41|
TN|AAAAAAAACELAAAAA|130.59|154.63|
TN|AAAAAAAACELDAAAA|0.00|181.07|
TN|AAAAAAAACFEAAAAA|3.78|-315.13|
TN|AAAAAAAACFHDAAAA|0.00|1.80|
TN|AAAAAAAACGFDAAAA|-386.87|96.92|
TN|AAAAAAAACHHDAAAA|143.17|251.64|
TN|AAAAAAAACHPCAAAA|0.17|198.29|
TN|AAAAAAAACJCBAAAA|-918.65|270.96|
TN|AAAAAAAACJDCAAAA|0.00|130.15|
TN|AAAAAAAACJLAAAAA|63.96|91.27|
TN|AAAAAAAACKFCAAAA|-540.59|35.64|
TN|AAAAAAAACKHAAAAA|204.52|110.61|
TN|AAAAAAAACKIAAAAA|18.43|-63.65|
TN|AAAAAAAACLAEAAAA|116.07|0.00|
TN|AAAAAAAACLGAAAAA|108.10|111.14|
TN|AAAAAAAACLKAAAAA|143.05|19.59|
TN|AAAAAAAACLLBAAAA|0.00|178.10|
TN|AAAAAAAACLOBAAAA|-2200.72|14.13|
TN|AAAAAAAACMADAAAA|71.42|-13.64|
TN|AAAAAAAACMJAAAAA|0.00|358.31|