Input
The input table has the daily stock prices from 1961 to 1962.
id | name | period | stockprice |
---|---|---|---|
1 | Company1 | 1961-05-1700:00:00 | 460 |
1 | Company1 | 1961-05-1800:00:00 | 457 |
1 | Company1 | 1961-05-1900:00:00 | 452 |
1 | Company1 | 1961-05-2200:00:00 | 459 |
1 | Company1 | 1961-05-2300:00:00 | 462 |
1 | Company1 | 1961-05-2400:00:00 | 459 |
1 | Company1 | 1961-05-2500:00:00 | 463 |
1 | Company1 | 1961-05-2600:00:00 | 479 |
1 | Company1 | 1961-05-2900:00:00 | 493 |
1 | Company1 | 1961-05-3100:00:00 | 490 |
1 | Company1 | 1961-06-0100:00:00 | 492 |
1 | Company1 | 1961-06-0200:00:00 | 498 |
1 | Company1 | 1961-06-0500:00:00 | 499 |
1 | Company1 | 1961-06-0600:00:00 | 497 |
1 | Company1 | 1961-06-0700:00:00 | 496 |
1 | Company1 | 1961-06-0800:00:00 | 490 |
1 | Company1 | 1961-06-0900:00:00 | 489 |
1 | Company1 | 1961-06-1200:00:00 | 478 |
1 | Company1 | 1961-06-1300:00:00 | 487 |
1 | Company1 | 1961-06-1400:00:00 | 491 |
... | ... | ... | ... |
SQL Call
SELECT * FROM SeriesSplitter( ON ibm_stock1 AS InputTable OUT TABLE OutputTable(ibm_stock1_split) USING PartitionColumns('id') OrderByColumns('period') SplitCount(50) Accumulate('stockprice') ) AS dt ;
Output
This query returns the following table:
SELECT * FROM ibm_stock1_split ORDER BY id, split_id, period;
split_id id period stockprice -------- -- -------------------------- ---------- 1-0 1 1900-01-01 00:00:00.000000 NULL 1-0 1 1961-05-17 00:00:00.000000 460.0 1-0 1 1961-05-18 00:00:00.000000 457.0 1-0 1 1961-05-19 00:00:00.000000 452.0 1-0 1 1961-05-22 00:00:00.000000 459.0 1-0 1 1961-05-23 00:00:00.000000 462.0 1-0 1 1961-05-24 00:00:00.000000 459.0 1-0 1 1961-05-25 00:00:00.000000 463.0 1-0 1 1961-05-26 00:00:00.000000 479.0 1-0 1 1961-05-29 00:00:00.000000 493.0 1-1 1 1961-05-26 00:00:00.000000 479.0 1-1 1 1961-05-29 00:00:00.000000 493.0 1-1 1 1961-05-31 00:00:00.000000 490.0 1-1 1 1961-06-01 00:00:00.000000 492.0 1-1 1 1961-06-02 00:00:00.000000 498.0 1-1 1 1961-06-05 00:00:00.000000 499.0 1-1 1 1961-06-06 00:00:00.000000 497.0 1-1 1 1961-06-07 00:00:00.000000 496.0 1-1 1 1961-06-08 00:00:00.000000 490.0 1-1 1 1961-06-09 00:00:00.000000 489.0 1-10 1 1961-09-08 00:00:00.000000 541.0 1-10 1 1961-09-11 00:00:00.000000 545.0 1-10 1 1961-09-12 00:00:00.000000 549.0 1-10 1 1961-09-13 00:00:00.000000 545.0 1-10 1 1961-09-14 00:00:00.000000 549.0 1-10 1 1961-09-15 00:00:00.000000 547.0 1-10 1 1961-09-18 00:00:00.000000 543.0 1-10 1 1961-09-19 00:00:00.000000 540.0 1-10 1 1961-09-20 00:00:00.000000 539.0 1-10 1 1961-09-21 00:00:00.000000 532.0 1-11 1 1961-09-20 00:00:00.000000 539.0 1-11 1 1961-09-21 00:00:00.000000 532.0 1-11 1 1961-09-22 00:00:00.000000 517.0 1-11 1 1961-09-25 00:00:00.000000 527.0 1-11 1 1961-09-26 00:00:00.000000 540.0 1-11 1 1961-09-27 00:00:00.000000 542.0 1-11 1 1961-09-28 00:00:00.000000 538.0 1-11 1 1961-09-29 00:00:00.000000 541.0 1-11 1 1961-10-02 00:00:00.000000 541.0 1-11 1 1961-10-03 00:00:00.000000 547.0 1-12 1 1961-10-02 00:00:00.000000 541.0 1-12 1 1961-10-03 00:00:00.000000 547.0 1-12 1 1961-10-04 00:00:00.000000 553.0 1-12 1 1961-10-05 00:00:00.000000 559.0 1-12 1 1961-10-06 00:00:00.000000 557.0 1-12 1 1961-10-10 00:00:00.000000 557.0 1-12 1 1961-10-11 00:00:00.000000 560.0 1-12 1 1961-10-12 00:00:00.000000 571.0 1-12 1 1961-10-13 00:00:00.000000 571.0 1-12 1 1961-10-16 00:00:00.000000 569.0 1-13 1 1961-10-13 00:00:00.000000 571.0 1-13 1 1961-10-16 00:00:00.000000 569.0 1-13 1 1961-10-17 00:00:00.000000 575.0 1-13 1 1961-10-18 00:00:00.000000 580.0 1-13 1 1961-10-19 00:00:00.000000 584.0 1-13 1 1961-10-20 00:00:00.000000 585.0 1-13 1 1961-10-23 00:00:00.000000 590.0 1-13 1 1961-10-24 00:00:00.000000 599.0 1-13 1 1961-10-25 00:00:00.000000 603.0 1-13 1 1961-10-26 00:00:00.000000 599.0 1-14 1 1961-10-25 00:00:00.000000 603.0 1-14 1 1961-10-26 00:00:00.000000 599.0 1-14 1 1961-10-27 00:00:00.000000 596.0 1-14 1 1961-10-30 00:00:00.000000 585.0 1-14 1 1961-10-31 00:00:00.000000 587.0 1-14 1 1961-11-01 00:00:00.000000 585.0 1-14 1 1961-11-02 00:00:00.000000 581.0 1-14 1 1961-11-03 00:00:00.000000 583.0 1-14 1 1961-11-06 00:00:00.000000 592.0 1-14 1 1961-11-07 00:00:00.000000 592.0 1-15 1 1961-11-06 00:00:00.000000 592.0 1-15 1 1961-11-07 00:00:00.000000 592.0 1-15 1 1961-11-08 00:00:00.000000 596.0 1-15 1 1961-11-09 00:00:00.000000 596.0 1-15 1 1961-11-13 00:00:00.000000 595.0 1-15 1 1961-11-14 00:00:00.000000 598.0 1-15 1 1961-11-15 00:00:00.000000 598.0 1-15 1 1961-11-16 00:00:00.000000 595.0 1-15 1 1961-11-17 00:00:00.000000 595.0 1-15 1 1961-11-20 00:00:00.000000 592.0 1-16 1 1961-11-17 00:00:00.000000 595.0 1-16 1 1961-11-20 00:00:00.000000 592.0 1-16 1 1961-11-21 00:00:00.000000 588.0 1-16 1 1961-11-22 00:00:00.000000 582.0 1-16 1 1961-11-24 00:00:00.000000 576.0 1-16 1 1961-11-27 00:00:00.000000 578.0 1-16 1 1961-11-28 00:00:00.000000 589.0 1-16 1 1961-11-29 00:00:00.000000 585.0 1-16 1 1961-11-30 00:00:00.000000 580.0 1-16 1 1961-12-01 00:00:00.000000 579.0 1-17 1 1961-11-30 00:00:00.000000 580.0 1-17 1 1961-12-01 00:00:00.000000 579.0 1-17 1 1961-12-04 00:00:00.000000 584.0 1-17 1 1961-12-05 00:00:00.000000 581.0 1-17 1 1961-12-06 00:00:00.000000 581.0 1-17 1 1961-12-07 00:00:00.000000 577.0 1-17 1 1961-12-08 00:00:00.000000 577.0 1-17 1 1961-12-11 00:00:00.000000 578.0 1-17 1 1961-12-12 00:00:00.000000 580.0 1-17 1 1961-12-13 00:00:00.000000 586.0 1-18 1 1961-12-12 00:00:00.000000 580.0 1-18 1 1961-12-13 00:00:00.000000 586.0 1-18 1 1961-12-14 00:00:00.000000 583.0 1-18 1 1961-12-15 00:00:00.000000 581.0 1-18 1 1961-12-18 00:00:00.000000 576.0 1-18 1 1961-12-19 00:00:00.000000 571.0 1-18 1 1961-12-20 00:00:00.000000 575.0 1-18 1 1961-12-21 00:00:00.000000 575.0 1-18 1 1961-12-22 00:00:00.000000 573.0 1-18 1 1961-12-26 00:00:00.000000 577.0 1-19 1 1961-12-22 00:00:00.000000 573.0 1-19 1 1961-12-26 00:00:00.000000 577.0 1-19 1 1961-12-27 00:00:00.000000 582.0 1-19 1 1961-12-28 00:00:00.000000 584.0 1-19 1 1961-12-29 00:00:00.000000 579.0 1-19 1 1962-01-02 00:00:00.000000 572.0 1-19 1 1962-01-03 00:00:00.000000 577.0 1-19 1 1962-01-04 00:00:00.000000 571.0 1-19 1 1962-01-05 00:00:00.000000 560.0 1-19 1 1962-01-08 00:00:00.000000 549.0 1-2 1 1961-06-08 00:00:00.000000 490.0 1-2 1 1961-06-09 00:00:00.000000 489.0 1-2 1 1961-06-12 00:00:00.000000 478.0 1-2 1 1961-06-13 00:00:00.000000 487.0 1-2 1 1961-06-14 00:00:00.000000 491.0 1-2 1 1961-06-15 00:00:00.000000 487.0 1-2 1 1961-06-16 00:00:00.000000 482.0 1-2 1 1961-06-19 00:00:00.000000 479.0 1-2 1 1961-06-20 00:00:00.000000 478.0 1-2 1 1961-06-21 00:00:00.000000 479.0 1-20 1 1962-01-05 00:00:00.000000 560.0 1-20 1 1962-01-08 00:00:00.000000 549.0 1-20 1 1962-01-09 00:00:00.000000 556.0 1-20 1 1962-01-10 00:00:00.000000 557.0 1-20 1 1962-01-11 00:00:00.000000 563.0 1-20 1 1962-01-12 00:00:00.000000 564.0 1-20 1 1962-01-15 00:00:00.000000 567.0 1-20 1 1962-01-16 00:00:00.000000 561.0 1-20 1 1962-01-17 00:00:00.000000 559.0 1-20 1 1962-01-18 00:00:00.000000 553.0 1-21 1 1962-01-17 00:00:00.000000 559.0 1-21 1 1962-01-18 00:00:00.000000 553.0 1-21 1 1962-01-19 00:00:00.000000 553.0 1-21 1 1962-01-22 00:00:00.000000 553.0 1-21 1 1962-01-23 00:00:00.000000 547.0 1-21 1 1962-01-24 00:00:00.000000 550.0 1-21 1 1962-01-25 00:00:00.000000 544.0 1-21 1 1962-01-26 00:00:00.000000 541.0 1-21 1 1962-01-29 00:00:00.000000 532.0 1-21 1 1962-01-30 00:00:00.000000 525.0 1-22 1 1962-01-29 00:00:00.000000 532.0 1-22 1 1962-01-30 00:00:00.000000 525.0 1-22 1 1962-01-31 00:00:00.000000 542.0 1-22 1 1962-02-01 00:00:00.000000 555.0 1-22 1 1962-02-02 00:00:00.000000 558.0 1-22 1 1962-02-05 00:00:00.000000 551.0 1-22 1 1962-02-06 00:00:00.000000 551.0 1-22 1 1962-02-07 00:00:00.000000 552.0 1-22 1 1962-02-08 00:00:00.000000 553.0 1-22 1 1962-02-09 00:00:00.000000 557.0 1-23 1 1962-02-08 00:00:00.000000 553.0 1-23 1 1962-02-09 00:00:00.000000 557.0 1-23 1 1962-02-12 00:00:00.000000 557.0 1-23 1 1962-02-13 00:00:00.000000 548.0 1-23 1 1962-02-14 00:00:00.000000 547.0 1-23 1 1962-02-15 00:00:00.000000 545.0 1-23 1 1962-02-16 00:00:00.000000 545.0 1-23 1 1962-02-19 00:00:00.000000 539.0 1-23 1 1962-02-20 00:00:00.000000 539.0 1-23 1 1962-02-21 00:00:00.000000 535.0 1-24 1 1962-02-20 00:00:00.000000 539.0 1-24 1 1962-02-21 00:00:00.000000 535.0 1-24 1 1962-02-23 00:00:00.000000 537.0 1-24 1 1962-02-26 00:00:00.000000 535.0 1-24 1 1962-02-27 00:00:00.000000 536.0 1-24 1 1962-02-28 00:00:00.000000 537.0 1-24 1 1962-03-01 00:00:00.000000 543.0 1-24 1 1962-03-02 00:00:00.000000 548.0 1-24 1 1962-03-05 00:00:00.000000 546.0 1-24 1 1962-03-06 00:00:00.000000 547.0 1-25 1 1962-03-05 00:00:00.000000 546.0 1-25 1 1962-03-06 00:00:00.000000 547.0 1-25 1 1962-03-07 00:00:00.000000 548.0 1-25 1 1962-03-08 00:00:00.000000 549.0 1-25 1 1962-03-09 00:00:00.000000 553.0 1-25 1 1962-03-12 00:00:00.000000 553.0 1-25 1 1962-03-13 00:00:00.000000 552.0 1-25 1 1962-03-14 00:00:00.000000 551.0 1-25 1 1962-03-15 00:00:00.000000 550.0 1-25 1 1962-03-16 00:00:00.000000 553.0 1-26 1 1962-03-15 00:00:00.000000 550.0 1-26 1 1962-03-16 00:00:00.000000 553.0 1-26 1 1962-03-19 00:00:00.000000 554.0 1-26 1 1962-03-20 00:00:00.000000 551.0 1-26 1 1962-03-21 00:00:00.000000 551.0 1-26 1 1962-03-22 00:00:00.000000 545.0 1-26 1 1962-03-23 00:00:00.000000 547.0 1-26 1 1962-03-26 00:00:00.000000 547.0 1-26 1 1962-03-27 00:00:00.000000 537.0 1-26 1 1962-03-28 00:00:00.000000 539.0 1-27 1 1962-03-27 00:00:00.000000 537.0 1-27 1 1962-03-28 00:00:00.000000 539.0 1-27 1 1962-03-29 00:00:00.000000 538.0 1-27 1 1962-03-30 00:00:00.000000 533.0 1-27 1 1962-04-02 00:00:00.000000 525.0 1-27 1 1962-04-03 00:00:00.000000 513.0 1-27 1 1962-04-04 00:00:00.000000 510.0 1-27 1 1962-04-05 00:00:00.000000 521.0 1-27 1 1962-04-06 00:00:00.000000 521.0 1-27 1 1962-04-09 00:00:00.000000 521.0 1-28 1 1962-04-06 00:00:00.000000 521.0 1-28 1 1962-04-09 00:00:00.000000 521.0 1-28 1 1962-04-10 00:00:00.000000 523.0 1-28 1 1962-04-11 00:00:00.000000 516.0 1-28 1 1962-04-12 00:00:00.000000 511.0 1-28 1 1962-04-13 00:00:00.000000 518.0 1-28 1 1962-04-16 00:00:00.000000 517.0 1-28 1 1962-04-17 00:00:00.000000 520.0 1-28 1 1962-04-18 00:00:00.000000 519.0 1-28 1 1962-04-19 00:00:00.000000 519.0 1-29 1 1962-04-18 00:00:00.000000 519.0 1-29 1 1962-04-19 00:00:00.000000 519.0 1-29 1 1962-04-20 00:00:00.000000 519.0 1-29 1 1962-04-23 00:00:00.000000 518.0 1-29 1 1962-04-24 00:00:00.000000 513.0 1-29 1 1962-04-25 00:00:00.000000 499.0 1-29 1 1962-04-26 00:00:00.000000 485.0 1-29 1 1962-04-27 00:00:00.000000 454.0 1-29 1 1962-04-30 00:00:00.000000 462.0 1-29 1 1962-05-01 00:00:00.000000 473.0 1-3 1 1961-06-20 00:00:00.000000 478.0 1-3 1 1961-06-21 00:00:00.000000 479.0 1-3 1 1961-06-22 00:00:00.000000 477.0 1-3 1 1961-06-23 00:00:00.000000 479.0 1-3 1 1961-06-26 00:00:00.000000 475.0 1-3 1 1961-06-27 00:00:00.000000 479.0 1-3 1 1961-06-28 00:00:00.000000 476.0 1-3 1 1961-06-29 00:00:00.000000 476.0 1-3 1 1961-06-30 00:00:00.000000 478.0 1-3 1 1961-07-03 00:00:00.000000 479.0 1-30 1 1962-04-30 00:00:00.000000 462.0 1-30 1 1962-05-01 00:00:00.000000 473.0 1-30 1 1962-05-02 00:00:00.000000 482.0 1-30 1 1962-05-03 00:00:00.000000 486.0 1-30 1 1962-05-04 00:00:00.000000 475.0 1-30 1 1962-05-07 00:00:00.000000 459.0 1-30 1 1962-05-08 00:00:00.000000 451.0 1-30 1 1962-05-09 00:00:00.000000 453.0 1-30 1 1962-05-10 00:00:00.000000 446.0 1-30 1 1962-05-11 00:00:00.000000 455.0 1-31 1 1962-05-10 00:00:00.000000 446.0 1-31 1 1962-05-11 00:00:00.000000 455.0 1-31 1 1962-05-14 00:00:00.000000 452.0 1-31 1 1962-05-15 00:00:00.000000 457.0 1-31 1 1962-05-16 00:00:00.000000 449.0 1-31 1 1962-05-17 00:00:00.000000 450.0 1-31 1 1962-05-18 00:00:00.000000 435.0 1-31 1 1962-05-21 00:00:00.000000 415.0 1-31 1 1962-05-22 00:00:00.000000 398.0 1-31 1 1962-05-23 00:00:00.000000 399.0 1-32 1 1962-05-22 00:00:00.000000 398.0 1-32 1 1962-05-23 00:00:00.000000 399.0 1-32 1 1962-05-24 00:00:00.000000 361.0 1-32 1 1962-05-25 00:00:00.000000 383.0 1-32 1 1962-05-28 00:00:00.000000 393.0 1-32 1 1962-05-29 00:00:00.000000 385.0 1-32 1 1962-05-31 00:00:00.000000 360.0 1-32 1 1962-06-01 00:00:00.000000 364.0 1-32 1 1962-06-04 00:00:00.000000 365.0 1-32 1 1962-06-05 00:00:00.000000 370.0 1-33 1 1962-06-04 00:00:00.000000 365.0 1-33 1 1962-06-05 00:00:00.000000 370.0 1-33 1 1962-06-06 00:00:00.000000 374.0 1-33 1 1962-06-07 00:00:00.000000 359.0 1-33 1 1962-06-08 00:00:00.000000 335.0 1-33 1 1962-06-11 00:00:00.000000 323.0 1-33 1 1962-06-12 00:00:00.000000 306.0 1-33 1 1962-06-13 00:00:00.000000 333.0 1-33 1 1962-06-14 00:00:00.000000 330.0 1-33 1 1962-06-15 00:00:00.000000 336.0 1-34 1 1962-06-14 00:00:00.000000 330.0 1-34 1 1962-06-15 00:00:00.000000 336.0 1-34 1 1962-06-18 00:00:00.000000 328.0 1-34 1 1962-06-19 00:00:00.000000 316.0 1-34 1 1962-06-20 00:00:00.000000 320.0 1-34 1 1962-06-21 00:00:00.000000 332.0 1-34 1 1962-06-22 00:00:00.000000 320.0 1-34 1 1962-06-25 00:00:00.000000 333.0 1-34 1 1962-06-26 00:00:00.000000 344.0 1-34 1 1962-06-27 00:00:00.000000 339.0 1-35 1 1962-06-26 00:00:00.000000 344.0 1-35 1 1962-06-27 00:00:00.000000 339.0 1-35 1 1962-06-28 00:00:00.000000 350.0 1-35 1 1962-06-29 00:00:00.000000 351.0 1-35 1 1962-07-02 00:00:00.000000 350.0 1-35 1 1962-07-03 00:00:00.000000 345.0 1-35 1 1962-07-05 00:00:00.000000 350.0 1-35 1 1962-07-06 00:00:00.000000 359.0 1-35 1 1962-07-09 00:00:00.000000 375.0 1-35 1 1962-07-10 00:00:00.000000 379.0 1-36 1 1962-07-09 00:00:00.000000 375.0 1-36 1 1962-07-10 00:00:00.000000 379.0 1-36 1 1962-07-11 00:00:00.000000 376.0 1-36 1 1962-07-12 00:00:00.000000 382.0 1-36 1 1962-07-13 00:00:00.000000 370.0 1-36 1 1962-07-16 00:00:00.000000 365.0 1-36 1 1962-07-17 00:00:00.000000 367.0 1-36 1 1962-07-18 00:00:00.000000 372.0 1-36 1 1962-07-19 00:00:00.000000 373.0 1-36 1 1962-07-20 00:00:00.000000 363.0 1-37 1 1962-07-19 00:00:00.000000 373.0 1-37 1 1962-07-20 00:00:00.000000 363.0 1-37 1 1962-07-23 00:00:00.000000 371.0 1-37 1 1962-07-24 00:00:00.000000 369.0 1-37 1 1962-07-25 00:00:00.000000 376.0 1-37 1 1962-07-26 00:00:00.000000 387.0 1-37 1 1962-07-27 00:00:00.000000 387.0 1-37 1 1962-07-30 00:00:00.000000 376.0 1-37 1 1962-07-31 00:00:00.000000 385.0 1-37 1 1962-08-01 00:00:00.000000 385.0 1-38 1 1962-07-31 00:00:00.000000 385.0 1-38 1 1962-08-01 00:00:00.000000 385.0 1-38 1 1962-08-02 00:00:00.000000 380.0 1-38 1 1962-08-03 00:00:00.000000 373.0 1-38 1 1962-08-06 00:00:00.000000 382.0 1-38 1 1962-08-07 00:00:00.000000 377.0 1-38 1 1962-08-08 00:00:00.000000 376.0 1-38 1 1962-08-09 00:00:00.000000 379.0 1-38 1 1962-08-10 00:00:00.000000 386.0 1-38 1 1962-08-13 00:00:00.000000 387.0 1-39 1 1962-08-10 00:00:00.000000 386.0 1-39 1 1962-08-13 00:00:00.000000 387.0 1-39 1 1962-08-14 00:00:00.000000 386.0 1-39 1 1962-08-15 00:00:00.000000 389.0 1-39 1 1962-08-16 00:00:00.000000 394.0 1-39 1 1962-08-17 00:00:00.000000 393.0 1-39 1 1962-08-20 00:00:00.000000 409.0 1-39 1 1962-08-21 00:00:00.000000 411.0 1-39 1 1962-08-22 00:00:00.000000 409.0 1-39 1 1962-08-23 00:00:00.000000 408.0 1-4 1 1961-06-30 00:00:00.000000 478.0 1-4 1 1961-07-03 00:00:00.000000 479.0 1-4 1 1961-07-05 00:00:00.000000 477.0 1-4 1 1961-07-06 00:00:00.000000 476.0 1-4 1 1961-07-07 00:00:00.000000 475.0 1-4 1 1961-07-10 00:00:00.000000 475.0 1-4 1 1961-07-11 00:00:00.000000 473.0 1-4 1 1961-07-12 00:00:00.000000 474.0 1-4 1 1961-07-13 00:00:00.000000 474.0 1-4 1 1961-07-14 00:00:00.000000 474.0 1-40 1 1962-08-22 00:00:00.000000 409.0 1-40 1 1962-08-23 00:00:00.000000 408.0 1-40 1 1962-08-24 00:00:00.000000 393.0 1-40 1 1962-08-27 00:00:00.000000 391.0 1-40 1 1962-08-28 00:00:00.000000 388.0 1-40 1 1962-08-29 00:00:00.000000 396.0 1-40 1 1962-08-30 00:00:00.000000 387.0 1-40 1 1962-08-31 00:00:00.000000 383.0 1-40 1 1962-09-04 00:00:00.000000 388.0 1-40 1 1962-09-05 00:00:00.000000 382.0 1-41 1 1962-09-04 00:00:00.000000 388.0 1-41 1 1962-09-05 00:00:00.000000 382.0 1-41 1 1962-09-06 00:00:00.000000 384.0 1-41 1 1962-09-07 00:00:00.000000 382.0 1-41 1 1962-09-10 00:00:00.000000 383.0 1-41 1 1962-09-11 00:00:00.000000 383.0 1-41 1 1962-09-12 00:00:00.000000 388.0 1-41 1 1962-09-13 00:00:00.000000 395.0 1-41 1 1962-09-14 00:00:00.000000 392.0 1-41 1 1962-09-17 00:00:00.000000 386.0 1-42 1 1962-09-14 00:00:00.000000 392.0 1-42 1 1962-09-17 00:00:00.000000 386.0 1-42 1 1962-09-18 00:00:00.000000 383.0 1-42 1 1962-09-19 00:00:00.000000 377.0 1-42 1 1962-09-20 00:00:00.000000 364.0 1-42 1 1962-09-21 00:00:00.000000 369.0 1-42 1 1962-09-24 00:00:00.000000 355.0 1-42 1 1962-09-25 00:00:00.000000 350.0 1-42 1 1962-09-26 00:00:00.000000 353.0 1-42 1 1962-09-27 00:00:00.000000 340.0 1-43 1 1962-09-26 00:00:00.000000 353.0 1-43 1 1962-09-27 00:00:00.000000 340.0 1-43 1 1962-09-28 00:00:00.000000 350.0 1-43 1 1962-10-01 00:00:00.000000 349.0 1-43 1 1962-10-02 00:00:00.000000 358.0 1-43 1 1962-10-03 00:00:00.000000 360.0 1-43 1 1962-10-04 00:00:00.000000 360.0 1-43 1 1962-10-05 00:00:00.000000 366.0 1-43 1 1962-10-09 00:00:00.000000 359.0 1-43 1 1962-10-10 00:00:00.000000 356.0 1-44 1 1962-10-09 00:00:00.000000 359.0 1-44 1 1962-10-10 00:00:00.000000 356.0 1-44 1 1962-10-11 00:00:00.000000 355.0 1-44 1 1962-10-12 00:00:00.000000 367.0 1-44 1 1962-10-15 00:00:00.000000 357.0 1-44 1 1962-10-16 00:00:00.000000 361.0 1-44 1 1962-10-17 00:00:00.000000 355.0 1-44 1 1962-10-18 00:00:00.000000 348.0 1-44 1 1962-10-19 00:00:00.000000 343.0 1-44 1 1962-10-22 00:00:00.000000 330.0 1-45 1 1962-10-19 00:00:00.000000 343.0 1-45 1 1962-10-22 00:00:00.000000 330.0 1-45 1 1962-10-23 00:00:00.000000 340.0 1-45 1 1962-10-24 00:00:00.000000 339.0 1-45 1 1962-10-25 00:00:00.000000 331.0 1-45 1 1962-10-26 00:00:00.000000 345.0 1-45 1 1962-10-29 00:00:00.000000 352.0 1-45 1 1962-10-30 00:00:00.000000 346.0 1-45 1 1962-10-31 00:00:00.000000 352.0 1-45 1 1962-11-01 00:00:00.000000 357.0 1-46 1 NULL NULL 1-46 1 1962-10-31 00:00:00.000000 352.0 1-46 1 1962-11-01 00:00:00.000000 357.0 1-5 1 1961-07-13 00:00:00.000000 474.0 1-5 1 1961-07-14 00:00:00.000000 474.0 1-5 1 1961-07-17 00:00:00.000000 465.0 1-5 1 1961-07-18 00:00:00.000000 466.0 1-5 1 1961-07-19 00:00:00.000000 467.0 1-5 1 1961-07-20 00:00:00.000000 471.0 1-5 1 1961-07-21 00:00:00.000000 471.0 1-5 1 1961-07-24 00:00:00.000000 467.0 1-5 1 1961-07-25 00:00:00.000000 473.0 1-5 1 1961-07-26 00:00:00.000000 481.0 1-6 1 1961-07-25 00:00:00.000000 473.0 1-6 1 1961-07-26 00:00:00.000000 481.0 1-6 1 1961-07-27 00:00:00.000000 488.0 1-6 1 1961-07-28 00:00:00.000000 490.0 1-6 1 1961-07-31 00:00:00.000000 489.0 1-6 1 1961-08-01 00:00:00.000000 489.0 1-6 1 1961-08-02 00:00:00.000000 485.0 1-6 1 1961-08-03 00:00:00.000000 491.0 1-6 1 1961-08-04 00:00:00.000000 492.0 1-6 1 1961-08-07 00:00:00.000000 494.0 1-7 1 1961-08-04 00:00:00.000000 492.0 1-7 1 1961-08-07 00:00:00.000000 494.0 1-7 1 1961-08-08 00:00:00.000000 499.0 1-7 1 1961-08-09 00:00:00.000000 498.0 1-7 1 1961-08-10 00:00:00.000000 500.0 1-7 1 1961-08-11 00:00:00.000000 497.0 1-7 1 1961-08-14 00:00:00.000000 494.0 1-7 1 1961-08-15 00:00:00.000000 495.0 1-7 1 1961-08-16 00:00:00.000000 500.0 1-7 1 1961-08-17 00:00:00.000000 504.0 1-8 1 1961-08-16 00:00:00.000000 500.0 1-8 1 1961-08-17 00:00:00.000000 504.0 1-8 1 1961-08-18 00:00:00.000000 513.0 1-8 1 1961-08-21 00:00:00.000000 511.0 1-8 1 1961-08-22 00:00:00.000000 514.0 1-8 1 1961-08-23 00:00:00.000000 510.0 1-8 1 1961-08-24 00:00:00.000000 509.0 1-8 1 1961-08-25 00:00:00.000000 515.0 1-8 1 1961-08-28 00:00:00.000000 519.0 1-8 1 1961-08-29 00:00:00.000000 523.0 1-9 1 1961-08-28 00:00:00.000000 519.0 1-9 1 1961-08-29 00:00:00.000000 523.0 1-9 1 1961-08-30 00:00:00.000000 519.0 1-9 1 1961-08-31 00:00:00.000000 523.0 1-9 1 1961-09-01 00:00:00.000000 531.0 1-9 1 1961-09-05 00:00:00.000000 547.0 1-9 1 1961-09-06 00:00:00.000000 551.0 1-9 1 1961-09-07 00:00:00.000000 547.0 1-9 1 1961-09-08 00:00:00.000000 541.0 1-9 1 1961-09-11 00:00:00.000000 545.0
The function displays the stats_output table on the screen:
stats value_col -------------------------- --------- output_table_row_count 463 processing_time_in_seconds 16 input_table_row_count 369 output_split_count 47 inserted_row_count 94 input_partition_count 1
Download a zip file of all examples and a SQL script file that creates their input tables.