[DRILL-811] Selecting individual columns from views created using 'select * ......' query throws an error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: SQL Parser
• Assignee: DrillCommitter
• Reporter: Rahul Kumar Challapalli
• Due: 15/Aug/14
• Created: 22/May/14 16:24
• Updated: 15/Apr/15 20:53
• Resolved: 29/Aug/14 17:55

Description

git.commit.id.abbrev=70fab8c

Follow the below steps :

create view v1 as select * from `dfs/parquet/rankings`;
select pageRank from v1;

The query fails with the below error :

message: "Failure while parsing sql. < IndexOutOfBoundsException:[ Index: 1, Size: 1 ]"

This looks like a known issue. However I couldn't find any bug related to it.

Issue Links

• Is contained by: DRILL-931 Wildcard queries cause problems in certain schemaless situations