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

["MyqueWooMiddo (Jira)" <ji...@apache.org>]

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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org