大数据库无法直接修改、删除数据
可以插入数据
如要修改表格内容,需要删除整表重建并进行数据导入
建立新表的语句也有差异,这里记录一下建表相关
create table sea_treaty_data_zh(
id BIGINT, // 大数据库表字段类型
registrationPDFName varchar,
textType varchar,
registrationNumber int,
volumnNumber varchar,
treatyType varchar,
title_en MULTIVALUE nlp_tokenizer 'ik' value_type 'varchar', // 有关快速查询
participants varchar,
subjectTerms varchar,
submitter varchar,
latestConclusionPlace varchar,
latestConclusionDate varchar,
conclusionTimes int,
registrationPlace varchar,
registrationDate varchar,
authenticText varchar,
publicationFormat varchar,
v varchar,
url varchar,
title_zh MULTIVALUE nlp_tokenizer 'ik' value_type 'varchar' // 有关快速查询
)
DISTRIBUTE BY HASH (id) // 重要
create table sea_treaty_data_en(
id BIGINT, // 大数据库表字段类型
registrationPDFName varchar,
textType varchar,
registrationNumber int,
volumnNumber varchar,
treatyType varchar,
title_en MULTIVALUE nlp_tokenizer 'ik' value_type 'varchar', // 有关快速查询
participants varchar,
subjectTerms varchar,
submitter varchar,
latestConclusionPlace varchar,
latestConclusionDate varchar,
conclusionTimes int,
registrationPlace varchar,
registrationDate varchar,
authenticText varchar,
publicationFormat varchar,
v varchar,
url varchar,
preview_url varchar,
download_url varchar,
contentWithTitle MULTIVALUE nlp_tokenizer 'ik' value_type 'varchar', // 有关快速查询
available tinyint,
price DECIMAL(5,2), // -999.99 ~ 999.99
classification tinyint
)
DISTRIBUTE BY HASH (id) // 重要