About
SQL - Query (SELECT) in Hive.
The SQL language of Hive is called hiveql.
Articles Related
Management
Language
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select
Explain
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Explain
Diagnostic
The query log is engine dependent.
For instance for Tez: https://headnode/#/main/view/TEZ/tez_cluster_instance
where: