JDBC Driver for Apache Hive

Build 22.0.8462

Troubleshooting

Troubleshooting the Connection

To show driver activity from query execution to network traffic, use Logfile and Verbosity. The examples of common connection errors below show how to use these properties to get more context.

Contact the support team for help tracing the source of an error or circumventing a performance issue.

  • Connection errors: Ensure that you have properly set TransportMode, Port, and if necessary HTTPPath to the values configured in the Apache Hive configuration file (hive-site.xml).
  • Authentication errors: Ensure that you have correctly set AuthScheme along with any corresponding properties, to the values configured in the Apache Hive configuration file (hive-site.xml).
  • Queries time out: A server that takes too long to respond will exceed the driver's client-side timeout. Often, setting the Timeout property to a higher value will avoid a connection error.

    Another option is to disable the timeout by setting the property to 0. Setting Verbosity to 2 will show where the time is being spent.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462