Burst Example: TimeInterval, SplitCriteria ('proportional') | Teradata Vantage - Burst Example: TimeInterval, SplitCriteria ('proportional') - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Input

SQL Call

SELECT * FROM Burst (
  ON burst_example AS InputTable 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 ;

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.0 2010-08-01  2010-08-02        86400.0
  1              200.0 2010-08-02  2010-08-03        86400.0
  1  283.3333333333333 2010-08-03  2010-08-04        86400.0
  1 133.33333333333331 2010-08-04  2010-08-05        86400.0
  1 213.33333333333331 2010-08-05  2010-08-06        86400.0
  1 213.33333333333331 2010-08-06  2010-08-07        86400.0
  1 213.33333333333331 2010-08-07  2010-08-08        86400.0
  1 163.33333333333331 2010-08-08  2010-08-09        86400.0
  1               80.0 2010-08-09  2010-08-10        86400.0

Download a zip file of all examples and a SQL script file that creates their input tables.