Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-10623

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

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Impala 3.2.0, Impala 3.4.0
    • Fix Version/s: None
    • Component/s: Clients
    • Labels:
      None
    • Environment:
      centos 7.8.2003 (x86_64) + CDH 6.3.2(either Impala 3.2 or Impala 3.4)
    • Epic Color:
      ghx-label-5

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

       

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              WoodyMiddleware MyqueWooMiddo
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - 672h
                672h
                Remaining:
                Remaining Estimate - 672h
                672h
                Logged:
                Time Spent - Not Specified
                Not Specified