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

Cannot reference outer columns from inline view over nested collection

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • Impala 2.5.0
    • Not Applicable
    • Frontend

    Description

      It should be possible to run this query:

      Query: explain select id, m from complextypestbl t, (select min(t.id + item) m from t.int_array) v
      ERROR: AnalysisException: Could not resolve column/field reference: 't.id'
      

      Table schema:

      id         bigint
      int_array  array<int>
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              skye Skye Wanderman-Milne
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: