[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.16.patch Fixed double copy in patch in case when file has a footer or/and header. > 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.12.patch, HIVE-10176.13.patch, > HIVE-10176.14.patch, HIVE-10176.15.patch, HIVE-10176.16.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)
[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.14.patch Ok, I do what you ask. About question from RB, I found related ticked: https://issues.apache.org/jira/browse/HIVE-11996. Table doesn't have properties "line.delimiter" or equals. And I don't found workaround for it problem. > 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.12.patch, HIVE-10176.13.patch, > HIVE-10176.14.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)
[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.13.patch Forget delete file if it in hdfs. > 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.12.patch, HIVE-10176.13.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)
[jira] [Commented] (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: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)
[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.12.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.12.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)
[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.11.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)
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=15234891#comment-15234891 ] Vladyslav Pavlenko commented on HIVE-10176: --- All the 2 failures are not related: org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver_index_bitmap3 org.apache.hive.jdbc.TestMultiSessionsHS2WithLocalClusterSpark.testSparkQuery. Need code review. > 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.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)
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=15234889#comment-15234889 ] Vladyslav Pavlenko commented on HIVE-10176: --- All the 2 failures are not related: > 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.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)
[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: -- Fix Version/s: 2.0.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 > Fix For: 2.0.0 > > Attachments: HIVE-10176.1.patch, HIVE-10176.10.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)
[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: -- Affects Version/s: 1.2.1 > 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: HIVE-10176.1.patch, HIVE-10176.10.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)
[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.10.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 >Reporter: Wenbo Wang >Assignee: Vladyslav Pavlenko > Attachments: HIVE-10176.1.patch, HIVE-10176.10.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)
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=15226105#comment-15226105 ] Vladyslav Pavlenko commented on HIVE-10176: --- The tests are not executed locally, when I checkout on master branch. > 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 >Assignee: Vladyslav Pavlenko > Attachments: 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, 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)
[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.9.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 >Reporter: Wenbo Wang >Assignee: Vladyslav Pavlenko > Attachments: 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, 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)
[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.8.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 >Reporter: Wenbo Wang >Assignee: Vladyslav Pavlenko > Attachments: 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, 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)
[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.7.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 >Reporter: Wenbo Wang >Assignee: Vladyslav Pavlenko > Attachments: 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, 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)
[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.6.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 >Reporter: Wenbo Wang >Assignee: Vladyslav Pavlenko > Attachments: HIVE-10176.1.patch, HIVE-10176.2.patch, > HIVE-10176.3.patch, HIVE-10176.4.patch, HIVE-10176.5.patch, > HIVE-10176.6.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)
[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.5.patch Now temporary file is created before LOAD within which the header and footer are removed. > 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 >Assignee: Vladyslav Pavlenko > Attachments: HIVE-10176.1.patch, HIVE-10176.2.patch, > HIVE-10176.3.patch, HIVE-10176.4.patch, HIVE-10176.5.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)
[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.4.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 >Reporter: Wenbo Wang >Assignee: Vladyslav Pavlenko > Attachments: HIVE-10176.1.patch, HIVE-10176.2.patch, > HIVE-10176.3.patch, HIVE-10176.4.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)
[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: -- Status: Open (was: Patch Available) > 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: 2.0.0 >Reporter: Wenbo Wang >Assignee: Vladyslav Pavlenko > Attachments: HIVE-10176.1.patch, HIVE-10176.2.patch, > HIVE-10176.3.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)
[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: -- Affects Version/s: (was: 2.0.0) 1.0.0 Status: Patch Available (was: Open) > 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 >Assignee: Vladyslav Pavlenko > Attachments: HIVE-10176.1.patch, HIVE-10176.2.patch, > HIVE-10176.3.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)
[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.3.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: 2.0.0 >Reporter: Wenbo Wang >Assignee: Vladyslav Pavlenko > Attachments: HIVE-10176.1.patch, HIVE-10176.2.patch, > HIVE-10176.3.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)
[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: -- Assignee: Vladyslav Pavlenko Affects Version/s: (was: 1.0.0) 2.0.0 Status: Patch Available (was: Open) > 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: 2.0.0 >Reporter: Wenbo Wang >Assignee: Vladyslav Pavlenko > Attachments: HIVE-10176.1.patch, HIVE-10176.2.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)
[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.2.patch I changed regex in view of bucketed tables. > 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, HIVE-10176.2.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)
[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)