[jira] [Updated] (HIVE-25505) Incorrect results with header. skip.header.line.count if first line is blank

["Panagiotis Garefalakis (Jira)" <ji...@apache.org>]

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

Panagiotis Garefalakis updated HIVE-25505:
------------------------------------------
    Description: 
aAtable with header. skip.header.line.count=1 does not skip the first line if it is blank, except in a fetch task.

To reproduce, create a csv table, ans set header. skip.header.line.count=1 in table properties.

In the table location, create a single file, with a blank (empty) first line, and say 2 further lines.

If you do a select * on it, you see 2 rows (correct)
If you do select count(\*) on it, you get 3 (incorrect)




{code:java}
// Some comments here
public String getFoo()
{
    return foo;
}
{code}


  was:
aAtable with header. skip.header.line.count=1 does not skip the first line if it is blank, except in a fetch task.

To reproduce, create a csv table, ans set header. skip.header.line.count=1 in table properties.

In the table location, create a single file, with a blank (empty) first line, and say 2 further lines.

If you do a select * on it, you see 2 rows (correct)
If you do select count(\*) on it, you get 3 (incorrect)


> Incorrect results with header. skip.header.line.count if first line is blank
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-25505
>                 URL: https://issues.apache.org/jira/browse/HIVE-25505
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>            Reporter: Steve Carlin
>            Priority: Major
>
> aAtable with header. skip.header.line.count=1 does not skip the first line if it is blank, except in a fetch task.
> To reproduce, create a csv table, ans set header. skip.header.line.count=1 in table properties.
> In the table location, create a single file, with a blank (empty) first line, and say 2 further lines.
> If you do a select * on it, you see 2 rows (correct)
> If you do select count(\*) on it, you get 3 (incorrect)
> {code:java}
> // Some comments here
> public String getFoo()
> {
>     return foo;
> }
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)