MyqueWooMiddo created IMPALA-10623:
--------------------------------------
Summary: In some case, when using EXISTS-subquery, exception
raised "No matching function with signature: regexp_like(BOOLEAN, STRING)."
Key: IMPALA-10623
URL: https://issues.apache.org/jira/browse/IMPALA-10623
Project: IMPALA
Issue Type: Bug
Components: Clients
Affects Versions: Impala 3.4.0, Impala 3.2.0
Environment: centos 7.8.2003 (x86_64) + CDH 6.3.2（either Impala 3.2 or
Impala 3.4）
Reporter: MyqueWooMiddo
table1 (col1 string,col2 string) textfile
table2 (col3 string) textfile
subquery 1:
select * from table1 t1 where exists (
select * from table2 t2 where regexp_like(t1.col2,t2.col3)
);
It raised "AnalysisException: No matching function with signature:
regexp_like(BOOLEAN, STRING)."
subquery 2:
select * from table1 t1 where exists (
select * from table2 t2 where t1.col2 like t2.col3
);
It raised "AnalysisException: left operand of LIKE must be of type STRING:
(TRUE LIKE t2.col3),"
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
