[
https://issues.apache.org/jira/browse/HIVE-634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12731319#action_12731319
]
Zheng Shao commented on HIVE-634:
---------------------------------
The format of the local file has nothing to do with the format of the source
table.
We should add the formatting sub clause for insert overwrite.
{code}
INSERT OVERWRITE LOCAL DIRECTORY '/mnt/daily_timelines'
[ ROW FORMAT DELIMITED | SERDE ... ]
[ FILE FORMAT ...]
SELECT * FROM daily_timelines;
{code}
> ctrl-A is the only output delimiter used, regardless of the Hive table
> structure
> --------------------------------------------------------------------------------
>
> Key: HIVE-634
> URL: https://issues.apache.org/jira/browse/HIVE-634
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Serializers/Deserializers
> Affects Versions: 0.3.0
> Reporter: Peter Skomoroch
> Priority: Minor
>
> No matter what the table format, INSERT OVERWRITE LOCAL DIRECTORY will always
> use ctrl-A delimiters ('\001' ).
> INSERT OVERWRITE LOCAL DIRECTORY '/mnt/daily_timelines' SELECT * FROM
> daily_timelines;
> where daily_timelines is defined as tab delimited
> CREATE TABLE daily_timelines (
> page_id BIGINT,
> dates STRING,
> pageviews STRING,
> total_pageviews BIGINT)
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY '\t'
> STORED AS TEXTFILE;
> This page also indicates Hive uses a fixed delimiter, and should be updated:
> http://wiki.apache.org/hadoop/Hive/LanguageManual/DML
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
