[
https://issues.apache.org/jira/browse/CALCITE-7428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18064062#comment-18064062
]
terran2010 commented on CALCITE-7428:
-------------------------------------
[~xuzifu666] If we don't add a new SQL Kind, there are currently two ways
1. Directly define 'REGEXP' as' SQL LikeOperator '(inheriting from' SQL
SpecialOperator '), in this way:
-Support function syntax 'REGEXP (a, b)' and infix syntax 'a REGEXP b' during
parsing`
2. Directly use the existing SQL Kind.RLIKE
I think using option two is more reasonable
> 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 in hive：
> {code:java}
> select brand_name from product where REGEXP(brand_name,'[a-zA-Z]'){code}
> now will run error：
> {code:java}
> Semantic analysis exception - function or view '`regexp`' cannot be
> resolved{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)
