Re: UPDATE in Hive -0.14.0

Thanks Alan Gates :) . My issue is solved. http://unmeshasreeveni.blogspot.in/2014/11/updatedeleteinsert-in-hive-0140.html On Wed, Dec 3, 2014 at 7:41 AM, Alan Gates wrote: > You have to use ORC as the table format (it's the only format that > supports update and delete at this point), and you

Re: UPDATE in Hive -0.14.0

You have to use ORC as the table format (it's the only format that supports update and delete at this point), and you have to explicitly mark the table as transactional. You must also bucket the table. For example: create table HiveTest (...) clustered by (_col_) into _num_ buckets stored as

Re: UPDATE in Hive -0.14.0

Here are some helpful wikidocs: - Hive Transactions - Limitations (file format must be ORC, tables must be

Re: UPDATE in Hive -0.14.0

hi unmesha sreeveni, As i told earlier create the table with ACID ouput format support. On Mon, Nov 24, 2014 at 3:09 PM, unmesha sreeveni wrote: > Created a Table in Hive > > create external table HiveTest (EmployeeID Int,FirstName > String,Designation String,Salary Int,Depa

Re: UPDATE in Hive -0.14.0

Created a Table in Hive create external table HiveTest (EmployeeID Int,FirstName String,Designation String,Salary Int,Department String) row format delimited fields terminated by "," location '/user/aibladmin/Hive'; And set all the properties in hive-site.xml hive.support.concurrency – true hive.

Re: UPDATE in Hive -0.14.0

Hi unmesha sreevani, *Create metastore in mysql and create the tables as per the below link.* https://github.com/apache/hive/blob/trunk/metastore/scripts/upCreate metastore in mysql and create the tables as per the below link.grade/mysql/hive-schema-0.14.0.mysql.sql

Re: UPDATE in Hive -0.14.0

Make sure you have configured these properties hive-site.xml hive.support.concurrency hive.enforce.bucketing hive.exec.dynamic.partition.mode hive.txn.manager hive.compactor.initiator.on hive.compactor.worker.threads also following property has been set at table level TBLPROPERTIES('transactiona

Re: UPDATE in Hive -0.14.0

whats your create table DDL? On 24 Nov 2014 13:43, "unmesha sreeveni" wrote: > Hi > > I am using hive -0.14.0 which support UPDATE statement > > but I am getting an error once I did this Command > UPDATE Emp SET salary = 5 WHERE employeeid = 19; > > FAILED: SemanticException [Error 10294]: At

UPDATE in Hive -0.14.0

Hi I am using hive -0.14.0 which support UPDATE statement but I am getting an error once I did this Command UPDATE Emp SET salary = 5 WHERE employeeid = 19; FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operation