question Hbase query best practice in Archives of Support Questions (Read Only)

Hbase query best practice

cui_lin — Sat, 12 Dec 2015 02:42:20 GMT

As Hbase has no its build-in query language, I'm wondering the best practice of hbase query..by spark, Phoenix, solar? We need select, group by, join operations mostly. How to decide which technique is right for our case?

Re: Hbase query best practice

nsabharwal — Sat, 12 Dec 2015 10:36:12 GMT

@Cui Lin

Apache Phoenix is really good.

https://phoenix.apache.org/

and

https://phoenix.apache.org/language/index.html

Re: Hbase query best practice

dkumar1 — Sun, 13 Dec 2015 06:16:29 GMT

Apache Phoenix is currently the only way to query HBase using SQL.

Re: Hbase query best practice

nsabharwal — Sun, 13 Dec 2015 06:53:13 GMT

@Cui Lin

and you can configure Squirel or DBVisualizer using phoenix jdbc driver.

http://www.dbvis.com/doc/8.0/doc/ug/installDriver/installDriver.html

Re: Hbase query best practice

gbraccialli3 — Tue, 15 Dec 2015 10:45:27 GMT

@Cui Lin

If you have to perform huge scans and joins between big tables, you can also consider creating hive tables using hbase storage handler and using hive to perform your sql queries.

See examples below:

https://community.hortonworks.com/questions/1558/bestoptimized-way-to-move-data-from-phoenix-to-hiv.html

https://community.hortonworks.com/questions/1652/how-can-i-query-hbase-from-hive.html

Re: Hbase query best practice

cui_lin — Wed, 16 Dec 2015 06:40:02 GMT

I tried Phoenix and installed it according to the instruction, but I got the following error message:

[root@cui-hdp-02 phoenix]# sqlline.py localhost Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix:localhost none none org.apache.phoenix.jdbc.PhoenixDriver Connecting to jdbc:phoenix:localhost

15/12/15 14:17:14 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable

15/12/15 14:17:14 WARN impl.MetricsConfig: Cannot locate configuration: tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties 15/12/15 14:17:15 ERROR client.ConnectionManager$HConnectionImplementation: The node /hbase is not in ZooKeeper. It should have been written by the master. Check the value configured in 'zookeeper.znode.parent'. There could be a mismatch with the one configured in the master.

My hbase's znode is by default defined as /hbase-unseure. How can i change phoenix to use current znode, instead of /hbase?

Re: Hbase query best practice

nsabharwal — Wed, 16 Dec 2015 06:42:03 GMT

@Cui Lin Could you accept one of the answers related to originial question and post this as new thread? It will help to keep the flow clean.