7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

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