Quilian commented on issue #8548:
URL: https://github.com/apache/seatunnel/issues/8548#issuecomment-2712912227
> Can you describe the structure of your table flight. fz?
CREATE TABLE `fz_location` (
`id` varchar(50) NOT NULL,
`vehicle_plate` varchar(50) NOT NULL COMMENT '车牌',
`alarm_sign` int unsigned DEFAULT NULL COMMENT '标志位',
`state` int DEFAULT NULL COMMENT '状态位',
`longitude` double DEFAULT NULL COMMENT '以度为单位的经度',
`latitude` double DEFAULT NULL COMMENT '以度为单位的纬度',
`latlng` geometry NOT NULL COMMENT '经纬度',
`altitude` int DEFAULT NULL COMMENT '海拔高度',
`location_speed` int DEFAULT NULL COMMENT '1 / 10km/ h',
`direction` int DEFAULT NULL COMMENT '顺时针',
`location_time` datetime NOT NULL COMMENT '时间',
`attach_flag` int DEFAULT NULL COMMENT '附加信息位',
`mileage` int DEFAULT NULL COMMENT '里程',
`oil` int DEFAULT NULL COMMENT '油量',
`pulse_speed` int DEFAULT NULL COMMENT '行速度',
`in_fz` int DEFAULT NULL COMMENT '0-否，1-是',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_plate_time` (`vehicle_plate`,`location_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=COMPACT COMMENT='位置';
--
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-unsubscr...@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
