You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "shradha (Jira)" <ji...@apache.org> on 2021/01/05 20:52:00 UTC
[jira] [Updated] (CALCITE-4454) Calcite SQLParser: Provide support
for RLIKE expressions
[ 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)