During the ACTRIAL project, we set up queries to grab and visualize data from the page creation event logging database through ReportUpdater (see T170850).

That data is now also available in Hive, and we would rather use that as the source of the data. In order to do so, the following needs to be done:

• Port the current queries to HQL.
• Verify that both HQL and SQL queries produce the same results.
• Wrap the HQL queries in this shell script.
• Update the ReportUpdater configuration.
• Test the configuration.
• Submit it to code review.

Also:

• Update the ReportUpdater documentation so it explains how to query Hive.