Hello everyone, Is ST_DISTANCE function not supported for V2 Engine? i am having an exception when i run a query with ST_DISTANCE and V2 Engine enabled. Query:

select lon,lat from mytable where ST_DISTANCE(location_st_point, ST_Point(-122, 37, 1)) < 5000 limit 1000

Exception:

[

{

"message": "SQLParsingError\njava.lang.RuntimeException Error composing query plan for: select lon,lat from mytable where ST_DISTANCE(location_st_point, ST_Point(-122, 37, 1)) < 5000 limit 1000\n\tat org.apache.pinot.query.QueryEnvironment.planQuery(QueryEnvironment.java:131)\n\tat org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:147)\n\tat org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:125)\n\tat org.apache.pinot.broker.requesthandler.BrokerRequestHandler.handleRequest(BrokerRequestHandler.java:47)\n...\nCaused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 88 to line 1, column 108: No match found for function signature ST_Point(<NUMERIC>, <NUMERIC>, <NUMERIC>)\n\tat java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n\tat java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\n\tat java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\n\tat java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)\n...\nCaused by: org.apache.calcite.sql.validate.SqlValidatorException: No match found for function signature ST_Point(<NUMERIC>, <NUMERIC>, <NUMERIC>)\n\tat java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\n\tat java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\n\tat java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\n\tat java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)",

"errorCode": 150

}

]

It is not. cc: @Rong R

yeah ST_POINT is a transform only function and thus Pinot V2 doesn't understand this signature.