with Hive JDBC How to get the Kyuubi JDBC driver Kyuubi Thrift API is fully compatible with HiveServer2, so technically, it allows any Hive JDBC driver to connect with Kyuubi Server. But it's recommended HDFS cluster correctly, you should be able to run the Hive SQL example on YARN. $ SHIVE_HOME/bin/hiveserver2 # In another terminal $ SHIVE_HOME/bin/beeline -u 'jdbc:hive2://localhost:10000/default' is to replace HiveServer2/Hive QL with Kyuubi/Spark SQL. If an existing HiveServer2 environment is already there, copying the environment and reusing the keytab and principal of HiveServer2 is a convenient

Kubernetes Tools Spark Block Cleaner ## Kyuubi Insider • Overview ○ Architecture ○ Kyuubi v.s. HiveServer2 • Kyuubi v.s. Spark Thrift JDBC/ODBC Server (STS). ## Contributing • Develop Tools ○ 1. Building using simple authentication to HiveServer2 on localhost:10000 $ beeline -u jdbc:hive2://localhost:10000 username password 2. Connect using simple authentication to HiveServer2 on hs.local:10000 using -n for hive/localhost@mydomain.com as HiveServer2 principal $ beeline -u "jdbc:hive2://hs2.local:10013/default;principal=hive/localhost@mydomain.com" 4. Connect using SSL connection to HiveServer2 on localhost at 10000

Kubernetes Tools Spark Block Cleaner ## Kyuubi Insider • Overview ○ Architecture ○ Kyuubi v.s. HiveServer2 • Kyuubi v.s. Spark Thrift JDBC/ODBC Server (STS). ## Contributing • Develop Tools ○ 1. Building using simple authentication to HiveServer2 on localhost:10000 $ beeline -u jdbc:hive2://localhost:10000 username password 2. Connect using simple authentication to HiveServer2 on hs.local:10000 using -n for hive/localhost@mydomain.com as HiveServer2 principal $ beeline -u "jdbc:hive2://hs2.local:10013/default;principal=hive/localhost@mydomain.com" 4. Connect using SSL connection to HiveServer2 on localhost at 10000

Kubernetes Tools Spark Block Cleaner ## Kyuubi Insider • Overview ○ Architecture ○ Kyuubi v.s. HiveServer2 • Kyuubi v.s. Spark Thrift JDBC/ODBC Server (STS). ## Contributing • Develop Tools ○ 1. Building using simple authentication to HiveServer2 on localhost:10000 $ beeline -u jdbc:hive2://localhost:10000 username password 2. Connect using simple authentication to HiveServer2 on hs.local:10000 using -n for hive/localhost@mydomain.com as HiveServer2 principal $ beeline -u "jdbc:hive2://hs2.local:10013/default;principal=hive/localhost@mydomain.com" 4. Connect using SSL connection to HiveServer2 on localhost at 10000

Kubernetes Tools Spark Block Cleaner ## Kyuubi Insider • Overview ○ Architecture ○ Kyuubi v.s. HiveServer2 • Kyuubi v.s. Spark Thrift JDBC/ODBC Server (STS). ## Contributing • Develop Tools ○ 1. Building using simple authentication to HiveServer2 on localhost:10000 $ beeline -u jdbc:hive2://localhost:10000 username password 2. Connect using simple authentication to HiveServer2 on hs.local:10000 using -n for hive/localhost@mydomain.com as HiveServer2 principal $ beeline -u "jdbc:hive2://hs2.local:10013/default;principal=hive/localhost@mydomain.com" 4. Connect using SSL connection to HiveServer2 on localhost at 10000

using simple authentication to HiveServer2 on localhost:10000 $ beeline -u jdbc:hive2://localhost:10000 username password 2. Connect using simple authentication to HiveServer2 on hs.local:10000 using -n for local:10013/default;principal=hive/localhost@mydomain.com" 4. Connect using SSL connection to HiveServer2 on localhost at 10000 $ beeline "jdbc:hive2://localhost:10000/default;ssl=true;sslTrustSto local test auth_username=chengpan [notebook] [[interpreters]] [[sql]] name=SparkSQL interface=hiveserver2 [spark] # Host of the Spark Thrift Server # For macOS users, use docker.for.mac.host.internal to

using simple authentication to HiveServer2 on localhost:10000 $ beeline -u jdbc:hive2://localhost:10000 username password 2. Connect using simple authentication to HiveServer2 on hs.local:10000 using -n for local:10013/default;principal=hive/localhost@mydomain.com" 4. Connect using SSL connection to HiveServer2 on localhost at 10000 $ beeline "jdbc:hive2://localhost:10000/default;ssl=true;sslTrustSto local test auth_username=chengpan [notebook] [[interpreters]] [[sql]] name=SparkSQL interface=hiveserver2 [spark] # Host of the Spark Thrift Server # For macOS users, use docker.for.mac.host.internal to

Kubernetes Tools Spark Block Cleaner ## Kyuubi Insider ## • Overview ○ Architecture o Kyuubi v.s. HiveServer2 o Kyuubi v.s. Spark Thrift JDBC/ODBC Server (STS). ## Contributing ## • Develop Tools ○ 1. Building using simple authentication to HiveServer2 on localhost:10000 $ beeline -u jdbc:hive2://localhost:10000 username password 2. Connect using simple authentication to HiveServer2 on hs.local:10000 using -n for hive/localhost@mydomain.com as HiveServer2 principal $ beeline -u "jdbc:hive2://hs2.local:10013/default;principal=hive/localhost@mydomain.com" 4. Connect using SSL connection to HiveServer2 on localhost at 10000

using simple authentication to HiveServer2 on localhost:10000 $ beeline -u jdbc:hive2://localhost:10000 username password 2. Connect using simple authentication to HiveServer2 on hs.local:10000 using -n for hive/localhost@mydomain.com as HiveServer2 principal $ beeline -u "jdbc:hive2://hs2.local:10013/default;principal=hive/localhost@mydomain.com" 4. Connect using SSL connection to HiveServer2 on localhost at 10000 local test auth_username=chengpan [notebook] [[interpreters]] [[sql]] name=SparkSQL interface=hiveserver2 [spark] # Host of the Spark Thrift Server # For macOS users, use docker.for.mac.host.internal to

Connectors For Trino SQL Engine ## Kyuubi Insider • Overview ○ Architecture o Kyuubi v.s. HiveServer2 o Kyuubi v.s. Spark Thrift JDBC/ODBC Server (STS) ## Contributing • Contributing Code Get Started with Hive JDBC ## How to get the Kyuubi JDBC driver Kyuubi Thrift API is fully compatible with HiveServer2, so technically, it allows to use any Hive JDBC driver to connect Kyuubi Server. But it’s recommended comma-separated list for all frontend protocols• THRIFT\_BINARY - HiveServer2 compatible thrift binary protocol.• THRIFT\_HTTP - HiveServer2 compatible thrift http protocol.• REST - Kyuubi defined REST API(experimental)