Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The full adbc connection URL syntax for phoenix is:

Code Block
titleBasic Connections
jdbc:phoneix[:zk_quorum][:zk_port][:zk_hbase_path]

...

Code Block
titleSample JDBC URL
jdbc:phoenix:m1.hdp.local,m2.hdp.local,d1.hdp.local:2181:/hbase-unsecure
Code Block
titleFor Kerberos Cluster Connections
jdbc:phoneix[:zk_quorum][:zk_port][:zk_hbase_path][:headless_keytab_file:principal]
Code Block
titleSample JDBC URL
jdbc:phoenix:m1.hdp.local,m2.hdp.local,d1.hdp.local:2181:/hbase-secure:/Users/dstreev/keytabs/myuser.headless.keytab:dstreev@HDP.LOCAL
Warning

They say that the above items in the url beyond 'phoenix' are optional if the clusters 'hbase-site.xml' for is in the path. I found that when I presented a copy of the 'hbase-site.xml' from the cluster and left off the optional elements, I got errors referencing 'Failed to create local dir'.

Info

When I connected successfully from DBVisualizer to HBase with the Phoenix JDBC Driver, it took about 10-20 seconds to connect.

 

Check out Phoenix Connections via sqlline.py to Kerberized HBase