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