Presto DB Reviews and details

Social recommendations and mentions

• Parsing logs from multiple data sources with Ahana and Cube

  Presto is an open-source distributed SQL query engine, originally developed at Facebook, now hosted under the Linux Foundation. It connects to multiple databases or other data sources (for example, Amazon S3). We can use a Presto cluster as a single compute engine for an entire data lake. - Source: dev.to / almost 2 years ago

• Can a data warehouse be skipped?

  Fair point, but I am talking about Athena (not SQL Server), which under the hood uses a distributed query engine. It is capable to deal with huge amounts of data, if the storage is in the right shape. You can read more about the underlying technology here: https://prestodb.io/. Source: about 2 years ago

• why use Redshift if we can use S3 to store data and can connect with Quicksight for dashboarding?

  So there is Presto, which is a distributed SQL engine created by Facebook. Source: about 2 years ago

• Understanding AWS Athena 101

  You can use Athena to run data analytics, with just standard SQL (Presto). - Source: dev.to / over 2 years ago

• ETL tool for query building across multiple databases in Mongo DB

  Presto does this, but I'm honestly uncertain how performant it is. In my experience, centralizing data is the superior approach to attempting to query multiple sources in place. Source: almost 3 years ago

• Rule-based Query Optimization

  Presto is a distributed query engine for big data. Like Apache Calcite, it uses rules to perform transformations. However, Presto doesn't have a cost-based search algorithm and relies only on heuristics when transitioning between optimization steps. See our previous blog for more details on Presto query optimizer. - Source: dev.to / almost 3 years ago