what is sysdate equivalent in pinot query? actually i trying to compare fields with current date / time in superset

There is no so

current_date

function as of now, however it’s easy to add. could you elaborate more on your requirements or you can create an issue on github(https://github.com/apache/incubator-pinot/issues) for the details.

i want to find records which schedules are likely to miss based status and time. where status!='ON_THE_WAY' and scheduled < current_date-1