[
https://issues.apache.org/jira/browse/HIVE-138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12905335#action_12905335
]
Adam Kramer commented on HIVE-138:
----------------------------------
We should be able to do this easily for the first case, just get column names
from some_table.
In the second case, we should just call f.col1-f.col2 "_c1", which is its name,
unless the user calls out "AS col1".
> Provide option to export a HEADER
> ---------------------------------
>
> Key: HIVE-138
> URL: https://issues.apache.org/jira/browse/HIVE-138
> Project: Hadoop Hive
> Issue Type: Improvement
> Components: Clients, Query Processor
> Reporter: Adam Kramer
> Priority: Minor
>
> 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.
