question Re: what is major differences between hive and Big Sql ? in Archives of Support Questions (Read Only)

what is major differences between hive and Big Sql ?

Former Member — Sun, 20 Nov 2016 12:58:43 GMT

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

rpathak — Sun, 20 Nov 2016 22:33:41 GMT

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 ?

cstanca — Mon, 21 Nov 2016 03:52:04 GMT

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

dinuswt22 — Wed, 21 Feb 2018 09:15:23 GMT

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