You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Lefty Leverenz (JIRA)" <ji...@apache.org> on 2014/04/07 00:32:16 UTC

[jira] [Commented] (HIVE-1598) use SequenceFile rather than TextFile format for hive query results

    [ https://issues.apache.org/jira/browse/HIVE-1598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13961553#comment-13961553 ] 

Lefty Leverenz commented on HIVE-1598:
--------------------------------------

This adds the *hive.query.result.fileformat* configuration parameter to HiveConf.java with a default value of TextFile.

(This comment makes it easy to find the jira that introduced *hive.query.result.fileformat*.)

> use SequenceFile rather than TextFile format for hive query results
> -------------------------------------------------------------------
>
>                 Key: HIVE-1598
>                 URL: https://issues.apache.org/jira/browse/HIVE-1598
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>             Fix For: 0.7.0
>
>         Attachments: HIVE-1598.2.patch, HIVE-1598.patch
>
>
> Hive query's result is written to a temporary directory first and then FetchTask takes the files and display it to the users. Currently the file format used for the resulting file is TextFile format. This could cause incorrect result display if some string typed column contains new lines, which are used as record delimiters in TextInputFormat. Switching to SequenceFile format will solve this problem. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)