[
https://issues.apache.org/jira/browse/HIVE-10176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15256600#comment-15256600
]
Vladyslav Pavlenko commented on HIVE-10176:
-------------------------------------------
[~ashutoshc]
I created one before: https://reviews.apache.org/r/46020. Yes, I agree with you
that my deŃision wasn't optimal. I had faced several problems in the beginning
that is why I decided to create temp file for this issue. I know now how to
solve it. That is why I do not create temp file in the new patch.
> 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
> Fix For: 2.0.0
>
> Attachments: HIVE-10176.1.patch, HIVE-10176.10.patch,
> HIVE-10176.11.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, data
>
>
> 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.4#6332)
