[DRILL-6546] Allow unnest function with nested columns and complex expressions

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Labels: ready-to-commit
• Assignee: Vova Vysotskyi
• Reporter: Vova Vysotskyi
• Reviewer: Hanumath Rao Maduri
• Created: 27/Jun/18 15:59
• Updated: 04/Jul/18 10:40
• Resolved: 04/Jul/18 10:40

Description

Currently queries with unnest and nested columns or complex expressions inside fails:

select u.item from cp.`lateraljoin/nested-customer.parquet` c,
unnest(c.orders.items) as u(item)

fails with error:

VALIDATION ERROR: From line 2, column 10 to line 2, column 21: Column 'orders.items' not found in table 'c'

Issue Links

• is depended upon by: DRILL-5999 Add support for LATERAL join
• links to: GitHub Pull Request #1346