Hive table not able to use row format serde

Question

I am getting this error. Please tell me how to configure csv serde with commands

Answer 1

Try this:

create table books(isbn string, book_title string, book_author string,year_of_publication string, publisher string, image_url_s string, image_url_m string, image_url_l string) row format serde 'org.apache.hadoop.hive.serde2.OpenCSVSerde' with serdeproperties("separatorChar" ="\;", "quoteChar"="\"") stored as textfile;