[ 
https://issues.apache.org/jira/browse/CALCITE-4454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

shradha updated CALCITE-4454:
-----------------------------
    Description: 
Enhance Calcite SQLParser to support SPARK SQL queries expressions   - RLIKE  

Current Behavior

{color:#000080}val {color}query1 = {color:#008000}"select cola from tableA 
where MAX(realm_email) rlike 
'.+@.+{color}{color:#000080}\\\\{color}{color:#008000}..+'"{color}

{color:#008000}StatementMetadataFragment(com.intuit.superglue.pipeline.parsers.CalciteStatementParser,UNKNOWN,List(),List(),List(org.apache.calcite.sql.parser.SqlParseException:
 Encountered "rlike" at line 1, column 48.{color}

{color:#008000}All these queries are correctly being parsed via SPARK SQL . But 
calcite's parser grammer file doesn't suport these tokens{color}

Since this is SPARK SQL specific , these changes will be implemented in BABEL 
Parser

> Calcite SQLParser: Provide support for RLIKE expressions
> --------------------------------------------------------
>
>                 Key: CALCITE-4454
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4454
>             Project: Calcite
>          Issue Type: Sub-task
>          Components: spark
>            Reporter: shradha
>            Priority: Major
>
> Enhance Calcite SQLParser to support SPARK SQL queries expressions   - RLIKE  
> Current Behavior
> {color:#000080}val {color}query1 = {color:#008000}"select cola from tableA 
> where MAX(realm_email) rlike 
> '.+@.+{color}{color:#000080}\\\\{color}{color:#008000}..+'"{color}
> {color:#008000}StatementMetadataFragment(com.intuit.superglue.pipeline.parsers.CalciteStatementParser,UNKNOWN,List(),List(),List(org.apache.calcite.sql.parser.SqlParseException:
>  Encountered "rlike" at line 1, column 48.{color}
> {color:#008000}All these queries are correctly being parsed via SPARK SQL . 
> But calcite's parser grammer file doesn't suport these tokens{color}
> Since this is SPARK SQL specific , these changes will be implemented in BABEL 
> Parser



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to