Managing Hive Query Log Files

[#1]

I want to see want to see Hive CLI log all SQL queries that are issued to MySQL.

[#2]

@Stinger

You can check all query logs of Hive session from log file under /tmp as,

/tmp/<Username>/hive.log

Please check.

[#3]

@nshelke

• /tmp/${user.name} in Hive 0.2.0 through 0.8.0
• /tmp/hive-${user.name} in Hive 0.8.1 through 0.14.0
• /tmp/hive in Hive 0.14.0 and later

[#4]

Nope.. I can't see anything @nshelke

[#5]

mysql can enable query logging https://dev.mysql.com/doc/refman/5.7/en/query-log.html

[#6]

@Timothy Spann cannot find the patterns in mysql log

[#7]

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.