1.0 - 8.00 - RandomSample Syntax - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Version 1.2

SELECT * FROM RandomSample (
  ON { table | view | (query) } AS InputTable
  USING
  NumSample (sample_size [,...])
  [ WeightColumn ('weight_column') ]
  [ SamplingMode ({ 'basic' | 'kmeans++' | 'kmeans||' }) ]
  [ Distance ({ 'euclidean' | 'manhattan' }) ]
  [ InputColumns ( { 'input_column' | input_column_range }[,...] ) ]
  [ AsCategories ( { 'ascat_column' | ascat_column_range }[,...] ) ]
  [ CategoryWeights (category_weight [,...]) ]
  [ CategoricalDistance ({ 'overlap' | 'hamming' }) ]
  [ Seed (seed)
    SeedColumn ({ 'seed_column' | seed_column_range } [,...])
  ]
  [ OverSamplingRate (rate) ]
  [ IterationNum (number_of_iterations) ]
) AS alias;