https://github.com/downloads/IllyaYalovyy/csv-serde/csv-serde-0.9.1.jar
hive> add jar /opt/hive-2.0.0/testdata/csv-serde-0.9.1.jar
hive> create external table employee (userid int, date_added date, name string, last_name string) row format serde 'com.bizo.hive.serde.csv.CSVSerde' with serdeproperties ("separatorChar"=",","quoteChar"=""") stored as textfile;
Change hive.server2.enable.doAs
to false in hive-site.xml