Hive用法
Hive基本用法
1.查看数据库/表,及其表结构
(1)show databases/tables;
(2)use database_name;
(3) desc table_name;
(4) desc formatted test;
2.Hive查询语句
(1)查询所有字段
select * from table;
(2)查询想要的字段
select a from table;
(3)只输出几条
select * from table limit 10;
(4)总记录查询
select count() from table;
3.函数查询
select max(a) from table;
select min(a) from table;
select sum(a) from table;
select avg(a) from table;
select count() from table;
4.group by …having…
5.Hive collect_set()排序和concat_ws()
concat_ws(’,’,sort_array(collect_set(actfrom))) as actsort
6.排名函数