The input table, murmurhash_input, is a log of midnight temperatures (in degrees Fahrenheit) for five consecutive nights in five cities. The rows of all columns except id are to be converted to hash values. Because the hash value depends on data type, the input table has three columns each, with different data types, for the city name, time period, and temperature:
Columns | Content | Data Types |
---|---|---|
2-4 | City name | BYTEA, VARCHAR, TEXT |
5-7 | Time period | TIMESTAMP, TEXT, DATE |
8-10 | Time period | DOUBLE PRECISION, INTEGER, TEXT |
id | city_bytea | city_varchar | city_text | period_timestamp | period_text |
---|---|---|---|---|---|
1 | Asheville | Asheville | Asheville | 2008-10-10 00:00:00 | 10-10-2008 00:00:00 |
2 | Greenville | Greenville | Greenville | 2008-10-11 00:00:00 | 10-11-2008 00:00:00 |
3 | Brownsville | Brownsville | Brownsville | 2008-10-12 00:00:00 | 10-12-2008 00:00:00 |
4 | Nashville | Nashville | Nashville | 2008-10-13 00:00:00 | 10-13-2008 00:00:00 |
5 | Knoxville | Knoxville | Knoxville | 2008-10-14 00:00:00 | 10-14-2008 00:00:00 |
period_date | temp_f_real | temp_f_integer | temp_f_text |
---|---|---|---|
2008-10-10 | 34.9 | 35 | 34.9 |
2008-10-11 | 34.4 | 34 | 34.4 |
2008-10-12 | 34 | 34 | 34 |
2008-10-13 | 35.6 | 36 | 35.6 |
2008-10-14 | 32 | 32 | 32 |