Skip to content

Instantly share code, notes, and snippets.

@chbatey

chbatey/RawWeatherDataInsert.cql

Last active August 29, 2015 14:24
Show Gist options
  • Save chbatey/a218f6d916f52476428d to your computer and use it in GitHub Desktop.
Save chbatey/a218f6d916f52476428d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
RawWeatherDataInsert.cql
INSERT INTO raw_weather_data(wsid, year, month, day, hour, country_code, state_code, temperature, one_hour_precip ) values ('station1', 2012, 12, 25, 1, 'GB', 'Cumbria', 14.0, 20) ;
INSERT INTO raw_weather_data(wsid, year, month, day, hour, country_code, state_code, temperature, one_hour_precip ) values ('station2', 2012, 12, 25, 1, 'GB', 'Cumbria', 4.0, 2) ;
INSERT INTO raw_weather_data(wsid, year, month, day, hour, country_code, state_code, temperature, one_hour_precip ) values ('station3', 2012, 12, 25, 1, 'GB', 'Greater London', 16.0, 10) ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment