LAlambdafunc·Nov 30, 2015
Surprised that no one mentioned Facebook's Presto project: https://github.com/facebook/presto
Presto team is just awesome.
In Ask HN: Which open source projects have kind, supportive, talented teams?prestodb
presto
Java2013–2025
prestodb / presto
presto
The official home of the Presto distributed SQL query engine for big data
20Distinct people
26Mentions
1Explicit recommenders
16.8KGitHub stars
What to know before exploring
What it is
The official home of the Presto distributed SQL query engine for big data
GitHub
Where it is used
No documented product use was verified in the last source check.
What people are saying
Java is much heavier weight [1] than languages like PHP and Python, and that’s not at all a bad thing - it just changes what the language is used for [2] and what’s normal…
wrmsr used a recommendation phrase. One indexed comment matches. This is a phrase match, not a verdict.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
- tobymao/sqlglot · linked in 2 of the same discussions
Mentioned in the same Hacker News threads. That is not proof they are substitutes.
This week on Hacker News
Nov 8–Nov 15 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/15/2026, 12:03:30 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by year26 dated mentions
Observed mentions: 2013-11-06 23:45:24 UTC to 2025-11-14 12:34:26 UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| 2013 | 2013-01-01 00:00:00 UTC | 2014-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2014 | 2014-01-01 00:00:00 UTC | 2015-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2015 | 2015-01-01 00:00:00 UTC | 2016-01-01 00:00:00 UTC | 2 | 0 | 2 |
| 2016 | 2016-01-01 00:00:00 UTC | 2017-01-01 00:00:00 UTC | 3 | 0 | 3 |
| 2017 | 2017-01-01 00:00:00 UTC | 2018-01-01 00:00:00 UTC | 4 | 0 | 4 |
| 2018 | 2018-01-01 00:00:00 UTC | 2019-01-01 00:00:00 UTC | 2 | 1 | 1 |
| 2019 | 2019-01-01 00:00:00 UTC | 2020-01-01 00:00:00 UTC | 2 | 1 | 1 |
| 2020 | 2020-01-01 00:00:00 UTC | 2021-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2021 | 2021-01-01 00:00:00 UTC | 2022-01-01 00:00:00 UTC | 2 | 0 | 2 |
| 2022 | 2022-01-01 00:00:00 UTC | 2023-01-01 00:00:00 UTC | 2 | 0 | 2 |
| 2023 | 2023-01-01 00:00:00 UTC | 2024-01-01 00:00:00 UTC | 3 | 1 | 2 |
| 2024 | 2024-01-01 00:00:00 UTC | 2025-01-01 00:00:00 UTC | 2 | 0 | 2 |
| 2025 | 2025-01-01 00:00:00 UTC | 2026-01-01 00:00:00 UTC | 1 | 0 | 1 |
What Hacker News says
2 sourcesThere's also Presto from fb, and Apache Drill. Phoenix seems to be on top of Hbase, which is more funkier that plain HDFS + SQL engine.
Besides, right now there's a huge need for analytical engines on top of HDFS (data lake or whatever you call it) - that's why there are all of these: (shamelessly stolen from an email from drill users):
- Apache Hive <https://hive.apache.org> (SQL-like, with interactive SQL
thanks to the Stinger initiative)
- Apache Drill <http://drill.apache.org> (ANSI SQL support)
- Apache Spark <https://spark.apache.org> (Spark SQL
<https://spark.apache.org/sql>, queries only, add data via Hive, RDD
<https://spark.apache.org/docs/latest/api/scala/index.html#or...
or Parquet <http://parquet.io/>)
- Apache Phoenix <http://phoenix.apache.org> (built atop Apache HBase
<http://hbase.apache.org>, lack
Read the rest
s full transaction
<http://en.wikipedia.org/wiki/Database_transaction> support, relational
operators <http://en.wikipedia.org/wiki/Relational_operators> and some
built-in functions)
- Cloudera Impala
<http://www.cloudera.com/content/cloudera/en/products-and-ser...
(significant HiveQL support, some SQL language support, no support for
indexes on its tables, importantly missing DELETE, UPDATE and INTERSECT;
amongst others)
- Presto <https://github.com/facebook/presto> from Facebook (can query
Hive, Cassandra <http://cassandra.apache.org>, relational DBs &etc.
Doesn't seem to be designed for low-latency responses across small
clusters, or support UPDATE operations. It is optimized for data
warehousing or analytics¹
<http://prestodb.io/docs/current/overview/use-cases.html>)
- SQL-Hadoop <https://www.mapr.com/why-hadoop/sql-hadoop> via MapR
community edition <https://www.mapr.com/products/hadoop-download> (seems
to be a packaging of Hive, HP Vertica
<http://www.vertica.com/hp-vertica-products/sqlonhadoop>, SparkSQL,
Drill and a native ODBC wrapper
<http://package.mapr.com/tools/MapR-ODBC/MapR_ODBC>)
- Apache Kylin <http://www.kylin.io> from Ebay (provides an SQL
interface and multi-dimensional analysis [OLAP
<http://en.wikipedia.org/wiki/OLAP>], "… offers ANSI SQL on Hadoop and
supports most ANSI SQL query functions". It depends on HDFS, MapReduce,
Hive and HBase; and seems targeted at very large data-sets though maintains
low query latency)
- Apache Tajo <http://tajo.apache.org> (ANSI/ISO SQL standard compliance
with JDBC <http://en.wikipedia.org/wiki/JDBC> driver support [benchmarks
against Hive and Impala
<http://blogs.gartner.com/nick-heudecker/apache-tajo-enters-t...
])
- Cascading <http://en.wikipedia.org/wiki/Cascading_%28software%29>'s
Lingual <http://docs.cascading.org/lingual/1.0/>²
<http://docs.cascading.org/lingual/1.0/#sql-support> ("Lingual provides
JDBC Drivers, a SQL command shell, and a catalog manager for publishing
files [or any resource] as schemas and tables.")