Load Hive partition from Hive view -
i have external hive table 4 partitions. have 4 hive views based on different hive table.
every week want hive view overwrite partitions in external hive table.
i know can create unpartitioned hive table view show below create table hive_table select * hive_view;
but there way overwrite partitions view data?
yes, there way:
insert overwrite table <table_name> partition(<partition_clause>) select <select_clause> it required set hive.exec.dynamic.partition true before such operations. see details here: hive language manual dml - dynamic partitions
view hive partition
No comments:
Post a Comment