[
https://issues.apache.org/jira/browse/CALCITE-7428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18063290#comment-18063290
]
Julian Hyde commented on CALCITE-7428:
--------------------------------------
The Jira case summary should be the specification. Describe what you are trying
to achieve and the steps to get there. It's confusing when you say you want a
REGEXP function, give an example that has an infix REGEXP operator, and then go
ahead and implement a function with two arguments. Please do better.
> Add regexp function (enabled in 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
>
> The SQL：
>
> {code:java}
> select brand_name from product where brand_name REGEXP('[a-zA-Z]') {code}
> Run error：
> {code:java}
> org.apache.calcite.sql.parser.SqlParseException: Encountered "REGEXP" at line
> 2, column 35.
> Was expecting one of:
> <EOF>
> "EXCEPT" ...
> "FETCH" ...
> "GROUP" ...
> "HAVING" ...
> "INTERSECT" ...
> "LIMIT" ...
> "OFFSET" ... {code}
> 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)
