Tuesday, 25 November 2014

[SOLVED] FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations in hive-0.14.0


CRUD operations are supported in Hive from 0.14 onwards.
See Wiki 

Hive supports data warehouse software facility,which facilitates querying and managing large datasets residing in distributed storage. In data warehouse there are situation where we need to update, delete etc transactions.In hive later versions UPDATE was not supported,but there were workarounds to do update a transaction

1. Update Statement In Hive For Small Tables
2. Update Statement In Hive For Large Tables using INSERT


Lets see how to do INSERT,UPDATE,DELETE in newer version of hive. 

Create a table "test"
CREATE EXTERNAL TABLE 
    test (EmployeeID Int,FirstName String,Designation  
        String,Salary Int,Department String) 
    ROW FORMAT DELIMITED FIELDS TERMINATED BY  "," 
    LOCATION '/user/hdfs/Hive';
We will try to update the salary of employee id 19 from 45,000 to 50,000.
 hive> UPDATE test 
           SET salary = 50000 
           WHERE employeeid = 19;

 FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction m anager that does not support these operations.

While applying above query it shows a semantic Exception.In order to allow update and delete we need to add additional settings in hive-site.xml and create table with ACID output format support.

To achieve the same follow below steps:

1. New Configuration Parameters for Transactions
 hive.support.concurrency – true
 hive.enforce.bucketing – true
 hive.exec.dynamic.partition.mode – nonstrict
 hive.txn.manager –org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
 hive.compactor.initiator.on – true
 hive.compactor.worker.threads – 1
You can set these configuration in hive-site.xml (after setting restart Hive ) for ever or via terminal.
Dont Forget to restart Hive once the above settings are applied, else you will get the same error again.
2. Below query creates HiveTest table with ACID support
(To do Update,delete or Insert we need to create a table that support ACID properties)
 create table HiveTest 
   (EmployeeID Int,FirstName String,Designation String,
     Salary Int,Department String) 
   clustered by (department) into 3 buckets 
   stored as orc TBLPROPERTIES ('transactional'='true') ;
3. Load data into HiveTest from a staging table,which contains the original data.
 from stagingtbl 
   insert into table HiveTest 
   select employeeid,firstname,designation,salary,department;

4. UPDATE,DELETE and INSERT operations


1.UPDATE
 update HiveTest 
    set salary = 50000 
    where employeeid = 19; 

SYNOPSIS

  1. The referenced column must be a column of the table being updated.
  2. The value assigned must be an expression that Hive supports in the select clause.  Thus arithmetic operators, UDFs, casts, literals, etc. are supported.  Subqueries are not supported.
  3. Only rows that match the WHERE clause will be updated.
  4. Partitioning columns cannot be updated.
  5. Bucketing columns cannot be updated.
  6. In Hive 0.14, upon successful completion of this operation the changes will be auto-committed.


2. INSERT
 insert into table HiveTest 
     values(21,'Hive','Hive',0,'B');

SYNOPSIS

  1. Each row listed in the VALUES clause is inserted into table tablename.
  2. Values must be provided for every column in the table.  The standard SQL syntax that allows the user to insert values into only some columns is not yet supported.  To mimic the standard SQL, nulls can be provided for columns the user does not wish to assign a value to.
  3. Dynamic partitioning is supported in the same way as for INSERT...SELECT.
  4. If the table being inserted into supports ACID and a transaction manager that supports ACID is in use, this operation will be auto-committed upon successful completion.



3. DELETE
 delete from HiveTest
     where employeeid=19;

SYNOPSIS
  1. Only rows that match the WHERE clause will be deleted.
  2. In Hive 0.14, upon successful completion of this operation the changes will be auto-committed.

