.org" <user@hive.apache.org>
> *Date: *Thursday, February 15, 2018 at 8:54 AM
> *To: *"user@hive.apache.org" <user@hive.apache.org>
> *Subject: *Re: Hive beeline and ACID tables.
>
>
>
> Looking back I may have omitted the --hiveconf setting. I wil
user@hive.apache.org" <user@hive.apache.org>
Subject: Re: Hive beeline and ACID tables.
Looking back I may have omitted the --hiveconf setting. I will try creating the
table again today and see if that was the issue.
On Thu, Feb 15, 2018 at 8:51 AM, Colin Willi
Looking back I may have omitted the --hiveconf setting. I will try creating
the table again today and see if that was the issue.
On Thu, Feb 15, 2018 at 8:51 AM, Colin Williams <
colin.williams.seat...@gmail.com> wrote:
> Hi Johannes. I did set the "transactional" property to true like:
>
>
Hi Johannes. I did set the "transactional" property to true like:
tblproperties("transactional"="true");
And also stored as orc and bucketed and partitioned the table. Finally I
did use double -- for setting the hiveconf. Then there must be some other
issue regarding using the ACID tables.
On
Hi Collin,
you need to set the table property “transactional” to true, this will mark the
table as ACID.
See also the example all the way at the bottom of this link.
https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions
For your error, the SELECT, maybe it is simply a
Hello,
I'm new to hive and had been porting some Redshift SQL to Hive. Today I ran
across a table that uses update.
After a somewhat time consuming translation process I was able to load the
create table definition. However the update part returned an error about
update not supported on non-acid
