pradeepgv42 opened a new issue #5797:
URL: https://github.com/apache/incubator-pinot/issues/5797


   select * 
   from table
   where timestamp > X and not regexp_like(column, '<regex_patter>')
   
   throws following exception
   
   `pinot error: {'errorCode': 150, 'message': 'PQLParsingError:\n' 
'java.lang.IllegalArgumentException: No enum constant ' 
'org.apache.pinot.pql.parsers.pql2.ast.FilterKind.NOT\n' '\tat 
java.lang.Enum.valueOf(Enum.java:238)\n' '\tat ' 
'org.apache.pinot.pql.parsers.pql2.ast.FilterKind.valueOf(FilterKind.java:21)\n'
 '\tat ' 
'org.apache.pinot.parsers.utils.ParserUtils.getFilterKind(ParserUtils.java:83)\n'
 '\tat ' 
'org.apache.pinot.pql.parsers.PinotQuery2BrokerRequestConverter.traverseFilterExpression(PinotQuery2BrokerRequestConverter.java:250)\n'
 '\tat ' 
'org.apache.pinot.pql.parsers.PinotQuery2BrokerRequestConverter.traverseFilterExpression(PinotQuery2BrokerRequestConverter.java:259)\n'
 '\tat ' 
'org.apache.pinot.pql.parsers.PinotQuery2BrokerRequestConverter.convertFilter(PinotQuery2BrokerRequestConverter.java:178)\n'
 '\tat ' 
'org.apache.pinot.pql.parsers.PinotQuery2BrokerRequestConverter.convert(PinotQuery2BrokerRequestConverter.java:58)\n'
 '\tat ' 'org.apache.pinot.sql.parsers.Calcit
 eSqlCompiler.compileToBrokerRequest(CalciteSqlCompiler.java:34)\n' '\tat ' 
'org.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:186)\n'
 '\tat ' 
'org.apache.pinot.broker.api.resources.PinotClientRequest.processSqlQueryPost(PinotClientRequest.java:155)\n'
 '\tat sun.reflect.GeneratedMethodAccessor11.invoke(Unknown ' 'Source)\n' '\tat 
' 
'sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n'
 '\tat java.lang.reflect.Method.invoke(Method.java:498)\n' '\tat ' 
'org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)'}`
   
   Wondering if it's just a missing enum or this node type was intentionally 
skipped? 


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to