Pdf to csv file format conversions

Question

I am having a requirement to load the multiple .pdf files from hdfs location. Now I want to convert all pdf file formats to csv file formats and load into hive tables. I tried to Google it but I am not getting how to convert pdf to csv format code. Can you please help me how to load all pdf files and convert to csv if possible please share the code?

Answer 1

You can convert the pdf files with the help of some external tools that you can find online. After this, upload the files on hdfs and create the hive table to store these files in the hive table. Refer to the below example to create a hive table and load a CSV file in it.

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; 

Below is the query to load the CSV file in the above table,

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

Refer to the below screenshot for the same: