Hadoop教程Hive执行过程.pptVIP

SELECT A.MEMBER_ID,COUNT(*) FROM A JOIN B ON A.MEMBER_ID=B.MEMBER_ID GROUP BY A.MEMBER_ID HAVING COUNT(*)1 statement : explainStatement EOF | execStatement EOF ; execStatement @init { msgs.push(statement); } @after { msgs.pop(); } : queryStatementExpression | loadStatement | ddlStatement ; queryStatementExpression : queryStatement (queryOperator^ queryStatement)* ; queryStatement : fromClause ( b+=body )+ - ^(TOK_QUERY fromClause body+) | regular_body ; SELECT A.MEMBER_ID,COUNT(*) FROM A JOIN B ON A.MEMBER_ID=B.MEMBER_ID GROUP BY A.MEMBER_ID