liunaijie commented on issue #6178: URL: https://github.com/apache/seatunnel/issues/6178#issuecomment-1888493440
> > as the exception said: now for hive table, we only support text, parquet, orc table format. if your table format is something else, you will get this exception. what's your table format? > > The table format is roughly like this. In order to prevent it from being too confusing, I deleted some repeated fields. > > CREATE TABLE `test_table` ( `ID` bigint NOT NULL AUTO_INCREMENT, `GET_TIME` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `is_deleted` int NOT NULL DEFAULT 0 COMMENT '是否删除 0：未删除 1：已删除', `STARTDATE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开始时刻', PRIMARY KEY (`ID`) USING BTREE, INDEX `idx_get_time`(`GET_TIME` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26282 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; this exception is write/sink error. you should check your hive table format instand of source mysql table. -- 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]
