sql-tests.testcases.tpcds.q35.result Maven / Gradle / Ivy

Go to download
-- delimiter: |; types: CHAR|CHAR|CHAR|INTEGER|BIGINT|INTEGER|INTEGER|DOUBLE|INTEGER|BIGINT|INTEGER|INTEGER|DOUBLE|INTEGER|BIGINT|INTEGER|INTEGER|DOUBLE
AK|F|D|1|1|1|1|1.00000000000|2|1|2|2|2.00000000000|2|1|2|2|2.00000000000|
AK|F|D|5|1|5|5|5.00000000000|3|1|3|3|3.00000000000|3|1|3|3|3.00000000000|
AK|F|M|0|1|0|0|0.00000000000|6|1|6|6|6.00000000000|0|1|0|0|0.00000000000|
AK|F|M|4|1|4|4|4.00000000000|2|1|2|2|2.00000000000|0|1|0|0|0.00000000000|
AK|F|M|5|1|5|5|5.00000000000|2|1|2|2|2.00000000000|2|1|2|2|2.00000000000|
AK|F|S|2|1|2|2|2.00000000000|3|1|3|3|3.00000000000|0|1|0|0|0.00000000000|
AK|F|S|2|1|2|2|2.00000000000|3|1|3|3|3.00000000000|3|1|3|3|3.00000000000|
AK|F|S|2|1|2|2|2.00000000000|5|1|5|5|5.00000000000|2|1|2|2|2.00000000000|
AK|F|S|3|1|3|3|3.00000000000|0|1|0|0|0.00000000000|2|1|2|2|2.00000000000|
AK|F|S|4|1|4|4|4.00000000000|1|1|1|1|1.00000000000|6|1|6|6|6.00000000000|
AK|F|S|5|1|5|5|5.00000000000|6|1|6|6|6.00000000000|4|1|4|4|4.00000000000|
AK|F|S|6|1|6|6|6.00000000000|2|1|2|2|2.00000000000|4|1|4|4|4.00000000000|
AK|F|S|6|1|6|6|6.00000000000|6|1|6|6|6.00000000000|3|1|3|3|3.00000000000|
AK|F|U|1|1|1|1|1.00000000000|5|1|5|5|5.00000000000|1|1|1|1|1.00000000000|
AK|F|U|4|1|4|4|4.00000000000|0|1|0|0|0.00000000000|4|1|4|4|4.00000000000|
AK|F|U|5|1|5|5|5.00000000000|2|1|2|2|2.00000000000|5|1|5|5|5.00000000000|
AK|F|W|0|1|0|0|0.00000000000|4|1|4|4|4.00000000000|0|1|0|0|0.00000000000|
AK|F|W|1|1|1|1|1.00000000000|1|1|1|1|1.00000000000|4|1|4|4|4.00000000000|
AK|F|W|2|1|2|2|2.00000000000|2|1|2|2|2.00000000000|5|1|5|5|5.00000000000|
AK|F|W|4|1|4|4|4.00000000000|2|1|2|2|2.00000000000|2|1|2|2|2.00000000000|
AK|M|D|0|1|0|0|0.00000000000|0|1|0|0|0.00000000000|2|1|2|2|2.00000000000|
AK|M|D|0|1|0|0|0.00000000000|5|1|5|5|5.00000000000|4|1|4|4|4.00000000000|
AK|M|D|5|1|5|5|5.00000000000|2|1|2|2|2.00000000000|4|1|4|4|4.00000000000|
AK|M|D|6|1|6|6|6.00000000000|3|1|3|3|3.00000000000|6|1|6|6|6.00000000000|
AK|M|M|0|1|0|0|0.00000000000|6|1|6|6|6.00000000000|5|1|5|5|5.00000000000|
AK|M|M|3|1|3|3|3.00000000000|3|1|3|3|3.00000000000|1|1|1|1|1.00000000000|
AK|M|M|5|1|5|5|5.00000000000|3|1|3|3|3.00000000000|0|1|0|0|0.00000000000|
AK|M|S|0|1|0|0|0.00000000000|2|1|2|2|2.00000000000|4|1|4|4|4.00000000000|
AK|M|S|4|1|4|4|4.00000000000|0|1|0|0|0.00000000000|1|1|1|1|1.00000000000|
AK|M|S|4|1|4|4|4.00000000000|0|1|0|0|0.00000000000|4|1|4|4|4.00000000000|
AK|M|S|5|1|5|5|5.00000000000|5|1|5|5|5.00000000000|2|1|2|2|2.00000000000|
AK|M|U|0|1|0|0|0.00000000000|3|1|3|3|3.00000000000|5|1|5|5|5.00000000000|
AK|M|U|4|1|4|4|4.00000000000|6|1|6|6|6.00000000000|1|1|1|1|1.00000000000|
AK|M|W|0|1|0|0|0.00000000000|6|1|6|6|6.00000000000|2|1|2|2|2.00000000000|
AK|M|W|2|1|2|2|2.00000000000|2|1|2|2|2.00000000000|5|1|5|5|5.00000000000|
AK|M|W|2|1|2|2|2.00000000000|4|1|4|4|4.00000000000|6|1|6|6|6.00000000000|
AK|M|W|3|1|3|3|3.00000000000|5|1|5|5|5.00000000000|4|1|4|4|4.00000000000|
AK|M|W|4|1|4|4|4.00000000000|6|1|6|6|6.00000000000|3|1|3|3|3.00000000000|
AL|F|D|0|1|0|0|0.00000000000|6|1|6|6|6.00000000000|3|1|3|3|3.00000000000|
AL|F|D|2|1|2|2|2.00000000000|0|1|0|0|0.00000000000|6|1|6|6|6.00000000000|
AL|F|D|2|1|2|2|2.00000000000|4|1|4|4|4.00000000000|5|1|5|5|5.00000000000|
AL|F|D|2|1|2|2|2.00000000000|6|1|6|6|6.00000000000|3|1|3|3|3.00000000000|
AL|F|D|3|1|3|3|3.00000000000|2|1|2|2|2.00000000000|0|1|0|0|0.00000000000|
AL|F|D|4|1|4|4|4.00000000000|6|1|6|6|6.00000000000|6|1|6|6|6.00000000000|
AL|F|D|5|1|5|5|5.00000000000|0|1|0|0|0.00000000000|6|1|6|6|6.00000000000|
AL|F|D|5|1|5|5|5.00000000000|2|1|2|2|2.00000000000|5|1|5|5|5.00000000000|
AL|F|D|5|1|5|5|5.00000000000|3|1|3|3|3.00000000000|3|1|3|3|3.00000000000|
AL|F|D|5|1|5|5|5.00000000000|4|1|4|4|4.00000000000|1|1|1|1|1.00000000000|
AL|F|D|5|1|5|5|5.00000000000|4|1|4|4|4.00000000000|2|1|2|2|2.00000000000|
AL|F|M|0|1|0|0|0.00000000000|3|1|3|3|3.00000000000|3|1|3|3|3.00000000000|
AL|F|M|1|1|1|1|1.00000000000|3|1|3|3|3.00000000000|1|1|1|1|1.00000000000|
AL|F|M|1|1|1|1|1.00000000000|3|1|3|3|3.00000000000|3|1|3|3|3.00000000000|
AL|F|M|1|1|1|1|1.00000000000|4|1|4|4|4.00000000000|4|1|4|4|4.00000000000|
AL|F|M|1|1|1|1|1.00000000000|6|1|6|6|6.00000000000|1|1|1|1|1.00000000000|
AL|F|M|1|2|1|1|1.00000000000|6|2|6|6|6.00000000000|5|2|5|5|5.00000000000|
AL|F|M|2|1|2|2|2.00000000000|0|1|0|0|0.00000000000|1|1|1|1|1.00000000000|
AL|F|M|2|1|2|2|2.00000000000|5|1|5|5|5.00000000000|3|1|3|3|3.00000000000|
AL|F|M|3|1|3|3|3.00000000000|3|1|3|3|3.00000000000|0|1|0|0|0.00000000000|
AL|F|M|4|1|4|4|4.00000000000|3|1|3|3|3.00000000000|2|1|2|2|2.00000000000|
AL|F|M|4|1|4|4|4.00000000000|6|1|6|6|6.00000000000|3|1|3|3|3.00000000000|
AL|F|M|5|1|5|5|5.00000000000|3|1|3|3|3.00000000000|1|1|1|1|1.00000000000|
AL|F|M|5|1|5|5|5.00000000000|5|1|5|5|5.00000000000|6|1|6|6|6.00000000000|
AL|F|M|6|1|6|6|6.00000000000|1|1|1|1|1.00000000000|6|1|6|6|6.00000000000|
AL|F|M|6|1|6|6|6.00000000000|3|1|3|3|3.00000000000|4|1|4|4|4.00000000000|
AL|F|S|1|1|1|1|1.00000000000|0|1|0|0|0.00000000000|4|1|4|4|4.00000000000|
AL|F|S|2|1|2|2|2.00000000000|1|1|1|1|1.00000000000|3|1|3|3|3.00000000000|
AL|F|S|2|1|2|2|2.00000000000|5|1|5|5|5.00000000000|4|1|4|4|4.00000000000|
AL|F|S|2|1|2|2|2.00000000000|5|1|5|5|5.00000000000|5|1|5|5|5.00000000000|
AL|F|S|3|1|3|3|3.00000000000|0|1|0|0|0.00000000000|3|1|3|3|3.00000000000|
AL|F|S|3|1|3|3|3.00000000000|2|1|2|2|2.00000000000|3|1|3|3|3.00000000000|
AL|F|S|3|1|3|3|3.00000000000|4|1|4|4|4.00000000000|3|1|3|3|3.00000000000|
AL|F|S|3|1|3|3|3.00000000000|4|1|4|4|4.00000000000|4|1|4|4|4.00000000000|
AL|F|S|5|1|5|5|5.00000000000|1|1|1|1|1.00000000000|6|1|6|6|6.00000000000|
AL|F|U|0|2|0|0|0.00000000000|1|2|1|1|1.00000000000|1|2|1|1|1.00000000000|
AL|F|U|0|1|0|0|0.00000000000|6|1|6|6|6.00000000000|5|1|5|5|5.00000000000|
AL|F|U|1|1|1|1|1.00000000000|1|1|1|1|1.00000000000|1|1|1|1|1.00000000000|
AL|F|U|1|1|1|1|1.00000000000|2|1|2|2|2.00000000000|5|1|5|5|5.00000000000|
AL|F|U|1|1|1|1|1.00000000000|3|1|3|3|3.00000000000|2|1|2|2|2.00000000000|
AL|F|U|2|1|2|2|2.00000000000|2|1|2|2|2.00000000000|0|1|0|0|0.00000000000|
AL|F|U|5|1|5|5|5.00000000000|6|1|6|6|6.00000000000|1|1|1|1|1.00000000000|
AL|F|U|6|1|6|6|6.00000000000|5|1|5|5|5.00000000000|2|1|2|2|2.00000000000|
AL|F|W|1|1|1|1|1.00000000000|1|1|1|1|1.00000000000|1|1|1|1|1.00000000000|
AL|F|W|1|1|1|1|1.00000000000|3|1|3|3|3.00000000000|2|1|2|2|2.00000000000|
AL|F|W|1|1|1|1|1.00000000000|4|1|4|4|4.00000000000|3|1|3|3|3.00000000000|
AL|F|W|2|1|2|2|2.00000000000|2|1|2|2|2.00000000000|5|1|5|5|5.00000000000|
AL|F|W|3|1|3|3|3.00000000000|1|1|1|1|1.00000000000|5|1|5|5|5.00000000000|
AL|F|W|3|1|3|3|3.00000000000|2|1|2|2|2.00000000000|3|1|3|3|3.00000000000|
AL|F|W|4|1|4|4|4.00000000000|3|1|3|3|3.00000000000|4|1|4|4|4.00000000000|
AL|F|W|5|1|5|5|5.00000000000|1|1|1|1|1.00000000000|3|1|3|3|3.00000000000|
AL|F|W|5|1|5|5|5.00000000000|1|1|1|1|1.00000000000|6|1|6|6|6.00000000000|
AL|F|W|5|1|5|5|5.00000000000|5|1|5|5|5.00000000000|4|1|4|4|4.00000000000|
AL|F|W|5|1|5|5|5.00000000000|6|1|6|6|6.00000000000|0|1|0|0|0.00000000000|
AL|M|D|1|1|1|1|1.00000000000|1|1|1|1|1.00000000000|2|1|2|2|2.00000000000|
AL|M|D|3|1|3|3|3.00000000000|3|1|3|3|3.00000000000|3|1|3|3|3.00000000000|
AL|M|D|4|1|4|4|4.00000000000|3|1|3|3|3.00000000000|6|1|6|6|6.00000000000|
AL|M|D|5|1|5|5|5.00000000000|0|1|0|0|0.00000000000|2|1|2|2|2.00000000000|
AL|M|M|2|1|2|2|2.00000000000|2|1|2|2|2.00000000000|1|1|1|1|1.00000000000|
AL|M|M|2|1|2|2|2.00000000000|2|1|2|2|2.00000000000|2|1|2|2|2.00000000000|
AL|M|M|2|1|2|2|2.00000000000|4|1|4|4|4.00000000000|5|1|5|5|5.00000000000|
AL|M|M|2|1|2|2|2.00000000000|6|1|6|6|6.00000000000|0|1|0|0|0.00000000000|