[DRILL-3411] CTAS Partition by column in deeper layer fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Fix Version/s: 1.1.0
• Component/s: Query Planning & Optimization
• Assignee: Jinfeng Ni
• Reporter: Sean Hsuan-Yi Chu
• Created: 27/Jun/15 06:41
• Updated: 01/Jul/15 01:01
• Resolved: 27/Jun/15 06:47

Description

A simple data such as

{
    "id": "0001",
    "type": "donut1",
    "batters":
    {
    	"batter": 1
    }
}

{
	"id": "0002",
    "type": "donut2",
    "batters":
    {
    	"batter": 2
    }
}

I tried to partition by batters.batter:

create table t1 (c1, c2) partition by (c2) as 
select t.id, t.batters.batter from `t.json` t;

But got this exception:
Error: SYSTEM ERROR: IllegalArgumentException: partition col c2 could not be resolved in table's column lists!