Presto Pros and Cons

Easy to implemataion in presto becasue engine will provide and also customer support. Same feature are similar to other RDBMS. Review collected by and hosted on G2.com.

Some operators limitaions and limated UDF (user define functions). Runnining queries limitation. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.