This page includes sample queries to run on our demo cluster preloaded with three sample datasets:
The following query on hourly counts returns a graph of the full time range of the dataset with the number of queries every hour:
From the graph, the following insights are available:
- The graph shows no activity during Hurricane Erin.
- The peak hour of activity corresponds to the Space Shuttle Discovery launch STS-70 on July 13.
The following query shows that the top 100 pages accessed during this peak hour were limited to shuttle liftoff coverage:
This query lists the most popular non-image URLs on each day in the dataset:
The following query returns the names of the most popular Wikipedia articles that start with
E from one hour on 9/13/2014:
World Cup 2014
The following query returns the average age of captains and players of all other positions. The query also compares the number of appearances in the World Cup for the two groups of players. Team captains are on average almost 5 years older than other players and have 3 times as many national team appearances.
The following query lists the captains, along with their club, country, position, and number of World Cup appearances.
The following query returns data for the top 25 clubs: number of players, number of captains, average country ranking of the team’s players, average player age. Barcelona has the most players in the World Cup (16), but Real Madrid/Man U have the most captains (2). Atletico Madrid has the highest average country rank for its players. Manchester City the oldest players, Schalke 4 the youngest.
The following query returns data by country: average player age and average number of World Cup appearances. Argentina has the oldest team, Ghana the youngest. Spain is the most experienced, Australia the least.
The following query compares player age to the number of World Cup appearances. Not surprisingly, the older you are, the more appearances you've had, in general.
The following query returns the number of players grouped by their jersey number. The query also returns the number of captains for each jersey number. Teams number all players 1-23. However, captains gravitate towards wearing #1, #4, #3, and #10.
The following query groups documents by the player's jersey number and then, for each jersey number group, returns the most common position for that jersey number. Some numbers are typically associated with a position: #1 is always the goalie, defenders are frequently #2 and #3, and #9 is usually a forward.
The following query returns the average player age and average number of World Cup appearances by their position. Goalies are older and more frequently the captain. Forwards typically have the most experience.
The following query returns data about the World Cup groups: average number of World Cup appearances, average age, and average country rank. Group D and G were rough. Group F and H were easy. Group H was also the youngest and least experienced, while group C was the oldest and most experienced.