【详述】正常使用create table abc as select * from bdc 语法，控制台提示 1064 - Unknown reason
【背景】做过哪些操作？
无异常操作，正常查询
【业务影响】
【StarRocks版本】2.5.0
【集群规模】1fe 1be 混合部署
【机器信息】8核32G
【联系方式】shaoyanghui_dh@163.com
【附件】
select 表的语句统一如下：
CREATE TABLE `v_un_gs_marpripinfo_1514532478577307649` (
`id` varchar(65533) NULL COMMENT "",
`company_name` varchar(65533) NULL COMMENT "",
`credit_code` varchar(65533) NULL COMMENT "",
`orgno` varchar(65533) NULL COMMENT "",
`regno` varchar(65533) NULL COMMENT "",
`oplocdistrict` varchar(65533) NULL COMMENT "",
`oplocdistrict_name` varchar(65533) NULL COMMENT "",
`industryphy` varchar(65533) NULL COMMENT "",
`industryphy_name` varchar(65533) NULL COMMENT "",
`industryco` varchar(65533) NULL COMMENT "",
`industryco_name` varchar(65533) NULL COMMENT "",
`lerep` varchar(65533) NULL COMMENT "",
`regcapcur` varchar(65533) NULL COMMENT "",
`regcapcur_name` varchar(65533) NULL COMMENT "",
`reccap` varchar(65533) NULL COMMENT "",
`dom` varchar(65533) NULL COMMENT "",
`tel` varchar(65533) NULL COMMENT "",
`opscope` varchar(65533) NULL COMMENT "",
`enttype` varchar(65533) NULL COMMENT "",
`enttype_name` varchar(65533) NULL COMMENT "",
`enttypeitem` varchar(65533) NULL COMMENT "",
`enttypeitem_name` varchar(65533) NULL COMMENT "",
`opfrom` varchar(65533) NULL COMMENT "",
`opto` varchar(65533) NULL COMMENT "",
`estdate` varchar(65533) NULL COMMENT "",
`state` varchar(65533) NULL COMMENT "",
`state_name` varchar(65533) NULL COMMENT "",
`enttypepro` varchar(65533) NULL COMMENT "",
`enttypepro_name` varchar(65533) NULL COMMENT "",
`empnum` varchar(65533) NULL COMMENT "",
`enttypegb` varchar(65533) NULL COMMENT "",
`enttypegb_name` varchar(65533) NULL COMMENT "",
`marprid` varchar(65533) NULL COMMENT "",
`regcap` varchar(65533) NULL COMMENT "",
`superorgid` varchar(65533) NULL COMMENT "",
`create_time` varchar(65533) NULL COMMENT "",
`zhgxsj` varchar(65533) NULL COMMENT "",
`lng` varchar(65533) NULL COMMENT "",
`lat` varchar(65533) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`id`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`id`) BUCKETS 16
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false",
"compression" = "LZ4"
);
fe.log (41.8 MB)