7.00.02 - Output - 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)

Because InputTypes has the value 'true', the output table has a separate value column for each unpivot column. The unpivot columns temp, pressure, and dewpoint have the data types INTEGER, DOUBLE PRECISION, and VARCHAR (respectively); therefore, their corresponding unpivoted columns have the data types LONG, DOUBLE PRECISION, and VARCHAR.

Unpivot Example 2 Output Table
sn city week climate_attributes attributevalue_long attributevalue_double attributevalue_str
1 Asheville 1 temp 32    
1 Asheville 1 pressure   1020.79998779297  
1 Asheville 1 dewpoint     27.6F
2 Asheville 2 temp 32    
2 Asheville 2 pressure   1021.29998779297  
2 Asheville 2 dewpoint     27.4F
3 Asheville 3 temp 34    
3 Asheville 3 pressure   1021.70001220703  
3 Asheville 3 dewpoint     28.2F
4 Nashville 1 temp 42    
4 Nashville 1 pressure   1021  
4 Nashville 1 dewpoint     29.4F
5 Nashville 2 temp 44    
5 Nashville 2 pressure   1019.79998779297  
5 Nashville 2 dewpoint     29.2F
6 Brownsville 2 temp 47    
6 Brownsville 2 pressure   1019  
6 Brownsville 2 dewpoint     28.9F
7 Brownsville 3 temp 46    
7 Brownsville 3 pressure   1019.20001220703  
7 Brownsville 3 dewpoint     28.9F