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 |
... |
... |
... |
... |