hive处理表分区

最新推荐文章于 2023-10-23 10:34:31 发布

原创最新推荐文章于 2023-10-23 10:34:31 发布 · 199 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#hive #spark

bigdata 专栏收录该内容

60 篇文章

订阅专栏

msck

MSCK [REPAIR] TABLE table_name [ADD/DROP/SYNC PARTITIONS];

只是为了方便,并不需要考虑性能则可以直接用 msck repair table table_name;

alter table table_name …

ALTER TABLE table_name ADD [IF NOT EXISTS] PARTITION partition_spec [LOCATION ‘location’][, PARTITION partition_spec [LOCATION ‘location’], …];


ALTER TABLE page_view ADD PARTITION (dt='2008-08-08', country='us') location '/path/to/us/part080808'
                          PARTITION (dt='2008-08-09', country='us') location '/path/to/us/part080809';

partition_spec:

(partition_column = partition_col_value, partition_column = partition_col_value, …)

ALTER TABLE table_name DROP [IF EXISTS] PARTITION partition_spec[, PARTITION partition_spec, …]
[IGNORE PROTECTION] [PURGE]; – (Note: PURGE available in Hive 1.2.0 and later, IGNORE PROTECTION not available 2.0.0 and later)