You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-04-02 21:35:17

chillies57
Member
5 posts

chillies57 said:

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

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 ?

mini_Component_properties.png.pngmini_error_msg.png.png

Last edited by chillies57 (2017-04-02 21:38:31)

Offline

#2 2017-04-05 16:22:20

chillies57
Member
5 posts

chillies57 said:

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

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

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy