RandomSample Syntax - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software
Version 1.0
SELECT * FROM RandomSample (
  ON (SELECT 1) PARTITION BY 1
  [ Domain ('host:port') ]
  [ Database ('db_name') ]
  [ UserID ('user_id') ]
  [ Password ('password') ]
  [ SSLSettings ('SSLsettings') ]
  [ SSLTrustStorePassword ('SSLtruststorepassword') ]
  InputTable ('input_table')
  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') ]
);
For information about the authentication arguments, see the following topics: