You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Vladyslav Pavlenko (JIRA)" <ji...@apache.org> on 2016/03/09 19:08:40 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-10176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vladyslav Pavlenko updated HIVE-10176:
--------------------------------------
    Attachment: HIVE-10176.1.patch

Regex used as filter for data inserted by sql query.

> 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
>            Reporter: Wenbo Wang
>         Attachments: HIVE-10176.1.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)