[DRILL-595] Can't project columns from a inner query that has "select *"

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: SQL Parser
• Assignee: DrillCommitter
• Reporter: Venki Korukanti
• Due: 15/Aug/14
• Created: 30/Apr/14 00:03
• Updated: 29/Aug/14 17:55
• Resolved: 29/Aug/14 17:55

Description

Following queries don't work currently with schema-less tables such as parquet or json.

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`);

Both fail with:

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 ]

Issue Links

• Is contained by: DRILL-931 Wildcard queries cause problems in certain schemaless situations
• is depended upon by: DRILL-438 Add support for Views (CREATE, DROP and select)