GitHub user AlexSpecflow edited a comment on 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 the 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 [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
