RandomSample Syntax - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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;