Tutorial > HBase Client > Hare > Export the Result of Running Hare Query

What is Hare?

Hare is hiveQL+HBase Coprocessor.

We can use hiveQL which is a subset of ANSI SQL to query data.


Why Hare?

The reson is high speed and easy install.

Hare is using hiveQL, but 3~80X faster than hive.

Actually, you don't have to do anything about installation.

All you have to do is install this client tool and regist the coprocessor "BaseHiveQLEndpoint".


For Example

We have data like this.

We input " select * from k1 where cf:city='Tainan' "

"k1" is htable name.

"cf:city" is column family + qualifier name.

Be carefull of the case of character in spelling.

It is case sensitive.


What do we support right now ?

SELECT [ ALL | DISTINCT] select_expr as alias, select_expr, ...
FROM table_reference
[WHERE where_condition]
[GROUP BY col_list [HAVING condition]]
[SORT B​​Y | ORDER BY col_list]
[LIMIT number]

Where Condition

Logical Operators

AND、OR、&&、 || 、NOT A

Relational Operators

A = B、A <=> B
A <> B、A != B
A < B、A <= B、A > B、A >= B
A IS NULL、A IS NOT NULL
A LIKE B
A RLIKE B
A REGEXP B

Aggregate Functions

count(*), count(expr), count(DISTINCT expr[, expr_.])
sum(col), sum(DISTINCT col)
avg(col), avg(DISTINCT col)
min(col), max(col)