Important: In Analytics Database Release 17.20.03.08 and later, the Model alias is changed to ModelTable in the ON clause. If you are running releases 17.20.03.01 through 17.20.03.07, use Model.
TD_GLMPredict Syntax Using Partition by Any
TD_GLMPredict (
ON { table | view | (query) } AS InputTable [ PARTITION BY ANY ]
ON { table | view | (query) } AS ModelTable DIMENSION
USING
IDColumn ('id_column')
[Accumulate({'accumulate_column'|accumulate_column_range}[,...])]
[OutputProb ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no','n','0'})]
[Responses ('response' [,...])]
[ Family ('Gaussian' | 'Binomial') ]
)
TD_GLMPredict Syntax Using Partition by Key
TD_GLMPredict (
ON { table | view | (query) } AS InputTable PARTITION BY partition_by_column
ON { table | view | (query) } AS ModelTable PARTITION BY partition_by_column
USING
IDColumn ('id_column')
[PartitionColumn ('partition_column')]
[Accumulate({'accumulate_column'|accumulate_column_range}[,...])]
[OutputProb ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no','n','0'})]
[Responses ('response' [,...])]
[ Family ('Gaussian' | 'Binomial') ]
)
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