| ==== | |
| ---- QUERY | |
| # A basic spilling query to exercise spill-to-disk end-to-end. | |
| set buffer_pool_limit=90m; | |
| set default_spillable_buffer_size=64k; | |
| select count(*) | |
| from (select distinct o_orderdate, o_custkey, o_comment | |
| from tpch_parquet.orders) v; | |
| ---- RESULTS | |
| 1500000 | |
| ---- TYPES | |
| BIGINT | |
| ---- RUNTIME_PROFILE | |
| # Verify that spilling was activated. | |
| aggregation(SUM, SpilledPartitions)> 0 | |
| ==== |