[I] CAST(col AS STRING) does not work in 1.2.0 anymore [pinot]

[via GitHub]

piby180 opened a new issue, #14052:
URL: https://github.com/apache/pinot/issues/14052

   CAST(col1 AS STRING) does not work anymore in 1.2.0. It used to work in 1.1.0
   
   SELECT CAST(1.2 AS STRING)
   
   `````
   pinot error: {'errorCode': 720,
    'message': 'QueryPlanningError:\n'
               "Error composing query plan for 'SELECT CAST(1.2 AS STRING)\n"
               "LIMIT 10001': From line 1, column 20 to line 1, column 25: "
               "Unknown identifier 'STRING''\n"
               
'org.apache.pinot.query.QueryEnvironment.planQuery(QueryEnvironment.java:136)\n'
               
'org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:158)\n'
               
'org.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:133)\n'
               
'org.apache.pinot.broker.requesthandler.BrokerRequestHandlerDelegate.handleRequest(BrokerRequestHandlerDelegate.java:86)\n'
               'From line 1, column 20 to line 1, column 25: Unknown identifier 
'
               "'STRING'\n"
               
'jdk.internal.reflect.GeneratedConstructorAccessor93.newInstance(Unknown '
               'Source)\n'
               
'java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\n'
               
'java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)\n'
               
'java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)\n'
               "Unknown identifier 'STRING'\n"
               
'jdk.internal.reflect.GeneratedConstructorAccessor92.newInstance(Unknown '
               'Source)\n'
               
'java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\n'
               
'java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)\n'
               
'java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)\n'}
   ````
   
   CAST(1.2 AS VARCHAR) is working fine. We have to refactor our queries in a 
couple of services.
   
   Also, can we have documentation on CAST function in pinot docs? It seems to 
be not there.
   
   Thanks!
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org