java csv 标题行处理,配置单元外部表格 - CSV文件 - 标题行

Below is the hive table i have created:

CREATE EXTERNAL TABLE Activity (

column1 type,

column2 type

)

ROW FORMAT DELIMITED FIELDS TERMINATED BY ','

LOCATION '/exttable/';

In my HDFS location /exttable, i have lot of CSV files and each CSV file also contain the header row. When i am doing select queries, the result contains the header row as well.

Is there any way in HIVE where we can ignore the header row or first line ?

解决方案

If you are using Hive version 0.13.0 or higher you can specify "skip.header.line.count"="1" in your table properties to remove the header.