sql-tests.testcases.tpcds.q27.result Maven / Gradle / Ivy
-- delimiter: |; types: CHAR|CHAR|INTEGER|DOUBLE|DECIMAL|DECIMAL|DECIMAL
AAAAAAAAAAABAAAA|TN|0|46.00000000000|114.72|0.00|32.12|
AAAAAAAAAAABAAAA|null|1|46.00000000000|114.72|0.00|32.12|
AAAAAAAAAAAEAAAA|TN|0|100.00000000000|77.97|0.00|57.69|
AAAAAAAAAAAEAAAA|null|1|100.00000000000|77.97|0.00|57.69|
AAAAAAAAAABAAAAA|TN|0|6.00000000000|48.89|13.61|2.44|
AAAAAAAAAABAAAAA|null|1|6.00000000000|48.89|13.61|2.44|
AAAAAAAAAACAAAAA|TN|0|62.00000000000|32.21|0.00|5.51|
AAAAAAAAAACAAAAA|null|1|62.00000000000|32.21|0.00|5.51|
AAAAAAAAAACDAAAA|TN|0|97.00000000000|161.78|0.00|55.00|
AAAAAAAAAACDAAAA|null|1|97.00000000000|161.78|0.00|55.00|
AAAAAAAAAADBAAAA|TN|0|28.00000000000|136.01|575.76|73.44|
AAAAAAAAAADBAAAA|null|1|28.00000000000|136.01|575.76|73.44|
AAAAAAAAAADCAAAA|TN|0|64.00000000000|116.14|0.00|108.01|
AAAAAAAAAADCAAAA|null|1|64.00000000000|116.14|0.00|108.01|
AAAAAAAAAAEBAAAA|TN|0|9.00000000000|5.43|0.00|5.21|
AAAAAAAAAAEBAAAA|null|1|9.00000000000|5.43|0.00|5.21|
AAAAAAAAAAEDAAAA|TN|0|45.50000000000|87.64|0.00|51.84|
AAAAAAAAAAEDAAAA|null|1|45.50000000000|87.64|0.00|51.84|
AAAAAAAAAAGBAAAA|TN|0|29.00000000000|101.94|0.00|100.92|
AAAAAAAAAAGBAAAA|null|1|29.00000000000|101.94|0.00|100.92|
AAAAAAAAAAGCAAAA|TN|0|97.00000000000|65.27|0.00|21.53|
AAAAAAAAAAGCAAAA|null|1|97.00000000000|65.27|0.00|21.53|
AAAAAAAAAAGEAAAA|TN|0|55.00000000000|73.88|0.00|71.00|
AAAAAAAAAAGEAAAA|null|1|55.00000000000|73.88|0.00|71.00|
AAAAAAAAAAHAAAAA|TN|0|20.00000000000|134.30|0.00|119.52|
AAAAAAAAAAHAAAAA|null|1|20.00000000000|134.30|0.00|119.52|
AAAAAAAAAAHBAAAA|TN|0|97.00000000000|7.40|0.00|6.73|
AAAAAAAAAAHBAAAA|null|1|97.00000000000|7.40|0.00|6.73|
AAAAAAAAAAHDAAAA|TN|0|69.00000000000|5.62|0.00|0.33|
AAAAAAAAAAHDAAAA|null|1|69.00000000000|5.62|0.00|0.33|
AAAAAAAAAAIAAAAA|TN|0|87.00000000000|106.98|0.00|27.81|
AAAAAAAAAAIAAAAA|null|1|87.00000000000|106.98|0.00|27.81|
AAAAAAAAAAKBAAAA|TN|0|84.50000000000|66.18|847.84|57.38|
AAAAAAAAAAKBAAAA|null|1|84.50000000000|66.18|847.84|57.38|
AAAAAAAAAALAAAAA|TN|0|6.00000000000|32.28|0.00|7.42|
AAAAAAAAAALAAAAA|null|1|6.00000000000|32.28|0.00|7.42|
AAAAAAAAAALCAAAA|TN|0|98.00000000000|34.31|55.30|1.71|
AAAAAAAAAALCAAAA|null|1|98.00000000000|34.31|55.30|1.71|
AAAAAAAAAALDAAAA|TN|0|59.00000000000|129.47|713.90|22.00|
AAAAAAAAAALDAAAA|null|1|59.00000000000|129.47|713.90|22.00|
AAAAAAAAAANAAAAA|TN|0|74.00000000000|60.88|0.00|13.20|
AAAAAAAAAANAAAAA|null|1|74.00000000000|60.88|0.00|13.20|
AAAAAAAAAANBAAAA|TN|0|96.00000000000|130.79|1864.51|129.48|
AAAAAAAAAANBAAAA|null|1|96.00000000000|130.79|1864.51|129.48|
AAAAAAAAAAOAAAAA|TN|0|85.00000000000|130.34|0.00|122.51|
AAAAAAAAAAOAAAAA|null|1|85.00000000000|130.34|0.00|122.51|
AAAAAAAAAAOCAAAA|TN|0|14.00000000000|64.58|0.00|33.98|
AAAAAAAAAAOCAAAA|null|1|14.00000000000|64.58|0.00|33.98|
AAAAAAAAAAODAAAA|TN|0|84.00000000000|30.50|0.00|28.97|
AAAAAAAAAAODAAAA|null|1|84.00000000000|30.50|0.00|28.97|
AAAAAAAAAAPBAAAA|TN|0|45.00000000000|118.89|2380.60|84.72|
AAAAAAAAAAPBAAAA|null|1|45.00000000000|118.89|2380.60|84.72|
AAAAAAAAABAAAAAA|TN|0|97.00000000000|124.75|0.00|74.85|
AAAAAAAAABAAAAAA|null|1|97.00000000000|124.75|0.00|74.85|
AAAAAAAAABABAAAA|TN|0|31.00000000000|29.98|17.09|27.58|
AAAAAAAAABABAAAA|null|1|31.00000000000|29.98|17.09|27.58|
AAAAAAAAABAEAAAA|TN|0|34.00000000000|17.21|0.00|13.42|
AAAAAAAAABAEAAAA|null|1|34.00000000000|17.21|0.00|13.42|
AAAAAAAAABCBAAAA|TN|0|38.00000000000|131.38|0.00|52.32|
AAAAAAAAABCBAAAA|null|1|38.00000000000|131.38|0.00|52.32|
AAAAAAAAABDAAAAA|TN|0|31.50000000000|68.35|0.00|63.28|
AAAAAAAAABDAAAAA|null|1|31.50000000000|68.35|0.00|63.28|
AAAAAAAAABDBAAAA|TN|0|56.00000000000|103.85|1624.17|59.19|
AAAAAAAAABDBAAAA|null|1|56.00000000000|103.85|1624.17|59.19|
AAAAAAAAABDDAAAA|TN|0|67.33333333333|119.42|23.19|38.72|
AAAAAAAAABDDAAAA|null|1|67.33333333333|119.42|23.19|38.72|
AAAAAAAAABDEAAAA|TN|0|61.00000000000|85.95|2282.36|44.61|
AAAAAAAAABDEAAAA|null|1|61.00000000000|85.95|2282.36|44.61|
AAAAAAAAABEDAAAA|TN|0|61.00000000000|85.14|0.00|50.23|
AAAAAAAAABEDAAAA|null|1|61.00000000000|85.14|0.00|50.23|
AAAAAAAAABFBAAAA|TN|0|31.00000000000|23.55|0.00|13.65|
AAAAAAAAABFBAAAA|null|1|31.00000000000|23.55|0.00|13.65|
AAAAAAAAABFCAAAA|TN|0|83.00000000000|15.50|0.00|0.00|
AAAAAAAAABFCAAAA|null|1|83.00000000000|15.50|0.00|0.00|
AAAAAAAAABGAAAAA|TN|0|64.00000000000|35.08|0.00|3.15|
AAAAAAAAABGAAAAA|null|1|64.00000000000|35.08|0.00|3.15|
AAAAAAAAABGBAAAA|TN|0|40.00000000000|25.07|0.00|16.04|
AAAAAAAAABGBAAAA|null|1|40.00000000000|25.07|0.00|16.04|
AAAAAAAAABGEAAAA|TN|0|39.50000000000|56.77|14.26|36.01|
AAAAAAAAABGEAAAA|null|1|39.50000000000|56.77|14.26|36.01|
AAAAAAAAABHAAAAA|TN|0|93.00000000000|74.80|0.00|21.69|
AAAAAAAAABHAAAAA|null|1|93.00000000000|74.80|0.00|21.69|
AAAAAAAAABHCAAAA|TN|0|31.50000000000|79.84|181.38|61.94|
AAAAAAAAABHCAAAA|null|1|31.50000000000|79.84|181.38|61.94|
AAAAAAAAABIBAAAA|TN|0|48.00000000000|170.89|0.00|140.12|
AAAAAAAAABIBAAAA|null|1|48.00000000000|170.89|0.00|140.12|
AAAAAAAAABJAAAAA|TN|0|46.50000000000|82.33|0.00|44.99|
AAAAAAAAABJAAAAA|null|1|46.50000000000|82.33|0.00|44.99|
AAAAAAAAABJBAAAA|TN|0|76.00000000000|12.40|0.00|3.96|
AAAAAAAAABJBAAAA|null|1|76.00000000000|12.40|0.00|3.96|
AAAAAAAAABJDAAAA|TN|0|34.00000000000|118.51|0.00|61.21|
AAAAAAAAABJDAAAA|null|1|34.00000000000|118.51|0.00|61.21|
AAAAAAAAABKAAAAA|TN|0|65.00000000000|8.78|0.00|5.18|
AAAAAAAAABKAAAAA|null|1|65.00000000000|8.78|0.00|5.18|
AAAAAAAAABKCAAAA|TN|0|26.00000000000|51.57|0.00|41.25|
AAAAAAAAABKCAAAA|null|1|26.00000000000|51.57|0.00|41.25|
AAAAAAAAABLBAAAA|TN|0|61.50000000000|149.12|0.00|82.54|
AAAAAAAAABLBAAAA|null|1|61.50000000000|149.12|0.00|82.54|
AAAAAAAAABMAAAAA|TN|0|14.00000000000|109.97|0.00|10.99|
AAAAAAAAABMAAAAA|null|1|14.00000000000|109.97|0.00|10.99|