[jira] [Created] (DRILL-3411) CTAS Partition by column in deeper layer fails

["Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org>]

Sean Hsuan-Yi Chu created DRILL-3411:
----------------------------------------

             Summary: CTAS Partition by column in deeper layer fails
                 Key: DRILL-3411
                 URL: https://issues.apache.org/jira/browse/DRILL-3411
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
            Reporter: Sean Hsuan-Yi Chu
            Assignee: Jinfeng Ni


A simple data such as 
{code}
{
    "id": "0001",
    "type": "donut1",
    "batters":
    {
    	"batter": 1
    }
}

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

I tried to partition by batters.batter: 
{code}
create table t1 (c1, c2) partition by (c2) as 
select t.id, t.batters.batter from `t.json` t;
{code}

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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)