new kids in the block - Drill, Presto, Kylin, Flink

[Cristian]

The are a lot of SQL engines on top of Hadoop like:

• Apache Drill / https://drill.apache.org/
  Schema-free, low latency SQL Query Engine for Hadoop, NoSQL and Cloud Storage
  It's backed up at enterprise level by MapR
• Apache Kylin / http://kylin.apache.org/
  Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets, original contributed from eBay Inc.
• Apache Flink / https://flink.apache.org/
  Apache Flink is an open source platform for distributed stream and batch data processing. Flink’s core is a streaming dataflow engine that provides data distribution, communication, and fault tolerance for distributed computations over data streams. The creators of Flink provide professional services trought their company Data Artisans.
• Facebook Presto / https://prestodb.io/
  Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
  It's backed up at enterprise level by Teradata - http://www.teradata.com/PRESTO/

My suggestion for Alteryx product managers is to build a tactical approach for these engines in 2016.

Regards,

Cristian.

[Cristian]

The creators of DRILL now are working to improve the software under the new startup called Dremio (http://www.dremio.com/)

[ARich]

 Hi All,

Thanks for the feedback. Please continue to upvote if you'd like to see these supported. Also, let us know specifically which ones you'd like support for.

Best,

Alex

[MichaelFern823]

Apache Drill can query any non-relational data stores as well. It provides you with the flexibility to work with nested data stores without transforming the data.

Presto was created to run interactive analytical queries on big data. Presto is targeted towards analysts who want to run queries that scales to the multiples of Petabytes.

Apache Drill is classified as a Database tool, whereas Presto is classified as a Big Data tool.

Even though it is well documented, installation and configuration for Apache Drill can take a long time. Presto, on the other hand, takes lesser time and gets ready to use within minutes.

https://www.hitechnectar.com/blogs/apache-drill-vs-presto/