Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

what is major differences between hive and Big Sql ?

Solved Go to solution
Highlighted

what is major differences between hive and Big Sql ?

New Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

Re: what is major differences between hive and Big Sql ?

@kishore sanchina

HiveQL is a query language and Hive is an execution engine. BigSQL is just another execution engine which can co-exist with Hive and leverage Hive storage model and metastore. Tables created in Hive are visible to Big SQL and vice versa. The major difference? Until recently, the response would have been that Hive requires MapReduce and BigSQL uses a different approach leveraging memory, however, recently Hive uses Tez and even more recently uses LLAP and the difference between them is just that they are just alternatives provides by Community vs. IBM.

If you were looking from the functional point of view, SQL functions, then IBM’s Big SQL provides higher degree of ANSI SQL language compatibility, however, Hive is almost there and at lower cost and larger community support.

+++

If any response was helpful, please vote/accept best answer.

4 REPLIES 4

Re: what is major differences between hive and Big Sql ?

Hi @kishore sanchina

This is very generic question. You can easily find answer doing simple web search like below:

https://developer.ibm.com/hadoop/2015/10/23/hive-and-big-sql-performance-test-update/

Feel free to ask questions which are more specific to use case and design.

Re: what is major differences between hive and Big Sql ?

@kishore sanchina

HiveQL is a query language and Hive is an execution engine. BigSQL is just another execution engine which can co-exist with Hive and leverage Hive storage model and metastore. Tables created in Hive are visible to Big SQL and vice versa. The major difference? Until recently, the response would have been that Hive requires MapReduce and BigSQL uses a different approach leveraging memory, however, recently Hive uses Tez and even more recently uses LLAP and the difference between them is just that they are just alternatives provides by Community vs. IBM.

If you were looking from the functional point of view, SQL functions, then IBM’s Big SQL provides higher degree of ANSI SQL language compatibility, however, Hive is almost there and at lower cost and larger community support.

+++

If any response was helpful, please vote/accept best answer.

Re: what is major differences between hive and Big Sql ?

New Contributor

@Constantin Stanca , so BigSQL can be compared with Phoenix which can be meant as a SQL layer over HBase?

Re: what is major differences between hive and Big Sql ?

Super Collaborator

You can query with BIGSQL from tables on cache with LLAP? I mean, if you have one table on memory with LLAP, you can query with BigSQL this table?

Don't have an account?
Coming from Hortonworks? Activate your account here