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 Wed, Feb 14, 2018 at 9:08 PM, Johannes Alberti <johan...@altiscale.com>
wrote:
> 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 issue in
> your mail, but your hiveconf parameter is missing a - ... it is beeline
> --hiveconf ..., not beeline -hiveconf ....
>
> Regards,
>
> Johannes
>
> Sent from my iPhone
>
> On Feb 14, 2018, at 5:27 PM, Colin Williams <
> colin.williams.seat...@gmail.com> wrote:
>
> 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 table.
>
> Then I read some documentation, added bucketing to the table definition,
> added beeline xml file, etc. Then I launch the create table script like
>
>
> `beeline --hiveconf hive.support.concurrency=true
> hive.exec.dynamic.partition.mode=nonstrict hive.txn.manager=org.apache.
> hadoop.hive.ql.lockmgr.DbTxnManager -f ./events.sql`
>
> beeline executes part of the SQL file but then provides no more output.
>
> To figure out what was going on I tried to query the table
>
>
> beeline -hiveconf hive.support.concurrency=true
> hive.exec.dynamic.partition.mode=nonstrict hive.txn.manager=org.apache.
> hadoop.hive.ql.lockmgr.DbTxnManager -e "Select * from analytics.events
> limit 10;"
> Connecting to jdbc:hive2://REDACTED
> REDACTED
> Connected to: Apache Hive (version 2.3.2-amzn-0)
> Driver: Hive JDBC (version 2.3.2-amzn-0)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> Error: Error while compiling statement: FAILED: SemanticException [Error
> 10265]: This command is not allowed on an ACID table
> analytics_user_vws.liveramp_events with a non-ACID transaction manager.
> Failed command: Select * from analytics_user_vws.liveramp_events limit 10
> (state=42000,code=10265)
> Closing: 0: jdbc:hive2://
>
>
> Why am I not getting that error from creating the table? ( and no INFO
> from beeline)
>
> Also can somebody help me figure out what I need to do to be able to
> create the ACID table?
>
> Thanks
>
>
