[HIVE-138] Provide option to export a HEADER

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: Clients, Query Processor
• Assignee: Paul Butler
• Reporter: Adam Kramer
• Created: 08/Dec/08 23:02
• Updated: 16/Aug/12 17:10
• Resolved: 30/Nov/10 07:05

Description

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

Issue Links

• is blocked by: HIVE-153 explain should give meaningful column names