You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Steve Carlin (Jira)" <ji...@apache.org> on 2021/09/07 16:17:00 UTC

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

Steve Carlin created HIVE-25505:
-----------------------------------

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


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)



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