[resolved] Error while Creating Hive table with Serde using thiverow

[Anonymous]

Hi, I want to run the below query using thiverow, 
Talend Open Studio for Big Data 6.3.1 & CDH 5.8
CREATE EXTERNAL TABLE intermediate_access_logs (
ip STRING,
date STRING,
method STRING,
url STRING,
http_version STRING,
code1 STRING,
code2 STRING,
dash STRING,
user_agent STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
WITH SERDEPROPERTIES (
'input.regex' = '([^ ]*) - - \\[([^\\]]*)\\] "([^\ ]*) ([^\ ]*) ([^\ ]*)" (\\d*) (\\d*) "([^"]*)" "([^"]*)"',
'output.format.string' = "%1$$s %2$$s %3$$s %4$$s %5$$s %6$$s %7$$s %8$$s %9$$s")
LOCATION '/user/hive/warehouse/original_access_logs';

Iam getting an error when I run this.

Am I missing something ? should I add any jar ?

[Anonymous · Accepted solution]

Fixed the issue by escaping double quotes ('"' to '\"') and back slashes ("\" to "\\" and "\\" to "\\\\")