[jira] [Updated] (HIVE-21951) Llap query on external table with header or footer returns incorrect row count.

["Sankar Hariappan (JIRA)" <ji...@apache.org>]

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

Sankar Hariappan updated HIVE-21951:
------------------------------------
    Status: Patch Available  (was: Open)

> Llap query on external table with header or footer returns incorrect row count.
> -------------------------------------------------------------------------------
>
>                 Key: HIVE-21951
>                 URL: https://issues.apache.org/jira/browse/HIVE-21951
>             Project: Hive
>          Issue Type: Bug
>          Components: llap, Query Processor
>    Affects Versions: 2.4.0, 4.0.0
>            Reporter: Sankar Hariappan
>            Assignee: Sankar Hariappan
>            Priority: Major
>         Attachments: HIVE-21951.01.patch
>
>
> If create a table with header and footer as follows.
> {code}
> CREATE EXTERNAL TABLE IF NOT EXISTS externaltableOpenCSV (eid int, name String, salary String, destination String)
>  COMMENT 'Employee details'
>  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
>  STORED AS TEXTFILE
>  LOCATION '/externaltableOpenCSV'
>  tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2");
> {code}
> Now, query on this table returns incorrect row count as header/footer are not skipped.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)