1.1 - 8.10 - RandomSample Syntax - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Version 1.5

SELECT * FROM RandomSample (
  ON { table | view | (query) } AS InputTable
  USING
  NumSample (sample_size [,...])
  [ WeightColumn ('weight_column') ]
  [ SamplingMode ({ 'basic' | 'kmeans++' | 'kmeans||' }) ]
  [ Distance ({ 'euclidean' | 'manhattan' }) ]
  [ TargetColumns ( { 'target_column' | target_column_range }[,...] ) ]
  [ NumericAsCategorical ( { 'ascat_column' | ascat_column_range }[,...] ) ]
  [ CategoryWeights (category_weight [,...]) ]
  [ CategoricalDistance ({ 'overlap' | 'hamming' }) ]
  [ Seed (seed)
    SeedColumn ({ 'seed_column' | seed_column_range } [,...])
  ]
  [ OverSamplingRate (rate) ]
  [ IterNum (number_of_iterations) ]
  [ SetIDAsFirstColumn ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
) AS alias;