how to escape delimiter in hive

Question

If the delimiter in hive is specified as ';' and if the data(within one columnb) happen to contain char ";" .

How to espace ";" within data?

Answer 1

Refer to the below code used to escape the delimiter in the values:

CREATE TABLE <table format>
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES
( "separatorChar" = ",", 
"quoteChar" = "'", 
"escapeChar" = "\\" ) 
STORED AS TEXTFILE;