Input
- scale_stat, created in Scale Example: Use Training Data to Scale Test Data
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.