hql解析

hql 执行顺序

1. FROM (ON) (JOIN)

2. WHERE

3. GROUP BY

4. HAVING

5. SELECT (DISTINCT) (DISTRIBUTE BY)/(CLUSTER BY)/(SORT BY)

6. ORDER BY (LIMIT) (UNION)/(UNION ALL)

解析得到的类型

1. use default

   TOK_SWITCHDATABASE

2. create table

   TOK_CREATETABLE

3. set hive.exec.compress.output=false

   not support

4. set hivevar:ds=2016-01-01;

   not suppoort

5. test nott support

6. insert overwrite table test1 select id from test2

   TOK_QUERY

7. with 语句 TOK_QUERY

8. alter table TOK_ALTERTABLE

9. drop table TOK_DROPTABLE

10. truncatee tablee TOK_TRUNCATETABLE

TOK_SWITCHDATABASE TOK_QUERY TOK_CREATETABLE TOK_TRUNCATETABLE TOK_DROPTABLE TOK_ALTERTABLE

hive 执行计划

hive 执行计划

hive 执行计划 写的不错

https://www.2cto.com/net/201701/587186.html

Hive SQL执行计划深度解析