terran2010 created CALCITE-7428:
-----------------------------------
Summary: 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
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)
