| ==== |
| ---- QUERY: SORT-STRESS-Q1 |
| # This is designed to spill to disk with the memory limit set in .py file |
| select l_partkey, l_extendedprice |
| from |
| tpch.lineitem |
| order by |
| l_comment, l_partkey, l_extendedprice |
| limit 100 |
| ---- RESULTS |
| 33895,67668.92999999999 |
| 34273,22938.13 |
| 42001,26404 |
| 68136,54102.37 |
| 78755,39876.25 |
| 95606,51251.2 |
| 101311,57741.64 |
| 102914,70925.67 |
| 114872,22642.44 |
| 124402,15690.4 |
| 129198,15953.47 |
| 169278,22903.59 |
| 199345,59217.94 |
| 43166,24401.52 |
| 21377,45442.95 |
| 94032,45145.32 |
| 182434,7582.15 |
| 48664,29027.88 |
| 166004,17120 |
| 106515,24344.16 |
| 66007,47677 |
| 90649,27873.88 |
| 108598,61050.42 |
| 122868,1890.86 |
| 195320,70766 |
| 109526,21497.28 |
| 82945,9639.700000000001 |
| 183444,21384.16 |
| 175662,38228.52 |
| 1142,40682.46 |
| 124580,48137.4 |
| 20061,16678.02 |
| 169435,45132.9 |
| 91002,17874 |
| 151988,57119.44 |
| 101435,24419.31 |
| 39784,67227.42 |
| 181153,6170.75 |
| 12867,16018.74 |
| 85324,23567.76 |
| 115291,5225.16 |
| 82372,47402.95 |
| 41894,82615.05 |
| 114408,8534.4 |
| 113518,62791.91 |
| 82368,62116.56 |
| 53736,25345.95 |
| 75276,26276.67 |
| 151217,24095.99 |
| 106038,27144.78 |
| 168239,30066.29 |
| 79726,66523.08 |
| 104767,72642.16 |
| 20882,16225.92 |
| 137266,41704.32 |
| 30960,41601.12 |
| 149884,79289.08 |
| 140238,51129.2 |
| 40675,79167.83 |
| 123651,33493 |
| 152229,29468.06 |
| 33439,1372.43 |
| 74806,37396.8 |
| 177077,43854.66 |
| 81599,56901.24 |
| 113816,23787.53 |
| 52994,77879.60000000001 |
| 194436,44382.47 |
| 75395,58926.77 |
| 58464,65433.16 |
| 94546,20027.02 |
| 16530,24591.01 |
| 127768,39506.72 |
| 132302,20014.5 |
| 198468,28196.28 |
| 2959,13033.65 |
| 22117,10391.1 |
| 6404,18345.6 |
| 31420,32434.08 |
| 106477,28185.93 |
| 93963,64579.68 |
| 192915,48189.84 |
| 99166,24468.36 |
| 7921,34749.48 |
| 97581,17364.38 |
| 60130,4360.52 |
| 9188,17554.88 |
| 106155,15094.95 |
| 184649,43341 |
| 51729,5042.16 |
| 113777,37606.17 |
| 49193,47971.98 |
| 66026,37696.76 |
| 13985,62666.34 |
| 171620,65973.17999999999 |
| 110692,54486.08 |
| 168967,93654.16 |
| 142138,4720.52 |
| 176024,2200.04 |
| 150703,73655.39999999999 |
| ---- TYPES |
| BIGINT, DOUBLE |
| ==== |