sql-tests.testcases.tpcds.q05.result Maven / Gradle / Ivy
-- delimiter: |; types: VARCHAR|CHAR|DECIMAL|DECIMAL|DECIMAL
catalog channel|catalog_pageAAAAAAAAAAABAAAA|202313.40|16399.02|-47694.75|
catalog channel|catalog_pageAAAAAAAAAACBAAAA|0.00|40.67|-580.23|
catalog channel|catalog_pageAAAAAAAAABABAAAA|99963.73|0.00|-9123.42|
catalog channel|catalog_pageAAAAAAAAACABAAAA|110031.72|730.25|2894.01|
catalog channel|catalog_pageAAAAAAAAADABAAAA|100574.53|0.00|-6936.97|
catalog channel|catalog_pageAAAAAAAAADCBAAAA|109501.15|0.00|-8502.77|
catalog channel|catalog_pageAAAAAAAAAEABAAAA|74938.91|2007.72|-28470.94|
catalog channel|catalog_pageAAAAAAAAAECBAAAA|94467.38|0.00|-7357.70|
catalog channel|catalog_pageAAAAAAAAAEMAAAAA|0.00|1870.55|-2882.54|
catalog channel|catalog_pageAAAAAAAAAEPAAAAA|0.00|745.57|-2382.22|
catalog channel|catalog_pageAAAAAAAAAFABAAAA|99713.31|10.36|-21969.43|
catalog channel|catalog_pageAAAAAAAAAFCBAAAA|42028.13|0.00|-11693.47|
catalog channel|catalog_pageAAAAAAAAAFPAAAAA|0.00|646.14|-196.28|
catalog channel|catalog_pageAAAAAAAAAGABAAAA|130003.30|0.00|8029.68|
catalog channel|catalog_pageAAAAAAAAAGCBAAAA|67932.46|0.00|-19090.29|
catalog channel|catalog_pageAAAAAAAAAGPAAAAA|0.00|14640.65|-7524.68|
catalog channel|catalog_pageAAAAAAAAAHABAAAA|73745.66|534.82|-24284.42|
catalog channel|catalog_pageAAAAAAAAAHCBAAAA|80403.30|0.00|7920.94|
catalog channel|catalog_pageAAAAAAAAAHPAAAAA|0.00|368.91|-315.48|
catalog channel|catalog_pageAAAAAAAAAIBBAAAA|0.00|1961.78|-2067.43|
catalog channel|catalog_pageAAAAAAAAAICBAAAA|51233.34|0.00|-26634.33|
catalog channel|catalog_pageAAAAAAAAAIMAAAAA|0.00|1450.80|-2935.35|
catalog channel|catalog_pageAAAAAAAAAIPAAAAA|0.00|6017.62|-4374.40|
catalog channel|catalog_pageAAAAAAAAAJABAAAA|0.00|59.40|-109.02|
catalog channel|catalog_pageAAAAAAAAAJCBAAAA|76099.08|0.00|-9751.99|
catalog channel|catalog_pageAAAAAAAAAJPAAAAA|0.00|13147.20|-10628.83|
catalog channel|catalog_pageAAAAAAAAAKPAAAAA|192922.64|132.30|-26672.26|
catalog channel|catalog_pageAAAAAAAAALCBAAAA|706.57|0.00|-2690.48|
catalog channel|catalog_pageAAAAAAAAALPAAAAA|130762.35|267.47|-25861.95|
catalog channel|catalog_pageAAAAAAAAAMBBAAAA|0.00|4716.80|-1832.19|
catalog channel|catalog_pageAAAAAAAAAMCBAAAA|17180.09|0.00|-472.86|
catalog channel|catalog_pageAAAAAAAAAMPAAAAA|208319.19|1508.22|-10123.53|
catalog channel|catalog_pageAAAAAAAAANCBAAAA|496.08|0.00|248.04|
catalog channel|catalog_pageAAAAAAAAANPAAAAA|181516.62|0.00|-10846.52|
catalog channel|catalog_pageAAAAAAAAAOPAAAAA|105275.63|811.08|-29136.42|
catalog channel|catalog_pageAAAAAAAAAPABAAAA|0.00|569.40|-1160.54|
catalog channel|catalog_pageAAAAAAAAAPCBAAAA|14782.30|0.00|7455.06|
catalog channel|catalog_pageAAAAAAAAAPPAAAAA|207956.31|2151.35|-40687.31|
catalog channel|catalog_pageAAAAAAAABAABAAAA|175328.40|658.60|-11798.95|
catalog channel|catalog_pageAAAAAAAABAJAAAAA|0.00|442.75|-2645.54|
catalog channel|catalog_pageAAAAAAAABBABAAAA|111653.24|0.00|-11685.07|
catalog channel|catalog_pageAAAAAAAABCABAAAA|66152.25|6000.80|-26884.15|
catalog channel|catalog_pageAAAAAAAABDABAAAA|94791.60|992.91|-15597.95|
catalog channel|catalog_pageAAAAAAAABDCBAAAA|80488.77|0.00|-9539.13|
catalog channel|catalog_pageAAAAAAAABDPAAAAA|0.00|4671.24|-1866.00|
catalog channel|catalog_pageAAAAAAAABEABAAAA|44094.18|1392.90|-27351.01|
catalog channel|catalog_pageAAAAAAAABECBAAAA|59973.49|10.56|-27067.70|
catalog channel|catalog_pageAAAAAAAABEIAAAAA|0.00|2316.60|-1437.01|
catalog channel|catalog_pageAAAAAAAABEPAAAAA|0.00|1681.34|-1942.91|
catalog channel|catalog_pageAAAAAAAABFABAAAA|106953.95|0.00|-28232.33|
catalog channel|catalog_pageAAAAAAAABFCBAAAA|119849.92|0.00|21540.18|
catalog channel|catalog_pageAAAAAAAABFPAAAAA|0.00|5292.06|-1546.65|
catalog channel|catalog_pageAAAAAAAABGABAAAA|59901.70|3376.62|-40143.40|
catalog channel|catalog_pageAAAAAAAABGCBAAAA|62240.04|439.05|-14709.55|
catalog channel|catalog_pageAAAAAAAABGPAAAAA|0.00|868.79|-1140.92|
catalog channel|catalog_pageAAAAAAAABHABAAAA|76979.86|1176.08|-11100.37|
catalog channel|catalog_pageAAAAAAAABHCBAAAA|77547.85|0.00|-912.18|
catalog channel|catalog_pageAAAAAAAABHPAAAAA|0.00|2202.00|-3022.79|
catalog channel|catalog_pageAAAAAAAABICBAAAA|103048.22|0.00|1192.82|
catalog channel|catalog_pageAAAAAAAABIMAAAAA|0.00|87.44|-262.84|
catalog channel|catalog_pageAAAAAAAABIPAAAAA|0.00|28.04|-170.37|
catalog channel|catalog_pageAAAAAAAABJBBAAAA|0.00|194.04|-155.26|
catalog channel|catalog_pageAAAAAAAABJCBAAAA|11123.10|0.00|-222.67|
catalog channel|catalog_pageAAAAAAAABJMAAAAA|0.00|508.40|-511.16|
catalog channel|catalog_pageAAAAAAAABJPAAAAA|0.00|5588.14|-1680.62|
catalog channel|catalog_pageAAAAAAAABKABAAAA|0.00|451.88|-197.56|
catalog channel|catalog_pageAAAAAAAABKBBAAAA|0.00|2647.40|-2693.56|
catalog channel|catalog_pageAAAAAAAABKPAAAAA|184674.29|5022.36|-11702.31|
catalog channel|catalog_pageAAAAAAAABLPAAAAA|197749.98|0.00|-8896.04|
catalog channel|catalog_pageAAAAAAAABMABAAAA|0.00|192.20|-115.80|
catalog channel|catalog_pageAAAAAAAABMCBAAAA|13832.49|0.00|-10994.47|
catalog channel|catalog_pageAAAAAAAABMPAAAAA|153981.97|79.49|-652.69|
catalog channel|catalog_pageAAAAAAAABNCBAAAA|617.85|0.00|-120.59|
catalog channel|catalog_pageAAAAAAAABNPAAAAA|174166.86|3157.33|-18851.56|
catalog channel|catalog_pageAAAAAAAABOCBAAAA|4800.08|0.00|-244.67|
catalog channel|catalog_pageAAAAAAAABOPAAAAA|130138.56|1700.57|-28949.36|
catalog channel|catalog_pageAAAAAAAABPABAAAA|0.00|840.00|-580.31|
catalog channel|catalog_pageAAAAAAAABPPAAAAA|226764.44|1823.48|20367.34|
catalog channel|catalog_pageAAAAAAAACAABAAAA|154257.53|2655.84|-11249.51|
catalog channel|catalog_pageAAAAAAAACAJAAAAA|0.00|2717.78|-1408.24|
catalog channel|catalog_pageAAAAAAAACBABAAAA|31649.83|0.00|-17515.52|
catalog channel|catalog_pageAAAAAAAACBIAAAAA|0.00|2615.16|-654.69|
catalog channel|catalog_pageAAAAAAAACCABAAAA|80106.49|37.42|-12477.15|
catalog channel|catalog_pageAAAAAAAACCBBAAAA|0.00|3160.50|-422.76|
catalog channel|catalog_pageAAAAAAAACDABAAAA|83895.76|6.96|3764.65|
catalog channel|catalog_pageAAAAAAAACDBBAAAA|0.00|37.92|-538.82|
catalog channel|catalog_pageAAAAAAAACDCBAAAA|72102.76|0.00|-435.48|
catalog channel|catalog_pageAAAAAAAACDPAAAAA|0.00|5264.37|-1681.97|
catalog channel|catalog_pageAAAAAAAACEABAAAA|67967.14|0.00|-12375.12|
catalog channel|catalog_pageAAAAAAAACECBAAAA|64728.33|0.00|-9519.58|
catalog channel|catalog_pageAAAAAAAACEPAAAAA|0.00|2091.83|-746.76|
catalog channel|catalog_pageAAAAAAAACFABAAAA|89087.14|1963.44|-5622.13|
catalog channel|catalog_pageAAAAAAAACFCBAAAA|47459.69|0.00|-2861.17|
catalog channel|catalog_pageAAAAAAAACFMAAAAA|0.00|987.28|-917.22|
catalog channel|catalog_pageAAAAAAAACFPAAAAA|0.00|2606.43|-670.63|
catalog channel|catalog_pageAAAAAAAACGABAAAA|87091.46|0.00|23535.26|
catalog channel|catalog_pageAAAAAAAACGCBAAAA|83760.87|0.00|-7672.13|
catalog channel|catalog_pageAAAAAAAACGPAAAAA|0.00|3773.59|-2627.01|
catalog channel|catalog_pageAAAAAAAACHABAAAA|104743.44|0.00|9498.09|
catalog channel|catalog_pageAAAAAAAACHCBAAAA|98111.66|0.00|-9365.72|