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

Cannot reference outer columns from inline view over nested collection

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: Impala 2.5.0
    • Fix Version/s: None
    • Component/s: Frontend
    • Labels:

      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

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              skye Skye Wanderman-Milne
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: