Tutorial using Hive CLI, enforce queues for TEZ


kinit PRINCIPAL -kt /etc/security/keytabs/PRINCIPAL.keytab
hive --hiveconf hive.execution.engine=mr
SET hive.execution.engine=tez;
SET tez.queue.name=QUEUE_NAME;
use MON_SCHEMA;
select count(*) from TABLE where id =1;

By starting Hive CLI with mr, it open the terminal quickly than default, this is because it will not request for AM resource.

PS : Hive CLI is not recommended and must be deprecated in your production environment, check here for more info