Hi,
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 (
ip STRING,
date STRING,
method STRING,
url STRING,
http_version STRING,
code1 STRING,
code2 STRING,
dash STRING,
user_agent STRING)
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")
LOCATION '/user/hive/warehouse/original_access_logs';
CREATE EXTERNAL TABLE tokenized_access_logs (
ip STRING,
date STRING,
method STRING,
url STRING,
http_version STRING,
code1 STRING,
code2 STRING,
dash STRING,
user_agent STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
LOCATION '/user/hive/warehouse/tokenized_access_logs';
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.
Kind Regards,
Gee
Created 12-02-2015 08:53 AM
Created 12-02-2015 09:59 AM
Hi,
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
Created 12-02-2015 11:17 AM
Created 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.
Created 12-10-2015 12:47 AM
Sorry for the delay and thank you for all your assistance. I can confirm that he memory increase did solve the issue.
Thanks,
Geouff
Created 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"