06-14-2017 04:05 PM
I'm using set request_pool= to run an impala query with specific resource pool, but with no success.
When i connect to impala-shell and run set request_pool=xxx, I get REQUEST_POOL set to xxx, after running my query i see it still running under the default pool.
How i can also pass this if i want to run the impala-shell with variables like impala-shell -i xxxx -q yyyy., Can i add to this commnad the set request_pool.
Thanks in advance
06-15-2017 01:32 PM
06-15-2017 01:59 PM
06-15-2017 02:08 PM
06-15-2017 02:26 PM
06-15-2017 03:03 PM - edited 06-15-2017 03:06 PM
Seems also this option is not working at all:
impala-shell -i xxxx -q request_pool=new_pool; select...
tried to run
impala-shell -i xxxx -q request_pool=new_pool;mpala-shell -i xxxx -q select ...
impala-shell -i xxxx -q "request_pool=new_pool" " select ..."
impala-shell -i xxxx -q "request_pool=new_pool"; -q " select ..."
06-15-2017 03:22 PM
My bad: forgot that -q is used for a single query use.
I solved the issue by putting the 2 select statement at file and used the -f option.
Still investigate the issue of the pool.