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.

Having trouble with lzo encoded external text table in impala

Having trouble with lzo encoded external text table in impala

New Contributor

We are using cloudera express using cdh 5.1.0 and impala 1.4

 

I created a table as recommended using hive

 

create external table if not exists default.testdata(
banner int,
zone int,
unique int,
total int )
row format delimited fields terminated by '\t'
Stored as INPUTFORMAT 'com.hadoop.mapred.DeprecatedLzoTextInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
location '/user/admin/testdata.txt.lzo';

 

I uploaded a afile compressed with lzop

 

I have installed the GPLEXTRAS

 

I cannot query it, and impala doesn't show any errors in the logs.

1 REPLY 1
Highlighted

Re: Having trouble with lzo encoded external text table in impala

Location refers to a directory, not a file. Try pointing the table definition at '/user/admin' and see if that works - or post any errors you get.

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