- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Managing Hive Query Log Files
- Labels:
-
Apache Hive
Created 05-25-2017 08:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I want to see want to see Hive CLI log all SQL queries that are issued to MySQL.
Created 05-26-2017 03:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can check all query logs of Hive session from log file under /tmp as,
/tmp/<Username>/hive.log
Please check.
Created 08-17-2017 09:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
/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
Created 05-26-2017 04:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nope.. I can't see anything @nshelke
Created 05-26-2017 05:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
mysql can enable query logging https://dev.mysql.com/doc/refman/5.7/en/query-log.html
Created 05-26-2017 06:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Timothy Spann cannot find the patterns in mysql log
Created 05-26-2017 08:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.