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