[
https://issues.apache.org/jira/browse/CALCITE-7428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18064047#comment-18064047
]
terran2010 commented on CALCITE-7428:
-------------------------------------
[~jensen] I have tried Calcite to support the REGEXP keyword, but it conflicts
with the current REGEXP function. In the test case of executing Spark, the
error 'Incorrect syntax near the keyword' REGEXP 'will be reported. Therefore,
I think it may be more reasonable to convert the REGEXP function according to
the Hive dialect
> 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)
