[
https://issues.apache.org/jira/browse/CALCITE-7428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18063402#comment-18063402
]
terran2010 commented on CALCITE-7428:
-------------------------------------
[~julianhyde] Thank you for your suggestion. I will provide more detailed
explanations for the Jira case
> Support regexp function change regexp operator for Hive library
> ---------------------------------------------------------------
>
> Key: CALCITE-7428
> URL: https://issues.apache.org/jira/browse/CALCITE-7428
> Project: Calcite
> Issue Type: New Feature
> Components: core
> Affects Versions: 1.41.0
> Reporter: terran2010
> Priority: Major
> Labels: pull-request-available
>
> When execute SQL：
> {code:java}
> select brand_name from product where brand_name REGEXP '[a-zA-Z]' {code}
> now will run error：
> {code:java}
> org.apache.calcite.sql.parser.SqlParseException: Encountered "REGEXP" at line
> 2, column 35.
> Was expecting one of:
> <EOF>
> "EXCEPT" ...
> "FETCH" ...
> "GROUP" ...
> "HAVING" ...
> "INTERSECT" ...
> "LIMIT" ...
> "OFFSET" ... {code}
> in calcite function Libs，we can find
> "REGEXP(value, regexp)" function，only support spark now，
> Can we try to
> {code:java}
> select brand_name from product where REGEXP(brand_name,'[a-zA-Z]'){code}
> convert to
> {code:java}
> select brand_name from product where brand_name REGEXP '[a-zA-Z]' {code}
> when set to Hive dialect
> we can refer hive document about Position:
> [https://hive.apache.org/docs/latest/language/hive-operators/]
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
