That query does not work but removing "TOP 10000" does. Presto adds the "TOP 10000" automatically. Side-note: I obfuscated my query to simplify it for the chat.

Presto-pinot connector is using pql mode and pinot query is using sql mode. TOP works only in PQL mode.