[
https://issues.apache.org/jira/browse/HIVE-634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12733995#action_12733995
]
Neal Richter commented on HIVE-634:
-----------------------------------
What would be the output difference between the proposed feature and doing a
two step process as follows?
DROP TABLE tmp_exports_daily_timelines;
CREATE TABLE tmp_exports_daily_timelines (
page_id BIGINT,
dates STRING,
pageviews STRING,
total_pageviews BIGINT
) ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE
LOCATION '/tmp/exports/daily_timelines';
INSERT OVERWRITE TABLE tmp_exports_daily_timelines
SELECT page_id, dates, pageviews, total_pageviews
FROM daily_timelines
[ some WHERE clause here]
> 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.
