7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
SeriesSplitter Example 1 Stats Table
statistics value
input_table_row_count 369
input_partition_count 1
output_split_count 47
inserted_row_count 94
output_table_row_count 463
processing_time_in_seconds 5

The query below returns the output shown in the following table:

SELECT * FROM ibm_stock1_split ORDER BY id, split_id;
SeriesSplitter Example 1 Output Table ibm_stock1_split
split_id id period stockprice
1-0 1 1961-05-1800:00:00 457
1-0 1 1961-05-1700:00:00 460
1-0 1 1961-05-2200:00:00 459
1-0 1 1961-05-2300:00:00 462
1-0 1 1961-05-2400:00:00 459
1-0 1 1961-05-1900:00:00 452
1-0 1 1961-05-2500:00:00 463
1-0 1 1961-05-2600:00:00 479
1-0 1 1900-01-0100:00:00  
1-0 1 1961-05-2900:00:00 493
1-1 1 1961-05-2600:00:00 479
1-1 1 1961-05-3100:00:00 490
1-1 1 1961-06-0200:00:00 498
1-1 1 1961-06-0500:00:00 499
1-1 1 1961-06-0600:00:00 497
1-1 1 1961-06-0700:00:00 496
1-1 1 1961-06-0800:00:00 490
1-1 1 1961-06-0100:00:00 492
1-1 1 1961-06-0900:00:00 489
1-1 1 1961-05-2900:00:00 493
1-10 1 1961-09-1800:00:00 543
1-10 1 1961-09-0800:00:00 541
1-10 1 1961-09-1500:00:00 547
1-10 1 1961-09-1400:00:00 549
1-10 1 1961-09-1300:00:00 545
1-10 1 1961-09-1200:00:00 549
1-10 1 1961-09-1100:00:00 545
1-10 1 1961-09-2100:00:00 532
1-10 1 1961-09-2000:00:00 539
1-10 1 1961-09-1900:00:00 540
1-11 1 1961-09-2000:00:00 539
1-11 1 1961-10-0200:00:00 541
1-11 1 1961-09-2900:00:00 541
1-11 1 1961-09-2800:00:00 538
1-11 1 1961-09-2700:00:00 542
1-11 1 1961-09-2600:00:00 540
1-11 1 1961-09-2500:00:00 527
1-11 1 1961-09-2200:00:00 517
1-11 1 1961-09-2100:00:00 532
1-11 1 1961-10-0300:00:00 547
... ... ... ...