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;
![image](https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NDA2MzY0NzQ4MCwiZG9tYWluIjoiZWR1cmVrYS5mcmVzaGRlc2suY29tIiwiYWNjb3VudF9pZCI6NDE0NTN9.mXrNNOCBEmGXYwyz-5fQno18yNFXHuVuEyzNKJkj_Dw)