describe formatted lqc_part;
CREATE TABLE `lqc_part4`
(`part_1` STRING COMMENT 'part_1',
`other_2` INT COMMENT 'other_2',
`part_3` STRING COMMENT 'part_3',
`part_4` STRING COMMENT 'part_4',
`part_5` STRING COMMENT 'part_5',
`part_field4` STRING4 COMMENT 'part_field4') COMMENT 'lqc_part'
PARTITIONED BY( `part_field5` STRING COMMENT'part_field5' )
ROW FORMAT DELIMITED FIELDS TERMINATED BY ' ' STORED AS ORCFILE
ALTER TABLE `test3_gx_sx` add if not exists
partition(col7_p2='5457_5',col8_time='2021-01-09')
partition(col7_p2='55_15',col8_time='2022-11-02')
alter table mysql_type__copy1 partition column (decimal_fq STRING);
扔两个hive语句
最新推荐文章于 2024-07-25 16:47:15 发布