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

Anonymous — Sat, 16 Nov 2024 09:56:41 GMT

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 ?

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

Anonymous — Wed, 05 Apr 2017 16:22:20 GMT

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

topic Re: [resolved] Error while Creating Hive table with Serde using thiverow in Talend Studio

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

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