Presto Reviews

Presto offers immense flexibility for users to connect with multiple data sources like HIVE, MySQL. The speed at which it can handle petabytes of data places it ahead of competition.

Couple of know limitations like the constraints with the drop and delete statements makes it difficult to be solely dependent on Presto for end to end work. Also the Insert Overwrite is a a pain.

Presto is helping me to query terabytes of data in hadoop at incredible fast speeds. I can extend my analysis timeline without having to think about the time constraints.

Easy to implemataion in presto becasue engine will provide and also customer support. Same feature are similar to other RDBMS.

Some operators limitaions and limated UDF (user define functions). Runnining queries limitation.

We can intergrate with any dataware house tool. I am using this engine with Treasure data.

I am amazed by the speed at which the data is delivered. The query response is superfast, eventually. Supports a large number of data bases. Highly flexible in adapting to the query translation.

Heavy duty resource-hungry processes. The more you allow to cache the more response time is good. Some queries run into pages, very complex while dealing with ElasticSearch DB. Translation to stat is where I feel Presto lacks.

I am using Presto to collate data across multiple databases and generate report. Also Presto is used as backend database to integrate with elastic search DB with superset. Superset unfortunately doesn't integrate with ES where presto does. Mix and match, join queries across DBs