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:)
... View more
