04-07-2016 09:56 AM
I'm running Quickstart cdh 5.5
Everything went well in second exercise until I tried to query created tables in Impala. they had 0 counts. I tried to find what went wrong and found an error message: Failed to load metadata for table intermediate_access_logs.... REASON : SerDe library 'org.apache.hive.contrib.serde2.RegexSerDe' ia not supported. I can query hive tables and get the sought result. So, how it can be done in different way in Impala? Can I hope during exam I'll have no such problems?
04-07-2016 10:41 AM
04-07-2016 11:40 AM
Thank you, OK, I understood, that with hive we prepare data for Impala.
I found that insert overwrite failed on the very last step. Just after map 100%.
I created intermediate table:
drop table if exists tokenized_access_logs_1;
create table tokenized_access_logs_1 as select * from intermediate_access_logs;
and then issued :
insert overwrite tokenized_access_logs as select * from tokenized_access_logs_1;
And it worked, I could finish my exercise 2. I wonder what is the cause of failure.