You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Volodymyr Vysotskyi (JIRA)" <ji...@apache.org> on 2018/06/27 16:00:00 UTC

[jira] [Created] (DRILL-6546) Allow unnest function with nested columns and complex expressions

Volodymyr Vysotskyi created DRILL-6546:
------------------------------------------

             Summary: Allow unnest function with nested columns and complex expressions
                 Key: DRILL-6546
                 URL: https://issues.apache.org/jira/browse/DRILL-6546
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Volodymyr Vysotskyi
            Assignee: Volodymyr Vysotskyi


Currently queries with unnest andĀ nested columnsĀ or complex expressions inside fails:
{code:sql}
select u.item from cp.`lateraljoin/nested-customer.parquet` c,
unnest(c.orders.items) as u(item)
{code}
fails with error:
{noformat}
VALIDATION ERROR: From line 2, column 10 to line 2, column 21: Column 'orders.items' not found in table 'c'
{noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)