Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

millan123
Contributor

Data extract using hive in Qliksense(how to set queue priority)?

Hi All,

Please help me with how to set the queue priority to hive in qliksense, we are using hive to extract data into qliksense and all queries are running in default queue.

We want to set the priority to high so that our queries will execute faster than default.

Thanks in advance

Clark

2 Replies
MVP
MVP

Re: Data extract using hive in Qliksense(how to set queue priority)?

You should be able to set which queue to execute in by sending a "set" statement in the Hive query before you do a "select". That way you execute in a high priority queue of your choice:

SQL

  set hive.server2.tez.default.queues=user1,user2,user3;


SQL

  select * from ......;

It might of course be another configuration parameter other than "hive.server2.tez.default.queues" that needs to be set since there are several that can be used depending on the Hive version and underlying execution engine.



millan123
Contributor

Re: Data extract using hive in Qliksense(how to set queue priority)?

Thank you so much Petter

Based upon your input we used another configuration parameter and It is working for us.

Once again thank you for your help.

Thanks,

Clark