The SingleStore Code Challenge: February

In this code challenge, we’ll work with time-series data. SingleStore is ideal for quickly ingesting and quickly querying and bucketing time-series data. In this challenge we’ll ingest a smart meter dataset and run queries to find trends.

Goal

Craft queries to find the meters with the highest usage.

Given

  1. Download University of California Irvine’s ElectricityLoadDiagrams20112014 Data Set from https://archive.ics.uci.edu/ml/datasets/ElectricityLoadDiagrams20112014

Tasks

  1. Create a table for the meter data.

  2. Import the data set from UC Irvine.

  3. Create queries to answer the following questions:

    a. Per day: Which consumed the most per day? Identify the date, meter, and total energy consumed for the highest consuming meter per day.

    b. Per month: Which consumed the most per month? Identify the date, meter, and total energy consumed for the highest consuming meter per month.

    c. Per year: How much did the annual usage change per year?

    d. Which meter came online last?

How to Win

  1. Post your table definition, load script, and queries as a public repo or gist on GitHub.

  2. Submit your GitHub URL to https://msql.co/3oDSoTD.

  3. All complete entries will receive this month’s Code Challenge badge in the forum.