drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-595) Can't project columns from a inner query that has "select *"
Date Tue, 26 Aug 2014 19:23:58 GMT

     [ https://issues.apache.org/jira/browse/DRILL-595?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jinfeng Ni updated DRILL-595:
-----------------------------

    Attachment: 0002-DRILL-595-DRILL-811-DRILL-1029-Support-select-in-vie.patch

> Can't project columns from a inner query that has "select *"
> ------------------------------------------------------------
>
>                 Key: DRILL-595
>                 URL: https://issues.apache.org/jira/browse/DRILL-595
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>            Reporter: Venki Korukanti
>            Assignee: DrillCommitter
>             Fix For: 0.5.0
>
>         Attachments: 0002-DRILL-595-DRILL-811-DRILL-1029-Support-select-in-vie.patch
>
>
> Following queries don't work currently with schema-less tables such as parquet or json.
> {code}
> with x as (select * from cp.`region.json`) select region_id, sales_city from x;
> select region_id, sales_city from ( select * from cp.`region.json`);
> {code}
> Both fail with:
> {code}
> message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException:
From line 1, column 51 to line 1, column 59 ] < EigenbaseContextException:[ From line 1,
column 51 to line 1, column 59 ] < SqlValidatorException:[ Column \'region_id\' not found
in any table ]
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message