# impala提升查询速度
compute stats tableName;
# 查看分区情况
show partitions tableName;
# 建分区表
create table tableName (字段) partitioned by (labs_etl_dt string);
# 向分区表里插数据
insert overwrite table tableName partition(labs_etl_dt)
# 将一列中多个元素打散成单个
select rename,age from demo lateral view explode(split(name,',')) demo as rename;
IMPALA跟HIVE实践中的小绝招
于 2022-11-30 18:05:25 首次发布