SET hive.fetch.task.conversion=none;
-- no footer
DROP TABLE IF EXISTS hf1;
CREATE TABLE hf1 (a string, b string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' TBLPROPERTIES('skip.header.line.count'='1');
INSERT OVERWRITE TABLE hf1 VALUES ('x','y'),('a','b'),('c','d');
SELECT * FROM hf1;

-- no header
DROP TABLE IF EXISTS hf2;
CREATE TABLE hf2 (a string, b string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' TBLPROPERTIES('skip.footer.line.count'='2');
INSERT OVERWRITE TABLE hf2 VALUES ('x','y'),('a','b'),('c','d');
SELECT * FROM hf2;

-- only header, no data
DROP TABLE IF EXISTS hf3;
CREATE TABLE hf3 (a string, b string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' TBLPROPERTIES('skip.header.line.count'='3');
INSERT OVERWRITE TABLE hf3 VALUES ('x','y'),('a','b'),('c','d');
SELECT * FROM hf3;

-- header and footer, no data
DROP TABLE IF EXISTS hf4;
CREATE TABLE hf4 (a string, b string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' TBLPROPERTIES('skip.header.line.count'='1','skip.footer.line.count'='2');
INSERT OVERWRITE TABLE hf4 VALUES ('x','y'),('a','b'),('c','d');
SELECT * FROM hf4;