| ==== |
| ---- QUERY: TPCDS-SS-INSERT-SETUP2 |
| CREATE TABLE store_sales_insert LIKE tpcds.store_sales |
| STORED AS $FILE_FORMAT |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY: TPCDS-SS-INSERT-DAY |
| # Insert a day's worth of data |
| INSERT OVERWRITE TABLE store_sales_insert PARTITION (ss_sold_date_sk) |
| SELECT * FROM tpcds.store_sales |
| WHERE ss_sold_date_sk = 2451239 |
| ---- RUNTIME_PROFILE |
| Partition: ss_sold_date_sk=2451239 |
| NumModifiedRows: 847 |
| ==== |
| ---- QUERY: TPCDS-SS-INSERT-MONTH |
| INSERT OVERWRITE TABLE store_sales_insert PARTITION (ss_sold_date_sk) |
| SELECT * FROM tpcds.store_sales |
| WHERE ss_sold_date_sk >= 2451270 and ss_sold_date_sk <= 2451299 |
| ---- RUNTIME_PROFILE |
| Partition: ss_sold_date_sk=2451270 |
| NumModifiedRows: 822 |
| Partition: ss_sold_date_sk=2451271 |
| NumModifiedRows: 813 |
| Partition: ss_sold_date_sk=2451272 |
| NumModifiedRows: 888 |
| Partition: ss_sold_date_sk=2451273 |
| NumModifiedRows: 946 |
| Partition: ss_sold_date_sk=2451274 |
| NumModifiedRows: 868 |
| Partition: ss_sold_date_sk=2451275 |
| NumModifiedRows: 917 |
| Partition: ss_sold_date_sk=2451276 |
| NumModifiedRows: 851 |
| Partition: ss_sold_date_sk=2451277 |
| NumModifiedRows: 675 |
| Partition: ss_sold_date_sk=2451278 |
| NumModifiedRows: 902 |
| Partition: ss_sold_date_sk=2451279 |
| NumModifiedRows: 769 |
| Partition: ss_sold_date_sk=2451280 |
| NumModifiedRows: 674 |
| Partition: ss_sold_date_sk=2451281 |
| NumModifiedRows: 934 |
| Partition: ss_sold_date_sk=2451282 |
| NumModifiedRows: 826 |
| Partition: ss_sold_date_sk=2451283 |
| NumModifiedRows: 894 |
| Partition: ss_sold_date_sk=2451284 |
| NumModifiedRows: 794 |
| Partition: ss_sold_date_sk=2451285 |
| NumModifiedRows: 991 |
| Partition: ss_sold_date_sk=2451286 |
| NumModifiedRows: 973 |
| Partition: ss_sold_date_sk=2451287 |
| NumModifiedRows: 800 |
| Partition: ss_sold_date_sk=2451288 |
| NumModifiedRows: 818 |
| Partition: ss_sold_date_sk=2451289 |
| NumModifiedRows: 904 |
| Partition: ss_sold_date_sk=2451290 |
| NumModifiedRows: 780 |
| Partition: ss_sold_date_sk=2451291 |
| NumModifiedRows: 758 |
| Partition: ss_sold_date_sk=2451292 |
| NumModifiedRows: 870 |
| Partition: ss_sold_date_sk=2451293 |
| NumModifiedRows: 999 |
| Partition: ss_sold_date_sk=2451294 |
| NumModifiedRows: 741 |
| Partition: ss_sold_date_sk=2451295 |
| NumModifiedRows: 1072 |
| Partition: ss_sold_date_sk=2451296 |
| NumModifiedRows: 1032 |
| Partition: ss_sold_date_sk=2451297 |
| NumModifiedRows: 698 |
| Partition: ss_sold_date_sk=2451298 |
| NumModifiedRows: 991 |
| Partition: ss_sold_date_sk=2451299 |
| NumModifiedRows: 703 |
| aggregation(SUM, RowsInserted): 25703 |
| ==== |
| ---- QUERY: TPCDS-SS-INSERT-QUARTER |
| INSERT OVERWRITE TABLE store_sales_insert PARTITION (ss_sold_date_sk) |
| SELECT * FROM tpcds.store_sales |
| WHERE ss_sold_date_sk >= 2451423 and ss_sold_date_sk <= 2451544 |
| ---- RUNTIME_PROFILE |
| Partition: ss_sold_date_sk=2451423 |
| NumModifiedRows: 1881 |
| Partition: ss_sold_date_sk=2451424 |
| NumModifiedRows: 2276 |
| Partition: ss_sold_date_sk=2451425 |
| NumModifiedRows: 1807 |
| Partition: ss_sold_date_sk=2451426 |
| NumModifiedRows: 2220 |
| Partition: ss_sold_date_sk=2451427 |
| NumModifiedRows: 1783 |
| Partition: ss_sold_date_sk=2451428 |
| NumModifiedRows: 2046 |
| Partition: ss_sold_date_sk=2451429 |
| NumModifiedRows: 2041 |
| Partition: ss_sold_date_sk=2451430 |
| NumModifiedRows: 1930 |
| Partition: ss_sold_date_sk=2451431 |
| NumModifiedRows: 1967 |
| Partition: ss_sold_date_sk=2451432 |
| NumModifiedRows: 1885 |
| Partition: ss_sold_date_sk=2451433 |
| NumModifiedRows: 1889 |
| Partition: ss_sold_date_sk=2451434 |
| NumModifiedRows: 1712 |
| Partition: ss_sold_date_sk=2451435 |
| NumModifiedRows: 1943 |
| Partition: ss_sold_date_sk=2451436 |
| NumModifiedRows: 1903 |
| Partition: ss_sold_date_sk=2451437 |
| NumModifiedRows: 1989 |
| Partition: ss_sold_date_sk=2451438 |
| NumModifiedRows: 1855 |
| Partition: ss_sold_date_sk=2451439 |
| NumModifiedRows: 2109 |
| Partition: ss_sold_date_sk=2451440 |
| NumModifiedRows: 2281 |
| Partition: ss_sold_date_sk=2451441 |
| NumModifiedRows: 1986 |
| Partition: ss_sold_date_sk=2451442 |
| NumModifiedRows: 2029 |
| Partition: ss_sold_date_sk=2451443 |
| NumModifiedRows: 1939 |
| Partition: ss_sold_date_sk=2451444 |
| NumModifiedRows: 2084 |
| Partition: ss_sold_date_sk=2451445 |
| NumModifiedRows: 1748 |
| Partition: ss_sold_date_sk=2451446 |
| NumModifiedRows: 1823 |
| Partition: ss_sold_date_sk=2451447 |
| NumModifiedRows: 1875 |
| Partition: ss_sold_date_sk=2451448 |
| NumModifiedRows: 2209 |
| Partition: ss_sold_date_sk=2451449 |
| NumModifiedRows: 1747 |
| Partition: ss_sold_date_sk=2451450 |
| NumModifiedRows: 1833 |
| Partition: ss_sold_date_sk=2451451 |
| NumModifiedRows: 2049 |
| Partition: ss_sold_date_sk=2451452 |
| NumModifiedRows: 2074 |
| Partition: ss_sold_date_sk=2451453 |
| NumModifiedRows: 1941 |
| Partition: ss_sold_date_sk=2451454 |
| NumModifiedRows: 1885 |
| Partition: ss_sold_date_sk=2451455 |
| NumModifiedRows: 1885 |
| Partition: ss_sold_date_sk=2451456 |
| NumModifiedRows: 1854 |
| Partition: ss_sold_date_sk=2451457 |
| NumModifiedRows: 1993 |
| Partition: ss_sold_date_sk=2451458 |
| NumModifiedRows: 1864 |
| Partition: ss_sold_date_sk=2451459 |
| NumModifiedRows: 1848 |
| Partition: ss_sold_date_sk=2451460 |
| NumModifiedRows: 2190 |
| Partition: ss_sold_date_sk=2451461 |
| NumModifiedRows: 1860 |
| Partition: ss_sold_date_sk=2451462 |
| NumModifiedRows: 2016 |
| Partition: ss_sold_date_sk=2451463 |
| NumModifiedRows: 1606 |
| Partition: ss_sold_date_sk=2451464 |
| NumModifiedRows: 2006 |
| Partition: ss_sold_date_sk=2451465 |
| NumModifiedRows: 1914 |
| Partition: ss_sold_date_sk=2451466 |
| NumModifiedRows: 2146 |
| Partition: ss_sold_date_sk=2451467 |
| NumModifiedRows: 1908 |
| Partition: ss_sold_date_sk=2451468 |
| NumModifiedRows: 1974 |
| Partition: ss_sold_date_sk=2451469 |
| NumModifiedRows: 1720 |
| Partition: ss_sold_date_sk=2451470 |
| NumModifiedRows: 2072 |
| Partition: ss_sold_date_sk=2451471 |
| NumModifiedRows: 1823 |
| Partition: ss_sold_date_sk=2451472 |
| NumModifiedRows: 1861 |
| Partition: ss_sold_date_sk=2451473 |
| NumModifiedRows: 1804 |
| Partition: ss_sold_date_sk=2451474 |
| NumModifiedRows: 2368 |
| Partition: ss_sold_date_sk=2451475 |
| NumModifiedRows: 1940 |
| Partition: ss_sold_date_sk=2451476 |
| NumModifiedRows: 1921 |
| Partition: ss_sold_date_sk=2451477 |
| NumModifiedRows: 2055 |
| Partition: ss_sold_date_sk=2451478 |
| NumModifiedRows: 1957 |
| Partition: ss_sold_date_sk=2451479 |
| NumModifiedRows: 2034 |
| Partition: ss_sold_date_sk=2451480 |
| NumModifiedRows: 1983 |
| Partition: ss_sold_date_sk=2451481 |
| NumModifiedRows: 2057 |
| Partition: ss_sold_date_sk=2451482 |
| NumModifiedRows: 1966 |
| Partition: ss_sold_date_sk=2451483 |
| NumModifiedRows: 1965 |
| Partition: ss_sold_date_sk=2451484 |
| NumModifiedRows: 2075 |
| Partition: ss_sold_date_sk=2451485 |
| NumModifiedRows: 1831 |
| Partition: ss_sold_date_sk=2451486 |
| NumModifiedRows: 2947 |
| Partition: ss_sold_date_sk=2451487 |
| NumModifiedRows: 2835 |
| Partition: ss_sold_date_sk=2451488 |
| NumModifiedRows: 3242 |
| Partition: ss_sold_date_sk=2451489 |
| NumModifiedRows: 2871 |
| Partition: ss_sold_date_sk=2451490 |
| NumModifiedRows: 3179 |
| Partition: ss_sold_date_sk=2451491 |
| NumModifiedRows: 3029 |
| Partition: ss_sold_date_sk=2451492 |
| NumModifiedRows: 2908 |
| Partition: ss_sold_date_sk=2451493 |
| NumModifiedRows: 2968 |
| Partition: ss_sold_date_sk=2451494 |
| NumModifiedRows: 2977 |
| Partition: ss_sold_date_sk=2451495 |
| NumModifiedRows: 3006 |
| Partition: ss_sold_date_sk=2451496 |
| NumModifiedRows: 2747 |
| Partition: ss_sold_date_sk=2451497 |
| NumModifiedRows: 3178 |
| Partition: ss_sold_date_sk=2451498 |
| NumModifiedRows: 3007 |
| Partition: ss_sold_date_sk=2451499 |
| NumModifiedRows: 2895 |
| Partition: ss_sold_date_sk=2451500 |
| NumModifiedRows: 2774 |
| Partition: ss_sold_date_sk=2451501 |
| NumModifiedRows: 3218 |
| Partition: ss_sold_date_sk=2451502 |
| NumModifiedRows: 2728 |
| Partition: ss_sold_date_sk=2451503 |
| NumModifiedRows: 2637 |
| Partition: ss_sold_date_sk=2451504 |
| NumModifiedRows: 2778 |
| Partition: ss_sold_date_sk=2451505 |
| NumModifiedRows: 2739 |
| Partition: ss_sold_date_sk=2451506 |
| NumModifiedRows: 2582 |
| Partition: ss_sold_date_sk=2451507 |
| NumModifiedRows: 2865 |
| Partition: ss_sold_date_sk=2451508 |
| NumModifiedRows: 3178 |
| Partition: ss_sold_date_sk=2451509 |
| NumModifiedRows: 2975 |
| Partition: ss_sold_date_sk=2451510 |
| NumModifiedRows: 3008 |
| Partition: ss_sold_date_sk=2451511 |
| NumModifiedRows: 2779 |
| Partition: ss_sold_date_sk=2451512 |
| NumModifiedRows: 3046 |
| Partition: ss_sold_date_sk=2451513 |
| NumModifiedRows: 3279 |
| Partition: ss_sold_date_sk=2451514 |
| NumModifiedRows: 2980 |
| Partition: ss_sold_date_sk=2451515 |
| NumModifiedRows: 2844 |
| Partition: ss_sold_date_sk=2451516 |
| NumModifiedRows: 2960 |
| Partition: ss_sold_date_sk=2451517 |
| NumModifiedRows: 2814 |
| Partition: ss_sold_date_sk=2451518 |
| NumModifiedRows: 2950 |
| Partition: ss_sold_date_sk=2451519 |
| NumModifiedRows: 2925 |
| Partition: ss_sold_date_sk=2451520 |
| NumModifiedRows: 3197 |
| Partition: ss_sold_date_sk=2451521 |
| NumModifiedRows: 2617 |
| Partition: ss_sold_date_sk=2451522 |
| NumModifiedRows: 3013 |
| Partition: ss_sold_date_sk=2451523 |
| NumModifiedRows: 2693 |
| Partition: ss_sold_date_sk=2451524 |
| NumModifiedRows: 3049 |
| Partition: ss_sold_date_sk=2451525 |
| NumModifiedRows: 2912 |
| Partition: ss_sold_date_sk=2451526 |
| NumModifiedRows: 3067 |
| Partition: ss_sold_date_sk=2451527 |
| NumModifiedRows: 3053 |
| Partition: ss_sold_date_sk=2451528 |
| NumModifiedRows: 3144 |
| Partition: ss_sold_date_sk=2451529 |
| NumModifiedRows: 3086 |
| Partition: ss_sold_date_sk=2451530 |
| NumModifiedRows: 2996 |
| Partition: ss_sold_date_sk=2451531 |
| NumModifiedRows: 3301 |
| Partition: ss_sold_date_sk=2451532 |
| NumModifiedRows: 3190 |
| Partition: ss_sold_date_sk=2451533 |
| NumModifiedRows: 3152 |
| Partition: ss_sold_date_sk=2451534 |
| NumModifiedRows: 3064 |
| Partition: ss_sold_date_sk=2451535 |
| NumModifiedRows: 2796 |
| Partition: ss_sold_date_sk=2451536 |
| NumModifiedRows: 3068 |
| Partition: ss_sold_date_sk=2451537 |
| NumModifiedRows: 3293 |
| Partition: ss_sold_date_sk=2451538 |
| NumModifiedRows: 2892 |
| Partition: ss_sold_date_sk=2451539 |
| NumModifiedRows: 3016 |
| Partition: ss_sold_date_sk=2451540 |
| NumModifiedRows: 2975 |
| Partition: ss_sold_date_sk=2451541 |
| NumModifiedRows: 3422 |
| Partition: ss_sold_date_sk=2451542 |
| NumModifiedRows: 2920 |
| Partition: ss_sold_date_sk=2451543 |
| NumModifiedRows: 3052 |
| Partition: ss_sold_date_sk=2451544 |
| NumModifiedRows: 3046 |
| aggregation(SUM, RowsInserted): 299097 |
| ==== |
| ---- QUERY: TPCDS-SS-INSERT-YEAR |
| INSERT OVERWRITE TABLE store_sales_insert PARTITION (ss_sold_date_sk) |
| SELECT * FROM tpcds.store_sales |
| WHERE ss_sold_date_sk >= 2451545 and ss_sold_date_sk < 2451911 |
| ---- RUNTIME_PROFILE |
| Partition: ss_sold_date_sk=2451545 |
| NumModifiedRows: 2743 |
| Partition: ss_sold_date_sk=2451546 |
| NumModifiedRows: 4074 |
| Partition: ss_sold_date_sk=2451547 |
| NumModifiedRows: 804 |
| Partition: ss_sold_date_sk=2451548 |
| NumModifiedRows: 948 |
| Partition: ss_sold_date_sk=2451549 |
| NumModifiedRows: 737 |
| Partition: ss_sold_date_sk=2451550 |
| NumModifiedRows: 932 |
| Partition: ss_sold_date_sk=2451551 |
| NumModifiedRows: 857 |
| Partition: ss_sold_date_sk=2451552 |
| NumModifiedRows: 881 |
| Partition: ss_sold_date_sk=2451553 |
| NumModifiedRows: 942 |
| Partition: ss_sold_date_sk=2451554 |
| NumModifiedRows: 884 |
| Partition: ss_sold_date_sk=2451555 |
| NumModifiedRows: 834 |
| Partition: ss_sold_date_sk=2451556 |
| NumModifiedRows: 942 |
| Partition: ss_sold_date_sk=2451557 |
| NumModifiedRows: 998 |
| Partition: ss_sold_date_sk=2451558 |
| NumModifiedRows: 742 |
| Partition: ss_sold_date_sk=2451559 |
| NumModifiedRows: 867 |
| Partition: ss_sold_date_sk=2451560 |
| NumModifiedRows: 831 |
| Partition: ss_sold_date_sk=2451561 |
| NumModifiedRows: 859 |
| Partition: ss_sold_date_sk=2451562 |
| NumModifiedRows: 759 |
| Partition: ss_sold_date_sk=2451563 |
| NumModifiedRows: 988 |
| Partition: ss_sold_date_sk=2451564 |
| NumModifiedRows: 956 |
| Partition: ss_sold_date_sk=2451565 |
| NumModifiedRows: 968 |
| Partition: ss_sold_date_sk=2451566 |
| NumModifiedRows: 944 |
| Partition: ss_sold_date_sk=2451567 |
| NumModifiedRows: 678 |
| Partition: ss_sold_date_sk=2451568 |
| NumModifiedRows: 912 |
| Partition: ss_sold_date_sk=2451569 |
| NumModifiedRows: 973 |
| Partition: ss_sold_date_sk=2451570 |
| NumModifiedRows: 772 |
| Partition: ss_sold_date_sk=2451571 |
| NumModifiedRows: 830 |
| Partition: ss_sold_date_sk=2451572 |
| NumModifiedRows: 872 |
| Partition: ss_sold_date_sk=2451573 |
| NumModifiedRows: 616 |
| Partition: ss_sold_date_sk=2451574 |
| NumModifiedRows: 792 |
| Partition: ss_sold_date_sk=2451575 |
| NumModifiedRows: 978 |
| Partition: ss_sold_date_sk=2451576 |
| NumModifiedRows: 819 |
| Partition: ss_sold_date_sk=2451577 |
| NumModifiedRows: 788 |
| Partition: ss_sold_date_sk=2451578 |
| NumModifiedRows: 950 |
| Partition: ss_sold_date_sk=2451579 |
| NumModifiedRows: 909 |
| Partition: ss_sold_date_sk=2451580 |
| NumModifiedRows: 763 |
| Partition: ss_sold_date_sk=2451581 |
| NumModifiedRows: 874 |
| Partition: ss_sold_date_sk=2451582 |
| NumModifiedRows: 1024 |
| Partition: ss_sold_date_sk=2451583 |
| NumModifiedRows: 907 |
| Partition: ss_sold_date_sk=2451584 |
| NumModifiedRows: 936 |
| Partition: ss_sold_date_sk=2451585 |
| NumModifiedRows: 802 |
| Partition: ss_sold_date_sk=2451586 |
| NumModifiedRows: 719 |
| Partition: ss_sold_date_sk=2451587 |
| NumModifiedRows: 816 |
| Partition: ss_sold_date_sk=2451588 |
| NumModifiedRows: 825 |
| Partition: ss_sold_date_sk=2451589 |
| NumModifiedRows: 871 |
| Partition: ss_sold_date_sk=2451590 |
| NumModifiedRows: 1004 |
| Partition: ss_sold_date_sk=2451591 |
| NumModifiedRows: 963 |
| Partition: ss_sold_date_sk=2451592 |
| NumModifiedRows: 884 |
| Partition: ss_sold_date_sk=2451593 |
| NumModifiedRows: 854 |
| Partition: ss_sold_date_sk=2451594 |
| NumModifiedRows: 888 |
| Partition: ss_sold_date_sk=2451595 |
| NumModifiedRows: 1049 |
| Partition: ss_sold_date_sk=2451596 |
| NumModifiedRows: 930 |
| Partition: ss_sold_date_sk=2451597 |
| NumModifiedRows: 991 |
| Partition: ss_sold_date_sk=2451598 |
| NumModifiedRows: 883 |
| Partition: ss_sold_date_sk=2451599 |
| NumModifiedRows: 771 |
| Partition: ss_sold_date_sk=2451600 |
| NumModifiedRows: 844 |
| Partition: ss_sold_date_sk=2451601 |
| NumModifiedRows: 786 |
| Partition: ss_sold_date_sk=2451602 |
| NumModifiedRows: 785 |
| Partition: ss_sold_date_sk=2451603 |
| NumModifiedRows: 936 |
| Partition: ss_sold_date_sk=2451604 |
| NumModifiedRows: 868 |
| Partition: ss_sold_date_sk=2451605 |
| NumModifiedRows: 707 |
| Partition: ss_sold_date_sk=2451606 |
| NumModifiedRows: 758 |
| Partition: ss_sold_date_sk=2451607 |
| NumModifiedRows: 934 |
| Partition: ss_sold_date_sk=2451608 |
| NumModifiedRows: 856 |
| Partition: ss_sold_date_sk=2451609 |
| NumModifiedRows: 781 |
| Partition: ss_sold_date_sk=2451610 |
| NumModifiedRows: 832 |
| Partition: ss_sold_date_sk=2451611 |
| NumModifiedRows: 756 |
| Partition: ss_sold_date_sk=2451612 |
| NumModifiedRows: 792 |
| Partition: ss_sold_date_sk=2451613 |
| NumModifiedRows: 914 |
| Partition: ss_sold_date_sk=2451614 |
| NumModifiedRows: 772 |
| Partition: ss_sold_date_sk=2451615 |
| NumModifiedRows: 921 |
| Partition: ss_sold_date_sk=2451616 |
| NumModifiedRows: 842 |
| Partition: ss_sold_date_sk=2451617 |
| NumModifiedRows: 878 |
| Partition: ss_sold_date_sk=2451618 |
| NumModifiedRows: 877 |
| Partition: ss_sold_date_sk=2451619 |
| NumModifiedRows: 923 |
| Partition: ss_sold_date_sk=2451620 |
| NumModifiedRows: 897 |
| Partition: ss_sold_date_sk=2451621 |
| NumModifiedRows: 776 |
| Partition: ss_sold_date_sk=2451622 |
| NumModifiedRows: 759 |
| Partition: ss_sold_date_sk=2451623 |
| NumModifiedRows: 883 |
| Partition: ss_sold_date_sk=2451624 |
| NumModifiedRows: 874 |
| Partition: ss_sold_date_sk=2451625 |
| NumModifiedRows: 918 |
| Partition: ss_sold_date_sk=2451626 |
| NumModifiedRows: 914 |
| Partition: ss_sold_date_sk=2451627 |
| NumModifiedRows: 1097 |
| Partition: ss_sold_date_sk=2451628 |
| NumModifiedRows: 953 |
| Partition: ss_sold_date_sk=2451629 |
| NumModifiedRows: 758 |
| Partition: ss_sold_date_sk=2451630 |
| NumModifiedRows: 783 |
| Partition: ss_sold_date_sk=2451631 |
| NumModifiedRows: 811 |
| Partition: ss_sold_date_sk=2451632 |
| NumModifiedRows: 873 |
| Partition: ss_sold_date_sk=2451633 |
| NumModifiedRows: 998 |
| Partition: ss_sold_date_sk=2451634 |
| NumModifiedRows: 1054 |
| Partition: ss_sold_date_sk=2451635 |
| NumModifiedRows: 956 |
| Partition: ss_sold_date_sk=2451636 |
| NumModifiedRows: 1001 |
| Partition: ss_sold_date_sk=2451637 |
| NumModifiedRows: 804 |
| Partition: ss_sold_date_sk=2451638 |
| NumModifiedRows: 998 |
| Partition: ss_sold_date_sk=2451639 |
| NumModifiedRows: 808 |
| Partition: ss_sold_date_sk=2451640 |
| NumModifiedRows: 1015 |
| Partition: ss_sold_date_sk=2451641 |
| NumModifiedRows: 951 |
| Partition: ss_sold_date_sk=2451642 |
| NumModifiedRows: 835 |
| Partition: ss_sold_date_sk=2451643 |
| NumModifiedRows: 779 |
| Partition: ss_sold_date_sk=2451644 |
| NumModifiedRows: 883 |
| Partition: ss_sold_date_sk=2451645 |
| NumModifiedRows: 1065 |
| Partition: ss_sold_date_sk=2451646 |
| NumModifiedRows: 751 |
| Partition: ss_sold_date_sk=2451647 |
| NumModifiedRows: 816 |
| Partition: ss_sold_date_sk=2451648 |
| NumModifiedRows: 1028 |
| Partition: ss_sold_date_sk=2451649 |
| NumModifiedRows: 756 |
| Partition: ss_sold_date_sk=2451650 |
| NumModifiedRows: 751 |
| Partition: ss_sold_date_sk=2451651 |
| NumModifiedRows: 839 |
| Partition: ss_sold_date_sk=2451652 |
| NumModifiedRows: 727 |
| Partition: ss_sold_date_sk=2451653 |
| NumModifiedRows: 898 |
| Partition: ss_sold_date_sk=2451654 |
| NumModifiedRows: 925 |
| Partition: ss_sold_date_sk=2451655 |
| NumModifiedRows: 908 |
| Partition: ss_sold_date_sk=2451656 |
| NumModifiedRows: 694 |
| Partition: ss_sold_date_sk=2451657 |
| NumModifiedRows: 880 |
| Partition: ss_sold_date_sk=2451658 |
| NumModifiedRows: 966 |
| Partition: ss_sold_date_sk=2451659 |
| NumModifiedRows: 807 |
| Partition: ss_sold_date_sk=2451660 |
| NumModifiedRows: 795 |
| Partition: ss_sold_date_sk=2451661 |
| NumModifiedRows: 781 |
| Partition: ss_sold_date_sk=2451662 |
| NumModifiedRows: 845 |
| Partition: ss_sold_date_sk=2451663 |
| NumModifiedRows: 742 |
| Partition: ss_sold_date_sk=2451664 |
| NumModifiedRows: 815 |
| Partition: ss_sold_date_sk=2451665 |
| NumModifiedRows: 842 |
| Partition: ss_sold_date_sk=2451666 |
| NumModifiedRows: 868 |
| Partition: ss_sold_date_sk=2451667 |
| NumModifiedRows: 926 |
| Partition: ss_sold_date_sk=2451668 |
| NumModifiedRows: 694 |
| Partition: ss_sold_date_sk=2451669 |
| NumModifiedRows: 834 |
| Partition: ss_sold_date_sk=2451670 |
| NumModifiedRows: 935 |
| Partition: ss_sold_date_sk=2451671 |
| NumModifiedRows: 869 |
| Partition: ss_sold_date_sk=2451672 |
| NumModifiedRows: 900 |
| Partition: ss_sold_date_sk=2451673 |
| NumModifiedRows: 962 |
| Partition: ss_sold_date_sk=2451674 |
| NumModifiedRows: 787 |
| Partition: ss_sold_date_sk=2451675 |
| NumModifiedRows: 778 |
| Partition: ss_sold_date_sk=2451676 |
| NumModifiedRows: 776 |
| Partition: ss_sold_date_sk=2451677 |
| NumModifiedRows: 799 |
| Partition: ss_sold_date_sk=2451678 |
| NumModifiedRows: 841 |
| Partition: ss_sold_date_sk=2451679 |
| NumModifiedRows: 921 |
| Partition: ss_sold_date_sk=2451680 |
| NumModifiedRows: 953 |
| Partition: ss_sold_date_sk=2451681 |
| NumModifiedRows: 878 |
| Partition: ss_sold_date_sk=2451682 |
| NumModifiedRows: 1072 |
| Partition: ss_sold_date_sk=2451683 |
| NumModifiedRows: 903 |
| Partition: ss_sold_date_sk=2451684 |
| NumModifiedRows: 803 |
| Partition: ss_sold_date_sk=2451685 |
| NumModifiedRows: 957 |
| Partition: ss_sold_date_sk=2451686 |
| NumModifiedRows: 902 |
| Partition: ss_sold_date_sk=2451687 |
| NumModifiedRows: 847 |
| Partition: ss_sold_date_sk=2451688 |
| NumModifiedRows: 989 |
| Partition: ss_sold_date_sk=2451689 |
| NumModifiedRows: 876 |
| Partition: ss_sold_date_sk=2451690 |
| NumModifiedRows: 1113 |
| Partition: ss_sold_date_sk=2451691 |
| NumModifiedRows: 883 |
| Partition: ss_sold_date_sk=2451692 |
| NumModifiedRows: 800 |
| Partition: ss_sold_date_sk=2451693 |
| NumModifiedRows: 880 |
| Partition: ss_sold_date_sk=2451694 |
| NumModifiedRows: 1049 |
| Partition: ss_sold_date_sk=2451695 |
| NumModifiedRows: 709 |
| Partition: ss_sold_date_sk=2451696 |
| NumModifiedRows: 749 |
| Partition: ss_sold_date_sk=2451697 |
| NumModifiedRows: 809 |
| Partition: ss_sold_date_sk=2451698 |
| NumModifiedRows: 831 |
| Partition: ss_sold_date_sk=2451699 |
| NumModifiedRows: 841 |
| Partition: ss_sold_date_sk=2451700 |
| NumModifiedRows: 717 |
| Partition: ss_sold_date_sk=2451701 |
| NumModifiedRows: 736 |
| Partition: ss_sold_date_sk=2451702 |
| NumModifiedRows: 994 |
| Partition: ss_sold_date_sk=2451703 |
| NumModifiedRows: 932 |
| Partition: ss_sold_date_sk=2451704 |
| NumModifiedRows: 911 |
| Partition: ss_sold_date_sk=2451705 |
| NumModifiedRows: 853 |
| Partition: ss_sold_date_sk=2451706 |
| NumModifiedRows: 898 |
| Partition: ss_sold_date_sk=2451707 |
| NumModifiedRows: 921 |
| Partition: ss_sold_date_sk=2451708 |
| NumModifiedRows: 994 |
| Partition: ss_sold_date_sk=2451709 |
| NumModifiedRows: 1051 |
| Partition: ss_sold_date_sk=2451710 |
| NumModifiedRows: 1077 |
| Partition: ss_sold_date_sk=2451711 |
| NumModifiedRows: 714 |
| Partition: ss_sold_date_sk=2451712 |
| NumModifiedRows: 1057 |
| Partition: ss_sold_date_sk=2451713 |
| NumModifiedRows: 919 |
| Partition: ss_sold_date_sk=2451714 |
| NumModifiedRows: 933 |
| Partition: ss_sold_date_sk=2451715 |
| NumModifiedRows: 835 |
| Partition: ss_sold_date_sk=2451716 |
| NumModifiedRows: 1009 |
| Partition: ss_sold_date_sk=2451717 |
| NumModifiedRows: 981 |
| Partition: ss_sold_date_sk=2451718 |
| NumModifiedRows: 888 |
| Partition: ss_sold_date_sk=2451719 |
| NumModifiedRows: 787 |
| Partition: ss_sold_date_sk=2451720 |
| NumModifiedRows: 937 |
| Partition: ss_sold_date_sk=2451721 |
| NumModifiedRows: 857 |
| Partition: ss_sold_date_sk=2451722 |
| NumModifiedRows: 982 |
| Partition: ss_sold_date_sk=2451723 |
| NumModifiedRows: 891 |
| Partition: ss_sold_date_sk=2451724 |
| NumModifiedRows: 785 |
| Partition: ss_sold_date_sk=2451725 |
| NumModifiedRows: 809 |
| Partition: ss_sold_date_sk=2451726 |
| NumModifiedRows: 638 |
| Partition: ss_sold_date_sk=2451727 |
| NumModifiedRows: 990 |
| Partition: ss_sold_date_sk=2451728 |
| NumModifiedRows: 1050 |
| Partition: ss_sold_date_sk=2451729 |
| NumModifiedRows: 867 |
| Partition: ss_sold_date_sk=2451730 |
| NumModifiedRows: 1000 |
| Partition: ss_sold_date_sk=2451731 |
| NumModifiedRows: 924 |
| Partition: ss_sold_date_sk=2451732 |
| NumModifiedRows: 731 |
| Partition: ss_sold_date_sk=2451733 |
| NumModifiedRows: 927 |
| Partition: ss_sold_date_sk=2451734 |
| NumModifiedRows: 805 |
| Partition: ss_sold_date_sk=2451735 |
| NumModifiedRows: 848 |
| Partition: ss_sold_date_sk=2451736 |
| NumModifiedRows: 796 |
| Partition: ss_sold_date_sk=2451737 |
| NumModifiedRows: 854 |
| Partition: ss_sold_date_sk=2451738 |
| NumModifiedRows: 775 |
| Partition: ss_sold_date_sk=2451739 |
| NumModifiedRows: 727 |
| Partition: ss_sold_date_sk=2451740 |
| NumModifiedRows: 907 |
| Partition: ss_sold_date_sk=2451741 |
| NumModifiedRows: 855 |
| Partition: ss_sold_date_sk=2451742 |
| NumModifiedRows: 664 |
| Partition: ss_sold_date_sk=2451743 |
| NumModifiedRows: 894 |
| Partition: ss_sold_date_sk=2451744 |
| NumModifiedRows: 1009 |
| Partition: ss_sold_date_sk=2451745 |
| NumModifiedRows: 780 |
| Partition: ss_sold_date_sk=2451746 |
| NumModifiedRows: 802 |
| Partition: ss_sold_date_sk=2451747 |
| NumModifiedRows: 764 |
| Partition: ss_sold_date_sk=2451748 |
| NumModifiedRows: 753 |
| Partition: ss_sold_date_sk=2451749 |
| NumModifiedRows: 794 |
| Partition: ss_sold_date_sk=2451750 |
| NumModifiedRows: 756 |
| Partition: ss_sold_date_sk=2451751 |
| NumModifiedRows: 791 |
| Partition: ss_sold_date_sk=2451752 |
| NumModifiedRows: 713 |
| Partition: ss_sold_date_sk=2451753 |
| NumModifiedRows: 1013 |
| Partition: ss_sold_date_sk=2451754 |
| NumModifiedRows: 810 |
| Partition: ss_sold_date_sk=2451755 |
| NumModifiedRows: 707 |
| Partition: ss_sold_date_sk=2451756 |
| NumModifiedRows: 978 |
| Partition: ss_sold_date_sk=2451757 |
| NumModifiedRows: 1016 |
| Partition: ss_sold_date_sk=2451758 |
| NumModifiedRows: 1071 |
| Partition: ss_sold_date_sk=2451759 |
| NumModifiedRows: 2075 |
| Partition: ss_sold_date_sk=2451760 |
| NumModifiedRows: 2188 |
| Partition: ss_sold_date_sk=2451761 |
| NumModifiedRows: 1832 |
| Partition: ss_sold_date_sk=2451762 |
| NumModifiedRows: 2187 |
| Partition: ss_sold_date_sk=2451763 |
| NumModifiedRows: 1935 |
| Partition: ss_sold_date_sk=2451764 |
| NumModifiedRows: 1905 |
| Partition: ss_sold_date_sk=2451765 |
| NumModifiedRows: 2108 |
| Partition: ss_sold_date_sk=2451766 |
| NumModifiedRows: 1985 |
| Partition: ss_sold_date_sk=2451767 |
| NumModifiedRows: 1641 |
| Partition: ss_sold_date_sk=2451768 |
| NumModifiedRows: 1845 |
| Partition: ss_sold_date_sk=2451769 |
| NumModifiedRows: 1844 |
| Partition: ss_sold_date_sk=2451770 |
| NumModifiedRows: 2017 |
| Partition: ss_sold_date_sk=2451771 |
| NumModifiedRows: 2054 |
| Partition: ss_sold_date_sk=2451772 |
| NumModifiedRows: 1985 |
| Partition: ss_sold_date_sk=2451773 |
| NumModifiedRows: 2125 |
| Partition: ss_sold_date_sk=2451774 |
| NumModifiedRows: 1864 |
| Partition: ss_sold_date_sk=2451775 |
| NumModifiedRows: 1814 |
| Partition: ss_sold_date_sk=2451776 |
| NumModifiedRows: 2009 |
| Partition: ss_sold_date_sk=2451777 |
| NumModifiedRows: 2101 |
| Partition: ss_sold_date_sk=2451778 |
| NumModifiedRows: 1835 |
| Partition: ss_sold_date_sk=2451779 |
| NumModifiedRows: 1711 |
| Partition: ss_sold_date_sk=2451780 |
| NumModifiedRows: 1865 |
| Partition: ss_sold_date_sk=2451781 |
| NumModifiedRows: 2063 |
| Partition: ss_sold_date_sk=2451782 |
| NumModifiedRows: 1942 |
| Partition: ss_sold_date_sk=2451783 |
| NumModifiedRows: 1800 |
| Partition: ss_sold_date_sk=2451784 |
| NumModifiedRows: 1805 |
| Partition: ss_sold_date_sk=2451785 |
| NumModifiedRows: 1969 |
| Partition: ss_sold_date_sk=2451786 |
| NumModifiedRows: 2101 |
| Partition: ss_sold_date_sk=2451787 |
| NumModifiedRows: 2073 |
| Partition: ss_sold_date_sk=2451788 |
| NumModifiedRows: 2011 |
| Partition: ss_sold_date_sk=2451789 |
| NumModifiedRows: 1984 |
| Partition: ss_sold_date_sk=2451790 |
| NumModifiedRows: 2049 |
| Partition: ss_sold_date_sk=2451791 |
| NumModifiedRows: 2070 |
| Partition: ss_sold_date_sk=2451792 |
| NumModifiedRows: 2030 |
| Partition: ss_sold_date_sk=2451793 |
| NumModifiedRows: 2085 |
| Partition: ss_sold_date_sk=2451794 |
| NumModifiedRows: 2046 |
| Partition: ss_sold_date_sk=2451795 |
| NumModifiedRows: 2014 |
| Partition: ss_sold_date_sk=2451796 |
| NumModifiedRows: 1955 |
| Partition: ss_sold_date_sk=2451797 |
| NumModifiedRows: 2031 |
| Partition: ss_sold_date_sk=2451798 |
| NumModifiedRows: 2053 |
| Partition: ss_sold_date_sk=2451799 |
| NumModifiedRows: 2174 |
| Partition: ss_sold_date_sk=2451800 |
| NumModifiedRows: 2128 |
| Partition: ss_sold_date_sk=2451801 |
| NumModifiedRows: 2014 |
| Partition: ss_sold_date_sk=2451802 |
| NumModifiedRows: 2264 |
| Partition: ss_sold_date_sk=2451803 |
| NumModifiedRows: 2306 |
| Partition: ss_sold_date_sk=2451804 |
| NumModifiedRows: 2151 |
| Partition: ss_sold_date_sk=2451805 |
| NumModifiedRows: 2062 |
| Partition: ss_sold_date_sk=2451806 |
| NumModifiedRows: 2204 |
| Partition: ss_sold_date_sk=2451807 |
| NumModifiedRows: 2020 |
| Partition: ss_sold_date_sk=2451808 |
| NumModifiedRows: 1950 |
| Partition: ss_sold_date_sk=2451809 |
| NumModifiedRows: 1948 |
| Partition: ss_sold_date_sk=2451810 |
| NumModifiedRows: 2171 |
| Partition: ss_sold_date_sk=2451811 |
| NumModifiedRows: 1713 |
| Partition: ss_sold_date_sk=2451812 |
| NumModifiedRows: 2006 |
| Partition: ss_sold_date_sk=2451813 |
| NumModifiedRows: 2297 |
| Partition: ss_sold_date_sk=2451814 |
| NumModifiedRows: 1784 |
| Partition: ss_sold_date_sk=2451815 |
| NumModifiedRows: 1976 |
| Partition: ss_sold_date_sk=2451816 |
| NumModifiedRows: 1945 |
| Partition: ss_sold_date_sk=2451817 |
| NumModifiedRows: 1888 |
| Partition: ss_sold_date_sk=2451818 |
| NumModifiedRows: 2003 |
| Partition: ss_sold_date_sk=2451819 |
| NumModifiedRows: 1753 |
| Partition: ss_sold_date_sk=2451820 |
| NumModifiedRows: 2122 |
| Partition: ss_sold_date_sk=2451821 |
| NumModifiedRows: 2006 |
| Partition: ss_sold_date_sk=2451822 |
| NumModifiedRows: 2046 |
| Partition: ss_sold_date_sk=2451823 |
| NumModifiedRows: 2117 |
| Partition: ss_sold_date_sk=2451824 |
| NumModifiedRows: 1943 |
| Partition: ss_sold_date_sk=2451825 |
| NumModifiedRows: 1830 |
| Partition: ss_sold_date_sk=2451826 |
| NumModifiedRows: 1867 |
| Partition: ss_sold_date_sk=2451827 |
| NumModifiedRows: 1944 |
| Partition: ss_sold_date_sk=2451828 |
| NumModifiedRows: 2065 |
| Partition: ss_sold_date_sk=2451829 |
| NumModifiedRows: 1784 |
| Partition: ss_sold_date_sk=2451830 |
| NumModifiedRows: 2169 |
| Partition: ss_sold_date_sk=2451831 |
| NumModifiedRows: 1974 |
| Partition: ss_sold_date_sk=2451832 |
| NumModifiedRows: 2157 |
| Partition: ss_sold_date_sk=2451833 |
| NumModifiedRows: 1629 |
| Partition: ss_sold_date_sk=2451834 |
| NumModifiedRows: 1963 |
| Partition: ss_sold_date_sk=2451835 |
| NumModifiedRows: 2035 |
| Partition: ss_sold_date_sk=2451836 |
| NumModifiedRows: 1926 |
| Partition: ss_sold_date_sk=2451837 |
| NumModifiedRows: 1976 |
| Partition: ss_sold_date_sk=2451838 |
| NumModifiedRows: 1887 |
| Partition: ss_sold_date_sk=2451839 |
| NumModifiedRows: 2053 |
| Partition: ss_sold_date_sk=2451840 |
| NumModifiedRows: 1758 |
| Partition: ss_sold_date_sk=2451841 |
| NumModifiedRows: 2067 |
| Partition: ss_sold_date_sk=2451842 |
| NumModifiedRows: 1892 |
| Partition: ss_sold_date_sk=2451843 |
| NumModifiedRows: 1879 |
| Partition: ss_sold_date_sk=2451844 |
| NumModifiedRows: 2203 |
| Partition: ss_sold_date_sk=2451845 |
| NumModifiedRows: 2275 |
| Partition: ss_sold_date_sk=2451846 |
| NumModifiedRows: 1917 |
| Partition: ss_sold_date_sk=2451847 |
| NumModifiedRows: 2008 |
| Partition: ss_sold_date_sk=2451848 |
| NumModifiedRows: 2193 |
| Partition: ss_sold_date_sk=2451849 |
| NumModifiedRows: 1867 |
| Partition: ss_sold_date_sk=2451850 |
| NumModifiedRows: 2184 |
| Partition: ss_sold_date_sk=2451851 |
| NumModifiedRows: 2716 |
| Partition: ss_sold_date_sk=2451852 |
| NumModifiedRows: 2676 |
| Partition: ss_sold_date_sk=2451853 |
| NumModifiedRows: 3405 |
| Partition: ss_sold_date_sk=2451854 |
| NumModifiedRows: 3302 |
| Partition: ss_sold_date_sk=2451855 |
| NumModifiedRows: 3086 |
| Partition: ss_sold_date_sk=2451856 |
| NumModifiedRows: 3060 |
| Partition: ss_sold_date_sk=2451857 |
| NumModifiedRows: 2844 |
| Partition: ss_sold_date_sk=2451858 |
| NumModifiedRows: 3160 |
| Partition: ss_sold_date_sk=2451859 |
| NumModifiedRows: 3106 |
| Partition: ss_sold_date_sk=2451860 |
| NumModifiedRows: 3019 |
| Partition: ss_sold_date_sk=2451861 |
| NumModifiedRows: 2746 |
| Partition: ss_sold_date_sk=2451862 |
| NumModifiedRows: 2991 |
| Partition: ss_sold_date_sk=2451863 |
| NumModifiedRows: 2971 |
| Partition: ss_sold_date_sk=2451864 |
| NumModifiedRows: 2975 |
| Partition: ss_sold_date_sk=2451865 |
| NumModifiedRows: 2985 |
| Partition: ss_sold_date_sk=2451866 |
| NumModifiedRows: 3068 |
| Partition: ss_sold_date_sk=2451867 |
| NumModifiedRows: 2885 |
| Partition: ss_sold_date_sk=2451868 |
| NumModifiedRows: 3291 |
| Partition: ss_sold_date_sk=2451869 |
| NumModifiedRows: 2694 |
| Partition: ss_sold_date_sk=2451870 |
| NumModifiedRows: 2975 |
| Partition: ss_sold_date_sk=2451871 |
| NumModifiedRows: 2923 |
| Partition: ss_sold_date_sk=2451872 |
| NumModifiedRows: 2949 |
| Partition: ss_sold_date_sk=2451873 |
| NumModifiedRows: 3373 |
| Partition: ss_sold_date_sk=2451874 |
| NumModifiedRows: 2847 |
| Partition: ss_sold_date_sk=2451875 |
| NumModifiedRows: 3111 |
| Partition: ss_sold_date_sk=2451876 |
| NumModifiedRows: 2790 |
| Partition: ss_sold_date_sk=2451877 |
| NumModifiedRows: 2945 |
| Partition: ss_sold_date_sk=2451878 |
| NumModifiedRows: 2641 |
| Partition: ss_sold_date_sk=2451879 |
| NumModifiedRows: 2961 |
| Partition: ss_sold_date_sk=2451880 |
| NumModifiedRows: 2966 |
| Partition: ss_sold_date_sk=2451881 |
| NumModifiedRows: 3246 |
| Partition: ss_sold_date_sk=2451882 |
| NumModifiedRows: 3029 |
| Partition: ss_sold_date_sk=2451883 |
| NumModifiedRows: 2990 |
| Partition: ss_sold_date_sk=2451884 |
| NumModifiedRows: 2981 |
| Partition: ss_sold_date_sk=2451885 |
| NumModifiedRows: 2668 |
| Partition: ss_sold_date_sk=2451886 |
| NumModifiedRows: 3125 |
| Partition: ss_sold_date_sk=2451887 |
| NumModifiedRows: 2681 |
| Partition: ss_sold_date_sk=2451888 |
| NumModifiedRows: 3343 |
| Partition: ss_sold_date_sk=2451889 |
| NumModifiedRows: 3053 |
| Partition: ss_sold_date_sk=2451890 |
| NumModifiedRows: 2957 |
| Partition: ss_sold_date_sk=2451891 |
| NumModifiedRows: 3060 |
| Partition: ss_sold_date_sk=2451892 |
| NumModifiedRows: 2876 |
| Partition: ss_sold_date_sk=2451893 |
| NumModifiedRows: 2719 |
| Partition: ss_sold_date_sk=2451894 |
| NumModifiedRows: 2999 |
| Partition: ss_sold_date_sk=2451895 |
| NumModifiedRows: 3245 |
| Partition: ss_sold_date_sk=2451896 |
| NumModifiedRows: 3115 |
| Partition: ss_sold_date_sk=2451897 |
| NumModifiedRows: 3070 |
| Partition: ss_sold_date_sk=2451898 |
| NumModifiedRows: 2978 |
| Partition: ss_sold_date_sk=2451899 |
| NumModifiedRows: 3004 |
| Partition: ss_sold_date_sk=2451900 |
| NumModifiedRows: 3194 |
| Partition: ss_sold_date_sk=2451901 |
| NumModifiedRows: 2833 |
| Partition: ss_sold_date_sk=2451902 |
| NumModifiedRows: 2826 |
| Partition: ss_sold_date_sk=2451903 |
| NumModifiedRows: 2850 |
| Partition: ss_sold_date_sk=2451904 |
| NumModifiedRows: 2789 |
| Partition: ss_sold_date_sk=2451905 |
| NumModifiedRows: 2867 |
| Partition: ss_sold_date_sk=2451906 |
| NumModifiedRows: 3129 |
| Partition: ss_sold_date_sk=2451907 |
| NumModifiedRows: 2876 |
| Partition: ss_sold_date_sk=2451908 |
| NumModifiedRows: 3114 |
| Partition: ss_sold_date_sk=2451909 |
| NumModifiedRows: 3060 |
| Partition: ss_sold_date_sk=2451910 |
| NumModifiedRows: 3109 |
| aggregation(SUM, RowsInserted): 553861 |
| ==== |
| ---- QUERY: TPCDS-SS-INSERT-VERIFY |
| SELECT COUNT(*) FROM store_sales_insert |
| ---- RESULTS |
| 879508 |
| ==== |
