Hi @Shawn, Can tblproperties('transactional'='true') be omitted starting from 3.x?
I just create a hive table without tblproperties('transactional'='true') and ingest data from flume hive sink ( https://flume.apache.org/releases/content/1.9.0/FlumeUserGuide.html#hive-sink), flume throws an exception like `Caused by: org.apache.hive.hcatalog.streaming.InvalidTable: Invalid table db:test, table:dllm: is not an Acid table`. How can I create a hive ACID table? I'd like to ingest stream data from flume to hive. Thank you for help! Best Wishes, Chiming HUANG On Sat, May 16, 2020 at 11:43 PM Huang Chiming <nanoh...@gmail.com> wrote: > Thanks for clarifying! > > Best Wishes, > Chiming HUANG > > > On Sat, May 16, 2020 at 11:40 PM Shawn Weeks <swe...@weeksconsulting.us> > wrote: > >> Starting in Hive 3.x all internal tables are transactional by default. >> Unless you need the buckets you should be able to just say create table and >> drop everything after partitioned by. >> >> >> >> Thanks >> >> Shawn >> >> >> >> *From: *Huang Chiming <nanoh...@gmail.com> >> *Reply-To: *"user@hive.apache.org" <user@hive.apache.org> >> *Date: *Saturday, May 16, 2020 at 10:32 AM >> *To: *"user@hive.apache.org" <user@hive.apache.org> >> *Subject: *create transactional table issue >> >> >> >> Hi guys, >> >> >> >> I use hive 3.1.2 connecting to standalone metastore and execute ddl in >> beeline/hive-cli failed, the error message is really weird to me… Anyone >> ever encounter the same issue? >> >> >> >> ``` >> >> create table test.dllm ( b string ) >> >> partitioned by (a int) >> >> clustered by (b) into 2 buckets >> >> stored as orc tblproperties('transactional'='true'); >> >> >> >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:The table must >> be stored using an ACID compliant format (such as ORC): test.dllm) >> >> ``` >> >> >> >> >> >> Best Wishes, >> >> Chiming HUANG >> >