Re: create transactional table issue

2020-05-17 Thread Huang Chiming
I rolled my own service by docker. I just figured out it's a problem with standalone hive metastore 3.0.0. After downgrading to hive 2.3.7 metastore service, everything works fine. FYI, the ddl was executed failed on (apache hive 3.1.2, standalone hive metastore 3.0.0, apache hadoop 3.2.1), but s

Re: create transactional table issue

2020-05-17 Thread Mich Talebzadeh
In Hive 3.1.1 the thread owner table creation works fine hive --version Hive 3.1.1 0: jdbc:hive2://rhes75:10099/default> create table test.dllm ( b string ) partitioned by (a int) clustered by (b) into 2 buckets stored as orc tblproperties('transactional'='true') . . . . . . . . . . . . . . . .

Re: create transactional table issue

2020-05-17 Thread Shawn Weeks
The Hive Streaming API has changed in Hive 3.x and that might have something to do with 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