hive skip line 설정

hadoop fs -cat /user/demo/states3/states3.txt

STATE_NAME

----------

california

ohio

north dakota

new york

colorado

new jersey

CREATE EXTERNAL TABLE states3 (states string) LOCATION '/user/demo/states3' TBLPROPERTIES("skip.header.line.count"="2");