drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Hsuan-Yi Chu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3408) CTAS partition by columns[i] from csv fails
Date Sat, 27 Jun 2015 06:53:04 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14604031#comment-14604031
] 

Sean Hsuan-Yi Chu commented on DRILL-3408:
------------------------------------------

[~jni] It is a little different from your comment. Can you help clarify if it is expected?

If yes, that means the arguments in partition by are actually pointing at the elements in
the select-list? Besides, sometimes it is necessary give alias (e.g., the use case in this
issue and DRILL-3411).

> CTAS partition by columns[i] from csv fails
> -------------------------------------------
>
>                 Key: DRILL-3408
>                 URL: https://issues.apache.org/jira/browse/DRILL-3408
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>            Reporter: Sean Hsuan-Yi Chu
>            Assignee: Jinfeng Ni
>
> CTAS does not work when users try to partition by index on complex types.
> For example,
> create table `z` partition by columns[0] as select columns[0], columns[1], columns[2]
from `t.csv`;
> Will result into 
> Error: PARSE ERROR: Encountered "columns" at line 1, column 31.
> Query parser does not support it; We need to do it from here



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

Mime
View raw message