Impala (2.7.0) + gzip compressed text + skip.header.line.count 

[mango-perf-3:21000] > create external table test1 (date_time string, loginid string, empty string, userid int, alias string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE location '/tmp/test1' tblproperties ( 'skip.header.line.count'='1');
Query: create external table test1 (date_time string, loginid string, empty string, userid int, alias string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE location '/tmp/test1' tblproperties ( 'skip.header.line.count'='1')

Fetched 0 row(s) in 0.05s
[mango-perf-3:21000] > select * from test1;
Query: select * from test1
Query submitted at: 2017-04-10 13:37:52 (Coordinator: http://mango-perf-3:25000)
Query progress can be monitored at: http://mango-perf-3:25000/query_plan?query_id=174f2c7a175ed042:1ff457f900000000
+--------------------------------------------------------------+---------+-------+--------+-------+
| date_time                                                    | loginid | empty | userid | alias |
+--------------------------------------------------------------+---------+-------+--------+-------+
| �0
    ���4i���(x�B�Ju��B���wj.z��\�ŭ��]�Lhhqد���@X[� | NULL    |       | NULL   |       |
| ��'�)O����x@,ɐ��d)M?>0I��                              | NULL    |       | NULL   |       |
+--------------------------------------------------------------+---------+-------+--------+-------+
Fetched 2 row(s) in 3.60s
[mango-perf-3:21000] > alter table test1 set tblproperties('skip.header.line.count'='0');
Query: alter table test1 set tblproperties('skip.header.line.count'='0')
+----------------+
| summary        |
+----------------+
| Updated table. |
+----------------+
Fetched 1 row(s) in 0.06s
[mango-perf-3:21000] > select * from test1;
Query: select * from test1
Query submitted at: 2017-04-10 13:38:06 (Coordinator: http://mango-perf-3:25000)
Query progress can be monitored at: http://mango-perf-3:25000/query_plan?query_id=6b4548d88b90524d:83c14d2000000000
+-------------------+----------+-------+--------+--------+
| date_time         | loginid  | empty | userid | alias  |
+-------------------+----------+-------+--------+--------+
| header            | i        | dont  | NULL   | need   |
| 20170401:01:01:01 | LoginId1 |       | 1      | Alias1 |
| 20170401:02:02:02 | LoginId2 |       | 2      | Alias2 |
| 20170401:03:03:03 | LoginId3 |       | 3      | Alias3 |
| 20170401:04:04:04 | LoginId4 |       | 4      | Alias4 |
| 20170401:05:05:05 | LoginId5 |       | 5      | Alias5 |
+-------------------+----------+-------+--------+--------+
WARNINGS: Error converting column: 3 to INT
Error parsing row: file: hdfs://mango-perf-1.gce.cloudera.com:8020/tmp/test1/test.txt.gz, before offset: 124

Fetched 6 row(s) in 0.14s
[mango-perf-3:21000] >