Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

select from a serdex table

Highlighted

select from a serdex table

Hi,

I have a table as below description. when I want to select from this table or even I want to drop the table , I get error as attached in serverlog.

please help what I have to do .I need to add that when I select from other table it shows the result.

hiveserver2-txt.txthiveserver2-2-txt.txt

table: description :

create external table carry_log ( Time STRING, code STRING, INFO STRING, EXPR STRING ) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' WITH SERDEPROPERTIES ( "input.regex"="(\\d{2}:\\d{2}:\\d{2}),(\\d{3})\\s(\\w{4})\\s\\s(.*)" ) STORED AS TEXTFILE LOCATION '/tmp/access_logs/';

2 REPLIES 2
Highlighted

Re: select from a serdex table

Guru

@Nima Zolghadr

Can you try creating another table along with output.format.string ?

Highlighted

Re: select from a serdex table

hi, no i can not , whatever i want to do with serv it gets error ,but other table format is ok

Don't have an account?
Coming from Hortonworks? Activate your account here