TD_ROC( ON { table | view | (query) } AS InputTable [ OUT [VOLATILE| PERMANENT] TABLE OutputTable(output_table_name) ] USING [ ModelIDColumn ('model_id_column') ] ProbabilityColumn ('probability_column') ObservationColumn ('observation_column') [ PositiveLabel ('positive_class_label') ] [ NumThresholds (num_thresholds) ] [ AUC ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ] [ Gini ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ] )
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