hive sql常用语句

#count查询
SELECT COUNT(*) FROM default.test_2 WHERE ds="2021-08-11";

#插入数据
insert into table default.test_2 partition(ds="{{ds}}") select "xiaoming1","551";

#删除数据
INSERT OVERWRITE TABLE default.test_2 partition(ds="{{ds}}") SELECT name,no FROM default.test_2 WHERE ds="{{ds}}" and name != "xiaoming4";

#lateral VIEW explode查询
select t1,tt,t3 from default.explode_split_test1 lateral VIEW explode(split(t2, ‘;‘)) tmptable as tt