hive sql 语法总结

1、limit 语句

限制返回的行数

2、列别名

 count(1) as times 

3、嵌套select语句

 select xxx from (select xx from table1 ) a ;

4、case ...when ...then语句

用户处理单个列的查询结果

select name,
  case 
   when salay <50000 then 'low'
   when salay >=50000 and salary <70000 then 'middle'
   else 'high'
  end as bracket from employee;

 

转载于:https://my.oschina.net/u/2874009/blog/895968