CREATE TABLE main_ref_map (
jzname varchar(255) ,
code varchar(255) ,
zbname varchar(100),
datav int,
isdel int,
ifmain int,
create_time varchar(100)
)
DISTRIBUTED BY HASH(jzname, code,datav)
BUCKETS 3
报错:
修改为单副本后创建成功:
CREATE TABLE main_ref_map (
jzname varchar(255) ,
code varchar(255) ,
zbname varchar(100),
datav int,
isdel int,
ifmain int,
create_time varchar(100)
)
DISTRIBUTED BY HASH(jzname, code,datav)
BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);
集群为1fe 3be