With Hive JDBC Drive，I connect to Kyuubi by service discovery mode and return the hive address？

[winfys]

Class.forName("org.apache.kyuubi.jdbc.KyuubiDriver");
            Connection conn = DriverManager.getConnection("jdbc:hive2://xxx.xxx.xxx.xxx:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNameSpace=kyuubi","test","test");

I use the above address to link to Kyuubi, but it returns the address of Hiveserver, what should I do

[pan3793]

What's your expected behavior?

[winfys]

The expected return address of Kyuubi is port 10009, but the returned port is 10000

[pan3793]

Could you please check the znodes under /kyuubi?

[winfys]

[zk: localhost:2181(CONNECTED) 0] ls /kyuubi [serviceUri=xxx:10009;version=1.3.1-incubating;sequence=0000000025] [zk: localhost:2181(CONNECTED) 1] get /kyuubi xxx.xxx.xxx.174
This is the information obtained from zookeeper

[pan3793]

We have UT to ensure that Kyuubi Hive JDBC driver works as expected in HA mode, please provides a reproducible steps if you think it doesn't work.

[cfmcgrady]

zooKeeperNamespace is case-sensitive. please try

Class.forName("org.apache.kyuubi.jdbc.KyuubiDriver");
Connection conn = DriverManager.getConnection("jdbc:hive2://xxx.xxx.xxx.xxx:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=kyuubi","test","test");

[pan3793]

zooKeeperNamespace is case-sensitive.

As we copied the Hive JDBC driver source code to Kyuubi repo, seems we can enhance it to make it be case-insensitive, WDYT @yaooqinn?

[cfmcgrady]

There is a bug in the current official documents and has already been fixed by PR-1320.

[yaooqinn]

zooKeeperNamespace is case-sensitive.

As we copied the Hive JDBC driver source code to Kyuubi repo, seems we can enhance it to make it be case-insensitive, WDYT @yaooqinn?

I'm ok with this suggestion

[winfys]

The problem has been resolved because the hostname of my zookeeper node is incorrectly configured，Thanks