TD_TargetEncodingFit (
ON {table | view | (query)} AS InputTable
ON {table | view | (query)} AS CategoryTable DIMENSION
[ OUT [ PERMANENT | VOLATILE ] TABLE OutputTable (output_table_name)]
USING
EncoderMethod({'CBM_BETA' | 'CBM_DIRICHLET' | 'CBM_GAUSSIAN_INVERSE_GAMMA'})
TargetColumns ({'target_column' | 'target_column_range'} [,... ])
ResponseColumn ('response_column')
[AlphaPrior(alpha_prior_value)]
[BetaPrior(beta_prior_value)]
[AlphaPriors(list_of_values)]
[NumDistinctResponses(num_distinct_responses)]
[U0Prior(u0_prior_value)]
[V0Prior(v0_prior_value)]
[Alpha0Prior(alpha0_prior_value)]
[Beta0Prior(beta0_prior_value)]
[DefaultValues ({ default_value | default_value_i, ... })]
)
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement