LinRegPredict Example - Teradata Vantage

Input

• Input table: housing_data, as in the Linear Regression Example
• Model table: LinRegModel, is the output of the Linear Regression Example, created as follows:

CREATE MULTISET TABLE LinRegModel AS (
  SELECT * FROM LinReg (
    ON LinRegInternal (
      ON housing_data
    ) AS dt1 PARTITION BY 1
  ) AS dt2
) WITH DATA;

SQL Call

SELECT * FROM LinRegPredict ( 
  ON housing_data AS "input" PARTITION BY ANY
  ON LinRegModel AS model DIMENSION
  USING
  InputColumns ('housesize','lotsize','bedrooms','granite','upgradedbathroom')
  Accumulate ('housesize','lotsize','bedrooms','granite','upgradedbathroom')
) AS dt ORDER BY 1;

Output