[tarmstrong-box2.ca.cloudera.com:21000] > use tpch_60_parquet;
[tarmstrong-box2.ca.cloudera.com:21000] > set mem_limit=10gb; SELECT *
FROM   (SELECT *, Rank()
                 OVER(
                   ORDER BY  l_orderkey) AS rank
        FROM   lineitem) a
WHERE  rank < 10;


    Query Timeline: 36m41s
       - Query submitted: 24.464us (24.464us)
       - Planning finished: 29.395ms (29.370ms)
       - Submit for admission: 29.610ms (215.551us)
       - Completed admission: 29.660ms (49.855us)
       - Ready to start on 1 backends: 29.804ms (143.744us)
       - All 1 execution backends (2 fragment instances) started: 30.798ms (993.647us)
       - Rows available: 12m46s (12m46s)
       - First row fetched: 12m47s (574.121ms)
       - Unregister query: 36m41s (23m54s)
...
        SORT_NODE (id=1):(Total: 27m8s, non-child: 22m31s, % non-child: 83.02%)
          ExecOption: Codegen Enabled
           - NumRowsPerRun: (Avg: 30.00M (30000966) ; Min: 8.75M (8751454) ; Max: 31.93M (31932740) ; Number of samples: 12)
           - InMemorySortTime: 2m14s
           - InitialRunsCreated: 12 (12)
           - MergeGetNext: 14m23s
           - MergeGetNextBatch: 12m46s
           - PeakMemoryUsage: 8.00 GB (8588991755)
           - RowsReturned: 360.01M (360011594)
           - RowsReturnedRate: 221.11 K/sec
           - SortDataSize: 90.12 GB (96765718386)
           - SpilledRuns: 13 (13)
           - TotalMergesPerformed: 1 (1)
          Buffer pool:
             - AllocTime: 5s277ms
             - CumulativeAllocationBytes: 203.34 GB (218336591872)
             - CumulativeAllocations: 104.11K (104111)
             - PeakReservation: 8.00 GB (8585740288)
             - PeakUnpinnedBytes: 90.13 GB (96775176192)
             - PeakUsedReservation: 8.00 GB (8585740288)
             - ReadIoBytes: 88.13 GB (94625595392)
             - ReadIoOps: 45.12K (45121)
             - ReadIoWaitTime: 12m36s
             - WriteIoBytes: 90.13 GB (96775176192)
             - WriteIoOps: 46.15K (46146)
             - WriteIoWaitTime: 3m6s


    Query Timeline: 31m29s
       - Query submitted: 67.024us (67.024us)
       - Planning finished: 4s177ms (4s177ms)
       - Submit for admission: 4s177ms (110.818us)
       - Completed admission: 4s177ms (58.137us)
       - Ready to start on 1 backends: 4s178ms (73.969us)
       - All 1 execution backends (2 fragment instances) started: 4s178ms (792.772us)
       - Rows available: 9m (8m55s)
       - First row fetched: 9m4s (4s787ms)
       - Unregister query: 31m29s (22m24s)
     - ComputeScanRangeAssignmentTimer: 36.459us

        SORT_NODE (id=1):(Total: 22m1s, non-child: 21m38s, % non-child: 98.27%)
          ExecOption: Codegen Enabled
           - NumRowsPerRun: (Avg: 30.00M (30000966) ; Min: 8.75M (8751454) ; Max: 31.93M (31932740) ; Number of samples: 12)
           - InMemorySortTime: 2m10s
           - InitialRunsCreated: 12 (12)
           - MergeGetNext: 13m10s
           - MergeGetNextBatch: 11m35s
           - PeakMemoryUsage: 8.00 GB (8588991755)
           - RowsReturned: 360.01M (360011594)
           - RowsReturnedRate: 272.42 K/sec
           - SortDataSize: 90.12 GB (96765718386)
           - SpilledRuns: 13 (13)
           - TotalMergesPerformed: 1 (1)
          Buffer pool:
             - AllocTime: 2s004ms
             - CumulativeAllocationBytes: 203.34 GB (218332397568)
             - CumulativeAllocations: 104.11K (104109)
             - PeakReservation: 8.00 GB (8585740288)
             - PeakUnpinnedBytes: 90.13 GB (96775176192)
             - PeakUsedReservation: 8.00 GB (8585740288)
             - ReadIoBytes: 88.12 GB (94621401088)
             - ReadIoOps: 45.12K (45119)
             - ReadIoWaitTime: 11m22s
             - WriteIoBytes: 90.12 GB (96770981888)
             - WriteIoOps: 46.14K (46144) 
             - WriteIoWaitTime: 3m18s