Dense Input
Syntax without partition:
TD_ScaleTransform ( ON { table | view | (query) } AS InputTable ON { table | view | (query) } AS FitTable DIMENSION [ USING Accumulate ({ 'accumulate_column' | 'accumulate_column_range' }[,...]) ] )
Syntax with partition:
TD_ScaleTransform ( ON { table | view | (query) } AS InputTable PARTITION BY partition_column [,...] ON { table | view | (query) } AS FitTable PARTITION BY partition_column [,...] [ USING Accumulate ({ 'accumulate_column' | 'accumulate_column_range' }[,...]) ] )
Sparse Input
Syntax without partition
TD_ScaleTransform ( ON { table | view | (query) } AS InputTable ON { table | view | (query) } AS FitTable DIMENSION USING AttributeNameColumn ('attribute_name_column') AttributeValueColumn ('attribute_value_column') [ Accumulate ({ 'accumulate_column' | 'accumulate_column_range' }[,...]) ] )
Syntax with partition
TD_ScaleTransform ( ON { table | view | (query) } AS InputTable PARTITION BY partition_column [,...] ON { table | view | (query) } AS FitTable PARTITION BY partition_column [,...] USING AttributeNameColumn ('attribute_name_column') AttributeValueColumn ('attribute_value_column') [ Accumulate ({ 'accumulate_column' | 'accumulate_column_range' }[,...]) ] )
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