Wenbo Wang created HIVE-10176:
---------------------------------

             Summary: 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


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)

Reply via email to