“Lucy, you got some ‘splainin’ to do!”
- Ricky Ricardo
Syntax: EXPLAIN [EXTENDED|DEPENDENCY|AUTHORIZATION] query
To get an EXPLAIN, you can either type the word EXPLAIN in front of any Hadoop SQL or click on the magnifying glass of Nexus. Hive provides an EXPLAIN command designed to show the user the execution plan for a query being explained. The EXPLAIN plan is designed to show the user exactly how Hive translates queries into MapReduce jobs.
An Abstract Syntax Tree is really the internalsource code that is represented as a tree of nodes. ...