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
原文：https://www.cnblogs.com/to-here/p/15158552.html