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);
文章来源地址https://www.toymoban.com/news/detail-736878.html
文章来源:https://www.toymoban.com/news/detail-736878.html
到了这里,关于扔两个hive语句的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!