[
https://issues.apache.org/jira/browse/CALCITE-7428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18068222#comment-18068222
]
Yu Xu commented on CALCITE-7428:
--------------------------------
Fixed in
[05e410f|https://github.com/apache/calcite/commit/05e410ff3ebeb91d6d4f946a7a45087bf3571f95]
Thank you for the contribution [~terran2010] !
Thank you for the review [~mbudiu] and suggestions [~julianhyde] [~jensen] !
> 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
> Fix For: 1.42.0
>
>
> 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)
