[HIVE-4623] LOAD DATA should support "ignore 1 lines" syntax

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.10.0
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: Gwen Shapira
• Created: 28/May/13 20:30
• Updated: 21/Jun/13 06:54

Description

MySQL supports the following syntax to ignore lines while loading data:
LOAD DATA INFILE '/tmp/test.txt' INTO TABLE test IGNORE 1 LINES;

Its a nice shortcut, especially for CSV files with column headers.

Issue Links

• relates to: HIVE-4776 Add option for skipping first n-rows of files