[ https://issues.apache.org/jira/browse/HIVE-21951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sankar Hariappan resolved HIVE-21951. ------------------------------------- Resolution: Won't Fix This fix is partial as it won't work for cases where query having predicates or aggregates. HIVE-21924 have a proposal to fix this properly. > 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, 3.2.0 > Reporter: Sankar Hariappan > Assignee: Sankar Hariappan > Priority: Major > Attachments: HIVE-21951.01.patch, HIVE-21951.02.patch > > > 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)