btablogs.blogg.se

Sadly, as with Oracle's offering, it's tied to a specific IBM product on the back end - in this case, IBM's Hadoop, InfoSphere BigInsights.

IBM BigSQL: It was only a matter of time before IBM did the same, although it announced the first technology preview of BigSQL back in early 2013. But unlike Drill, it's Oracle's own product, and it only integrates with Oracle Database 12c and up, which seriously limits the market for it. Like Drill, it can query both Hadoop and other NoSQL stores. Oracle Big Data SQL: It was only a matter of time before Oracle released its own SQL-querying front end for Hadoop. Some data-insertion functions are supported, but they're still very basic: You can't perform updates, only inserts. It can query both Hive and Cassandra using ANSI SQL commands, and developers can extend the system by writing connectors for it using its service provider interface. Presto: Built by Facebook's engineers and used internally at that company, this open source query engine is reminiscent of Apache Drill in that it's source-agnostic. Consequently, it's a Pivotal-only product, although Pivotal stumps for its parallel SQL processing and high compliance with SQL standards. HAWQ for Pivotal HD: Pivotal provides its own Hadoop distribution ( Pivotal HD), and HAWQ is a proprietary component for performing SQL queries in HDFS. But Impala's main difference from Drill is that it's not meant to be source-agnostic it queries Hadoop exclusively. Data stored in either HDFS or HBase can be queried, and the SQL syntax is, predictably, the same as Apache Hive. Consider it an almost no-brainer for those making use of HBase, thanks to it being open source, aggressively developed, and outfitted with useful features like bulk data loading.Ĭloudera Impala: In some ways, Impala is another implementation of Dremel/Apache Drill, designed to expand on Hive so that exiting Hive users can make the most of it. Apache Phoenix: Its developers call it a "SQL skin for HBase" - a way to query HBase with SQL-like commands via an embeddable JDBC driver built for high performance and read/write operations.