We are going to explore Apache web logs taken from the online store. These logs are taken from the Apache web server and uploaded to HDFS. You'll see how to read Apache logs out of the box. The name of the store is unicorn fashion. Here is an example log line:
135.51.156.129 - - [02/Dec/2013:13:52:29] "POST /product.screen?productName=SHORTS&JSESSIONID=CA10MO9AZ5USANA4955 HTTP 1.1" 200 2334 "http://www.yahoo.com" "Opera/9.01 (Windows NT 5.1; U; en)" 167
It's a normal Apache access combined log. We can build reports, dashboards, and alerts on top of this data. You will:
Learn the basics of SPL to create queries
Learn visualization abilities
Drill-down from the aggregated report to the underlying detailed data
Check the job details used to prepare report data
Create alerts and see a simple alert use-case
Create a dashboard presenting web analytics reports on a single page
Create a virtual index
You know already how to create a virtual index; we provide a screenshot with an index...