RandomSample Syntax - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

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;