unionall
Hive优化案例
user_info_txt (s_id string,s_name string,s_birthday string,s_age string
,s_sex string ,s_money string ,s_com string )
user_brand_txt (s_id string,brand string,order_time string,s_title string )
DROP TABLE if EXISTS user_stat; create table user_stat(a int, b int) partitioned by (tp string)
STORED AS TEXTFILE;set hive.exec.dynamic.partition=true; set
hive.exec.dynamic.partition.mode=nonstrict;
unionall
user_info_txt (s_id string,s_name string,s_birthday string,s_age string
,s_sex string ,s_money string ,s_com string )
user_brand_txt (s_id string,brand string,order_time string,s_title string )
DROP TABLE if EXISTS user_stat; create table user_stat(a int, b int) partitioned by (tp string)
STORED AS TEXTFILE;set hive.exec.dynamic.partition=true; set
hive.exec.dynamic.partition.mode=nonstrict;
unionall
user_info_txt (s_id string,s_name string,s_birthday string,s_age string
,s_sex string ,s_money string ,s_com string )
user_brand_txt (s_id string,brand string,order_time string,s_title string )
DROP TABLE if EXISTS user_stat; create table user_stat(a int, b int) partitioned by (tp string)
STORED AS TEXTFILE;set hive.exec.dynamic.partition=true; set
hive.exec.dynamic.partition.mode=nonstrict;
评论0
最新资源