what is major differences between hive and Big Sql ?

[#1]

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.

[#2 · Accepted solution]

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

[#3]

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

[#4]

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?