Hive Tutorial 30: Multi character delimiter
The default serde can be used. Multi character delimiters can be used for fields , line , escape characters by specifying them in the serde properties. CREATE EXTERNAL TABLE page_view(viewTime INT, userid BIGINT, page_url STRING, referrer_url STRING, ip STRING COMMENT 'IP Address of the User', country STRING COMMENT 'country of origination') COMMENT 'This is the staging page view table' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054' SERDE serde_name WITH SERDEPROPERTIES (field.delim='||') STORED AS TEXTFILE LOCATION '<hdfs_location>';