Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

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

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.

3 Comments
Cristian
9 - Comet

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

ARich
Alteryx Alumni (Retired)
Status changed to: Under Review

 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
5 - Atom

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/