XGBoostPredict Example 3: Sparse Input Format - Teradata Vantage

Input

• input: sparse_housing_test_binary, created by inputting housing_test_binary (input table for XGBoostPredict Example 1: Binary Classification) to the Unpivoting function:

  DROP TABLE IF EXISTS sparse_housing_test_binary;
  
  CREATE MULTISET TABLE sparse_housing_test_binary AS (
    SELECT sn, homestyle, attribute, value_col AS value1 FROM 
      Unpivoting (
        ON housing_test_binary
        USING
        TargetColumns (
          'price','lotsize','bedrooms','bathrms','stories',
          'garagepl','driveway','recroom','fullbase','gashw','airco','prefarea'
        )
        Accumulate ('sn','homestyle')
      ) AS dt
  ) WITH DATA;
  

• ModelTable: sparse_housing_xgboost_model, output by XGBoost Example 3: Sparse Input Format

SQL Call

CREATE MULTISET TABLE sparse_housing_predict AS (
  SELECT * FROM XGBoost_Predict (
    ON sparse_housing_test_binary AS "input" PARTITION BY sn
    ON sparse_housing_xgboost_model AS modeltable DIMENSION ORDER BY tree_id, iter, class_num
    USING
    AttributeNameColumn ('attribute')
    AttributeValueColumn ('value1')
    IdColumn ('sn')
    NumBoostedTrees (1)
    Accumulate ('homestyle')
  ) AS dt
) WITH DATA;

Output