I want to see want to see Hive CLI log all SQL queries that are issued to MySQL.
Hive uses the MySQL jdbc connector for issuing queries to MySQL. You can turn on logging through the jdbc connection url (append &profileSQL=true&logger=com.mysql.jdbc.log.StandardLogger) you are using to connect to mysql db in hive-site.xml.
To turn it on the MySQL server you need to set the following in the my.cnf.
general_log = 1 general_log_file = /path/to/query.log
See more information here.