Skip first line of csv while loading in hive table Skip first line of csv while loading in hive table hadoop hadoop

Skip first line of csv while loading in hive table


hadoop hive hiveql

To get this you can use hive's property which is TBLPROPERTIES ("skip.header.line.count"="1")
you can also refer example -

CREATE TABLE temp   (      name STRING,      id   INT   ) row format delimited fields terminated BY '\t' lines terminated BY '\n' tblproperties("skip.header.line.count"="1");

hadoop hive hiveql

Just for those who have already created the table with the header. Here is the alter command for the same.

ALTER TABLE tablename SET TBLPROPERTIES ("skip.header.line.count"="1");

hadoop hive hiveql

Just don't mix double quotes and single quotes in the same CLI command:

CREATE TABLE db.test   (      fname STRING,      lname STRING,      age   STRING,      mob   BIGINT   ) row format delimited fields terminated BY '\t' tblproperties('skip.header.line.count'='1') stored AS textfile;

otherwise hive load NULL values.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last