Jdbc-type-settings> With the same drivers(Jar files), I'm able to connect to HBase database with the Python script which is included as part of Phoenix Downloads. The HBase ODBC Driver is a powerful tool that allows you to connect with Apache HBase columnar databases, directly from any applications that support ODBC connectivity.
I'm learning about HBase, which is written in Java and therefore has a Java API. I assumed it also supported JDBC but it looks like it doesn't, and now I'm thinking I don't really understand what JDBC means.
What is the difference? What can I do with a Java API that I can't do with JDBC and vice versa?
user1956609user1956609
2 Answers
It is a design choice. Extract from HBase presentation : Use Apache HBaseâ„¢ when you need random, realtime read/write access to your Big Data. This project's goal is the hosting of very large tables -- billions of rows X millions of columns -- atop clusters of commodity hardware. Apache HBase is an open-source, distributed, versioned, non-relational database ...
So the creators of the project focused on their concern (BigData) and provided an API that does not directly support SQL, but is intended to be efficient in BigData context.
Accessing HBase through a JDBC driver is indeed possible, but is another project : Apache Phoenix : Apache Phoenix is a relational database layer over HBase delivered as a client-embedded JDBC driver targeting low latency queries over HBase data. Apache Phoenix takes your SQL query, compiles it into a series of HBase scans, and orchestrates the running of those scans to produce regular JDBC result sets.
Jdbc Drivers For Netbeans Download
For reference, JDBC is a standard API that allows access to a database through SQL language in a database independant way. In that sense, JDBS is a Java API, but database authors can provide other Java API ...
JDBC is the standard API for access to relational database supporting SQL, like MySQL, Oracle, H2 ...
HBase is not a Relational Database and doesn't support SQL for queries, so it can't implement JDBC. It has a custom API to access it with Java called Java API inside HBase docs.
ToilalToilal
Not the answer you're looking for? Browse other questions tagged javahbase or ask your own question.
Active6 years ago
I have a problem. I want to connect to hbase with java. I found some things about connecting to java, as datanocleos. I want to connect with java jdbc but I think there is not any hbase jdbc driver.can anyone know how to do it? help me please..
AsmaAsma
2 Answers
this is what you need
Phoenix: A SQL skin over HBase'We put the SQL back in NoSQL'Phoenix is a SQL skin over HBase, delivered as a client-embedded JDBC driver, powering the HBase use cases at Salesforce.com. Phoenix targets low-latency queries (milliseconds), as opposed to batch operation via map/reduce. To see what's supported, go to our language reference guide, read more on our wiki, and download it.
Mehul RathodMehul Rathod
You may use 3rd party clients like Playorm which has just started supporting Hbase. Visit http://buffalosw.com/products/playorm/