Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

what is major differences between hive and Big Sql ?

avatar
 
1 ACCEPTED SOLUTION

avatar
Super Guru

@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.

View solution in original post

4 REPLIES 4

avatar

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.

avatar
Super Guru

@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.

avatar
Explorer

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

avatar
Master 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?