[
https://issues.apache.org/jira/browse/HIVE-634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brock Noland resolved HIVE-634.
-------------------------------
Resolution: Duplicate
> 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: 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.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
