Re: [D] Kyuubi ODBC Example [kyuubi]

["AlexSpecflow (via GitHub)" <gi...@apache.org>]

GitHub user AlexSpecflow added a comment to the discussion: Kyuubi ODBC Example

Hi.

raising this old question. Is there any progress on getting support of connectivity to Kyuubi through an ODBC driver?
My case is to query Kyuubi from a .net core application (.net 8).
How can i do that? Is there any cost-free or commercial ODBC driver that allows to connect to Kyuubi ?

https://kyuubi.readthedocs.io/en/v1.11.0/index.html
In the documentation is mentioned this:
_A HiveServer2-compatible interface that allows end users to use a thrift client(cross-language support, both tcp and http), a [Java Database Connectivity(JDBC)](https://kyuubi.readthedocs.io/en/v1.11.0/client/jdbc/index.html) interface over thrift, or an [Open Database Connectivity (ODBC)](https://kyuubi.readthedocs.io/en/v1.11.0/client/odbc/index.html) interface over a JDBC-to-ODBC bridge to communicate with Kyuubi._

Given this - i tried "Cloudera ODBC Driver for Apache Hive" from my .net 8 app (which BTW successfully retrieves data from Hive), but got:
`System.Data.Odbc.OdbcException HResult=0x80131937 Message=ERROR [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. ERROR [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.[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. Source= StackTrace: at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, SQLRETURN retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) at System.Data.Odbc.OdbcC
 onnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)`

However, i am able to retrieve data successfully using "beeline" tool or Dbeaver through a JDBC interface (connection parameters like host, port, etc - are the same as in my unsuccessful attempt to get data from the .net app).

PS: i also tried "Databricks ODBC Driver", but the result is the same.

GitHub link: https://github.com/apache/kyuubi/discussions/5355#discussioncomment-15960306

----
This is an automatically sent email for notifications@kyuubi.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@kyuubi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org