HiveSQL执行流程：InputFormat、OutputFormat、SerDe理清这三者之间的关系：SerDe is a shor...

SELECT e.id,e.date,e.people FROM (SELECT id, s.date, @sdate1 := (CASE WH...

SELECT d.Name AS Department, e1.Name AS Employee, e1.Salary FROM Employe...

SELECT DATE( CREATE TIME ) 日期, COUNT( USER_ID ) 每日新增用户 FROM USER GROUP B...

SELECT CITY_ID 城市 , count( DISTINCT ( USER_ID ) ) CITY_ID 最近7天内下过单的用户数 F...