Hive高级查询(一)
1.select 基础select 用于映射符合指定查询条件的行Hive select是数据库标准SQL子集使用方法类似于Mysqlselect 1;select [distinct] column_name list from table_name;select * from table_name;select * from employee where name!='Lily' limit 5;2.CTE和嵌套查询CTE语法with t1 as (select ...) s
复制链接