[GitHub] [incubator-seatunnel] kyehe commented on issue #4367: [Bug] [Connector-V2][Hive] NullPointerException or IndexOutOfBoundsException when addRowBatch() executed.

["kyehe (via GitHub)" <gi...@apache.org>]

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: commits-unsubscribe@seatunnel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org