New Contributor
Posts: 5
Registered: ‎10-03-2015
Accepted Solution
Exercise 3 : no response from intermediate_access_logs table creation query
Hi, 

Not getting any response When I execute below query. Its more than 3 hrs now and no response yet. I am running this query on Quick Start VM.

Could you please help me with this issue.

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';
Who Me Too'd this topic