08-07-2014 07:46 AM
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(
total int )
row format delimited fields terminated by '\t'
Stored as INPUTFORMAT 'com.hadoop.mapred.DeprecatedLzoTextInputFormat'
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.
09-22-2014 09:04 AM
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.