Re: Hive 0.14 configuration

Here's more information about configuring for transactions: Hive Transactions -- Configuration . -- Lefty On Tue, Nov 4, 2014 at 4:19 AM, mahesh kumar wrote: > Hi, > Finally i updated and d

Re: Hive 0.14 configuration

Hi, Finally i updated and deleted from hive table.we need to create table with transactional = true like following. create table test(id int, name varchar(128)) clustered by (id) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') insert into table test values(1,'Mahesh'); upd

Re: Hive 0.14 configuration

Hi Nitin, I created table with ORC format when i update it shows the following error. CREATE TABLE students (name VARCHAR(64), age INT, gpa DECIMAL(3, 2)) CLUSTERED BY (age) INTO 2 BUCKETS STORED AS ORC; INSERT INTO TABLE students VALUES ('fred flintstone', 35, 1.28), ('barney rubble',

Re: Hive 0.14 configuration

currently only ORCFileformat is supports ACIDOutputformat So you may want to create a table with orcfile format and see if you are able to do acid opertaions. On Tue, Nov 4, 2014 at 1:14 PM, mahesh kumar wrote: > Hi Nitin, > > how to create table with AcidOuptut Format.?Can you s

Re: Hive 0.14 configuration

Hi Nitin, how to create table with AcidOuptut Format.?Can you send me examples. Thanks Mahesh On Tue, Nov 4, 2014 at 12:21 PM, Nitin Pawar wrote: > As the error says, your table file format has to be AcidOutPutFormat or > table needs to be bucketed to perform update operation. > >

Re: Hive 0.14 configuration

As the error says, your table file format has to be AcidOutPutFormat or table needs to be bucketed to perform update operation. You may want to create a new table from your existing table with AcidOutPutFormat and insert data from current table to that table and then try update op on new table On

Hive 0.14 configuration

Hi , Is anyone tried hive 0.14 configuration.I built it using maven from github. Insert is working fine but when i use update/delete i got the error.First i created table and inserted rows. CREATE TABLE new(id int ,name string)ROW FORMAT DELIMITED FIELDS TERMINATED BY ','; insert into ta