Query never sent to server if it contains set statements

[lucastheisen]

I have a query that is failing due to memory kill of the form:

select
  *
from my_schema.my_table
where
  date >= '2024-03-12T00:00:00Z'
  date < '2024-03-19T00:00:00Z'
order by date asc;

However, when i try to increase memory:

SET mapreduce.map.memory.mb=5120;
SET mapreduce.reduce.memory.mb=5120;
SET mapreduce.map.java.opts=-Xmx4608m;
SET mapreduce.reduce.java.opts=-Xmx4608m;
select
  *
from my_schema.my_table
where
  date >= '2024-03-12T00:00:00Z'
  date < '2024-03-19T00:00:00Z'
order by date asc;

The client simply exits with EOF being the error. Running the same query on ambari works.

[beltran]

What is the output of the first query? When you say the output of the second one is EOF you mean the client crashes and EOF gets printed (just those three chars) and the client exists? What do you get when you run the query in beeline?

[lucastheisen]

@beltran ,

What is the output of the first query? When you say the output of the second one is EOF you mean the client crashes and EOF gets printed (just those three chars) and the client exists?

Correct. The client exits and the error message EOF is printed (because i let the error object bubble out to my cli).

What do you get when you run the query in beeline?

Not sure... I've never used beeline. But also, i had to refactor my query to make better use of partition pruning and smaller extract sizes to move forward so increasing memory is no longer a blocker for me. You can close this issue if you want, but still would be good to know if using SET statements is not-supported by this driver, or if maybe i was doing it wrong (the later is not at all unlikely).

[beltran]

They are supported, see this test. But I don't know why it wasn't working for you.