question JDBC connection with your HBase bypassing the Phoenix driver in Archives of Support Questions (Read Only)

JDBC connection with your HBase bypassing the Phoenix driver

bandarusridhar1 — Thu, 01 Sep 2016 22:32:58 GMT

Hi,

When I'm trying to establish connection between HBase, It looks like when you try to do the native HBase connection in metadata, HBase server requires the JDBC connection to go through the Phoenix driver so that we can establish the connection. Is there anyway if we can establish a JDBC connection with your HBase bypassing the Phoenix driver?

If yes, please share me the steps or document where I can get process to establish connection between HBase and Talend etc.,

Thanks in advance.

Re: JDBC connection with your HBase bypassing the Phoenix driver

elserj — Thu, 01 Sep 2016 22:37:11 GMT

Phoenix provides the JDBC connection to HBase (in addition to the SQL 'skin'). There is no JDBC interface provided by Apache HBase.

Re: JDBC connection with your HBase bypassing the Phoenix driver

rgelhausen — Thu, 01 Sep 2016 22:40:01 GMT

The PhoenixDriver is what provides the JDBC interface to HBase to begin with.

I'm not aware of any JDBC HBase driver that doesn't involve Phoenix.

Re: JDBC connection with your HBase bypassing the Phoenix driver

bandarusridhar1 — Thu, 01 Sep 2016 23:23:06 GMT

@Josh Elser @Randy Gelhausen

Thanks for the quick reply. If I don't install Phoneix Query Server then is it possible to establish JDBC connection?

@Ted Yu

Re: JDBC connection with your HBase bypassing the Phoenix driver

elserj — Thu, 01 Sep 2016 23:38:29 GMT

Yes. The Phoenix JDBC does not require the Phoenix Query Server. The Phoenix Query Server provides a "thin" JDBC driver.