Amazing blog by @User on achieving Full SQL on top of Pinot by integrating it with Presto. https://eng.uber.com/engineering-sql-support-on-apache-pinot/

Just for full disclosure: This blog talks about the v1 of the presto-pinot connector and Uber has since May 2019 moved on towards a subsequent version that is currently checked into prestodb trunk https://prestodb.io/docs/current/connector/pinot.html, (https://github.com/prestodb/presto/commit/78f24709b80f17bc7b7f6a0317cd9ee0515c638e#diff-85578e635f2c1b08e3e35616ae74c2f3. )