16.20 - Aster Model Table Schemas - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)

Forest_Predict Model Table Schema

CREATE FACT TABLE public.aster_fp_admissions_clsmodel
(
  worker_ip VARCHAR,
  task_index INTEGER,
  tree_num INTEGER,
  tree VARCHAR
)
DISTRIBUTE BY HASH (task_index)
STORAGE ROW;

GLMPredict Model Table Schema

CREATE ANALYTIC FACT TABLE public.glm_housing_model
(
  attribute INTEGER,
  predictor VARCHAR(1024),
  category VARCHAR(1024),
  estimate DOUBLE PRECISION,
  std_err DOUBLE PRECISION,
  { t_score | z_score } DOUBLE PRECISION,
  p_value DOUBLE PRECISION,
  significance VARCHAR(50),
  family VARCHAR(20)
)
DISTRIBUTE BY HASH (attribute)
STORAGE ROW;

The model table has the column t_score if created with Family ('GAUSSIAN'), otherwise it has the column z_score.

NaiveBayesPredict Model Table Schema

CREATE ANALYTIC FACT TABLE public.aster_nb_modelsc
(
  class_nb VARCHAR(128),
  variable_nb VARCHAR(128),
  type_nb VARCHAR(128),
  category VARCHAR(32),
  cnt BIGINT,
  sum_nb DOUBLE PRECISION,
  sum_sq DOUBLE PRECISION,
  total_cnt BIGINT
)
DISTRIBUTE BY HASH (class_nb)
STORAGE ROW;

NaiveBayesTextClassifierPredict Model Table Schema

CREATE DIMENSION TABLE public.nbtcp_spam_multinomialmodel
(
  token VARCHAR,
  category VARCHAR,
  prob DOUBLE PRECISION
)
DISTRIBUTE BY REPLICATION
STORAGE ROW;

Single_Tree_Predict Model Table Schema

CREATE DIMENSION TABLE public.glass_model
(
  node_id BIGINT,
  node_size BIGINT,
  node_gini_p DOUBLE PRECISION,
  node_entropy DOUBLE PRECISION,
  node_chisq_pv DOUBLE PRECISION,
  node_label VARCHAR(512),
  node_majorvotes BIGINT,
  split_value DOUBLE PRECISION,
  split_gini_p DOUBLE PRECISION,
  split_entropy DOUBLE PRECISION,
  split_chisq_pv DOUBLE PRECISION,
  left_id BIGINT,
  left_size BIGINT,
  left_label VARCHAR(512),
  left_majorvotes BIGINT,
  right_id BIGINT,
  right_size BIGINT,
  right_label VARCHAR(512),
  right_majorvotes BIGINT,
  left_bucket VARCHAR(512),
  right_bucket VARCHAR(512),
  attribute VARCHAR(512)
)
DISTRIBUTE BY REPLICATION
STORAGE ROW;

SparseSVMPredict Model Table Schema

CREATE FACT TABLE public.aster_svm_iris_model_default
(
  classid INTEGER,
  weights BYTEA
)
DISTRIBUTE BY HASH (classid)
STORAGE ROW;