[
https://issues.apache.org/jira/browse/HIVE-10176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15941986#comment-15941986
]
Pengcheng Xiong commented on HIVE-10176:
----------------------------------------
Hello, I am deferring this to Hive 3.0 as we are going to cut the first RC and
it is not marked as blocker. Please feel free to commit to the branch if this
can be resolved before the release.
> skip.header.line.count causes values to be skipped when performing insert
> values
> --------------------------------------------------------------------------------
>
> Key: HIVE-10176
> URL: https://issues.apache.org/jira/browse/HIVE-10176
> Project: Hive
> Issue Type: Bug
> Affects Versions: 1.0.0, 1.2.1
> Reporter: Wenbo Wang
> Assignee: Vladyslav Pavlenko
> Attachments: data, HIVE-10176.10.patch, HIVE-10176.11.patch,
> HIVE-10176.12.patch, HIVE-10176.13.patch, HIVE-10176.14.patch,
> HIVE-10176.15.patch, HIVE-10176.16.patch, HIVE-10176.1.patch,
> HIVE-10176.2.patch, HIVE-10176.3.patch, HIVE-10176.4.patch,
> HIVE-10176.5.patch, HIVE-10176.6.patch, HIVE-10176.7.patch,
> HIVE-10176.8.patch, HIVE-10176.9.patch
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
