CREATE EXTERNAL TABLE `dws.外表name`(
`id` string COMMENT 'from deserializer',
`create_by` string COMMENT 'from deserializer',
`create_at` timestamp COMMENT 'from deserializer',
`update_by` string COMMENT 'from deserializer',
`update_at` timestamp COMMENT 'from deserializer',
`position_top` int COMMENT 'from deserializer',
`position_left` int COMMENT 'from deserializer',
`materiel_group_child_id` string COMMENT 'from deserializer',
`drawing_no` string COMMENT 'from deserializer',
`width` int COMMENT 'from deserializer',
`height` int COMMENT 'from deserializer',
`drawing_type` string COMMENT 'from deserializer')
ROW FORMAT SERDE
es和hive外部表映射
最新推荐文章于 2023-09-08 15:58:23 发布