Sorry for the resend, but does anyone know who I might best talk to about this?
Would it be worthwhile to bring this question to the dev list?
Thanks again for the help,
Ray
From: Ray Navarette [mailto:ray.navare...@pb.com]
Sent: Thursday, February 8, 2018 6:33 PM
To: user@hive.apache.org
Subje
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
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 copy-n-paste