[jira] Commented: (HIVE-138) Provide option to export a HEADER

["He Yongqiang (JIRA)" <ji...@apache.org>]

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

He Yongqiang commented on HIVE-138:
-----------------------------------

+1 running tests

> Provide option to export a HEADER
> ---------------------------------
>
>                 Key: HIVE-138
>                 URL: https://issues.apache.org/jira/browse/HIVE-138
>             Project: Hive
>          Issue Type: Improvement
>          Components: Clients, Query Processor
>            Reporter: Adam Kramer
>            Assignee: Paul Butler
>            Priority: Minor
>         Attachments: HIVE-138.patch
>
>
>     When writing data to directories or files for later analysis, or when exploring data in the hive CLI with raw SELECT statements, it'd be great if we could get a "header" or something so we know which columns our output comes from. Any chance this is easy to add? Just print the column names (or formula used to generate them) in the first row?
> SELECT foo.* WITH HEADER FROM some_table foo limit 3;
> col1    col2    col3
> 1   9   6
> 7   5   0
> 7   5   3
> SELECT f.col1-f.col2, col3 WITH HEADER FROM some_table foo limit 3;
> f.col1-f.col2     col3
> -8     6
> 2     0
> 2     3
> ...etc

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.