7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
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
MurmurHash Examples Input Table murmurhash_input (Columns 1-6)
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
MurmurHash Examples Input Table murmurhash_input (Columns 7-10)
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