TD_OutlierFilterFit構文 - Advanced SQL Engine - Teradata Database

CREATE TABLE fit_table AS (
  SELECT * FROM TD_OutlierFilterFit (
    ON { table | view | (query) } AS InputTable
    USING
    TargetColumns ({ 'target_column' | target_column_range }[,...])
    [ GroupColumns ('group_column') ]
    OutlierMethod ({ 'percentile' | 'tukey' | 'carling' })
    LowerPercentile (min_value)
    UpperPercentile (max_value)
    [ IQRMultiplier (k) ]
    ReplacementValue ({ 'delete' | 'null' | 'median' | replacement_value})
    [ RemoveTail ({ 'both' | 'upper' | 'lower' }) ]
    PercentileMethod ({ 'PercentileCont' | 'PercentileDISC' })
  ) AS alias
) WITH DATA;