You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/06/27 08:42:04 UTC
[jira] [Created] (DRILL-3411) CTAS Partition by column in deeper
layer fails
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)