Re: create transactional table issue

th it I’m not sure as I’ve never used Flume. Are you >> using a vendor distribution of Hive 3.x or are you rolling your own? >> >> >> >> What does “show create table your_table;” show? It is possible to turn >> off acid if your setting Hive up manually. >>

Re: create transactional table issue

t; *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 starting from 3.x? > >

Re: create transactional table issue

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'

Re: create transactional table issue

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 except

Re: create transactional table issue

Thanks for clarifying! Best Wishes, Chiming HUANG On Sat, May 16, 2020 at 11:40 PM Shawn Weeks 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. >

Re: create transactional table issue

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 Reply-To: "user@hive.apache.org" Date: Saturday, May 16, 2020 at 10:32 AM T