inceptor、hive遇到的問(wèn)題

1.創(chuàng)建表

create table if not exists text (sid int ,sname String)；

2.插入數(shù)據(jù)時(shí)報(bào)錯(cuò)：

insert into text values (1,"zhangsan");

[42000][10797] COMPILE FAILED: Semantic error: [Error 10797] Only allow to single insert into Hyperbase/ES/Transaction Orc, other data destination not allowed

意思是使用insert into 方式插入數(shù)據(jù)只能是orc事務(wù)表，其他類型的源數(shù)據(jù)是不被允許的

3.網(wǎng)上查找解決方式是這樣創(chuàng)建表：

create table if not exists text (sid int ,sname String)

row format delimited fields terminated by ',' stored as ORC;

使用這種方式創(chuàng)建表后還是報(bào)同樣的錯(cuò)誤

4.加個(gè)分桶解決問(wèn)題

SET transaction.type=inceptor;

CREATE TABLE ta (name STRING,age INT)CLUSTERED BY (age)INTO 2 BUCKETS STORED AS ORC

TBLPROPERTIES ("transactional"="true");