Small remark : In addition Eric later on gave me the advice to include the CSV Serde, because the statement still didn't run successfully. This is vital, as this serde is located at Hive standard lib, the "add jar" should not be necessary, but at this point in time seems to be.   So here is that maybe important additional piece of information from Eric who worked on the case I created later after posting my question here at the community :   "ADD JAR /opt/cloudera/parcels/CDH/lib/hive/lib/opencsv-2.3.jar;   Do "ls /opt/cloudera/parcels/CDH/lib/hive/lib/opencsv*" to see whether you have the same version as mine, then try again. The problem seems to be fixed in 5.4." (remark : my CDH version was 5.3.3)     With adding the serde jar and creating the table before executing insert overwrite table statement, the separatorChar was used and I got the table format I needed. ... View more