Presto is an open source distributed SQL query engine for running interactive analytic queries against heterogeneous data sources. It was open sourced by Facebook. Although it is also known as PrestoDB, Presto is not a general-purpose database management system (DBMS). It does not manage the storage of data. Instead, Presto is a query engine which allows querying data where it lives, including Hive, Cassandra, Kafka, and relational databases. A single Presto query is able to combine data from multiple sources. Presto was designed, built and optimized for interactive queries. In comparison, both Presto and Hive support SQL queries against HDFS, while Presto is targeted at interactive queries and Hive is suitable for batch processing. Presto supports ANSI-compatible SQL statements. Presto was open-sourced by Facebook[04][05][06]
- Website
- http://prestodb.io[01]
- Source Code
- https://github.com/prestodb/presto[02]
- Developer
- Country of Origin
- US
- Start Year
- 2013 [07]
- Project Type
- Open Source
- Written in
- Java
- Supported Languages
- SQL
- License
- Apache v2
Presto is an open source distributed SQL query engine for running interactive analytic queries against heterogeneous data sources. It was open sourced by Facebook. Although it is also known as PrestoDB, Presto is not a general-purpose database management system (DBMS). It does not manage the storage of data. Instead, Presto is a query engine which allows querying data where it lives, including Hive, Cassandra, Kafka, and relational databases. A single Presto query is able to combine data from multiple sources. Presto was designed, built and optimized for interactive queries. In comparison, both Presto and Hive support SQL queries against HDFS, while Presto is targeted at interactive queries and Hive is suitable for batch processing. Presto supports ANSI-compatible SQL statements. Presto was open-sourced by Facebook[04][05][06]
History[05][03]
Facebook started the development of Presto in 2012 and open sourced its first release in 2013.
TileDB
Citations
7 sources- http://prestodb.io prestodb.io
- GitHub - prestodb/presto: The official home of the Presto distributed SQL query engine for big data · GitHub github.com
- Presto (SQL query engine) - Wikipedia wikipedia.org
- https://blog.treasuredata.com/blog/2015/03/20/presto-versus-hive/ treasuredata.com
- https://www.facebook.com/notes/facebook-engineering/presto-interacting-with-petabytes-of-data-at-facebook/10151786197628920 facebook.com
- https://prestodb.io prestodb.io
- https://www.computerworld.com/article/2485668/business-intelligence/facebook-goes-open-source-with-query-engine-for-big-data.html computerworld.com