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)