@cduby In order to use LLAP, you should connect to Hive2 HiveServer2. However, based on the jdbc url, it seems you are connecting to Hive1 HiveServer2. That's probably why you get the error, 'hive.llap.execution.mode variable does not exist'. Hive2 HiveServer2 port is typically 10500. You should figure out the Hive2 HiveServer2 host (whether it is localhost), get the correct jdbc url and connect to Hive2 HiveServer2 with the jdbc url. ... View more

Hi @Parinita Kothari, I tried with hive ver. 1.2.1 and I couldn't reproduce your issue as shown in the below. What version of hive are you using? hive> set hive.support.concurrency=true; hive> set hive.enforce.bucketing=true; hive> set hive.exec.dynamic.partition.mode=nonstrict; hive> set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; hive> set hive.compactor.initiator.on=true; hive> create table test_decimal(i int, time_key DECIMAL(38,2)) clustered by (TIME_KEY) into 16 buckets stored as orc TBLPROPERTIES ('transactional' = 'true'); OK Time taken: 0.557 seconds hive> insert into table test_decimal values(1, 15.56); Query ID = hrt_qa_20160702163059_7e2c279f-158e-4477-9123-357db69075b9 Total jobs = 1 Launching Job 1 out of 1 Status: Running (Executing on YARN cluster with App id application_1467208466253_0268) -------------------------------------------------------------------------------- VERTICES STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED -------------------------------------------------------------------------------- Map 1 .......... SUCCEEDED 1 1 0 0 0 0 Reducer 2 ...... SUCCEEDED 16 16 0 0 0 0 -------------------------------------------------------------------------------- VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 44.74 s -------------------------------------------------------------------------------- Loading data to table default.test_decimal Table default.test_decimal stats: [numFiles=1, numRows=1, totalSize=655, rawDataSize=0] OK Time taken: 49.152 seconds hive> select * from test_decimal; OK 115.56 Time taken: 0.282 seconds, Fetched: 1 row(s) ... View more

@Rich Raposa When you start hive cli, it starts a yarn application, which can be viewed via resource manager UI. When you 'exit', you finish the application. And when you starts hive cli again, it starts another yarn application. But when you do Ctrl+c, that does not finish the application although that application eventually times out. While that previous application still hangs around and when you start CLI again anyway, it try to start a new app, but there is probably not enough capacity because of the previous application. When that previous application eventually times out, a new application start running and that's when you can use Hive CLI again. ... View more

Hi Sankar, Are you using HDP cluster? If so, you can take an advantage of Ranger, which allow you to grant different permission to different users. You can lean more about Ranger via http://hortonworks.com/apache/ranger/ ... View more