You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by ta...@apache.org on 2019/04/17 22:21:16 UTC
[impala] 01/02: IMPALA-8410: enable TestTpcdsInsert by default
This is an automated email from the ASF dual-hosted git repository.
tarmstrong pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/impala.git
commit 30082232ed83d712b24756bf09fd2c48dc15e571
Author: Tim Armstrong <ta...@cloudera.com>
AuthorDate: Tue Apr 16 23:09:39 2019 -0700
IMPALA-8410: enable TestTpcdsInsert by default
Fix incorrect output to match current behaviour. The test takes
24s on my system but can be run in parallel with other tests.
Change-Id: Ibf9a279d57ad74de0c77a90dde69e5c4dc563a3f
Reviewed-on: http://gerrit.cloudera.org:8080/13055
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
---
.../tpcds-insert/queries/partitioned-insert.test | 534 ++++++++++++++++++++-
tests/query_test/test_tpcds_queries.py | 5 -
2 files changed, 509 insertions(+), 30 deletions(-)
diff --git a/testdata/workloads/tpcds-insert/queries/partitioned-insert.test b/testdata/workloads/tpcds-insert/queries/partitioned-insert.test
index 46937a0..e03fa3c 100644
--- a/testdata/workloads/tpcds-insert/queries/partitioned-insert.test
+++ b/testdata/workloads/tpcds-insert/queries/partitioned-insert.test
@@ -1,11 +1,11 @@
====
---- QUERY: TPCDS-SS-INSERT-SETUP1
DROP TABLE IF EXISTS store_sales_insert
----- RESULTS
====
---- 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
@@ -20,55 +20,539 @@ 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=2451284/: 794
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=2451437/: 1989
-ss_sold_date_sk=2451528/: 3144
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=2451514/: 2980
+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=2451789/: 1984
-ss_sold_date_sk=2451758/: 1071
-ss_sold_date_sk=2451850/: 2184
-ss_sold_date_sk=2451680/: 953
-ss_sold_date_sk=2451636/: 1001
+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=2451727/: 990
-ss_sold_date_sk=2451741/: 855
-ss_sold_date_sk=2451697/: 809
-ss_sold_date_sk=2451576/: 819
-ss_sold_date_sk=2451894/: 2999
+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=2451864/: 2975
-ss_sold_date_sk=2451880/: 2966
-ss_sold_date_sk=2451772/: 1985
-ss_sold_date_sk=2451605/: 707
-ss_sold_date_sk=2451833/: 1629
+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=2451545/: 2743
-ss_sold_date_sk=2451819/: 1753
+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=2451559/: 867
+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
-57244
-====
\ No newline at end of file
+879508
+====
diff --git a/tests/query_test/test_tpcds_queries.py b/tests/query_test/test_tpcds_queries.py
index 54d884f..72b0224 100644
--- a/tests/query_test/test_tpcds_queries.py
+++ b/tests/query_test/test_tpcds_queries.py
@@ -516,11 +516,6 @@ class TestTpcdsInsert(ImpalaTestSuite):
cls.ImpalaTestMatrix.add_dimension(create_single_exec_option_dimension())
cls.ImpalaTestMatrix.add_constraint(lambda v:
is_supported_insert_format(v.get_value('table_format')))
- if cls.exploration_strategy() == 'core' and not pytest.config.option.table_formats:
- # Don't run on core, unless the user explicitly wants to validate a specific table
- # format. Each test vector takes > 30s to complete and it doesn't add much
- # additional coverage on top of what's in the functional insert test suite
- cls.ImpalaTestMatrix.add_constraint(lambda v: False);
def test_tpcds_partitioned_insert(self, vector):
self.run_test_case('partitioned-insert', vector)