17.10 - TD_OutlierFilterFit構文 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine分析関数

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
2021年7月
Content Type
プログラミング リファレンス
Publication ID
B035-1206-171K-JPN
Language
日本語 (日本)
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;