Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13011

HIve 0.14 has introduce transaction feature. but when inserting a row my API stuck at " kill command"

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.14.0
    • None
    • API
    • None

    Description

      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 ??

      Attachments

        Activity

          People

            navis Navis Ryu
            grvtomar Gaurav Tomar
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: