1.0 - 8.00 - Burst Example 2: TimeTable, SplitCriteria ('proportional') - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Input

SQL Call

SELECT * FROM Burst (
  ON burst_example AS input_table PARTITION BY id ORDER BY id
  USING
  TimeColumn ('start_time_column', 'end_time_column')
  TimeInterval (86400)
  TargetColumns ('num_custs')
  StartTime ('08/01/2010')
  EndTime ('08/10/2010')
  SplitCriteria ('proportional')
  Accumulate ('id')
) AS dt ORDER BY id;

Output

The value assigned to each subinterval is determined by dividing the value from each row by the number of subintervals in the row. For example, the value assigned to 2010-08-06 is based on the first 3 rows of the input table: 400/5 + 500/6 + 200/4 = 80 + 83.33 + 50 = 213.33

id num_custs burst_start burst_end burst_duration
1 200 2010-08-01 2010-08-02 86400
1 200 2010-08-02 2010-08-03 86400
1 283.333333333333 2010-08-03 2010-08-04 86400
1 133.333333333333 2010-08-04 2010-08-05 86400
1 213.333333333333 2010-08-05 2010-08-06 86400
1 213.333333333333 2010-08-06 2010-08-07 86400
1 213.333333333333 2010-08-07 2010-08-08 86400
1 163.333333333333 2010-08-08 2010-08-09 86400
1 80 2010-08-09 2010-08-10 86400