TF_IDF (TF_IDF version 2.1, TF version 1.1) - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
SELECT * FROM TF_IDF (
  ON TF (
    ON {  table  |  view  | (query) } PARTITION BY  docid 
      [ Formula ({ 'normal' | 'bool' | 'log' | 'augment' }) ]
  ) AS tf PARTITION BY  term 
  [ ON (SELECT COUNT (DISTINCT  docid)
    FROM  doccount_table) AS doccount DIMENSION ]
  [ ON (SELECT  term, COUNT (DISTINCT  docid)
    FROM  docperterm_table 
    GROUP BY  term)AS docperterm PARTITION BY  term  ]
  [ ON (SELECT DISTINCT (term) AS term, idf
    FROM  tf_idf_output_table  ) AS idf PARTITION BY  term  ]
);