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
>
