[HIVE-10176] skip.header.line.count causes values to be skipped when performing insert values

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0.0, 1.2.1
• Target Version/s: 3.0.0
• Assignee: Vladyslav Pavlenko
• Reporter: Wenbo Wang
• Created: 01/Apr/15 05:16
• Updated: 27/Feb/24 22:23

Description

When inserting values in to tables with TBLPROPERTIES ("skip.header.line.count"="1") the first value listed is also skipped.

create table test (row int, name string) TBLPROPERTIES ("skip.header.line.count"="1");
load data local inpath '/root/data' into table test;
insert into table test values (1, 'a'), (2, 'b'), (3, 'c');

(1, 'a') isn't inserted into the table.