MEM_LIMIT in impala shell command

[#1]

I have some impala queries in a file and I want each time I am running the queries to set the mem_limit = 3gb but in the command not in the file inside

impala-shell -f /path/ (and add here the mem_limit)

Is this possible?

[#2 · Accepted solution]

Hi @drgenious , 

I believe this is possible by providing impala-shell with the following parameter:

impala-shell -f /path/ --query_option='mem_limit=3gb'

Let me know if that works.

Regards,

Alex