sql-tests.testcases.tpcds.q86.result Maven / Gradle / Ivy
-- delimiter: |; types: DECIMAL|CHAR|CHAR|INTEGER|BIGINT
325552630.64|null|null|2|1|
33602545.41|Shoes |null|1|1|
33399717.80|Music |null|1|2|
33061835.62|Women |null|1|3|
32942681.04|Books |null|1|4|
32233369.67|Men |null|1|5|
32135907.22|Electronics |null|1|6|
32027085.12|Jewelry |null|1|7|
31908139.65|Sports |null|1|8|
31877378.15|Children |null|1|9|
31428816.29|Home |null|1|10|
935154.67|null|null|1|11|
2981755.34|Books |history |0|1|
2533681.90|Books |romance |0|2|
2513406.90|Books |computers |0|3|
2359621.74|Books |fiction |0|4|
2220829.36|Books |home repair |0|5|
2132619.93|Books |reference |0|6|
2023862.05|Books |travel |0|7|
1938302.12|Books |parenting |0|8|
1916049.65|Books |science |0|9|
1904474.64|Books |business |0|10|
1903280.30|Books |sports |0|11|
1819360.79|Books |self-help |0|12|
1817324.19|Books |mystery |0|13|
1698653.10|Books |entertainments |0|14|
1641874.01|Books |cooking |0|15|
1453516.79|Books |arts |0|16|
84068.23|Books |null|0|17|
8603692.12|Children |infants |0|1|
7982811.62|Children |toddlers |0|2|
7716135.48|Children |school-uniforms |0|3|
7529560.01|Children |newborn |0|4|
45178.92|Children |null|0|5|
2625503.90|Electronics |dvd/vcr players |0|1|
2351244.66|Electronics |televisions |0|2|
2283231.32|Electronics |memory |0|3|
2262599.89|Electronics |stereo |0|4|
2257811.83|Electronics |karoke |0|5|
2235218.27|Electronics |monitors |0|6|
2228844.29|Electronics |scanners |0|7|
1948029.88|Electronics |wireless |0|8|
1894729.95|Electronics |disk drives |0|9|
1838653.07|Electronics |automotive |0|10|
1793728.96|Electronics |portable |0|11|
1768939.49|Electronics |cameras |0|12|
1733994.95|Electronics |musical |0|13|
1730490.24|Electronics |personal |0|14|
1670511.23|Electronics |camcorders |0|15|
1512375.29|Electronics |audio |0|16|
2408305.34|Home |paint |0|1|
2349779.93|Home |curtains/drapes |0|2|
2306676.63|Home |bedding |0|3|
2284168.74|Home |flatware |0|4|
2269734.86|Home |glassware |0|5|
2112112.73|Home |lighting |0|6|
2085612.39|Home |bathroom |0|7|
1924834.23|Home |mattresses |0|8|
1868688.89|Home |tables |0|9|
1820604.22|Home |furniture |0|10|
1816997.04|Home |decor |0|11|
1805905.27|Home |kids |0|12|
1788142.30|Home |blinds/shades |0|13|
1570699.11|Home |accent |0|14|
1503088.13|Home |rugs |0|15|
1457642.85|Home |wallpaper |0|16|
55823.63|Home |null|0|17|
2754963.88|Jewelry |jewelry boxes |0|1|
2346470.04|Jewelry |pendants |0|2|
2308524.13|Jewelry |rings |0|3|
2216602.19|Jewelry |custom |0|4|
2141484.71|Jewelry |gold |0|5|
2105589.88|Jewelry |estate |0|6|
2105536.74|Jewelry |womens watch |0|7|
2057556.93|Jewelry |mens watch |0|8|
1964085.08|Jewelry |costume |0|9|
1838748.38|Jewelry |birdal |0|10|
1820456.21|Jewelry |earings |0|11|
1811297.48|Jewelry |loose stones |0|12|
1738088.37|Jewelry |diamonds |0|13|
1636759.38|Jewelry |semi-precious |0|14|
1625306.26|Jewelry |bracelets |0|15|
1457032.40|Jewelry |consignment |0|16|
98583.06|Jewelry |null|0|17|
8968117.21|Men |shirts |0|1|
8079270.31|Men |sports-apparel |0|2|
7734264.66|Men |accessories |0|3|
7451717.49|Men |pants |0|4|
9196797.97|Music |classical |0|1|
8755969.85|Music |pop |0|2|
8444376.89|Music |country |0|3|
6891047.77|Music |rock |0|4|
111525.32|Music |null|0|5|
8938639.40|Shoes |mens |0|1|
8290473.41|Shoes |kids |0|2|
8241359.70|Shoes |womens |0|3|
8132072.90|Shoes |athletic |0|4|
2530419.12|Sports |golf |0|1|
2513869.92|Sports |athletic shoes |0|2|
2340416.63|Sports |outdoor |0|3|