[
https://issues.apache.org/jira/browse/HIVE-881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12767588#action_12767588
]
Ning Zhang commented on HIVE-881:
---------------------------------
It's probably not hard to create external table in CTAS. It was left out just
because it's probably not very useful to create an external table holding the
query results (seems the motivation for external table is that the data are
already there and we just want queriability on them). If there are really needs
to create external tables, we can make it a bootcamp task. The only think need
to change is probably the parser, the file location, and the FileSink's
destination URI.
The CTAS currently support row format serde (there is a test case in ctas.q and
an example in the wiki documentation).
> CTAS does not work on with fields terminator
> --------------------------------------------
>
> Key: HIVE-881
> URL: https://issues.apache.org/jira/browse/HIVE-881
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: Ning Zhang
> Assignee: Ning Zhang
> Attachments: Hive-881.patch, Hive-881_2.patch
>
>
> This query got wrong results:
> create table tmp row format fields terminated by ',' stored as textfile as
> select * from nzhang_tt;
> The result is the same as no "fields terminated by".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
