sql-tests.testcases.tpcds.q78.result Maven / Gradle / Ivy
-- delimiter: |; types: INTEGER|BIGINT|BIGINT|DECIMAL|BIGINT|DECIMAL|DECIMAL|BIGINT|DECIMAL|DECIMAL
2000|119|51419|0.80|60|52.03|86.53|75|129.90|61.37|
2000|119|51419|0.54|60|52.03|86.53|112|133.58|181.47|
2000|119|51419|0.53|60|52.03|86.53|114|130.74|74.90|
2000|119|51419|0.49|60|52.03|86.53|123|138.96|100.60|
2000|119|51419|0.48|60|52.03|86.53|126|102.57|42.27|
2000|119|51419|0.41|60|52.03|86.53|147|97.44|44.52|
2000|119|51419|0.38|60|52.03|86.53|157|155.41|212.72|
2000|119|51419|0.36|60|52.03|86.53|166|110.48|48.99|
2000|119|51419|0.36|60|52.03|86.53|168|82.94|52.89|
2000|119|51419|0.34|60|52.03|86.53|174|125.70|126.69|
2000|911|75040|0.14|14|38.78|40.41|100|116.03|37.82|
2000|911|75040|0.13|14|38.78|40.41|110|132.32|163.18|
2000|911|75040|0.11|14|38.78|40.41|122|138.20|135.20|
2000|911|75040|0.10|14|38.78|40.41|144|75.49|81.34|
2000|911|75040|0.10|14|38.78|40.41|147|131.37|217.59|
2000|2423|79617|0.08|3|66.00|18.36|37|112.12|233.76|
2000|2423|79617|0.06|3|66.00|18.36|49|104.81|200.98|
2000|2423|79617|0.06|3|66.00|18.36|51|84.99|175.23|
2000|2423|79617|0.05|3|66.00|18.36|63|159.84|322.59|
2000|2423|79617|0.05|3|66.00|18.36|65|141.68|227.15|
2000|2423|79617|0.03|3|66.00|18.36|90|136.62|229.76|
2000|2423|79617|0.03|3|66.00|18.36|97|141.93|222.05|
2000|2423|79617|0.03|3|66.00|18.36|115|151.55|229.73|
2000|2918|52124|2.61|47|98.06|115.41|18|41.37|59.08|
2000|2918|52124|1.88|47|98.06|115.41|25|96.81|133.45|
2000|2918|52124|1.57|47|98.06|115.41|30|99.87|48.34|
2000|2918|52124|0.98|47|98.06|115.41|48|26.84|34.48|
2000|2918|52124|0.92|47|98.06|115.41|51|105.05|201.51|
2000|2918|52124|0.68|47|98.06|115.41|69|62.07|109.76|
2000|2918|52124|0.65|47|98.06|115.41|72|68.39|103.43|
2000|2918|52124|0.53|47|98.06|115.41|89|65.19|49.51|
2000|2918|52124|0.47|47|98.06|115.41|101|62.69|92.69|
2000|2918|52124|0.44|47|98.06|115.41|107|37.55|55.38|
2000|2918|52124|0.43|47|98.06|115.41|109|48.31|43.23|
2000|3397|6926|2.34|68|79.62|75.24|29|131.24|226.60|
2000|3397|6926|2.34|68|79.62|75.24|29|136.99|260.63|
2000|3397|6926|2.19|68|79.62|75.24|31|99.51|215.26|
2000|3397|6926|1.94|68|79.62|75.24|35|152.97|228.55|
2000|3397|6926|1.42|68|79.62|75.24|48|110.57|230.14|
2000|3397|6926|0.99|68|79.62|75.24|69|171.64|277.79|
2000|3397|6926|0.94|68|79.62|75.24|72|131.46|255.29|
2000|3397|6926|0.94|68|79.62|75.24|72|138.71|261.05|
2000|3397|6926|0.93|68|79.62|75.24|73|171.52|377.85|
2000|3397|6926|0.72|68|79.62|75.24|94|161.82|252.59|
2000|3691|60308|0.32|34|68.21|94.29|105|180.34|229.16|
2000|3691|60308|0.31|34|68.21|94.29|109|159.14|240.70|
2000|3691|60308|0.30|34|68.21|94.29|113|123.26|162.36|
2000|3691|60308|0.27|34|68.21|94.29|127|98.90|154.94|
2000|3691|60308|0.22|34|68.21|94.29|154|100.26|128.40|
2000|3691|60308|0.22|34|68.21|94.29|156|133.83|189.11|
2000|3691|60308|0.19|34|68.21|94.29|175|89.35|117.26|
2000|3691|60308|0.18|34|68.21|94.29|186|91.37|124.51|
2000|3691|60308|0.18|34|68.21|94.29|187|133.01|126.69|
2000|4142|65211|4.70|94|19.82|9.98|20|148.05|187.80|
2000|4142|65211|1.68|94|19.82|9.98|56|110.70|135.72|
2000|4142|65211|1.62|94|19.82|9.98|58|83.84|22.88|
2000|4142|65211|1.24|94|19.82|9.98|76|111.68|65.70|
2000|4142|65211|1.06|94|19.82|9.98|89|109.86|98.30|
2000|4142|65211|1.06|94|19.82|9.98|89|125.53|135.36|
2000|4823|40858|0.39|15|29.46|40.47|38|99.56|52.34|
2000|4823|40858|0.33|15|29.46|40.47|46|141.39|64.56|
2000|4823|40858|0.25|15|29.46|40.47|59|149.92|80.27|
2000|4823|40858|0.25|15|29.46|40.47|61|142.30|68.26|
2000|4823|40858|0.19|15|29.46|40.47|80|86.40|57.41|
2000|4823|40858|0.15|15|29.46|40.47|102|140.67|141.09|
2000|4823|40858|0.15|15|29.46|40.47|103|158.36|116.23|
2000|4823|40858|0.13|15|29.46|40.47|119|120.56|87.44|
2000|6133|24941|0.52|23|70.89|56.56|44|124.09|15.61|
2000|6133|24941|0.50|23|70.89|56.56|46|170.63|56.37|
2000|6133|24941|0.34|23|70.89|56.56|67|177.27|49.37|
2000|6133|24941|0.21|23|70.89|56.56|110|147.02|131.12|
2000|6133|24941|0.21|23|70.89|56.56|111|131.01|66.29|
2000|6133|24941|0.20|23|70.89|56.56|114|137.97|24.02|
2000|6133|24941|0.19|23|70.89|56.56|120|105.45|53.98|
2000|6133|24941|0.18|23|70.89|56.56|128|131.10|33.12|
2000|6133|24941|0.17|23|70.89|56.56|138|114.92|45.30|
2000|6185|67634|0.05|2|47.05|6.78|39|48.48|31.10|
2000|6185|67634|0.04|2|47.05|6.78|53|42.78|21.68|
2000|6185|67634|0.04|2|47.05|6.78|57|95.24|74.91|
2000|6185|67634|0.03|2|47.05|6.78|59|102.78|29.84|
2000|6194|79216|1.63|67|73.25|19.03|41|118.95|57.48|
2000|6194|79216|1.18|67|73.25|19.03|57|96.19|90.36|
2000|6194|79216|1.10|67|73.25|19.03|61|68.13|70.85|
2000|6194|79216|0.71|67|73.25|19.03|94|124.65|30.15|
2000|6194|79216|0.61|67|73.25|19.03|109|64.31|42.47|
2000|7153|86796|null|null|76.24|50.82|86|96.07|26.01|
2000|7153|86796|null|null|76.24|50.82|100|76.38|70.46|
2000|7153|86796|null|null|76.24|50.82|101|40.63|29.11|
2000|7153|86796|null|null|76.24|50.82|102|84.14|68.99|
2000|7153|86796|null|null|76.24|50.82|111|113.19|64.26|
2000|7153|86796|null|null|76.24|50.82|114|60.81|51.69|
2000|7153|86796|null|null|76.24|50.82|125|27.65|16.15|
2000|7153|86796|null|null|76.24|50.82|129|71.82|92.85|
2000|7153|86796|null|null|76.24|50.82|137|60.21|41.11|
2000|7153|86796|null|null|76.24|50.82|151|46.15|16.66|
2000|7261|99191|0.11|10|10.48|13.05|87|81.71|107.91|
2000|7261|99191|0.11|10|10.48|13.05|89|157.32|152.17|
2000|7261|99191|0.10|10|10.48|13.05|97|142.38|244.18|
2000|7261|99191|0.09|10|10.48|13.05|108|116.45|163.96|
2000|7261|99191|0.09|10|10.48|13.05|115|145.82|162.35|