Could someone please tell me what are the commands that work in mySQL but not in pinot query

Hi Naman. I'm not sure I understand your question. Are you looking for SQL compatibility between mysql and pinot?

So, Marketing Guy™ here, thus my answer will be somewhat naïve, but from what I understand, the SQL used in Apache Pinot is based off of Apache Calcite (see its parser docs here), but with some key differences (see this; though this blog was written with a particular view of how to attack and exploit the database — SQL injections — and is already somewhat obsolete). I don't think I've ever seen a direct MySQL - to - Pinot SQL dialect / parser comparison.