摘要:
1.执行参数优化 --分区 SET hive.exec.dynamic.partition=true; SET hive.exec.dynamic.partition.mode=nonstrict; set hive.exec.max.dynamic.partitions.pernode=10000 阅读全文
摘要:
一、临时表创建技巧: drop view mytab2; create or replace view mytab2 as select 1 as c1 union all select 2 as c1 union all select 3 as c1 ; --1、子查询 select * , c1 阅读全文