| ==== |
| ---- QUERY |
| # IMPALA-2207: Analytic eval node feeding into build side of nested loop join. |
| set mem_limit=200m; |
| select straight_join * from (values(1 id), (2), (3)) v1, |
| (select *, count(*) over() from tpch.lineitem where l_orderkey < 100000) v2 |
| order by id, l_orderkey, l_partkey, l_suppkey, l_linenumber |
| limit 5 |
| ---- RESULTS |
| 1,1,2132,4633,4,28.00,28955.64,0.09,0.06,'N','O','1996-04-21','1996-03-30','1996-05-16','NONE','AIR','lites. fluffily even de',100382 |
| 1,1,15635,638,6,32.00,49620.16,0.07,0.02,'N','O','1996-01-30','1996-02-07','1996-02-03','DELIVER IN PERSON','MAIL','arefully slyly ex',100382 |
| 1,1,24027,1534,5,24.00,22824.48,0.10,0.04,'N','O','1996-03-30','1996-03-14','1996-04-01','NONE','FOB',' pending foxes. slyly re',100382 |
| 1,1,63700,3701,3,8.00,13309.60,0.10,0.02,'N','O','1996-01-29','1996-03-05','1996-01-31','TAKE BACK RETURN','REG AIR','riously. regular, express dep',100382 |
| 1,1,67310,7311,2,36.00,45983.16,0.09,0.06,'N','O','1996-04-12','1996-02-28','1996-04-20','TAKE BACK RETURN','MAIL','ly final dependencies: slyly bold ',100382 |
| ---- TYPES |
| tinyint,bigint,bigint,bigint,int,decimal,decimal,decimal,decimal,string,string,string,string,string,string,string,string,bigint |
| ==== |
| ---- QUERY |
| # IMPALA-6595: same query as above, but tuned to trigger a different bug where we hit |
| # "Memory Limit Exceeded" when adding a batch to NljBuilder. |
| set buffer_pool_limit=20m; |
| set mem_limit=30m; |
| select straight_join * from (values(1 id), (2), (3)) v1, |
| (select *, count(*) over() from tpch.lineitem where l_orderkey < 100000) v2 |
| order by id, l_orderkey, l_partkey, l_suppkey, l_linenumber |
| limit 5 |
| ---- CATCH |
| Memory limit exceeded |
| ==== |
