生成されたラベルを持つ等幅ビンの場合
CREATE TABLE primary_output_table AS (
SELECT * FROM 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') ]
) AS alias
) WITH DATA;
指定したラベルを持つ可変幅ビンの場合
CREATE TABLE primary_output_table AS (
SELECT * FROM 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') ]
) AS alias
) WITH DATA;