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.


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 ....



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
> 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

Reply via email to