版本 2.3.2
建表sql如下：
CREATE TABLE technics_line_0902 (
id int(11) NOT NULL COMMENT “自增ID”,
tenant_id int(11) NOT NULL COMMENT “租户ID”,
name varchar(32) NULL COMMENT “名称”,
code varchar(32) NULL COMMENT “编码”,
bom_id int(11) NULL COMMENT “bomID”,
materiel_id int(11) NULL COMMENT “物料ID”,
materiel_code varchar(32) NULL COMMENT “物料编码”,
materiel_name varchar(32) NULL COMMENT “物料名称”,
materiel_spec varchar(32) NULL COMMENT “”,
version varchar(12) NULL COMMENT “版本”,
is_enable tinyint(4) NULL COMMENT “是否启用”,
is_publish tinyint(4) NULL COMMENT “是否发布”,
technics_group_id int(11) NULL COMMENT “工艺分组ID”,
status tinyint(4) NULL COMMENT “状态：0，删除；1，正常；”,
created_time varchar(30) NULL COMMENT “记录添加时间”,
last_modified_time varchar(30) NULL COMMENT “记录更新时间”,
created_account varchar(32) NULL COMMENT “创建人账号”,
created_name varchar(32) NULL COMMENT “最后更新人账号”,
technics_template_id int(11) NULL COMMENT “工序流程模板ID”,
created_user_name varchar(32) NULL COMMENT " 创建人",
last_modified_user_name varchar(32) NULL DEFAULT “” COMMENT “最后修改人”,
process_type tinyint(4) NULL COMMENT “0:无,1:三元 2.铁锂”
) ENGINE=OLAP
PRIMARY KEY(id)
COMMENT “OLAP”
DISTRIBUTED BY HASH(id) BUCKETS 40
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”
);
查询元数据sql如下：
SELECT COLUMN_NAME, DATA_TYPE,IS_NULLABLE,
(CASE WHEN DATA_TYPE = ‘bigint’ THEN NUMERIC_precision
WHEN DATA_TYPE = ‘int’ THEN NUMERIC_precision
WHEN DATA_TYPE = ‘smallint’ THEN NUMERIC_precision
WHEN DATA_TYPE = ‘tinyint’ THEN NUMERIC_precision
WHEN DATA_TYPE = ‘bit’ THEN NUMERIC_precision
ELSE CHARACTER_MAXIMUM_LENGTH
END ) AS COLUMN_LENGTH
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = ‘mes’
AND TABLE_NAME = ‘technics_line_0902’;
查询元数据显示结果如下：
创表时指定name等字段可以为空（null），但查询元数据显示的name等字段不能为空（null）。