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.
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.