Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-15763

Subquery in both LHS and RHS of IN/NOT IN throws misleading error

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.0
    • Component/s: Query Planning
    • Labels:

      Description

      Following query throws an error

      select * from part where (select max(p_size) from part) IN (select p_size from part);

      Error

      SemanticException [Error 10249]: Line 1:79 Unsupported SubQuery Expression 'p_size': Only 1 SubQuery expression is supported.
      

      Such queries should either be supported or should be detected and an appropriate error message should be thrown.

        Attachments

        1. HIVE-15763.1.patch
          2 kB
          Vineet Garg
        2. HIVE-15763.2.patch
          4 kB
          Vineet Garg

          Activity

            People

            • Assignee:
              vgarg Vineet Garg
              Reporter:
              vgarg Vineet Garg
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: