You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by unmesha sreeveni <un...@gmail.com> on 2014/11/24 09:10:23 UTC
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 = 50000 WHERE employeeid = 19;
FAILED: SemanticException [Error 10294]: Attempt to do update or delete
using transaction manager that does not support these operations.
hive>
Am I doing anything wrong?
--
*Thanks & Regards *
*Unmesha Sreeveni U.B*
*Hadoop, Bigdata Developer*
*Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
http://www.unmeshasreeveni.blogspot.in/
Re: UPDATE in Hive -0.14.0
Posted by unmesha sreeveni <un...@gmail.com>.
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 <ga...@hortonworks.com> 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 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 orc tblproperties('transactional' = 'true');
>
> Alan.
>
> unmesha sreeveni <un...@gmail.com>
> November 24, 2014 at 1:39
> 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.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
>
> The when I tried
> hive>
> >
> > UPDATE HiveTest SET salary = 50000 WHERE employeeid = 19;
> FAILED: SemanticException [Error 10297]: Attempt to do update or delete on
> table default.HiveTest that does not use an AcidOutputFormat or is not
> bucketed
>
> Is it beacause of hive.enforce.bucketing – true set in hive-site.xml
> Is bucketing like partition?
>
>
>
>
>
>
>
>
> --
> *Thanks & Regards *
>
>
> *Unmesha Sreeveni U.B*
> *Hadoop, Bigdata Developer*
> *Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
> http://www.unmeshasreeveni.blogspot.in/
>
>
> Mahesh Kumar <sa...@gmail.com>
> November 24, 2014 at 1:25
> 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
> <https://github.com/apache/hive/blob/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.14.0.mysql.sql>
> .
>
> *And add these properties in hive-site.xml.*
>
> <property>
> <name>hive.support.concurrency</name>
> <value>true</value>
> </property>
>
> <property>
> <name>hive.enforce.bucketing</name>
> <value>true</value>
> </property>
>
> <property>
> <name>hive.exec.dynamic.partition.mode</name>
> <value>nonstrict</value>
> </property>
>
> <property>
> <name>hive.txn.manager</name>
> <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
> </property>
>
> <property>
> <name>hive.compactor.initiator.on</name>
> <value>true</value>
> </property>
>
> <property>
> <name>hive.compactor.worker.threads</name>
> <value>1</value>
> </property>
>
> *Make sure your table creation supports ACID ouput format.Create like
> following*.
>
> create table test(id int, name varchar(128)) clustered by (id) into 2
> buckets stored as orc TBLPROPERTIES ('transactional'='true')
>
>
> Regards,
>
> Mahesh.S
> @Sanjiv Singh <sa...@gmail.com>
> November 24, 2014 at 0:39
> 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('transactional'='true')
>
> Regards
> Sanjiv Singh
> Mob : +091 9990-447-339
>
>
> Nitin Pawar <ni...@gmail.com>
> November 24, 2014 at 0:28
>
> whats your create table DDL?
> unmesha sreeveni <un...@gmail.com>
> November 24, 2014 at 0:10
> 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 = 50000 WHERE employeeid = 19;
>
> FAILED: SemanticException [Error 10294]: Attempt to do update or delete
> using transaction manager that does not support these operations.
> hive>
>
>
> Am I doing anything wrong?
>
> --
> *Thanks & Regards *
>
>
> *Unmesha Sreeveni U.B*
> *Hadoop, Bigdata Developer*
> *Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
> http://www.unmeshasreeveni.blogspot.in/
>
>
>
> --
> Sent with Postbox <http://www.getpostbox.com>
>
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or entity
> to which it is addressed and may contain information that is confidential,
> privileged and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient, you are hereby notified that
> any printing, copying, dissemination, distribution, disclosure or
> forwarding of this communication is strictly prohibited. If you have
> received this communication in error, please contact the sender immediately
> and delete it from your system. Thank You.
--
*Thanks & Regards *
*Unmesha Sreeveni U.B*
*Hadoop, Bigdata Developer*
*Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
http://www.unmeshasreeveni.blogspot.in/
Re: UPDATE in Hive -0.14.0
Posted by Alan Gates <ga...@hortonworks.com>.
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 orc tblproperties('transactional' = 'true');
Alan.
> unmesha sreeveni <ma...@gmail.com>
> November 24, 2014 at 1:39
> 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.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
>
> The when I tried
> hive>
> >
> > UPDATE HiveTest SET salary = 50000 WHERE employeeid = 19;
> FAILED: SemanticException [Error 10297]: Attempt to do update or
> delete on table default.HiveTest that does not use an AcidOutputFormat
> or is not bucketed
>
> Is it beacause of hive.enforce.bucketing – true set in hive-site.xml
> Is bucketing like partition?
>
>
>
>
>
>
>
>
> --
> */Thanks & Regards/ *
> /*
> */
> *Unmesha Sreeveni U.B/
> /*
> *Hadoop, Bigdata Developer*
> *Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
> http://www.unmeshasreeveni.blogspot.in/
>
> /
> /
> Mahesh Kumar <ma...@gmail.com>
> November 24, 2014 at 1:25
> 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
> <https://github.com/apache/hive/blob/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.14.0.mysql.sql>.
>
> *And add these properties in hive-site.xml.*
>
> <property>
> <name>hive.support.concurrency</name>
> <value>true</value>
> </property>
>
> <property>
> <name>hive.enforce.bucketing</name>
> <value>true</value>
> </property>
>
> <property>
> <name>hive.exec.dynamic.partition.mode</name>
> <value>nonstrict</value>
> </property>
>
> <property>
> <name>hive.txn.manager</name>
> <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
> </property>
>
> <property>
> <name>hive.compactor.initiator.on</name>
> <value>true</value>
> </property>
>
> <property>
> <name>hive.compactor.worker.threads</name>
> <value>1</value>
> </property>
>
> *Make sure your table creation supports ACID ouput format.Create like
> following*.
>
> create table test(id int, name varchar(128)) clustered by (id) into 2
> buckets stored as orc TBLPROPERTIES ('transactional'='true')
>
>
> Regards,
>
> Mahesh.S
> @Sanjiv Singh <ma...@gmail.com>
> November 24, 2014 at 0:39
> 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('transactional'='true')
>
> Regards
> Sanjiv Singh
> Mob : +091 9990-447-339
>
>
> Nitin Pawar <ma...@gmail.com>
> November 24, 2014 at 0:28
>
> whats your create table DDL?
>
> unmesha sreeveni <ma...@gmail.com>
> November 24, 2014 at 0:10
> 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 = 50000 WHERE employeeid = 19;
>
> FAILED: SemanticException [Error 10294]: Attempt to do update or
> delete using transaction manager that does not support these operations.
> hive>
>
>
> Am I doing anything wrong?
>
> --
> */Thanks & Regards/ *
> /*
> */
> *Unmesha Sreeveni U.B/
> /*
> *Hadoop, Bigdata Developer*
> *Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
> http://www.unmeshasreeveni.blogspot.in/
>
> /
> /
--
Sent with Postbox <http://www.getpostbox.com>
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
Re: UPDATE in Hive -0.14.0
Posted by Lefty Leverenz <le...@gmail.com>.
Here are some helpful wikidocs:
- Hive Transactions
<https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions>
- Limitations
<https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Limitations>
(file
format must be ORC, tables must be bucketed)
- Configuration
<https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Configuration>
- Table Properties
<https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-TableProperties>
- Bucketed Tables
<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL+BucketedTables>
- ORC Files
<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ORC>
-- Lefty
On Mon, Nov 24, 2014 at 2:15 AM, Mahesh Kumar <sa...@gmail.com>
wrote:
> 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 <un...@gmail.com>
> wrote:
>
>> 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.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
>>
>> The when I tried
>> hive>
>> >
>> > UPDATE HiveTest SET salary = 50000 WHERE employeeid = 19;
>> FAILED: SemanticException [Error 10297]: Attempt to do update or delete
>> on table default.HiveTest that does not use an AcidOutputFormat or is not
>> bucketed
>>
>> Is it beacause of hive.enforce.bucketing – true set in hive-site.xml
>> Is bucketing like partition?
>>
>>
>>
>>
>>
>> On Mon, Nov 24, 2014 at 2:55 PM, Mahesh Kumar <sa...@gmail.com>
>> wrote:
>>
>>> 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
>>> <https://github.com/apache/hive/blob/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.14.0.mysql.sql>
>>> .
>>>
>>> *And add these properties in hive-site.xml.*
>>>
>>> <property>
>>> <name>hive.support.concurrency</name>
>>> <value>true</value>
>>> </property>
>>>
>>> <property>
>>> <name>hive.enforce.bucketing</name>
>>> <value>true</value>
>>> </property>
>>>
>>> <property>
>>> <name>hive.exec.dynamic.partition.mode</name>
>>> <value>nonstrict</value>
>>> </property>
>>>
>>> <property>
>>> <name>hive.txn.manager</name>
>>> <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
>>> </property>
>>>
>>> <property>
>>> <name>hive.compactor.initiator.on</name>
>>> <value>true</value>
>>> </property>
>>>
>>> <property>
>>> <name>hive.compactor.worker.threads</name>
>>> <value>1</value>
>>> </property>
>>>
>>> *Make sure your table creation supports ACID ouput format.Create like
>>> following*.
>>>
>>> create table test(id int, name varchar(128)) clustered by (id) into 2
>>> buckets stored as orc TBLPROPERTIES ('transactional'='true')
>>>
>>>
>>> Regards,
>>>
>>> Mahesh.S
>>>
>>>
>>
>>
>> --
>> *Thanks & Regards *
>>
>>
>> *Unmesha Sreeveni U.B*
>> *Hadoop, Bigdata Developer*
>> *Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
>> http://www.unmeshasreeveni.blogspot.in/
>>
>>
>>
>
Re: UPDATE in Hive -0.14.0
Posted by Mahesh Kumar <sa...@gmail.com>.
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 <un...@gmail.com>
wrote:
> 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.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
>
> The when I tried
> hive>
> >
> > UPDATE HiveTest SET salary = 50000 WHERE employeeid = 19;
> FAILED: SemanticException [Error 10297]: Attempt to do update or delete on
> table default.HiveTest that does not use an AcidOutputFormat or is not
> bucketed
>
> Is it beacause of hive.enforce.bucketing – true set in hive-site.xml
> Is bucketing like partition?
>
>
>
>
>
> On Mon, Nov 24, 2014 at 2:55 PM, Mahesh Kumar <sa...@gmail.com>
> wrote:
>
>> 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
>> <https://github.com/apache/hive/blob/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.14.0.mysql.sql>
>> .
>>
>> *And add these properties in hive-site.xml.*
>>
>> <property>
>> <name>hive.support.concurrency</name>
>> <value>true</value>
>> </property>
>>
>> <property>
>> <name>hive.enforce.bucketing</name>
>> <value>true</value>
>> </property>
>>
>> <property>
>> <name>hive.exec.dynamic.partition.mode</name>
>> <value>nonstrict</value>
>> </property>
>>
>> <property>
>> <name>hive.txn.manager</name>
>> <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
>> </property>
>>
>> <property>
>> <name>hive.compactor.initiator.on</name>
>> <value>true</value>
>> </property>
>>
>> <property>
>> <name>hive.compactor.worker.threads</name>
>> <value>1</value>
>> </property>
>>
>> *Make sure your table creation supports ACID ouput format.Create like
>> following*.
>>
>> create table test(id int, name varchar(128)) clustered by (id) into 2
>> buckets stored as orc TBLPROPERTIES ('transactional'='true')
>>
>>
>> Regards,
>>
>> Mahesh.S
>>
>>
>
>
> --
> *Thanks & Regards *
>
>
> *Unmesha Sreeveni U.B*
> *Hadoop, Bigdata Developer*
> *Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
> http://www.unmeshasreeveni.blogspot.in/
>
>
>
Re: UPDATE in Hive -0.14.0
Posted by unmesha sreeveni <un...@gmail.com>.
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.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
The when I tried
hive>
>
> UPDATE HiveTest SET salary = 50000 WHERE employeeid = 19;
FAILED: SemanticException [Error 10297]: Attempt to do update or delete on
table default.HiveTest that does not use an AcidOutputFormat or is not
bucketed
Is it beacause of hive.enforce.bucketing – true set in hive-site.xml
Is bucketing like partition?
On Mon, Nov 24, 2014 at 2:55 PM, Mahesh Kumar <sa...@gmail.com>
wrote:
> 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
> <https://github.com/apache/hive/blob/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.14.0.mysql.sql>
> .
>
> *And add these properties in hive-site.xml.*
>
> <property>
> <name>hive.support.concurrency</name>
> <value>true</value>
> </property>
>
> <property>
> <name>hive.enforce.bucketing</name>
> <value>true</value>
> </property>
>
> <property>
> <name>hive.exec.dynamic.partition.mode</name>
> <value>nonstrict</value>
> </property>
>
> <property>
> <name>hive.txn.manager</name>
> <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
> </property>
>
> <property>
> <name>hive.compactor.initiator.on</name>
> <value>true</value>
> </property>
>
> <property>
> <name>hive.compactor.worker.threads</name>
> <value>1</value>
> </property>
>
> *Make sure your table creation supports ACID ouput format.Create like
> following*.
>
> create table test(id int, name varchar(128)) clustered by (id) into 2
> buckets stored as orc TBLPROPERTIES ('transactional'='true')
>
>
> Regards,
>
> Mahesh.S
>
>
--
*Thanks & Regards *
*Unmesha Sreeveni U.B*
*Hadoop, Bigdata Developer*
*Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
http://www.unmeshasreeveni.blogspot.in/
Re: UPDATE in Hive -0.14.0
Posted by Mahesh Kumar <sa...@gmail.com>.
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
<https://github.com/apache/hive/blob/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.14.0.mysql.sql>
.
*And add these properties in hive-site.xml.*
<property>
<name>hive.support.concurrency</name>
<value>true</value>
</property>
<property>
<name>hive.enforce.bucketing</name>
<value>true</value>
</property>
<property>
<name>hive.exec.dynamic.partition.mode</name>
<value>nonstrict</value>
</property>
<property>
<name>hive.txn.manager</name>
<value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
</property>
<property>
<name>hive.compactor.initiator.on</name>
<value>true</value>
</property>
<property>
<name>hive.compactor.worker.threads</name>
<value>1</value>
</property>
*Make sure your table creation supports ACID ouput format.Create like
following*.
create table test(id int, name varchar(128)) clustered by (id) into 2
buckets stored as orc TBLPROPERTIES ('transactional'='true')
Regards,
Mahesh.S
Re: UPDATE in Hive -0.14.0
Posted by "@Sanjiv Singh" <sa...@gmail.com>.
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('transactional'='true')
Regards
Sanjiv Singh
Mob : +091 9990-447-339
On Mon, Nov 24, 2014 at 1:58 PM, Nitin Pawar <ni...@gmail.com>
wrote:
> whats your create table DDL?
> On 24 Nov 2014 13:43, "unmesha sreeveni" <un...@gmail.com> 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 = 50000 WHERE employeeid = 19;
>>
>> FAILED: SemanticException [Error 10294]: Attempt to do update or delete
>> using transaction manager that does not support these operations.
>> hive>
>>
>>
>> Am I doing anything wrong?
>>
>> --
>> *Thanks & Regards *
>>
>>
>> *Unmesha Sreeveni U.B*
>> *Hadoop, Bigdata Developer*
>> *Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
>> http://www.unmeshasreeveni.blogspot.in/
>>
>>
>>
Re: UPDATE in Hive -0.14.0
Posted by Nitin Pawar <ni...@gmail.com>.
whats your create table DDL?
On 24 Nov 2014 13:43, "unmesha sreeveni" <un...@gmail.com> 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 = 50000 WHERE employeeid = 19;
>
> FAILED: SemanticException [Error 10294]: Attempt to do update or delete
> using transaction manager that does not support these operations.
> hive>
>
>
> Am I doing anything wrong?
>
> --
> *Thanks & Regards *
>
>
> *Unmesha Sreeveni U.B*
> *Hadoop, Bigdata Developer*
> *Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
> http://www.unmeshasreeveni.blogspot.in/
>
>
>