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;