79 comments:

  1. Hi, i am using hive 0.14 and followed steps all as mentioned above and i have set new configuration parameters as you said. But still i am getting same error

    SemanticException [Error 10294]: Attempt to do update or delete using transaction m anager that does not support these operations.

    Please advice

    ReplyDelete
    Replies
    1. Can you show the configurations you set?And where did you set the parameters?

      Delete
    2. Hi, I am getting the same error. i have set the parameters in hive shell,itself

      Delete
    3. Hi,

      Can you please post what steps you followed?

      Delete
    4. Hi Sameekshya,

      You need set those new properties in Hive-Site.xml and restart the Hive server and create tables, check update,insert and delete

      Delete

  2. hive.support.concurrency
    true

    Whether Hive supports concurrency control or not.
    A ZooKeeper instance must be up and running when using zookeeper Hive lock manager



    hive.enforce.bucketing
    true
    Whether bucketing is enforced. If true, while inserting into the table, bucketing is enforced.


    hive.exec.dynamic.partition.mode
    nonstrict

    In strict mode, the user must specify at least one static partition
    in case the user accidentally overwrites all partitions.
    In nonstrict mode all partitions are allowed to be dynamic.



    hive.txn.manager
    org.apache.hadoop.hive.ql.lockmgr.DbTxnManager

    Set to org.apache.hadoop.hive.ql.lockmgr.DbTxnManager as part of turning on Hive
    transactions, which also requires appropriate settings for hive.compactor.initiator.on,
    hive.compactor.worker.threads, hive.support.concurrency (true), hive.enforce.bucketing
    (true), and hive.exec.dynamic.partition.mode (nonstrict).
    The default DummyTxnManager replicates pre-Hive-0.13 behavior and provides
    no transactions.



    hive.compactor.initiator.on
    true

    Whether to run the initiator and cleaner threads on this metastore instance or not.
    Set this to true on one instance of the Thrift metastore service as part of turning
    on Hive transactions. For a complete list of parameters required for turning on
    transactions, see hive.txn.manager.



    hive.compactor.worker.threads
    1

    How many compactor worker threads to run on this metastore instance. Set this to a
    positive number on one or more instances of the Thrift metastore service as part of
    turning on Hive transactions. For a complete list of parameters required for turning
    on transactions, see hive.txn.manager.
    Worker threads spawn MapReduce jobs to do compactions. They do not do the compactions
    themselves. Increasing the number of worker threads will decrease the time it takes
    tables or partitions to be compacted once they are determined to need compaction.
    It will also increase the background load on the Hadoop cluster as more MapReduce jobs
    will be running in the background.


    In hive-site.xml, can you pls chare your contact number srinivas.thunga@gmail.com

    ReplyDelete
    Replies
    1. For a small clarification , can u set it directly in terminal instead of hive-site.xml and try?

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

      Delete
  3. directly means, can you let me know the command how to set directly on terminal plsssssss

    ReplyDelete
  4. yes, i did the same from hive console,

    But still i am not able to update and delete.

    getting the same error.

    Pls help

    ReplyDelete
    Replies
    1. Is that the same error or something like FAILED: SemanticException [Error 10297]: Attempt to do update or delete on table default.test that does not use an AcidOutputFormat or is not bucketed

      Delete
    2. yes same error

      SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations

      Delete
  5. yes same error like

    SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

    Only single record insert is working fine.
    Not able delete and update

    ReplyDelete
    Replies
    1. After setting the parameters did you created a table with ACID property???

      Delete
    2. It is mensioned in this blog itself.
      1. New Configuration Parameters for Transactions
      2. Creates Hive table with ACID support
      3. Load data into Hive table
      4. Do UPDATE,DELETE and INSERT

      Delete
    3. Hi Sreeveni,

      Thanks a lot for your support.

      Its working fine.

      Able to insert, update and delete records.

      Delete
    4. Hello sreevani and vasu,
      Even i have made all the configuration settings,but still getting the same error as:
      "FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations"
      and am setting them in the terminal,can u please help me in resolving this error?

      Thank you.

      Delete
    5. HI Tejashwini,

      Can post in details step by step you did till now? And which version of Hive you are using???

      Delete
    6. Hello sreevani and vasu,
      Even i have made all the configuration settings,but still getting the same error as:
      "FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations"
      and am setting them in the terminal,can u please help me in resolving this error?

      Thank you.

      Delete
    7. Instead of setting direct in Terminal can u please do the same in Hive-site.xml and restart the hive-server

      Delete
    8. can you please show your create statement.

      Delete
  6. Hi Sreevani,

    I am also getting the similar issue for update

    Error is :
    FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

    I have already setted parmaters as in this blog

    After that tried create , Insert and update but still not worked.


    ReplyDelete
    Replies
    1. After setting the parameters, have you restarted hive server and Metastore?

      Delete
    2. Yes you are right srinivas. Please restart Hive.

      Delete
    3. But sreeveni, can we insert with selected columns like

      insert into table A id,name select id,name from B

      Delete
  7. Hi, I am new to hive
    How to restart hive and Metastore ?
    can you please help me to do this.
    Thanks,
    Nalin

    ReplyDelete
    Replies
    1. Sure go to where Hive was extracted

      $ service --status-all

      check hive-server2 and metastore is running

      $ sudo service hive-server2 restart

      Delete
  8. I am setting at the session level
    In case if i need to do change configurations in hive, hive-site.xml is not available in hive-1.0.0 right how to do that

    ReplyDelete
    Replies
    1. You can set it in terminal aswell.

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

      Delete
    2. I did that at session level also but still i am not able to update

      Delete
    3. please find below what I am doing

      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> set hive.compactor.worker.threads=1;
      hive> create table HiveTest3(EmployeeID Int,FirstName String,Designation String ,Salary Int,Department String) clustered by (department) into 3 buckets stored as orc TBLPROPERTIES ('transactional'='true') ;
      OK
      Time taken: 0.519 seconds
      hive> Insert into table HiveTest3 select * from HiveTest1;
      Query ID = nalin_20150220010303_6feec16c-c945-4abc-98c9-fb5c13e9fcda
      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_1424286757124_0011, Tracking URL = http://bgengmst.ibm.com:8 088/proxy/application_1424286757124_0011/
      Kill Command = /opt/hadoop/hadoop-2.3.0/bin/hadoop job -kill job_1424286757124 _0011
      Hadoop job information for Stage-1: number of mappers: 2; number of reducers: 0
      2015-02-20 01:03:35,704 Stage-1 map = 0%, reduce = 0%
      2015-02-20 01:03:52,221 Stage-1 map = 50%, reduce = 0%, Cumulative CPU 1.26 se c
      2015-02-20 01:03:58,400 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 2.51 s ec
      MapReduce Total cumulative CPU time: 2 seconds 510 msec
      Ended Job = job_1424286757124_0011
      Loading data to table dbtest.hivetest3
      Table dbtest.hivetest3 stats: [numFiles=1, numRows=1, totalSize=502, rawDataSiz e=268]
      MapReduce Jobs Launched:
      Stage-Stage-1: Map: 2 Cumulative CPU: 2.51 sec HDFS Read: 1165 HDFS Write: 664 SUCCESS
      Total MapReduce CPU Time Spent: 2 seconds 510 msec
      OK
      Time taken: 31.73 seconds
      hive> select * from HiveTest3;
      OK
      1 test mgr 1000 b
      Time taken: 0.13 seconds, Fetched: 1 row(s)
      hive> update HiveTest3 set salary = 2000 where EmployeeId = 1;
      FAILED: SemanticException [Error 10294]: Attempt to do update or delete using t ransaction manager that does not support these operations.
      hive>

      Delete
    4. Can you pls set the same thing Hive-Site.xml and restart the server

      Delete
  9. set in Hive-Site.xml file and restart server

    ReplyDelete
    Replies
    1. I don't see any Hive-Site.xml in conf directory, if not available how to create hive-site.xml

      Delete
    2. if posssible, can u please paste conf directary folders

      Delete
    3. [nalin@bgengmst conf]$ ls
      beeline-log4j.properties.template hive-env.sh.template
      configuration.xsl hive-exec-log4j.properties.template
      hive-default.xml.template hive-log4j.properties.template
      hive-env.sh hive-site.xml-snarveso

      Delete
    4. check the hive-default.xml file, u can find the properties hive.support.concurrency

      Then rename the file to Hive-Site.xml

      Delete
    5. I tried to rename it as hive-site.xml but I am not able to connect hive

      Delete
    6. No need to connect to Hive to rename. come out from Hive then go to Hive where it got extracted and rename the file

      Delete
    7. I have copied the file hive-default.xml.template as hive-site.xml in conf directory after that I tried to connect ./bin/hive interface so I am getting errors
      if possible can you provide me ur mobile number so I can explain the scenario exactly what I did

      Delete
    8. my emailid nalinikanth7@gmail.com

      Delete
    9. from where you are starting Hive? Are you using cloudera?

      Delete

    10. Logging initialized using configuration in jar:file:/opt/apache-hive-1.0.0-bin/lib/hive-common-1.0.0.jar!/hive-log4j.properties
      SLF4J: Class path contains multiple SLF4J bindings.
      SLF4J: Found binding in [jar:file:/opt/hadoop/hadoop-2.3.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
      SLF4J: Found binding in [jar:file:/opt/apache-hive-1.0.0-bin/lib/hive-jdbc-1.0.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
      SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
      SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
      Exception in thread "main" java.lang.RuntimeException: java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D
      at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:444)
      at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:626)
      at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:570)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
      Caused by: java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D
      at org.apache.hadoop.fs.Path.initialize(Path.java:206)
      at org.apache.hadoop.fs.Path.(Path.java:172)
      at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:487)
      at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:430)
      ... 7 more
      Caused by: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D
      at java.net.URI.checkPath(URI.java:1804)
      at java.net.URI.(URI.java:752)
      at org.apache.hadoop.fs.Path.initialize(Path.java:203)
      ... 10 more

      Delete
    11. Java HotSpot(TM) 64-Bit Server VM warning: Insufficient space for shared memory file:
      /tmp/hsperfdata_nalin/24733
      Try using the -Djava.io.tmpdir= option to select an alternate temp location.

      Error: Could not find or load main class fs

      Delete
  10. login as: nalin
    nalin@10.64.131.139's password:
    Last login: Fri Feb 20 03:35:34 2015 from 10.2.192.187
    [nalin@bgengmst ~]$ cd $HIVE_HOME
    [nalin@bgengmst apache-hive-1.0.0-bin]$ ./bin/hive
    Unable to determine Hadoop version information.
    'hadoop version' returned:
    Java HotSpot(TM) 64-Bit Server VM warning: Insufficient space for shared memory file: /tmp/hsperfdata_nalin/25370 Try using the -Djava.io.tmpdir= option to select an alternate temp location. Hadoop 2.3.0 Subversion http://svn.apache.org/repos/asf/hadoop/common -r 1567123 Compiled by jenkins on 2014-02-11T13:40Z Compiled with protoc 2.5.0 From source with checksum dfe46336fbc6a044bc124392ec06b85 This command was run using /opt/hadoop/hadoop-2.3.0/share/hadoop/common/hadoop-common-2.3.0.jar
    [nalin@bgengmst apache-hive-1.0.0-bin]$ hdfs fs -ls /
    Java HotSpot(TM) 64-Bit Server VM warning: Insufficient space for shared memory file:
    /tmp/hsperfdata_nalin/25445
    Try using the -Djava.io.tmpdir= option to select an alternate temp location.

    Error: Could not find or load main class fs
    [nalin@bgengmst apache-hive-1.0.0-bin]$

    ReplyDelete
  11. check etc/init.d for services. Then u can service name to start manually

    ReplyDelete
  12. this is not having services related to hive
    [nalin@bgengmst etc]$ cd init.d
    [nalin@bgengmst init.d]$ ls
    abrt-ccpp hadoop mdmonitor psacct sandbox
    abrtd haldaemon messagebus quota_nld saslauthd
    abrt-oops halt netconsole rdisc single
    acpid ip6tables netfs restorecond smartd
    atd iptables network rngd sshd
    auditd irqbalance nfs rpcbind svnserve
    blk-availability kdump nfslock rpcgssd sysstat
    cpuspeed killall nimbus rpcidmapd udev-post
    crond lvm2-lvmetad ntpdate rpcsvcgssd xe-linux-distribution
    functions lvm2-monitor postfix rsyslog zookeeper

    ReplyDelete
    Replies
    1. [nalin@bgengmst apache-hive-1.0.0-bin]$ cd /var/log
      [nalin@bgengmst log]$ ls
      anaconda.ifcfg.log ConsoleKit maillog-20150222 spooler
      anaconda.log cron mesos spooler-20150217
      anaconda.program.log cron-20150217 messages spooler-20150222
      anaconda.storage.log cron-20150222 messages-20150217 storage.log
      anaconda.syslog dmesg messages-20150222 tallylog
      anaconda.yum.log dmesg.old prelink wtmp
      audit dracut.log sa yum.log
      boot.log lastlog secure zookeeper
      btmp maillog secure-20150217
      btmp-20150217 maillog-20150217 secure-20150222

      Delete
    2. Can you please try out the same in CDH 5 (cloudera)

      Delete
  13. I am using Hive 1.1.0 and facing same issues as Nalini mentioned above. Is you problem resolved?

    Seems this is the only thread over internet discussion hive transaction setup. Any idea how can we reach Hive team so that they can help?

    Smilevasu, would you be please willing to help by getting into livemeeting? I understand thats too much to ask. In case you decide so, my email ID is amitg2k@gmail.com

    ReplyDelete
  14. Hi Amit, what you are facing issue on Hive? If possible paste the issue. I sent a request to your mail id.

    ReplyDelete
    Replies
    1. I setup all configuration as above in hive-default.xml.template and saved it as hive-default.xml in CONF directory. However there was no benefit. I created new table as mentioned in step 2 above, I was still getting same error for update:

      SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

      I configured parameters using CLI:

      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> set hive.compactor.worker.threads=1;

      Now I am unable to connect to metastore itself:

      select * from HiveTest;
      FAILED: LockException [Error 10280]: Error communicating with the metastore

      On repeated attempts to restart hive and setup parameters through CLI, I am unable to execute query.
      When i execute

      select * from HiveTest;

      Cursor moves to next line and keep blinking forever. There are only 4 records in this table and query works fine before setting abovementioned CLI parameters.

      BTW, i am unable to locate your email. Could you please resend?

      Delete
    2. For FAILED: LockException [Error 10280]: Error communicating with the metastore ,edit hive-site.xml
      In property tag with set name as hive.in.test and value as true
      and then restrart the service.

      Delete
  15. Many thanks #smilevasu for your time and valuable expertise. Could not have imagined and solved so many issues. Five cheers to you :)

    ReplyDelete
  16. How to release a lock? I killed the script using Ctrl+C and just to realize my table is locked:

    hive> show locks;
    OK
    Lock ID Database Table Partition State Type Transaction ID Last Hearbeat Acquired At User Hostname
    253 default stg_cards NULL WAITING EXCLUSIVE NULL 1429344374976 NULL amit ubuntu14
    Time taken: 0.054 seconds, Fetched: 2 row(s)

    ReplyDelete
  17. Hi smilevasu,
    after editing hive-site.xml how to restart hive? can you please mention steps?

    ReplyDelete
  18. Hi I am able to do update and delete in hive but not working in beeline and from jdbc java program.

    Can anyone help on this

    ReplyDelete
  19. Hello,

    Can you explain the table properties you set in the CREATE TABLE statement? For example you have:

    clustered by (department) into 3 buckets
    stored as orc TBLPROPERTIES ('transactional'='true') ;

    Is there a reason you set clustered by or stored as orc like that? is it required for these transactional hive functions?

    ReplyDelete
    Replies
    1. Hi Matthew ,
      I used a data of 3 different departments,so i clustered them into 3. and inorder to satisfy ACID properties we need to create table in orc format.Can u please try in normal table?

      Delete
  20. Hi unmesha

    I have done all the things u suggested to run acid properties, and as amit garg has done i have folloelwed the same steps but still facing a problem in insert update delete. Semantic error coming.

    Please help me out

    ReplyDelete
  21. Hi Unmesha

    Thanks a lot for the wonderful post. Finally you came for the rescue, this is what I have been searching for months.

    ReplyDelete
    Replies
    1. Hi Unmesha,

      Can you please provide a post on sqoop incremental updates. (not for new rows, for row level updates).

      Delete
  22. hive (default)> INSERT INTO table tomar VALUES(1,'TOM','Pun');
    Query ID = training_20160203110303_156d121d-5e82-4cfb-a2d3-ff97fc8dd0f9
    Total jobs = 1
    Launching Job 1 out of 1
    Number of reduce tasks determined at compile time: 5
    In order to change the average load for a reducer (in bytes):
    set hive.exec.reducers.bytes.per.reducer=
    In order to limit the maximum number of reducers:
    set hive.exec.reducers.max=
    In order to set a constant number of reducers:
    set mapreduce.job.reduces=
    Starting Job = job_1424080128507_5223, Tracking URL = http://hydetamaster:8088/proxy/application_1424080128507_5223/
    Kill Command = /opt/installation/hadoop/bin/hadoop job -kill job_1424080128507_5223
    Interrupting... Be patient, this might take some time.
    Press Ctrl+C again to kill JVM
    killing job with: job_1424080128507_5223


    Hive API stuck at kill command. Can anyone help me out with this ?

    ReplyDelete
  23. hive> update buildingupdatetst
    > set rilfeaturecode = 'L10000'
    > where riluniqueid = 'LO0102_0000023280354';


    FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

    can anyone help me above error

    ReplyDelete
  24. Hi,

    Please let me know hive tables you are created for this??? and let me know the steps you followed till now???

    ReplyDelete
  25. Have anyone tried updating tables in hive cli and it works and it doesnot work from java after setting configuration parameters mentioned above ? Any idea of solution for this ?

    ReplyDelete
  26. FAILED: Error in acquiring locks: Error communicating with the metastore

    Error: Error while processing statement: FAILED: Error in acquiring locks: Error
    communicating with the metastore (state=42000,code=10)

    Any idea about this ?

    ReplyDelete
  27. This comment has been removed by the author.

    ReplyDelete
  28. How to remove this error in case of external tables?

    ReplyDelete
  29. Is there a way to Update the row without having to edit the Hive-Site.xml

    ReplyDelete
  30. Great blog to read... I learnt more useful information from this blog.. thank you for sharing

    hadoop training | big data training | hadoop training in chennai

    ReplyDelete
  31. After reading this blog i very strong in this topics and this blog really helpful to all... explanation are very clear so very easy to understand... thanks a lot for sharing this blog

    hadoop training course syllabus | big data training and course syllabus

    ReplyDelete