hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pengcheng Xiong (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-10176) skip.header.line.count causes values to be skipped when performing insert values
Date Sat, 25 Mar 2017 21:35:41 GMT

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

Pengcheng Xiong updated HIVE-10176:
-----------------------------------
    Target Version/s: 3.0.0  (was: 2.2.0)

> 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)

Mime
View raw message