[
https://issues.apache.org/jira/browse/CALCITE-7428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18064186#comment-18064186
]
Julian Hyde commented on CALCITE-7428:
--------------------------------------
To summarize the conversation to this point: adding a new function to an
operator table is EASY; adding a new infix operator is HARD.
Can we change the goal of this case to just support
{code:java}select brand_name from product where REGEXP(brand_name,'[a-zA-Z]')
{code}
in the Hive operator table. Log another case for infix REGEXP; the work is
going to be similar to the case that added RLIKE to the parser.
> 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)
