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