You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Gaurav Tomar (JIRA)" <ji...@apache.org> on 2016/02/05 14:03:39 UTC

[jira] [Created] (HIVE-13011) HIve 0.14 has introduce transaction feature. but when inserting a row my API stuck at " kill command"

Gaurav Tomar created HIVE-13011:
-----------------------------------

             Summary: HIve 0.14 has introduce transaction feature. but when inserting a row my API stuck at " kill command"
                 Key: HIVE-13011
                 URL: https://issues.apache.org/jira/browse/HIVE-13011
             Project: Hive
          Issue Type: New Feature
          Components: API
    Affects Versions: 0.14.0
            Reporter: Gaurav Tomar


Hive 0.14 has introduce transactions feature. But we need to configure few things before any transaction e.g

set hive.support.concurrency = true
set hive.enforce.bucketing = true
set hive.exec.dynamic.partition.mode = nonstrict
set hive.txn.manager =org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
set hive.compactor.initiator.on = true
set hive.compactor.worker.threads  = 1


to create a table with this command :

CREATE TABLE college(clg_id int,clg_name string,clg_loc string) clustered by (clg_id) into 5 buckets stored as orc TBLPROPERTIES('transactional'='true');

Now when I am inserting a row into the table using 

INSERT INTO table college values(1,'nec','nlr'),(2,'vit','vlr'),(3,'srm','chen'),(4,'lpu','del'),(5,'stanford','uk'),(6,'JNTUA','atp'),(7,'cambridge','us');


My Hive API stuck at "Kill Command" describe below.

Query ID = training_20160205183232_2bb88ba5-187b-4f9e-b93a-47c91b87c79a
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1424080128507_5229, Tracking URL = http://hydetamaster:8088/proxy/application_1424080128507_5229/
Kill Command = /opt/installation/hadoop/bin/hadoop job  -kill job_1424080128507_5229

Can anybody please help me out with this ??





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)