Re: create transactional table issue

2020-05-17 Thread Huang Chiming
, 2020 at 11:43 PM Huang Chiming >> wrote: >> >> Thanks for clarifying! >> >> >> >> Best Wishes, >> >> Chiming HUANG >> >> >> >> >> >> On Sat, May 16, 2020 at 11:40 PM Shawn Weeks >> wrote: >> >> St

Re: create transactional table issue

2020-05-17 Thread Mich Talebzadeh
ou need the buckets you should be able to just say create table and > drop everything after partitioned by. > > > > Thanks > > Shawn > > > > *From: *Huang Chiming > *Reply-To: *"user@hive.apache.org" > *Date: *Saturday, May 16, 2020 at 10:32 AM > *To: *&quo

Re: create transactional table issue

2020-05-17 Thread Shawn Weeks
setting Hive up manually. Thanks From: Huang Chiming Reply-To: "user@hive.apache.org" Date: Saturday, May 16, 2020 at 11:09 AM To: "user@hive.apache.org" Subject: Re: create transactional table issue Hi @Shawn, Can tblproperties('transactional'='true') be omitted starti

Re: create transactional table issue

2020-05-16 Thread Huang Chiming
should be able to just say create table and >> drop everything after partitioned by. >> >> >> >> Thanks >> >> Shawn >> >> >> >> *From: *Huang Chiming >> *Reply-To: *"user@hive.apache.org" >> *Date: *Saturda

Re: create transactional table issue

2020-05-16 Thread Huang Chiming
rtitioned by. > > > > Thanks > > Shawn > > > > *From: *Huang Chiming > *Reply-To: *"user@hive.apache.org" > *Date: *Saturday, May 16, 2020 at 10:32 AM > *To: *"user@hive.apache.org" > *Subject: *create transactional table issue >

Re: create transactional table issue

2020-05-16 Thread Shawn Weeks
t 10:32 AM To: "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

create transactional table issue

2020-05-16 Thread Huang Chiming
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