SQL layers on NoSQL databases

What are the SQL layer solution over NoSQL databases such as key/value stores?

asked Mar 1, 2013 by anonymous

8 Answers

Phoenix: A SQL layer on HBase:


They also show some performance results:


answered Mar 5, 2013 by anonymous

F1 - The Fault-Tolerant Distributed RDBMS Supporting Google's Ad Business:


With F1, we have built a novel hybrid system that combines the
scalability, fault tolerance, transparent sharding, and cost benefits
so far available only in “NoSQL” systems with the usability,
familiarity, and transactional guarantees expected from an RDBMS.

answered Mar 7, 2013 by anonymous

Tenzing A SQL Implementation On The MapReduce Framework:


Tenzing is a query engine built on top of MapReduce for ad hoc
analysis of Google data. Tenzing supports a mostly complete SQL
implementation (with several extensions) combined with several key
characteristics such as heterogeneity, high performance, scalability,
reliability, metadata awareness, low latency, support for columnar
storage and structured data, and easy extensibility. Tenzing is
currently used internally at Google by 1000+ employees and serves
10000+ queries per day over 1.5 petabytes of compressed data. In this
paper, we describe the architecture and implementation of Tenzing, and
present benchmarks of typical analytical queries.

answered Mar 7, 2013 by anonymous

HAWQ from EMC:


HAWQ (pronounced hawk) represents the EMC Greenplum engineering effort
that brings 10 years of large-scale data management research and
development to the Apache Hadoop framework. Leveraging the feature
richness and maturity of the industry leading Greenplum MPP analytical
database, this innovation has resulted in the world's first true SQL
parallel database on top of the Hadoop Distributed File System (HDFS).


Project Hawq, the SQL database layer that rides atop of HDFS rather
than trying to replace it with a NoSQL data store

answered Mar 7, 2013 by anonymous

Apache Hive: http://hive.apache.org/

It defines a SQL-like language called HiveQL.

answered Mar 8, 2013 by anonymous

Stinger Initiative: Making Apache Hive 100 Times Faster: http://hortonworks.com/blog/100x-faster-hive/

commented Mar 9, 2013 by anonymous

Cloudera Impala


Source code:


it uses the same metadata, SQL syntax (Hive SQL), ODBC driver and user
interface (Hue Beeswax) as Apache Hive, providing a familiar and
unified platform for batch-oriented or real-time queries.

answered Mar 8, 2013 by anonymous



Spire is the first SQL database for large, user-facing applications
built on Hadoop. Spire is built to power large-scale websites, mobile
apps, and machine-to-machine data.

Unlike any other Hadoop and SQL solution, Spire scales to tens of
thousands of reads and writes per second, with full ANSI SQL and
intuitive management tools.

Architecturally similar to Google F1, Spire makes it simple to build
applications for the Big Data Era.

answered Mar 9, 2013 by anonymous

Hadapt: http://hadapt.com/

Hadapt unifies SQL and Hadoop, enabling customers to analyze all of their data (structured, unstructured, and multi-structured) in a single platform – no connectors, complexities, or rigid structure.

answered Mar 9, 2013 by anonymous

Please log in or register to answer this question.

Related questions

1 answer
asked Mar 11, 2013 by anonymous
0 answers
asked Jun 6, 2017 by anonymous
0 answers
1 answer
Copyright © SysTutorials. User contributions licensed under cc-wiki with attribution required.
Hosted on Dreamhost