CODEWITHSUNDEEP
sqlhbasevertica
user1484616
user1484616

Reputation: 1

Adding SQL functions to HBase

We use a lot of SQL at my office but we want to move to HBase eventually since its the new wave of technology. But SQL has things like grouping and aggregation functions and equations that HBase doesn't, and we're looking into how we can put that functionality into HBase. I've looked around a lot but haven't found anything too useful to start my implementation. Are there any suggestions on how we could port SQL functions into HBase? Is it even possible?

Upvotes: 0

Views: 1373

Answers (5)

Praveen Kumar K R
Praveen Kumar K R

Reputation: 1860

Use Phoenix SQL,It has fast performance due to use of server side co-processor for data aggregation, query parallelization for storing and accessing HBase database.

Upvotes: 0

Martin Weindel
Martin Weindel

Reputation: 316

Take a look to the open source project Phoenix.
Phoenix is a SQL skin over HBase, delivered as a client-embedded JDBC driver, powering the HBase use cases at Salesforce.com.

Upvotes: 2

David Gruzman
David Gruzman

Reputation: 8088

Take a look on this discussion : Group by In HBase It explains what are analytical capabilities of the HBase.

Upvotes: 0

geoffrobinson
geoffrobinson

Reputation: 1580

I'm not sure you are aware since you put the "vertica" tag in your post, but you can use both at the same time. Specifically, Vertica has a lot of Hadoop integration.

You should use the right tool or combination of tools for the job and not worry about using something because it is new.

Upvotes: 1

Tariq
Tariq

Reputation: 34184

Have a look at Apache Hive..It provides us SQL like interface on top of our Hadoop cluster. Along with that it also acts us a datawarehouse over the Hadoop cluster.

Upvotes: 0

Related Questions