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.
