For Equal-Width Bins with Generated Labels
TD_BincodeFit (
ON { table | view | (query) } AS InputTable
[ OUT [ PERMANENT | VOLATILE ] TABLE OutputTable (output_table) ]
USING
TargetColumns ({ 'target_column' | target_column_range }[,...])
MethodType ('equal-width')
NBins ('single bin value' | 'separate bin values')
[ LabelPrefix ('single prefix' | 'separate prefix values') ]
)
For Variable-Width Bins with Specified Labels
TD_BincodeFit (
ON { table | view | (query) } AS InputTable
ON { table | view | (query) } AS FitInput DIMENSION
USING
TargetColumns ({ 'target_column' | target_column_range }[,...])
MethodType ('variable-width')
[ MinValueColumn ('minvalue_column') ]
[ MaxValueCOlumn ('maxvalue_column') ]
[ LabelColumn ('label_column') ]
[ TargetColNames ('target_names_column') ]
)
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