Reply
New Contributor
Posts: 5
Registered: ‎08-07-2014

Having trouble with lzo encoded external text table in impala

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.

Highlighted
Explorer
Posts: 14
Registered: ‎08-13-2013

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.

Announcements