The hash values for each city name in the output table are the same, regardless of data type, but the hash values for each time period are different for each data type.
When the temperature value in the input table is an integer (as in rows 3 and 5 of Input), the hash values are the same for INTEGER and TEXT, but different for REAL. When the temperature value in the input table is real, the hash values are the same for REAL and TEXT, but different for INTEGER.
MurmurHash Example 1 Output Table (Columns 1-4)
| id |
city_bytea_murmurhash |
city_varchar_murmurhash |
city_text_murmurhash |
| 1 |
-548788049 |
-548788049 |
-548788049 |
| 2 |
595880669 |
595880669 |
595880669 |
| 3 |
773070680 |
773070680 |
773070680 |
| 4 |
1115825340 |
1115825340 |
1115825340 |
| 5 |
-1362387812 |
-1362387812 |
-1362387812 |
MurmurHash Example 1 Output Table (Columns 5-7)
| period_timestamp_murmurhash |
period_text_murmurhash |
period_date_murmurhash |
| 1962681181 |
-463297848 |
557349452 |
| -1741097193 |
1584740227 |
-1509759604 |
| 1530898040 |
1693067691 |
-122411470 |
| -1426854377 |
-2116413651 |
1981218164 |
| -1560585364 |
2011908706 |
1085005088 |
MurmurHash Example 1 Output Table (Columns 8-10)
| temp_f_real_murmurhash |
temp_f_integer_murmurhash |
temp_f_text_murmurhash |
| 491855154 |
-392240485 |
491855154 |
| -499861358 |
-2026295078 |
-499861358 |
| -141326552 |
-2026295078 |
-2026295078 |
| 138771797 |
-736537098 |
138771797 |
| 1047067045 |
-902858061 |
-902858061 |