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

[Sankar Hariappan (JIRA)]

Sankar Hariappan created HIVE-21951:
---------------------------------------

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


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)