Input - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software
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