[IMPALA-10623] In some case, when using EXISTS-subquery, exception raised "No matching function with signature: regexp_like(BOOLEAN, STRING)."

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 3.2.0, Impala 3.4.0
• Component/s: Clients
• Environment: centos 7.8.2003 (x86_64) + CDH 6.3.2（either Impala 3.2 or Impala 3.4）
• Epic Color: ghx-label-5
• Assignee: Unassigned
• Reporter: MyqueWooMiddo
• Created: 30/Mar/21 09:02
• Updated: 30/Mar/21 09:02

Description

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),"