Interpolator (version 1.0) - 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 Interpolator (
  ON {  table|view|(query)}  AS input_table
    PARTITION BY  id 
    ORDER BY  ordering_column 
  [ ON {  table|view|(query) } AS time_table
      DIMENSION ORDER BY  ordering_column  ]
  [ ON {  table|view|(query) } AS count_row_number
      PARTITION BY  id  ]
  TimeColumn ('time_column')
  [ TimeInterval (time_interval) ]
  ValueColumns ({ 'value_column' | 'value_column_range' }[,...])
  [ InterpolationType (interpolation_type  [,...] ) ]
  [ AggregationType (aggregation_type  [,...] ) ]
  [ TimeDataType (time_data_type) ]
  [ ValueDataType (value_type  [,...])]
  [ StartTime (start_time) ]
  [ EndTime (end_time) ]
  [ ValuesBeforeFirst ('value' [,...]) ]
  [ ValuesAfterLast ('value' [,...]) ]
  [ DuplicateRowsCount ('value1' [,'value2']) ]
  [ Accumulate
    ({ 'accumulate_column' | 'accumulate_column_range' }[,...]) ]
);