| ==== |
| ---- QUERY |
| # IMPALA-5485: exchange nodes can hit out-of-memory. This query was tuned so that |
| # it hits the memory limit in the exchange node when allocating receiver-side |
| # buffers. It's also possible but less likely that this will hit a memory limit |
| # in the scan nodes. |
| set mem_limit=170m; |
| set num_scanner_threads=1; |
| select * |
| from tpch_parquet.lineitem l1 |
| join tpch_parquet.lineitem l2 on l1.l_orderkey = l2.l_orderkey and |
| l1.l_partkey = l2.l_partkey and l1.l_suppkey = l2.l_suppkey |
| and l1.l_linenumber = l2.l_linenumber |
| order by l1.l_orderkey desc, l1.l_partkey, l1.l_suppkey, l1.l_linenumber |
| limit 5 |
| ---- CATCH |
| Memory limit exceeded |
| ==== |
| ---- QUERY |
| # Run the above query with a high enough memory limit to succeed on the 3 node |
| # minicluster. |
| set mem_limit=500m; |
| set num_scanner_threads=1; |
| select * |
| from tpch_parquet.lineitem l1 |
| join tpch_parquet.lineitem l2 on l1.l_orderkey = l2.l_orderkey and |
| l1.l_partkey = l2.l_partkey and l1.l_suppkey = l2.l_suppkey |
| and l1.l_linenumber = l2.l_linenumber |
| order by l1.l_orderkey desc, l1.l_partkey, l1.l_suppkey, l1.l_linenumber |
| limit 5 |
| ---- RESULTS |
| 6000000,32255,2256,1,5.00,5936.25,0.04,0.03,'N','O','1996-11-02','1996-11-19','1996-12-01','TAKE BACK RETURN','MAIL','carefully ',6000000,32255,2256,1,5.00,5936.25,0.04,0.03,'N','O','1996-11-02','1996-11-19','1996-12-01','TAKE BACK RETURN','MAIL','carefully ' |
| 6000000,96127,6128,2,28.00,31447.36,0.01,0.02,'N','O','1996-09-22','1996-10-01','1996-10-21','NONE','AIR','ooze furiously about the pe',6000000,96127,6128,2,28.00,31447.36,0.01,0.02,'N','O','1996-09-22','1996-10-01','1996-10-21','NONE','AIR','ooze furiously about the pe' |
| 5999975,6452,1453,2,7.00,9509.15,0.04,0.00,'A','F','1993-11-02','1993-09-23','1993-11-19','DELIVER IN PERSON','SHIP','lar pinto beans aft',5999975,6452,1453,2,7.00,9509.15,0.04,0.00,'A','F','1993-11-02','1993-09-23','1993-11-19','DELIVER IN PERSON','SHIP','lar pinto beans aft' |
| 5999975,7272,2273,1,32.00,37736.64,0.07,0.01,'R','F','1993-10-07','1993-09-30','1993-10-21','COLLECT COD','REG AIR','tructions. excu',5999975,7272,2273,1,32.00,37736.64,0.07,0.01,'R','F','1993-10-07','1993-09-30','1993-10-21','COLLECT COD','REG AIR','tructions. excu' |
| 5999975,37131,2138,3,18.00,19226.34,0.04,0.01,'A','F','1993-11-17','1993-08-28','1993-12-08','DELIVER IN PERSON','FOB',', quick deposits. ironic, unusual deposi',5999975,37131,2138,3,18.00,19226.34,0.04,0.01,'A','F','1993-11-17','1993-08-28','1993-12-08','DELIVER IN PERSON','FOB',', quick deposits. ironic, unusual deposi' |
| ---- TYPES |
| BIGINT, BIGINT, BIGINT, INT, DECIMAL, DECIMAL, DECIMAL, DECIMAL, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING, BIGINT, BIGINT, BIGINT, INT, DECIMAL, DECIMAL, DECIMAL, DECIMAL, STRING, STRING, STRING, STRING, STRING, STRING, STRING, STRING |
| ==== |