When writing output files, OUTPUTFORMAT does not take effect.
-------------------------------------------------------------
Key: HIVE-2802
URL: https://issues.apache.org/jira/browse/HIVE-2802
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 0.7.1
Environment: hadoop-0.20.203
Reporter: Yifeng Geng
I want to query the input text and store the result as other format such as
sequence file.
For example:
CREATE TABLE pokes (foo INT, bar STRING) STORED AS INPUTFORMAT
'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat';
LOAD DATA LOCAL INPATH './examples/files/kv1.txt' OVERWRITE INTO TABLE pokes;
INSERT OVERWRITE DIRECTORY '/tmp/pokes_out' select * from pokes;
Result file in /tmp/pokes_out is in Text Format not
HiveSequenceFileOutputFormat.
I dig into the source code, and it seems there is a property
"hive.query.result.fileformat" that cause the result to be in text format.
Is it a bug and how to achieve my purpose?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
