question Re: MEM_LIMIT in impala shell command in Support Questions

MEM_LIMIT in impala shell command

drgenious — Thu, 17 Jun 2021 14:34:43 GMT

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?

Re: MEM_LIMIT in impala shell command

aakulov — Thu, 17 Jun 2021 20:35:25 GMT

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