kyehe commented on issue #4367:
URL:
https://github.com/apache/incubator-seatunnel/issues/4367#issuecomment-1473458039
table schema:
CREATE TABLE `xxx` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`file_id` bigint(20) unsigned NOT NULL COMMENT '',
`file_version` bigint(20) NOT NULL COMMENT '',
`file_content` longtext COMMENT '文件内容',
`commit_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',
`commit_user` varchar(250) NOT NULL COMMENT '',
`comment` text COMMENT '',
`schedule_content` longtext COMMENT '',
`schedule_uuid` varchar(512) NOT NULL DEFAULT '' COMMENT '',
`file_type` int(11) NOT NULL COMMENT '',
`use_type` int(11) NOT NULL COMMENT '',
`file_desc` varchar(250) NOT NULL DEFAULT '' COMMENT '',
`file_name` varchar(512) NOT NULL DEFAULT '' COMMENT '',
`status` int(11) NOT NULL COMMENT '',
`change_type` int(11) NOT NULL COMMENT '',
`is_current_prod` int(11) NOT NULL DEFAULT '0' COMMENT '',
`project_id` bigint(20) unsigned NOT NULL COMMENT '项目id',
`file_property_content` longtext COMMENT '',
`parent_file_id` bigint(20) NOT NULL DEFAULT '0' COMMENT ',
`wrap_content` longtext COMMENT '',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_fid_fversion` (`file_id`,`file_version`),
KEY `idx_uuid_version` (`file_version`,`schedule_uuid`),
KEY `idx_commituser_status` (`commit_user`,`status`),
KEY `idx_project_id` (`project_id`),
KEY `idx_fid_currentprod` (`file_id`,`is_current_prod`) USING BTREE,
KEY `idx_schedule_uuid_is_current_prod_change_type`
(`schedule_uuid`,`is_current_prod`,`change_type`),
KEY `idx_is_current_prod` (`is_current_prod`)
) ENGINE=InnoDB AUTO_INCREMENT=42400405 DEFAULT CHARSET=utf8mb4
COMMENT='文件版本表'
Hive
CREATE TABLE `xxx`(
`id` string COMMENT '自增主键',
`file_id` string COMMENT '',
`file_version` bigint COMMENT '',
`file_content` string COMMENT '',
`commit_time` timestamp COMMENT '',
`commit_user` string COMMENT '',
`comment` string COMMENT '',
`schedule_content` string COMMENT '',
`schedule_uuid` string COMMENT '',
`file_type` bigint COMMENT '',
`use_type` bigint COMMENT '',
`file_desc` string COMMENT '',
`file_name` string COMMENT '',
`status` bigint COMMENT '',
`change_type` bigint COMMENT '',
`is_current_prod` bigint COMMENT '',
`project_id` string COMMENT '项目id',
`file_property_content` string COMMENT '',
`parent_file_id` bigint COMMENT '',
`wrap_content` string COMMENT '')
COMMENT 'xxx'
PARTITIONED BY (
`dt` string COMMENT '')
ROW FORMAT SERDE
'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
