12-02-2015 08:30 AM - last edited on 10-31-2017 05:32 AM by cjervis
I'm new here and trying to complete the cloudera live guide. I'm trying to follow the steps required to load the data from access.log.2 but the task doens't complete. It's not giving me any errors and I'm not sure where to look for log files.
The code I'm using looks like this:
CREATE EXTERNAL TABLE intermediate_access_logs (
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
WITH SERDEPROPERTIES (
'input.regex' = '([^ ]*) - - \\[([^\\]]*)\\] "([^\ ]*) ([^\ ]*) ([^\ ]*)" (\\d*) (\\d*) "([^"]*)" "([^"]*)"',
'output.format.string' = "%1$$s %2$$s %3$$s %4$$s %5$$s %6$$s %7$$s %8$$s %9$$s")
CREATE EXTERNAL TABLE tokenized_access_logs (
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
ADD JAR /usr/lib/hive/lib/hive-contrib.jar;
INSERT OVERWRITE TABLE tokenized_access_logs SELECT * FROM intermediate_access_logs;
I'm sure I'm missing something silly here.
12-02-2015 08:53 AM
12-02-2015 09:59 AM
Yes I am using the QuickStart VM. 2 CPUs, 8GB of RAM, express edition.
Yes I'm using Hue and I can only see the following message with the spinning wheel next to it:
"There are currently no logs to visualize."
That is the only message
12-02-2015 11:17 AM
12-03-2015 02:35 PM
I had exactly the same problem while running a VMWare with 8196 MB of memory. When I switched to 10GB+ it worked, so I guess 8 GB is a bit optmistic.
I followed the tutorial and did little else. I restarted the tutorial 3 times before I changed the memory setting, and none worked.
10-21-2017 08:42 AM
Hi Team, I am new to Clodera and I hope I will get help from the community
I also came across the same issue can anyone suggest where did u increase the memory?
I have 12 GB in my laptop
Do i have to do changes in settings anywhere to resolve this issue?
Please help I am stuck with few Exceptions
"AnalysisException: Could not resolve table reference: 'tokenized_access_logs' "
" AnalysisException: Could not resolve table reference: 'intermediate_access_logs' "
These exceptions came while running the code in Hue
It seems tables did not get generated properly --- saw these when i checked for tables " Could not load: tokenized_access_logs" , "Could not load: intermediate_access_logs"