CODEWITHSUNDEEP
hadoophbasehive
user855
user855

Reputation: 19918

Are all hive queries supported when hive is backed by hbase?

I am primarily interested in GROUP BY, HAVING, AVG, PERCENTILE etc kind of aggregation functions.

If not, are there any alternatives to it?

Upvotes: 2

Views: 192

Answers (2)

Mark Grover
Mark Grover

Reputation: 4080

Those should all work. Hive table backed by HBase just uses a different storage handler as compared to a "regular" Hive table. However, as far as I know, a storage handler doesn't have any impact on what queries can be run through Hive.

Upvotes: 1

wlk
wlk

Reputation: 5785

https://cwiki.apache.org/Hive/languagemanual-udf.html is definitive list of UDF's and functions available in Hive.

Upvotes: 1

Related Questions