Member since
06-13-2025
1
Post
0
Kudos Received
0
Solutions
09-25-2025
10:45 PM
Hi team, I am currently facing issue connecting to Hive database using python libraries (pyodbc, pyhive, impyla), the Cloudera driver and Apache Knox. While the network level connection to the relevant host and port is successful. (verified via ncat, telnet), I am unable to complete the connection and authenticate through these tools. Connection details: Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so;" "Host=nonprodm01.cdslindia.com;" "Port=8443;" "Schema=default;" "TransportMode=http;" "HTTPPath=/gateway/default/hive" "SSL=0;" # Enable SSL if Knox uses HTTPS "AuthMech=3;" # For username/password authentication; use 1 for no auth or 2 for Kerberos "UID=username;" "PWD=password;" Knox gateway is used to access HiveServer2 Error message: Connection failed: "('HY000', '[HY000] [Cloudera][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection. (1110) (SQLDriverConnect)')." Could you please assist in identifying the correct parameters (such as HTTPPath, transport_mode, SSL, etc) or guide me to connect through Knox with these clients. Thank you for your support. Kind regards, Kedar Nandiwdekar CDSL Email: kedar.intern@cdslindia.com M: +91 8452806087
... View more
Labels:
- Labels:
-
Apache Knox
-
Apache Zookeeper