Exercise 3: No responce from tokenized_access_log

10Ben — Tue, 21 Apr 2026 13:59:12 GMT

Good morning all

I am trying to walk through the tutorial, and got to excersize 3 where you load the access log.

So did the two steps to load the data (and confirmed that it was there).

Ran the hive commands

ran invalidate metadata

And see the new table in Hue

But when I run the actual command:

select count(*),url from tokenized_access_log
where url like %product%
group by url order by count(*) desc;

I get

Operation had no results

Re: Exercise 3: No responce from tokenized_access_log

10Ben — Thu, 29 Jan 2015 15:46:02 GMT

After reddoing the load of data, I think what happaend was that dor some reason, the first bit of the hive command failed, so it never created a intermediate_access_logs. Not certain the creation failed, might have been a typo my end, but would make sence as the fourth step is to load data from intermediate to tokenized. And the command would work with no output, which would make sence if the table is empty.

Uncertain why it failed, but just drob both tables.

DROP TABLE intermediate_access_logs;

DROP TABLE tokenized_access_logs;

Then rerun the hive section and check that you have both tables afterwards.

Hope it helps someone:)

question Exercise 3: No responce from tokenized_access_log in Archives of Support Questions (Read Only)

Exercise 3: No responce from tokenized_access_log

Re: Exercise 3: No responce from tokenized_access_log