Book Image

Learning Storm

By : Ankit Jain, Anand Nalya
Book Image

Learning Storm

By: Ankit Jain, Anand Nalya

Overview of this book

<p>Starting with the very basics of Storm, you will learn how to set up Storm on a single machine and move on to deploying Storm on your cluster. You will understand how Kafka can be integrated with Storm using the Kafka spout.</p> <p>You will then proceed to explore the Trident abstraction tool with Storm to perform stateful stream processing, guaranteeing single message processing in every topology. You will move ahead to learn how to integrate Hadoop with Storm. Next, you will learn how to integrate Storm with other well-known Big Data technologies such as HBase, Redis, and Kafka to realize the full potential of Storm.</p> <p>Finally, you will perform in-depth case studies on Apache log processing and machine learning with a focus on Storm, and through these case studies, you will discover Storm's realm of possibilities.</p>
Table of Contents (16 chapters)
Learning Storm
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

MySQL queries


This section will explain how you can analyze or query the stored data to generate some statistics. We will cover the following types of statistics:

  • How to calculate the page hits from each country

  • How to calculate the count of each browser

  • How to calculate the count of each operating system

Calculating the page hits from each country

Run the following command on the MySQL console to calculate the number of hits on a page from each country:

select country, count(*) from apachelog group by country;

The output for the preceding command is as follows:

+---------------------------+----------+
| country                   | count(*) |
+---------------------------+----------+
| Asia/Pacific Region       |        9 |
| Belarus                   |       12 |
| Belgium                   |       12 |
| Bosnia and Herzegovina    |       12 |
| Brazil                    |       36 |
| Bulgaria                  |       12 |
| Canada                    |      218 |
| Europe                   ...