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)