How to enable debug logging on the Hive CLI in Pivotal HD

Products

• Services Suite

Issue/Introduction

While troubleshooting connection or performance issues with the Hive CLI, it may be necessary to enable debug logging on the Hive client to fully understand the issue.

Environment

Resolution

Follow the steps below to enable debug logging on the Hive CLI:
 

1. Close the current Hive CLI session.

2. Reconnect to the Hive CLI using the following command and options:

hive -hiveconf hive.log.file=debug_hive.log -hiveconf hive.log.dir=/tmp/hiveCLI -hiveconf hive.root.logger=DEBUG,DRFA

3. Reproduce the issue.

4. Review the log /tmp/hivecli/hivecli_debug.log.

Note: The KB article "Hive CLI hangs for an extended period of time then fails with "No Route to Host""  may be useful if troubleshooting connectivity issues.