sql-tests.testcases.tpcds.q26.result Maven / Gradle / Ivy
The newest version!
-- delimiter: |; types: CHAR|DOUBLE|DECIMAL|DECIMAL|DECIMAL
AAAAAAAAAAAEAAAA|63.00000000000|30.01|0.00|25.29|
AAAAAAAAAABEAAAA|96.00000000000|75.34|0.00|10.54|
AAAAAAAAAACAAAAA|73.00000000000|199.77|0.00|41.95|
AAAAAAAAAACCAAAA|23.50000000000|26.62|110.97|14.20|
AAAAAAAAAADBAAAA|23.00000000000|131.56|0.00|26.31|
AAAAAAAAAADEAAAA|15.00000000000|283.91|0.00|19.87|
AAAAAAAAAAEAAAAA|71.00000000000|176.71|0.00|142.69|
AAAAAAAAAAEBAAAA|96.00000000000|66.74|1014.39|16.01|
AAAAAAAAAAFCAAAA|85.00000000000|76.81|143.61|42.24|
AAAAAAAAAAGEAAAA|47.00000000000|136.93|0.00|95.28|
AAAAAAAAAAHBAAAA|27.00000000000|105.84|0.00|35.98|
AAAAAAAAAAIDAAAA|78.33333333333|126.37|0.00|61.94|
AAAAAAAAAAJBAAAA|60.33333333333|85.60|23.20|15.50|
AAAAAAAAAAKDAAAA|21.00000000000|84.42|0.00|26.85|
AAAAAAAAAALCAAAA|20.00000000000|62.79|0.00|48.97|
AAAAAAAAAALDAAAA|49.00000000000|73.16|0.00|21.01|
AAAAAAAAAAMCAAAA|81.00000000000|229.62|15221.17|202.06|
AAAAAAAAAANAAAAA|42.00000000000|79.99|0.00|76.79|
AAAAAAAAAANDAAAA|94.00000000000|27.92|0.00|1.67|
AAAAAAAAAAOAAAAA|66.00000000000|44.30|25.82|10.06|
AAAAAAAAAAOCAAAA|34.33333333333|84.50|1133.95|63.43|
AAAAAAAAABABAAAA|45.00000000000|79.82|0.00|67.84|
AAAAAAAAABAEAAAA|1.00000000000|171.54|0.00|49.74|
AAAAAAAAABBAAAAA|8.00000000000|279.08|0.00|55.81|
AAAAAAAAABBCAAAA|56.00000000000|45.97|1286.38|23.44|
AAAAAAAAABBDAAAA|47.00000000000|22.44|0.00|21.99|
AAAAAAAAABCBAAAA|84.00000000000|43.87|0.00|28.51|
AAAAAAAAABEDAAAA|43.00000000000|105.77|668.40|37.01|
AAAAAAAAABFEAAAA|66.00000000000|239.55|0.00|184.45|
AAAAAAAAABJAAAAA|49.00000000000|10.24|0.00|8.08|
AAAAAAAAABKAAAAA|71.00000000000|99.42|0.00|15.90|
AAAAAAAAABLBAAAA|40.00000000000|233.60|0.00|93.44|
AAAAAAAAABOCAAAA|51.00000000000|4.55|0.00|4.14|
AAAAAAAAACCAAAAA|39.00000000000|63.75|22.26|17.79|
AAAAAAAAACDCAAAA|51.00000000000|158.98|1334.07|124.79|
AAAAAAAAACDDAAAA|85.50000000000|75.74|0.00|36.29|
AAAAAAAAACEEAAAA|38.00000000000|78.69|0.00|19.67|
AAAAAAAAACFDAAAA|93.00000000000|59.44|0.00|7.72|
AAAAAAAAACGCAAAA|55.00000000000|103.21|0.00|27.86|
AAAAAAAAACHBAAAA|62.00000000000|180.29|0.00|32.45|
AAAAAAAAACIBAAAA|95.00000000000|214.40|0.00|4.28|
AAAAAAAAACKBAAAA|59.00000000000|92.91|0.00|29.68|
AAAAAAAAACMCAAAA|65.00000000000|119.55|0.00|84.88|
AAAAAAAAACNBAAAA|65.00000000000|169.29|0.00|121.88|
AAAAAAAAACNCAAAA|12.00000000000|64.16|0.00|16.04|
AAAAAAAAACOBAAAA|90.00000000000|50.84|0.00|6.10|
AAAAAAAAACODAAAA|46.00000000000|35.84|0.00|16.28|
AAAAAAAAACPAAAAA|62.00000000000|191.00|823.82|132.20|
AAAAAAAAADABAAAA|31.00000000000|30.66|0.00|2.45|
AAAAAAAAADACAAAA|31.00000000000|174.06|0.00|46.99|
AAAAAAAAADAEAAAA|21.00000000000|65.43|0.00|62.15|
AAAAAAAAADBAAAAA|88.00000000000|102.57|7392.18|92.31|
AAAAAAAAADBDAAAA|67.00000000000|221.22|0.00|79.63|
AAAAAAAAADCAAAAA|67.00000000000|70.16|2248.62|36.48|
AAAAAAAAADCDAAAA|37.00000000000|92.28|0.00|31.66|
AAAAAAAAADDCAAAA|27.00000000000|133.79|0.00|14.71|
AAAAAAAAADEAAAAA|99.00000000000|26.54|0.00|8.75|
AAAAAAAAADFDAAAA|49.00000000000|56.58|0.00|5.65|
AAAAAAAAADGEAAAA|49.00000000000|87.96|0.00|15.83|
AAAAAAAAADHAAAAA|36.00000000000|32.89|849.52|25.65|
AAAAAAAAADIAAAAA|98.00000000000|168.89|0.00|69.24|
AAAAAAAAADIDAAAA|5.00000000000|99.30|0.00|86.45|
AAAAAAAAADJBAAAA|87.00000000000|88.35|7.68|8.83|
AAAAAAAAADJCAAAA|71.00000000000|30.50|0.00|7.01|
AAAAAAAAADKAAAAA|40.50000000000|123.01|0.00|8.12|
AAAAAAAAADKBAAAA|23.00000000000|61.77|0.00|52.50|
AAAAAAAAADLAAAAA|35.00000000000|108.69|0.00|78.25|
AAAAAAAAADMBAAAA|14.00000000000|181.43|0.00|170.54|
AAAAAAAAADNAAAAA|23.00000000000|43.28|0.00|5.62|
AAAAAAAAADNBAAAA|19.00000000000|119.64|0.00|7.17|
AAAAAAAAADOCAAAA|37.50000000000|30.23|0.00|19.36|
AAAAAAAAADODAAAA|66.00000000000|4.61|0.00|2.53|
AAAAAAAAAEADAAAA|63.00000000000|153.04|0.00|148.44|
AAAAAAAAAEAEAAAA|25.00000000000|189.94|0.00|144.35|
AAAAAAAAAEBAAAAA|15.00000000000|96.74|0.00|10.64|
AAAAAAAAAECBAAAA|57.00000000000|31.66|0.00|11.39|
AAAAAAAAAEDBAAAA|90.00000000000|185.31|0.00|18.53|
AAAAAAAAAEFBAAAA|44.00000000000|56.32|0.00|39.50|
AAAAAAAAAEFCAAAA|14.00000000000|136.80|735.43|82.08|
AAAAAAAAAEGBAAAA|93.00000000000|138.20|0.00|134.05|
AAAAAAAAAEGDAAAA|71.00000000000|109.73|332.44|59.20|
AAAAAAAAAEHCAAAA|73.00000000000|216.23|0.00|211.90|
AAAAAAAAAEHDAAAA|28.00000000000|85.43|0.00|38.97|
AAAAAAAAAEJBAAAA|46.00000000000|85.18|0.00|79.21|
AAAAAAAAAEKCAAAA|59.00000000000|69.26|0.00|2.07|
AAAAAAAAAEMDAAAA|3.00000000000|183.78|0.00|134.15|
AAAAAAAAAFAAAAAA|54.00000000000|255.71|0.00|86.94|
AAAAAAAAAFADAAAA|90.00000000000|51.00|0.00|7.65|
AAAAAAAAAFBEAAAA|34.50000000000|105.16|0.00|37.67|
AAAAAAAAAFCDAAAA|81.00000000000|66.53|0.00|54.13|
AAAAAAAAAFDDAAAA|24.00000000000|110.75|0.00|56.10|
AAAAAAAAAFEEAAAA|44.00000000000|78.87|2115.77|71.77|
AAAAAAAAAFFBAAAA|39.50000000000|189.83|0.00|56.23|
AAAAAAAAAFFDAAAA|27.00000000000|73.31|37.25|2.19|
AAAAAAAAAFGCAAAA|64.00000000000|164.07|883.16|150.20|
AAAAAAAAAFHBAAAA|18.00000000000|92.06|0.00|26.69|
AAAAAAAAAFIDAAAA|26.00000000000|165.65|409.99|46.38|
AAAAAAAAAFLBAAAA|12.50000000000|146.01|13.65|118.78|
AAAAAAAAAFMCAAAA|41.00000000000|37.88|0.00|13.63|
AAAAAAAAAFMDAAAA|72.00000000000|97.77|0.00|24.44|