How to connect to hbase?

Question

Hi I have a question actually in big data platform. We can connect to hive through beeline(beeline commands) in putty or odbc connection with any GUI Sql tools. But how can we connect to Hbase? As per my understanding we have Hbase in Shell format or in Java API format. But how do we connect to Hbase?

Answer 1

You can start the HBase interactive shell using “hbase shell” command as shown below. first you need to go to hadoop cluster (by ssh or putty etc... based on your environment) where hbase is installed and execute below.

hbase shell

• Apache HBase Browser App added in Hue 2.5 if you are using cloudera.

• You can also use Apache Pheonix to connect to hbase to do operations programatically Use JDBC to get a connection to an HBase cluster like this:

  Connection conn = DriverManager.getConnection("jdbc:phoenix:server1,server2:3333",props); see the phoenix docs..

• other tools which are not so popular are 1.hbaseexplorer 2.Toad for Cloud Databases 3.HareDB HBase Client 4.hrider