[
https://issues.apache.org/jira/browse/CALCITE-7428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18064001#comment-18064001
]
Zhen Chen commented on CALCITE-7428:
------------------------------------
I'd like to add a question. If you want to use it in Hive, is it possible to do
so through dialect conversion, or could you try checking if existing Hive
dialects are already supported? If you want Calcite to support the REGEXP
keyword, I think the Jira description might need some adjustments. What do you
think?
> 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)
