CSV integration with Hadoop

Question

Hi Team,

How do we integrate to Hadoop with CSV?

Answer 1

For integrating Hadoop with CSV, we can use Hive. Refer to the below example for reading a CSV file in Hive:

create table users_data(userid varchar(10), location varchar(100), age varchar(5)) row format serde 'org.apache.hadoop.hive.serde2.OpenCSVSerde' with serdeproperties("separatorChar" = "\;","quoteChar" = "\"") stored as textfile;

load data inpath 'BX-Users.csv' into table users_data;