All Tools
P
DataFreeOpen Source
PRESTO
Distributed SQL query engine for big data analytics
Apache-2.0
ABOUT
Presto solves the cross-source data query problem by letting analysts and engineers run ANSI SQL against data stored in HDFS, S3, relational databases, Kafka, and NoSQL systems — without moving data into a separate warehouse. Instead of ETL-ing everything into one system, teams query data in place with a single engine that scales to petabytes.
INSTALL
docker run -d -p 8080:8080 prestodb/prestoINTEGRATION GUIDE
1. Run interactive SQL queries across petabytes of data in S3 and HDFS without pre-loading into a warehouse
2. Federate queries across MySQL, PostgreSQL, MongoDB, and Kafka topics from a single SQL interface
3. Power BI tools like Tableau and Superset with a fast ANSI SQL endpoint for live dashboards
4. Join data from a data lake with operational databases for real-time analytics use cases
5. Replace slow Hive queries with Presto's in-memory pipelined execution for 10x faster analytics
TAGS
sqlbig-dataquery-engineanalyticsdata-lakedistributed