1.1 - 8.10 - ScaleSummary Example - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Input

CREATE MULTISET TABLE scale_stat AS (                                            
  SELECT * FROM ScaleMap (
    ON scale_housing
    USING
    TargetColumns ('[2:6]')
    MissValue ('omit')
  ) AS dt 
) WITH DATA;

SQL Call

SELECT * FROM ScaleSummary (
  ON scale_stat AS "input" PARTITION BY 1
) AS dt ORDER BY 1;

Output

 stattype  price                lotsize          bedrooms           bathrms            stories            
 --------- -------------------- ---------------- ------------------ ------------------ ------------------ 
 avg                    65037.5           5067.5              2.875              1.125              1.875
 count                      8.0              8.0                8.0                8.0                8.0
 ignorerow                  2.0              2.0                2.0                2.0                2.0
 infinity                   0.0              0.0                0.0                0.0                0.0
 max                    88500.0           6650.0                3.0                2.0                4.0
 min                    42000.0           3060.0                2.0                1.0                1.0
 nan                        0.0              0.0                0.0                0.0                0.0
 null                       1.0              0.0                1.0                0.0                0.0
 squaresum          3.556719E10       2.161594E8               67.0               11.0               37.0
 std         15712.500710307973 1237.67927994291 0.3535533905932738 0.3535533905932738 1.1259916264596033
 sum                   520300.0          40540.0               23.0                9.0               15.0
 variance  2.4688267857142857E8        1531850.0              0.125              0.125 1.2678571428571428

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.