You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by kw...@apache.org on 2017/05/27 05:34:36 UTC
[06/11] incubator-impala git commit: IMPALA-5376: Loads all TPC-DS
tables
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q47.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q47.test b/testdata/workloads/tpcds/queries/tpcds-q47.test
index d6181a1..b65606e 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q47.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q47.test
@@ -18,18 +18,18 @@ with v1 as (
ss_sold_date_sk = d_date_sk and
ss_store_sk = s_store_sk and
(
- d_year = 2000 or
- ( d_year = 2000-1 and d_moy =12) or
- ( d_year = 2000+1 and d_moy =1)
+ d_year = 1999 or
+ ( d_year = 1999-1 and d_moy =12) or
+ ( d_year = 1999+1 and d_moy =1)
)
group by i_category, i_brand,
s_store_name, s_company_name,
d_year, d_moy),
v2 as(
- select v1.i_category, v1.i_brand
- ,v1.d_year
- ,v1.avg_monthly_sales
- ,v1.sum_sales, v1_lag.sum_sales psum, v1_lead.sum_sales nsum
+ select v1.i_category, v1.i_brand, v1.s_store_name, v1.s_company_name,
+ v1.d_year, v1.d_moy,
+ v1.avg_monthly_sales,
+ v1.sum_sales, v1_lag.sum_sales psum, v1_lead.sum_sales nsum
from v1, v1 v1_lag, v1 v1_lead
where v1.i_category = v1_lag.i_category and
v1.i_category = v1_lead.i_category and
@@ -41,115 +41,114 @@ with v1 as (
v1.s_company_name = v1_lead.s_company_name and
v1.rn = v1_lag.rn + 1 and
v1.rn = v1_lead.rn - 1)
- select * from ( select *
- from v2
- where d_year = 2000 and
- avg_monthly_sales > 0 and
- case when avg_monthly_sales > 0 then abs(sum_sales - avg_monthly_sales) / avg_monthly_sales else null end > 0.1
- order by sum_sales - avg_monthly_sales, d_year
- limit 100
- ) as v3;
+select *
+from v2
+where d_year = 1999 and
+ avg_monthly_sales > 0 and
+ case when avg_monthly_sales > 0 then abs(sum_sales - avg_monthly_sales) / avg_monthly_sales else null end > 0.1
+order by sum_sales - avg_monthly_sales, 3
+limit 100;
---- RESULTS
-'Music','exportischolar #2',2000,361.19,13.04,106.77,409.30
-'Children','edu packexporti #2',2000,362.04,16.51,244.81,332.70
-'Children','amalgexporti #2',2000,359.25,17.80,119.79,402.04
-'Men','exportiimporto #2',2000,360.29,24.07,146.16,311.11
-'Shoes','edu packedu pack #2',2000,435.23,99.52,117.61,342.76
-'Shoes','edu packedu pack #2',2000,367.25,33.69,183.52,248.83
-'Music','importoscholar #2',2000,356.14,25.73,467.16,446.34
-'Music','importoscholar #2',2000,349.97,21.94,158.75,189.86
-'Women','importoamalg #2',2000,339.12,13.02,362.77,64.19
-'Music','exportischolar #2',2000,395.42,70.06,176.36,100.96
-'Shoes','amalgedu pack #2',2000,373.16,49.95,506.85,391.35
-'Children','amalgexporti #2',2000,359.25,37.88,385.03,162.10
-'Children','edu packexporti #2',2000,370.88,49.92,572.50,170.68
-'Men','importoimporto #2',2000,386.15,67.23,219.86,262.57
-'Shoes','edu packedu pack #2',2000,435.23,117.61,240.82,99.52
-'Music','exportischolar #2',2000,361.19,46.12,409.30,265.88
-'Children','amalgexporti #2',2000,359.25,44.62,402.04,579.27
-'Shoes','amalgedu pack #2',2000,381.90,71.30,153.69,174.69
-'Shoes','edu packedu pack #2',2000,347.34,38.61,100.06,583.75
-'Children','importoexporti #2',2000,329.89,25.04,175.20,331.63
-'Shoes','importoedu pack #2',2000,324.17,22.89,207.71,293.57
-'Shoes','edu packedu pack #2',2000,435.23,134.15,348.95,240.82
-'Children','importoexporti #2',2000,302.23,2.18,399.83,387.33
-'Children','importoexporti #2',2000,329.89,33.47,192.64,241.84
-'Shoes','importoedu pack #2',2000,377.75,81.52,162.18,261.97
-'Music','exportischolar #2',2000,369.79,74.38,89.31,558.77
-'Music','exportischolar #2',2000,395.42,100.96,70.06,314.94
-'Women','amalgamalg #2',2000,336.94,43.31,171.61,308.07
-'Shoes','exportiedu pack #2',2000,297.03,5.41,136.96,163.28
-'Music','exportischolar #2',2000,395.42,103.98,209.35,735.08
-'Men','exportiimporto #2',2000,297.08,8.54,164.76,440.19
-'Women','edu packamalg #2',2000,297.48,9.18,86.30,205.52
-'Music','importoscholar #2',2000,356.14,68.53,731.67,467.16
-'Music','importoscholar #2',2000,354.33,66.79,540.56,337.62
-'Women','edu packamalg #2',2000,387.24,101.42,312.67,319.73
-'Men','importoimporto #2',2000,295.69,10.42,147.56,208.51
-'Men','importoimporto #2',2000,299.57,14.43,122.98,189.73
-'Shoes','importoedu pack #2',2000,324.17,39.68,293.57,282.13
-'Women','edu packamalg #2',2000,387.24,102.88,238.97,312.67
-'Men','importoimporto #2',2000,284.22,1.16,235.46,195.91
-'Music','importoscholar #2',2000,350.94,67.98,177.70,180.42
-'Music','exportischolar #2',2000,369.79,89.31,458.60,74.38
-'Men','edu packimporto #2',2000,311.30,31.70,241.11,63.42
-'Women','importoamalg #2',2000,297.16,18.02,300.59,51.18
-'Shoes','importoedu pack #2',2000,354.37,75.24,362.69,186.63
-'Music','edu packscholar #2',2000,305.20,28.38,77.11,147.96
-'Children','edu packexporti #2',2000,351.05,76.01,180.52,141.75
-'Women','importoamalg #2',2000,339.12,64.19,13.02,254.39
-'Men','exportiimporto #2',2000,297.08,24.11,242.76,248.58
-'Women','edu packamalg #2',2000,288.12,16.55,274.43,347.53
-'Music','importoscholar #2',2000,354.33,84.08,114.57,183.08
-'Children','importoexporti #2',2000,359.26,90.06,209.99,127.84
-'Music','edu packscholar #2',2000,357.13,88.56,219.38,126.28
-'Women','edu packamalg #2',2000,309.34,41.33,236.30,86.68
-'Women','edu packamalg #2',2000,387.24,120.03,164.15,315.35
-'Women','amalgamalg #2',2000,336.94,72.42,308.07,212.67
-'Music','edu packscholar #2',2000,303.17,38.66,174.79,40.61
-'Children','exportiexporti #2',2000,269.23,4.78,164.15,361.87
-'Women','amalgamalg #2',2000,288.29,24.72,92.24,38.35
-'Children','importoexporti #2',2000,296.51,33.44,338.99,305.21
-'Women','edu packamalg #2',2000,321.60,58.71,246.93,111.44
-'Music','edu packscholar #2',2000,303.17,40.61,38.66,381.59
-'Shoes','importoedu pack #2',2000,303.60,41.77,476.55,152.55
-'Shoes','amalgedu pack #2',2000,262.91,1.76,199.71,232.04
-'Women','exportiamalg #2',2000,312.08,52.17,181.79,604.07
-'Men','importoimporto #1',2000,264.92,6.09,51.74,324.71
-'Men','importoimporto #2',2000,299.61,42.73,312.20,302.03
-'Music','edu packscholar #2',2000,364.77,108.75,264.08,233.09
-'Shoes','edu packedu pack #2',2000,356.72,100.87,404.12,151.68
-'Men','edu packimporto #2',2000,260.32,4.82,153.07,52.59
-'Men','importoimporto #2',2000,299.57,44.48,186.44,115.44
-'Music','exportischolar #2',2000,361.19,106.77,586.37,13.04
-'Women','edu packamalg #2',2000,297.48,44.57,110.27,86.30
-'Shoes','exportiedu pack #2',2000,257.65,5.06,179.25,171.34
-'Men','edu packimporto #2',2000,260.32,8.01,392.05,153.07
-'Men','exportiimporto #2',2000,276.31,24.40,175.44,121.21
-'Men','edu packimporto #2',2000,259.77,7.97,361.69,271.30
-'Music','exportischolar #1',2000,265.85,14.47,111.80,143.69
-'Children','importoexporti #2',2000,296.51,45.30,305.21,509.36
-'Women','amalgamalg #2',2000,288.29,38.35,24.72,167.12
-'Children','amalgexporti #2',2000,258.19,8.51,284.62,174.93
-'Men','amalgimporto #2',2000,269.19,19.52,283.80,149.64
-'Men','exportiimporto #2',2000,263.88,14.25,144.04,79.18
-'Women','importoamalg #2',2000,297.16,48.06,51.18,161.10
-'Children','edu packexporti #2',2000,351.05,102.51,141.75,329.38
-'Shoes','exportiedu pack #2',2000,257.65,9.16,122.20,172.63
-'Men','edu packimporto #2',2000,311.30,63.42,31.70,250.44
-'Women','amalgamalg #2',2000,296.20,48.54,300.19,68.95
-'Shoes','edu packedu pack #2',2000,347.34,100.06,114.45,38.61
-'Women','importoamalg #2',2000,297.16,51.18,18.02,48.06
-'Shoes','importoedu pack #2',2000,366.10,120.48,485.39,NULL
-'Women','exportiamalg #2',2000,303.16,57.72,163.35,244.09
-'Children','edu packexporti #2',2000,362.04,117.20,240.88,251.77
-'Men','edu packimporto #2',2000,311.30,68.07,336.53,888.77
-'Women','exportiamalg #2',2000,252.16,10.20,245.51,37.14
-'Music','exportischolar #1',2000,268.64,27.05,362.79,162.28
-'Shoes','edu packedu pack #2',2000,347.34,106.81,454.54,487.93
-'Music','importoscholar #2',2000,354.33,114.57,171.28,84.08
-'Children','amalgexporti #2',2000,250.37,10.75,210.60,63.72
-'Men','importoimporto #2',2000,299.61,60.11,216.51,312.20
+'Men','importoimporto #1','ese','Unknown',1999,3,5492.81,2070.65,3307.78,2784.11
+'Music','exportischolar #1','eing','Unknown',1999,2,5134.23,1740.21,4401.89,2721.61
+'Music','edu packscholar #1','ese','Unknown',1999,4,5463.70,2091.07,3391.39,3095.31
+'Music','edu packscholar #1','ought','Unknown',1999,7,5552.30,2226.34,4081.99,7573.33
+'Music','edu packscholar #1','ese','Unknown',1999,2,5463.70,2268.27,4139.47,3391.39
+'Men','edu packimporto #1','ought','Unknown',1999,7,5176.25,1993.73,3542.54,5764.35
+'Children','exportiexporti #1','ese','Unknown',1999,3,5185.89,2019.69,3479.21,2982.05
+'Shoes','amalgedu pack #1','ation','Unknown',1999,6,5152.09,2077.67,3123.43,2368.73
+'Men','edu packimporto #1','eing','Unknown',1999,3,5501.18,2453.88,2683.70,2615.32
+'Children','exportiexporti #1','ation','Unknown',1999,4,5238.35,2232.03,3221.70,3649.52
+'Shoes','importoedu pack #1','eing','Unknown',1999,5,4698.61,1703.27,2687.15,2757.83
+'Music','exportischolar #1','bar','Unknown',1999,7,5318.14,2346.06,3483.88,7658.62
+'Music','edu packscholar #1','ation','Unknown',1999,2,5622.22,2657.68,4207.03,3543.82
+'Children','exportiexporti #1','bar','Unknown',1999,7,5280.66,2324.79,3003.61,5961.39
+'Children','importoexporti #1','eing','Unknown',1999,2,4650.43,1734.45,2341.19,2720.78
+'Shoes','importoedu pack #1','ought','Unknown',1999,4,4537.63,1623.33,2928.34,1905.23
+'Women','edu packamalg #1','ation','Unknown',1999,4,4507.41,1596.92,2865.38,2665.75
+'Men','importoimporto #1','ought','Unknown',1999,6,5045.75,2152.15,2834.94,2667.92
+'Men','edu packimporto #1','eing','Unknown',1999,4,5501.18,2615.32,2453.88,2874.96
+'Shoes','exportiedu pack #1','bar','Unknown',1999,3,5296.08,2410.44,2685.85,3821.39
+'Men','importoimporto #1','able','Unknown',1999,2,5194.81,2333.43,2765.75,2674.91
+'Music','amalgscholar #1','ought','Unknown',1999,2,4565.60,1727.16,3895.09,2606.58
+'Music','edu packscholar #1','eing','Unknown',1999,5,5539.30,2704.16,3862.34,3960.90
+'Shoes','importoedu pack #1','ation','Unknown',1999,4,4690.57,1855.85,3524.69,3050.34
+'Men','edu packimporto #1','eing','Unknown',1999,2,5501.18,2683.70,4304.21,2453.88
+'Women','exportiamalg #1','able','Unknown',1999,2,4123.60,1306.40,2876.61,2238.71
+'Music','exportischolar #1','able','Unknown',1999,5,5090.10,2281.80,2488.24,3304.75
+'Shoes','exportiedu pack #1','ought','Unknown',1999,2,4755.53,1951.00,3949.06,2767.05
+'Men','importoimporto #1','ese','Unknown',1999,6,5492.81,2691.33,3210.74,3754.33
+'Men','amalgimporto #1','ation','Unknown',1999,2,4909.46,2116.43,3187.20,3356.64
+'Men','importoimporto #1','ought','Unknown',1999,2,5045.75,2253.70,4158.86,3467.09
+'Shoes','amalgedu pack #1','ation','Unknown',1999,7,5152.09,2368.73,2077.67,7543.60
+'Men','edu packimporto #1','ese','Unknown',1999,3,4979.36,2201.00,3110.55,3118.30
+'Children','exportiexporti #1','ation','Unknown',1999,2,5238.35,2462.96,3808.48,3221.70
+'Men','amalgimporto #1','ation','Unknown',1999,4,4909.46,2136.23,3356.64,3046.51
+'Children','importoexporti #1','able','Unknown',1999,7,4586.29,1814.46,2643.58,6423.18
+'Men','edu packimporto #1','ation','Unknown',1999,4,5170.36,2407.58,3086.77,2492.73
+'Shoes','amalgedu pack #1','ese','Unknown',1999,7,4392.18,1630.14,2755.91,6185.73
+'Shoes','amalgedu pack #1','able','Unknown',1999,5,4940.22,2187.55,2894.91,3018.65
+'Men','edu packimporto #1','ought','Unknown',1999,4,5176.25,2424.94,4285.78,3286.20
+'Women','amalgamalg #1','able','Unknown',1999,6,4507.24,1761.81,2891.95,2302.21
+'Men','importoimporto #1','ation','Unknown',1999,3,5410.91,2672.68,3591.65,2988.08
+'Men','importoimporto #1','ation','Unknown',1999,5,5410.91,2677.81,2988.08,2881.34
+'Men','edu packimporto #1','bar','Unknown',1999,4,5632.73,2901.64,3202.87,3447.78
+'Children','exportiexporti #1','able','Unknown',1999,5,4955.24,2230.80,2395.57,3003.89
+'Men','importoimporto #1','eing','Unknown',1999,5,5074.07,2356.88,2833.40,2854.62
+'Men','edu packimporto #1','bar','Unknown',1999,2,5632.73,2916.43,3847.05,3202.87
+'Shoes','exportiedu pack #1','ese','Unknown',1999,3,4865.28,2151.76,3212.91,3768.25
+'Men','importoimporto #1','ese','Unknown',1999,4,5492.81,2784.11,2070.65,3210.74
+'Shoes','exportiedu pack #1','bar','Unknown',1999,7,5296.08,2591.12,3012.98,6254.36
+'Shoes','exportiedu pack #1','ation','Unknown',1999,5,4873.51,2170.98,2302.76,3236.50
+'Shoes','amalgedu pack #1','able','Unknown',1999,2,4940.22,2239.16,3495.29,2563.93
+'Children','exportiexporti #1','eing','Unknown',1999,7,5109.65,2410.24,2916.46,6558.23
+'Women','importoamalg #1','able','Unknown',1999,7,4574.74,1881.03,2345.66,6036.28
+'Women','amalgamalg #1','ought','Unknown',1999,7,4619.70,1926.67,3528.98,5162.15
+'Children','importoexporti #1','bar','Unknown',1999,7,4566.77,1879.57,3400.62,6244.92
+'Music','edu packscholar #1','ation','Unknown',1999,6,5622.22,2943.26,3643.42,3847.77
+'Music','exportischolar #1','ation','Unknown',1999,4,4962.65,2283.77,3210.01,2539.84
+'Music','exportischolar #1','ation','Unknown',1999,2,4962.65,2284.23,3250.69,3210.01
+'Men','edu packimporto #1','ation','Unknown',1999,5,5170.36,2492.73,2407.58,3288.94
+'Men','edu packimporto #1','able','Unknown',1999,3,4989.30,2318.98,2618.89,3315.77
+'Music','exportischolar #1','bar','Unknown',1999,4,5318.14,2651.96,2989.10,3649.76
+'Music','exportischolar #1','bar','Unknown',1999,2,5318.14,2656.31,3419.77,2989.10
+'Shoes','amalgedu pack #1','bar','Unknown',1999,6,4805.40,2149.56,2686.70,3098.25
+'Children','exportiexporti #1','bar','Unknown',1999,4,5280.66,2625.99,3301.62,4331.44
+'Music','amalgscholar #1','ation','Unknown',1999,4,4934.50,2280.93,2322.89,2421.13
+'Music','edu packscholar #1','able','Unknown',1999,7,5335.90,2684.15,3543.33,7540.94
+'Shoes','importoedu pack #1','eing','Unknown',1999,2,4698.61,2058.86,3191.74,2812.15
+'Shoes','edu packedu pack #1','ought','Unknown',1999,5,4745.29,2109.27,3203.82,2737.82
+'Shoes','importoedu pack #1','ought','Unknown',1999,5,4537.63,1905.23,1623.33,3170.58
+'Men','edu packimporto #1','able','Unknown',1999,6,4989.30,2357.82,3363.58,3142.81
+'Children','exportiexporti #1','able','Unknown',1999,2,4955.24,2326.67,2746.99,3097.63
+'Men','edu packimporto #1','eing','Unknown',1999,5,5501.18,2874.96,2615.32,3714.00
+'Shoes','exportiedu pack #1','ation','Unknown',1999,7,4873.51,2256.56,3236.50,6245.37
+'Shoes','importoedu pack #1','ese','Unknown',1999,3,4676.74,2060.29,3273.67,2610.86
+'Men','amalgimporto #1','ese','Unknown',1999,6,4764.59,2150.16,3284.27,3475.17
+'Music','amalgscholar #1','ation','Unknown',1999,3,4934.50,2322.89,3197.76,2280.93
+'Shoes','exportiedu pack #1','bar','Unknown',1999,2,5296.08,2685.85,4235.44,2410.44
+'Children','importoexporti #1','able','Unknown',1999,5,4586.29,1982.77,2837.74,2643.58
+'Music','exportischolar #1','able','Unknown',1999,4,5090.10,2488.24,2966.36,2281.80
+'Shoes','importoedu pack #1','able','Unknown',1999,7,4700.91,2100.12,2533.01,5888.57
+'Music','edu packscholar #1','bar','Unknown',1999,2,5484.78,2903.45,3410.13,3024.86
+'Shoes','exportiedu pack #1','ation','Unknown',1999,3,4873.51,2300.45,2797.30,2302.76
+'Shoes','exportiedu pack #1','ation','Unknown',1999,4,4873.51,2302.76,2300.45,2170.98
+'Shoes','importoedu pack #1','bar','Unknown',1999,3,4794.67,2225.70,2756.97,2413.76
+'Music','edu packscholar #1','ought','Unknown',1999,5,5552.30,2985.49,3241.69,4081.99
+'Music','edu packscholar #1','eing','Unknown',1999,3,5539.30,2973.01,3069.18,3862.34
+'Shoes','amalgedu pack #1','eing','Unknown',1999,7,4706.54,2143.18,2458.07,5967.73
+'Children','exportiexporti #1','ought','Unknown',1999,5,5018.27,2458.03,3467.53,2683.61
+'Children','exportiexporti #1','able','Unknown',1999,4,4955.24,2395.57,3097.63,2230.80
+'Children','exportiexporti #1','eing','Unknown',1999,2,5109.65,2550.30,4039.10,2685.10
+'Music','exportischolar #1','ought','Unknown',1999,4,5079.18,2520.64,3233.50,3079.89
+'Women','edu packamalg #1','ation','Unknown',1999,2,4507.41,1951.42,4166.02,2865.38
+'Women','amalgamalg #1','ought','Unknown',1999,1,4619.70,2065.94,9639.59,2521.70
+'Music','importoscholar #1','ought','Unknown',1999,3,4004.44,1456.84,2438.63,2790.03
+'Shoes','edu packedu pack #1','eing','Unknown',1999,5,4664.86,2122.71,3131.02,2852.96
+'Women','importoamalg #1','bar','Unknown',1999,3,4437.21,1895.27,2678.48,2999.04
+'Music','exportischolar #1','able','Unknown',1999,2,5090.10,2550.48,3702.29,2966.36
+'Music','edu packscholar #1','able','Unknown',1999,1,5335.90,2796.97,13360.68,3413.22
+'Children','exportiexporti #1','eing','Unknown',1999,4,5109.65,2574.12,2685.10,2672.73
---- TYPES
-STRING, STRING, INT, DECIMAL, DECIMAL, DECIMAL, DECIMAL
+STRING, STRING, STRING, STRING, INT, INT, DECIMAL, DECIMAL, DECIMAL, DECIMAL
====
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q52.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q52.test b/testdata/workloads/tpcds/queries/tpcds-q52.test
index b9b4153..dfa1fc4 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q52.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q52.test
@@ -13,9 +13,8 @@ where
dt.d_date_sk = store_sales.ss_sold_date_sk
and store_sales.ss_item_sk = item.i_item_sk
and item.i_manager_id = 1
- and dt.d_moy = 12
- and dt.d_year = 1998
- and ss_sold_date_sk between 2451149 and 2451179 -- added for partition pruning
+ and dt.d_moy = 11
+ and dt.d_year = 2000
group by
dt.d_year,
item.i_brand,
@@ -26,59 +25,106 @@ order by
brand_id
limit 100;
---- RESULTS
-1998,2001002,'amalgimporto #2',17501.99
-1998,2004002,'edu packimporto #2',14472.43
-1998,5004002,'edu packscholar #2',14284.98
-1998,5001002,'amalgscholar #2',12435.77
-1998,1002002,'importoamalg #2',11943.72
-1998,4004002,'edu packedu pack #2',9636.47
-1998,3002001,'importoexporti #1',6423.43
-1998,7016001,'corpnameless #1',6320.14
-1998,5001001,'amalgscholar #1',5882.18
-1998,10009015,'maxiunivamalg #15',5734.82
-1998,6011001,'amalgbrand #1',5659.65
-1998,2002001,'importoimporto #1',5432.18
-1998,8004003,'edu packnameless #3',5272.87
-1998,6002005,'importocorp #5',5271.95
-1998,5004001,'edu packscholar #1',4905.18
-1998,4001001,'amalgedu pack #1',4733.84
-1998,10012011,'importoamalgamalg #11',4587.31
-1998,7009010,'maxibrand #10',4423.50
-1998,9015009,'scholarunivamalg #9',4343.74
-1998,8014005,'edu packmaxi #5',3859.59
-1998,6005001,'scholarcorp #1',3437.97
-1998,10013015,'exportiamalgamalg #15',3335.26
-1998,1003002,'exportiamalg #2',3138.03
-1998,9016003,'corpunivamalg #3',3014.73
-1998,5003001,'exportischolar #1',2643.16
-1998,10013013,'exportiamalgamalg #13',2600.43
-1998,1004001,'edu packamalg #1',2446.66
-1998,1003001,'exportiamalg #1',2388.04
-1998,6006007,'corpcorp #7',2381.19
-1998,10004004,'edu packunivamalg #4',1953.67
-1998,2003001,'exportiimporto #1',1940.85
-1998,1004002,'edu packamalg #2',1582.04
-1998,10003016,'exportiunivamalg #16',1461.97
-1998,6007003,'brandcorp #3',1437.27
-1998,3002002,'importoexporti #2',1371.75
-1998,8004009,'edu packnameless #9',1020.28
-1998,1002001,'importoamalg #1',693.80
-1998,3003001,'exportiexporti #1',690.56
-1998,6012005,'importobrand #5',646.97
-1998,3003002,'exportiexporti #2',542.79
-1998,1001001,'amalgamalg #1',386.25
-1998,7010003,'univnameless #3',335.72
-1998,9012005,'importounivamalg #5',333.70
-1998,3001001,'amalgexporti #1',329.28
-1998,5002001,'importoscholar #1',299.76
-1998,7010009,'univnameless #9',297.50
-1998,6015006,'scholarbrand #6',250.24
-1998,8013007,'exportimaxi #7',208.00
-1998,6009003,'maxicorp #3',198.90
-1998,7001005,'amalgbrand #5',146.70
-1998,7007004,'brandbrand #4',68.54
-1998,4001002,'amalgedu pack #2',63.42
-1998,7012010,'importonameless #10',26.60
+2000,2001002,'amalgimporto #2',133668.20
+2000,1003001,'exportiamalg #1',85038.62
+2000,3002002,'importoexporti #2',79104.47
+2000,3004002,'edu packexporti #2',78772.08
+2000,3003001,'exportiexporti #1',67105.01
+2000,2004002,'edu packimporto #2',65904.27
+2000,4001002,'amalgedu pack #2',56283.13
+2000,5002002,'importoscholar #2',54390.12
+2000,7016001,'corpnameless #1',51331.65
+2000,2002001,'importoimporto #1',50831.66
+2000,7001005,'amalgbrand #5',50727.31
+2000,9015009,'scholarunivamalg #9',49522.53
+2000,5004002,'edu packscholar #2',45205.15
+2000,4003001,'exportiedu pack #1',42810.52
+2000,5001002,'amalgscholar #2',42061.33
+2000,1003002,'exportiamalg #2',41130.32
+2000,2003002,'exportiimporto #2',39318.67
+2000,7007004,'brandbrand #4',38993.74
+2000,1002002,'importoamalg #2',38952.02
+2000,8003010,'exportinameless #10',37010.51
+2000,1002001,'importounivamalg #1',36393.47
+2000,4002001,'scholarmaxi #6',34103.67
+2000,1001002,'amalgamalg #2',32518.42
+2000,4004002,'edu packedu pack #2',32114.76
+2000,5001001,'edu packexporti #2',31507.22
+2000,6005005,'edu packnameless #8',31445.28
+2000,1001001,'amalgamalg #1',31305.49
+2000,4002001,'importoedu pack #1',31248.26
+2000,6005001,'scholarcorp #1',30955.09
+2000,1004001,'edu packamalg #1',30464.10
+2000,7009004,'maxibrand #4',29127.01
+2000,10010013,'univamalgamalg #13',29071.87
+2000,6012008,'importobrand #8',28799.91
+2000,8005009,'corpnameless #10',28231.03
+2000,5003001,'exportischolar #1',27336.64
+2000,5001001,'brandunivamalg #11',26418.90
+2000,3001002,'amalgexporti #2',25858.35
+2000,4004001,'edu packedu pack #1',25715.17
+2000,7009009,'exportibrand #10',25380.68
+2000,4004001,'maxinameless #8',23992.40
+2000,10014001,'maxibrand #4',23662.09
+2000,10009015,'maxiunivamalg #15',23576.97
+2000,3003001,'exportiedu pack #2',21959.63
+2000,10004004,'edu packunivamalg #4',21950.07
+2000,3002001,'importoexporti #1',21677.43
+2000,1004002,'edu packamalg #2',21563.27
+2000,2002002,'importoimporto #2',21502.53
+2000,2001001,'importoimporto #2',21106.22
+2000,9012003,'importounivamalg #3',21075.27
+2000,3003002,'exportiexporti #2',20711.54
+2000,10015013,'scholaramalgamalg #13',20610.41
+2000,7010005,'corpunivamalg #6',19821.13
+2000,4003001,'exportischolar #2',19693.88
+2000,9012008,'importounivamalg #8',19463.65
+2000,7010009,'univnameless #9',19176.91
+2000,7008004,'namelessbrand #4',19128.07
+2000,2003001,'exportiimporto #1',19074.52
+2000,6008005,'namelesscorp #5',19067.51
+2000,3004001,'edu packexporti #1',18504.78
+2000,5001001,'exportinameless #8',18493.00
+2000,10003016,'exportiunivamalg #16',18413.97
+2000,3001001,'maxibrand #8',18290.52
+2000,8003007,'edu packnameless #8',18265.99
+2000,7016007,'corpnameless #7',18103.37
+2000,5003002,'exportischolar #2',17930.96
+2000,8016004,'corpmaxi #4',17828.86
+2000,2004001,'importoexporti #2',17646.57
+2000,10004012,'edu packunivamalg #12',17608.05
+2000,8002009,'importonameless #9',17513.05
+2000,7004009,'importoimporto #2',17312.88
+2000,2004001,'edu packunivamalg #8',17084.17
+2000,9014006,'edu packunivamalg #6',16958.88
+2000,9015011,'exportiamalg #2',15875.77
+2000,10004005,'importounivamalg #6',15258.42
+2000,6008002,'namelesscorp #2',15199.06
+2000,6004002,'edu packcorp #2',14905.77
+2000,9013009,'exportiunivamalg #9',14704.96
+2000,7012010,'importonameless #10',14697.15
+2000,7013007,'exportinameless #7',14068.62
+2000,7008009,'namelessbrand #9',13759.65
+2000,7006007,'edu packamalg #2',13705.14
+2000,10012004,'importoamalgamalg #4',13514.95
+2000,6015006,'scholarbrand #6',13421.39
+2000,10002012,'importounivamalg #12',13080.55
+2000,9016003,'corpunivamalg #3',12936.25
+2000,6002004,'importocorp #4',12491.48
+2000,8004003,'edu packnameless #3',12480.24
+2000,6011008,'amalgbrand #8',12236.00
+2000,6003008,'exporticorp #8',11621.79
+2000,8005008,'scholarnameless #8',11609.84
+2000,4001001,'amalgedu pack #1',11110.78
+2000,7009010,'maxibrand #10',11061.00
+2000,3004001,'edu packscholar #2',11025.47
+2000,7012001,'amalgamalgamalg #2',10846.24
+2000,7016009,'univnameless #10',10454.42
+2000,7014001,'edu packnameless #1',9596.47
+2000,1002001,'importoamalg #1',9579.28
+2000,8010004,'univmaxi #4',9508.89
+2000,3001001,'amalgexporti #1',9373.84
+2000,6010005,'univbrand #5',9222.91
---- TYPES
INT, INT, STRING, DECIMAL
====
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q53.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q53.test b/testdata/workloads/tpcds/queries/tpcds-q53.test
index 6d909ce..8ecba26 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q53.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q53.test
@@ -5,8 +5,8 @@ select
from
(select
i_manufact_id,
- sum(ss_sales_price) sum_sales
- -- avg(sum(ss_sales_price)) over (partition by i_manufact_id) avg_quarterly_sales
+ sum(ss_sales_price) sum_sales,
+ avg(sum(ss_sales_price)) over (partition by i_manufact_id) avg_quarterly_sales
from
item,
store_sales,
@@ -16,39 +16,125 @@ from
ss_item_sk = i_item_sk
and ss_sold_date_sk = d_date_sk
and ss_store_sk = s_store_sk
- and d_month_seq in (1212, 1212 + 1, 1212 + 2, 1212 + 3, 1212 + 4, 1212 + 5, 1212 + 6, 1212 + 7, 1212 + 8, 1212 + 9, 1212 + 10, 1212 + 11)
+ and d_month_seq in (1200, 1200 + 1, 1200 + 2, 1200 + 3, 1200 + 4, 1200 + 5, 1200 + 6, 1200 + 7, 1200 + 8, 1200 + 9, 1200 + 10, 1200 + 11)
and ((i_category in ('Books', 'Children', 'Electronics')
and i_class in ('personal', 'portable', 'reference', 'self-help')
and i_brand in ('scholaramalgamalg #14', 'scholaramalgamalg #7', 'exportiunivamalg #9', 'scholaramalgamalg #9'))
or (i_category in ('Women', 'Music', 'Men')
and i_class in ('accessories', 'classical', 'fragrances', 'pants')
and i_brand in ('amalgimporto #1', 'edu packscholar #1', 'exportiimporto #1', 'importoamalg #1')))
- and ss_sold_date_sk between 2451911 and 2452275 -- partition key filter
group by
i_manufact_id,
d_qoy
) tmp1
--- where
--- case when avg_quarterly_sales > 0 then abs (sum_sales - avg_quarterly_sales) / avg_quarterly_sales else null end > 0.1
+where
+ case when avg_quarterly_sales > 0 then abs (sum_sales - avg_quarterly_sales) / avg_quarterly_sales else null end > 0.1
order by
- -- avg_quarterly_sales,
+ avg_quarterly_sales,
sum_sales,
i_manufact_id
limit 100
---- RESULTS
-612,2.27
-315,2.79
-887,4.72
-315,21.91
-612,25.35
-195,50.08
-887,68.61
-612,71.67
-612,81.19
-315,83.14
-195,92.64
-887,136.13
-315,201.00
+30,165.67,340.63
+30,247.07,340.63
+30,627.63,340.63
+619,158.76,348.64
+619,210.81,348.64
+619,464.26,348.64
+619,560.73,348.64
+271,79.26,354.33
+271,86.87,354.33
+271,179.61,354.33
+271,1071.58,354.33
+827,82.44,356.59
+827,666.52,356.59
+296,188.61,369.12
+296,265.76,369.12
+296,655.24,369.12
+308,200.28,385.98
+308,214.07,385.98
+308,489.17,385.98
+308,640.41,385.98
+486,178.80,400.53
+486,455.08,400.53
+486,468.01,400.53
+486,500.23,400.53
+554,191.48,407.97
+554,346.80,407.97
+554,660.97,407.97
+208,151.84,410.38
+208,207.02,410.38
+208,533.75,410.38
+208,748.93,410.38
+662,199.83,412.13
+662,300.61,412.13
+662,460.94,412.13
+662,687.16,412.13
+394,264.65,413.40
+394,272.02,413.40
+394,674.12,413.40
+221,183.63,416.08
+221,534.62,416.08
+221,552.44,416.08
+621,232.20,418.11
+621,624.80,418.11
+507,76.98,419.46
+507,505.36,419.46
+507,644.24,419.46
+316,36.25,423.03
+316,158.85,423.03
+316,697.32,423.03
+316,799.72,423.03
+56,110.81,423.09
+56,371.77,423.09
+56,500.77,423.09
+56,709.04,423.09
+517,194.87,426.28
+517,313.41,426.28
+517,482.41,426.28
+517,714.46,426.28
+411,364.09,426.89
+411,519.60,426.89
+247,313.42,427.68
+247,353.08,427.68
+247,628.37,427.68
+652,228.75,434.75
+652,314.98,434.75
+652,365.90,434.75
+652,829.38,434.75
+129,301.69,436.45
+129,325.26,436.45
+129,550.47,436.45
+129,568.39,436.45
+99,164.24,438.66
+99,183.75,438.66
+99,1013.10,438.66
+235,111.64,441.03
+235,179.51,441.03
+235,493.83,441.03
+235,979.14,441.03
+360,143.83,445.41
+360,293.99,445.41
+360,928.51,445.41
+732,106.56,447.06
+732,300.77,447.06
+732,498.49,447.06
+732,882.44,447.06
+190,202.77,451.98
+190,233.10,451.98
+190,358.97,451.98
+190,1013.09,451.98
+147,212.53,455.89
+147,366.10,455.89
+147,553.92,455.89
+147,691.02,455.89
+665,283.25,456.08
+665,357.22,456.08
+665,691.20,456.08
+85,325.28,456.28
+85,350.10,456.28
+85,387.62,456.28
+85,762.12,456.28
---- TYPES
-INT, DECIMAL
+INT, DECIMAL, DECIMAL
====
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q55.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q55.test b/testdata/workloads/tpcds/queries/tpcds-q55.test
index 8761c3d..e522ffb 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q55.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q55.test
@@ -11,10 +11,9 @@ from
where
d_date_sk = ss_sold_date_sk
and ss_item_sk = i_item_sk
- and i_manager_id = 36
+ and i_manager_id = 28
and d_moy = 12
- and d_year = 2001
- and ss_sold_date_sk between 2452245 and 2452275 -- partition key filter
+ and d_year = 1999
group by
i_brand,
i_brand_id
@@ -23,42 +22,106 @@ order by
i_brand_id
limit 100;
---- RESULTS
-5004002,'edu packscholar #2',8314.04
-8008010,'namelessnameless #10',7463.64
-2003001,'edu packimporto #2',6744.03
-6015006,'scholarbrand #6',6336.98
-7014001,'edu packcorp #4',5898.02
-3003001,'scholarnameless #6',4715.48
-3004001,'exportibrand #4',4593.27
-1001001,'importoamalgamalg #7',3485.91
-3002001,'exportiexporti #2',2922.84
-10007011,'brandunivamalg #11',2794.45
-4003002,'exportiedu pack #2',2630.40
-7014010,'edu packnameless #10',2563.40
-9015011,'importoscholar #2',2391.90
-5002001,'exportischolar #2',2197.92
-2004001,'importoimporto #2',2025.35
-2003001,'maxinameless #6',1924.80
-10002007,'maxiunivamalg #8',1876.50
-9003008,'exportimaxi #8',1457.94
-8013002,'exportimaxi #2',1390.74
-2004002,'edu packimporto #2',1234.62
-4004002,'edu packedu pack #2',1060.28
-4001002,'amalgedu pack #2',951.00
-3003002,'exportiexporti #2',910.16
-6001002,'amalgcorp #2',834.08
-6016001,'importoamalg #2',823.00
-2002002,'importoimporto #2',754.92
-9006004,'corpmaxi #4',627.66
-3004002,'edu packexporti #2',505.26
-1004001,'edu packamalg #2',490.20
-10004013,'edu packunivamalg #13',467.10
-10006004,'importonameless #10',279.11
-2003002,'exportiimporto #2',250.24
-7004002,'edu packbrand #2',210.50
-8015007,'exportiamalg #2',163.05
-10011016,'amalgamalgamalg #16',10.85
-5001002,'amalgscholar #2',8.82
+1001001,'amalgamalg #1',136722.83
+2001001,'amalgimporto #1',133391.08
+5001001,'amalgscholar #1',118347.84
+5003001,'exportischolar #1',109595.01
+1002001,'importoamalg #1',105226.72
+5003002,'exportischolar #2',95810.25
+5004001,'edu packscholar #1',90624.90
+4001001,'amalgedu pack #1',83730.42
+1001002,'amalgamalg #2',81937.80
+4001002,'amalgedu pack #2',78799.33
+2002001,'importoimporto #1',77701.54
+3003001,'exportiexporti #1',66809.69
+4002001,'importoedu pack #1',65056.38
+5001002,'amalgscholar #2',63100.23
+4003001,'exportiedu pack #1',61067.16
+3001001,'amalgexporti #1',58157.56
+5002001,'importoscholar #1',57895.73
+2003001,'exportiimporto #1',54996.70
+4004002,'edu packedu pack #2',54650.86
+6016005,'corpbrand #5',50955.77
+1004001,'edu packamalg #1',50844.36
+6002001,'importocorp #1',48122.46
+7015003,'scholarnameless #3',47531.49
+1004002,'edu packamalg #2',46925.04
+6006006,'corpcorp #6',44504.94
+3002001,'importoexporti #1',44449.84
+5002002,'importoscholar #2',43736.13
+9004008,'edu packmaxi #8',43124.13
+6011006,'amalgbrand #6',42516.13
+9016003,'corpunivamalg #3',41651.94
+8009007,'maxinameless #7',40216.48
+9008008,'namelessmaxi #8',37294.08
+10012012,'importoamalgamalg #12',36166.35
+2004001,'edu packimporto #1',36056.65
+10003013,'exportiunivamalg #13',32619.62
+1003001,'exportiamalg #1',28084.23
+8010006,'univmaxi #6',27531.46
+8006005,'corpnameless #5',26468.77
+2004002,'edu packimporto #2',26438.94
+6014007,'edu packbrand #7',25884.76
+6005001,'scholarcorp #1',25849.68
+9005002,'scholarmaxi #2',25116.15
+9011003,'amalgunivamalg #3',25085.52
+10006017,'corpunivamalg #17',25085.08
+6009008,'maxicorp #8',24934.96
+7011009,'amalgnameless #9',24823.19
+9011009,'amalgunivamalg #9',24802.03
+8013007,'exportimaxi #7',24582.70
+8012005,'importomaxi #5',24370.92
+6003006,'exporticorp #6',23710.13
+3004001,'edu packexporti #1',23358.51
+1003002,'exportiamalg #2',23154.78
+7002004,'importobrand #4',23003.13
+9005011,'scholarmaxi #11',22313.86
+9013009,'exportiunivamalg #9',22303.83
+9003003,'exportimaxi #3',21736.62
+2001002,'amalgimporto #2',21466.13
+6011001,'amalgbrand #1',21162.91
+6008008,'namelesscorp #8',20636.40
+9016009,'corpunivamalg #9',20465.89
+10013009,'exportiamalgamalg #9',19610.85
+10009006,'maxiunivamalg #6',19564.84
+4002002,'importoedu pack #2',19399.39
+3002002,'importoexporti #2',19272.70
+6002002,'importocorp #2',19147.26
+3001002,'amalgexporti #2',19008.57
+6014001,'edu packbrand #1',18807.55
+8002010,'importonameless #10',18591.58
+7003005,'exportibrand #5',18527.36
+2003002,'exportiimporto #2',18318.61
+6005003,'scholarcorp #3',18167.51
+8009003,'maxinameless #3',17115.53
+8001003,'amalgnameless #3',17068.61
+7015007,'scholarnameless #7',16069.97
+9011008,'amalgunivamalg #8',15861.18
+8011009,'amalgmaxi #9',15785.74
+6014008,'edu packbrand #8',15668.28
+10016003,'corpamalgamalg #3',15322.94
+6015003,'scholarbrand #3',14890.37
+8005010,'scholarnameless #10',14620.95
+8004009,'edu packnameless #9',14529.33
+10004001,'edu packunivamalg #1',14101.90
+8006008,'corpnameless #8',13159.42
+10015001,'scholaramalgamalg #1',13119.59
+9015009,'scholarunivamalg #9',12679.95
+7006010,'corpbrand #10',11490.56
+10005001,'scholarunivamalg #1',11299.62
+6015001,'scholarbrand #1',11242.40
+6013007,'exportibrand #7',11162.36
+6006002,'corpcorp #2',10986.40
+10015011,'scholaramalgamalg #11',10980.10
+8004003,'edu packnameless #3',10945.08
+6001005,'amalgcorp #5',10108.20
+10014016,'edu packamalgamalg #16',9656.21
+6008001,'namelesscorp #1',9546.46
+6009003,'maxicorp #3',8425.25
+10011013,'amalgamalgamalg #13',7914.33
+7009005,'maxibrand #5',7859.23
+10006001,'corpunivamalg #1',6901.74
+9009002,'maximaxi #2',4025.61
---- TYPES
INT, STRING, DECIMAL
====
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q59.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q59.test b/testdata/workloads/tpcds/queries/tpcds-q59.test
index df123e1..5f51f01 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q59.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q59.test
@@ -51,7 +51,7 @@ from
where
d.d_week_seq = wss.d_week_seq
and ss_store_sk = s_store_sk
- and d_month_seq between 1185 and 1185 + 11
+ and d_month_seq between 1212 and 1212 + 11
) y,
(select
s_store_name s_store_name2,
@@ -71,7 +71,7 @@ from
where
d.d_week_seq = wss.d_week_seq
and ss_store_sk = s_store_sk
- and d_month_seq between 1185 + 12 and 1185 + 23
+ and d_month_seq between 1212 + 12 and 1212 + 23
) x
where
s_store_id1 = s_store_id2
@@ -82,106 +82,106 @@ order by
d_week_seq1
limit 100;
---- RESULTS
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5153,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5155,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
-'able','AAAAAAAACAAAAAAA',5157,NULL,NULL,NULL,NULL,NULL,NULL,NULL
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5271,1.36,3.08,0.32,0.48,1.14,0.75,1.84
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5272,1.09,0.75,0.68,0.98,1.00,1.33,0.99
+'able','AAAAAAAACAAAAAAA',5273,1.19,1.02,0.47,0.63,0.70,1.49,0.57
+'able','AAAAAAAACAAAAAAA',5273,1.19,1.02,0.47,0.63,0.70,1.49,0.57
---- TYPES
STRING, STRING, INT, DECIMAL, DECIMAL, DECIMAL, DECIMAL, DECIMAL, DECIMAL, DECIMAL
====
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q6.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q6.test b/testdata/workloads/tpcds/queries/tpcds-q6.test
index 63861c2..2df8994 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q6.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q6.test
@@ -1,48 +1,75 @@
====
---- QUERY: TPCDS-Q6
-select * from (
- select a.ca_state state, count(*) cnt
- from customer_address a
- ,customer c
- ,store_sales s
- ,date_dim d
- ,item i
- where
- a.ca_address_sk = c.c_current_addr_sk
- and c.c_customer_sk = s.ss_customer_sk
- and s.ss_sold_date_sk = d.d_date_sk
- and s.ss_item_sk = i.i_item_sk
- and d.d_month_seq =
- (select distinct (d_month_seq)
- from date_dim
- where d_year = 1999
- and d_moy = 1
- limit 1)
- and i.i_current_price > 1.2 *
- (select avg(j.i_current_price)
- from item j
- where j.i_category = i.i_category)
- group by a.ca_state
- having count(*) >= 10
- order by cnt limit 100) as t
+select a.ca_state state, count(*) cnt
+from customer_address a,
+ customer c,
+ store_sales s,
+ date_dim d,
+ item i
+where a.ca_address_sk = c.c_current_addr_sk
+ and c.c_customer_sk = s.ss_customer_sk
+ and s.ss_sold_date_sk = d.d_date_sk
+ and s.ss_item_sk = i.i_item_sk
+ and d.d_month_seq =
+ (select distinct (d_month_seq)
+ from date_dim
+ where d_year = 2001
+ and d_moy = 1
+ limit 1)
+ and i.i_current_price > 1.2 *
+ (select avg(j.i_current_price)
+ from item j
+ where j.i_category = i.i_category)
+group by a.ca_state
+having count(*) >= 10
+order by 2,1
+limit 100
---- RESULTS: VERIFY_IS_EQUAL_SORTED
-'OK',10
-'IL',10
-'NY',11
-'',11
-'FL',12
-'IA',13
-'TN',13
-'NE',13
-'KS',15
-'MO',15
-'CO',15
-'NC',18
-'LA',18
-'OH',22
-'VA',22
-'TX',24
-'GA',32
+'VT',14
+'ME',16
+'NJ',18
+'MD',19
+'AK',21
+'NH',21
+'MA',24
+'NV',26
+'OR',27
+'ND',28
+'UT',31
+'SD',35
+'ID',36
+'NM',36
+'WV',45
+'WA',46
+'SC',47
+'CO',48
+'AL',49
+'FL',49
+'LA',49
+'NY',52
+'WI',53
+'MT',55
+'PA',56
+'OK',57
+'CA',60
+'MS',69
+'NULL',73
+'AR',73
+'TN',74
+'IN',76
+'KS',80
+'MN',81
+'MI',83
+'MO',83
+'NE',87
+'IA',96
+'OH',102
+'KY',103
+'IL',106
+'NC',107
+'VA',137
+'GA',153
+'TX',228
---- TYPES
STRING, BIGINT
====
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q61.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q61.test b/testdata/workloads/tpcds/queries/tpcds-q61.test
index 0a54b99..4ab922c 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q61.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q61.test
@@ -17,11 +17,11 @@ from
and ca_address_sk = c_current_addr_sk
and ss_item_sk = i_item_sk
and ca_gmt_offset = -5
- and i_category = 'Books'
+ and i_category = 'Jewelry'
and (p_channel_dmail = 'Y' or p_channel_email = 'Y' or p_channel_tv = 'Y')
and s_gmt_offset = -5
- and d_year = 2000
- and d_moy = 11) promotional_sales,
+ and d_year = 1998
+ and d_moy = 1) promotional_sales,
(select sum(ss_ext_sales_price) total
from store_sales
,store
@@ -35,13 +35,13 @@ from
and ca_address_sk = c_current_addr_sk
and ss_item_sk = i_item_sk
and ca_gmt_offset = -5
- and i_category = 'Books'
+ and i_category = 'Jewelry'
and s_gmt_offset = -5
- and d_year = 2000
- and d_moy = 11) all_sales
+ and d_year = 1998
+ and d_moy = 1) all_sales
order by promotions, total
---- RESULTS
-141055.32,285703.76,49.37118083430193568300
+969445.96,1772143.56,54.70470800909605765700
---- TYPES
DECIMAL, DECIMAL, DECIMAL
====
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q63.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q63.test b/testdata/workloads/tpcds/queries/tpcds-q63.test
index f8bcebf..a01e6a1 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q63.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q63.test
@@ -16,14 +16,13 @@ from
ss_item_sk = i_item_sk
and ss_sold_date_sk = d_date_sk
and ss_store_sk = s_store_sk
- and d_month_seq in (1212, 1212 + 1, 1212 + 2, 1212 + 3, 1212 + 4, 1212 + 5, 1212 + 6, 1212 + 7, 1212 + 8, 1212 + 9, 1212 + 10, 1212 + 11)
+ and d_month_seq in (1200, 1200 + 1, 1200 + 2, 1200 + 3, 1200 + 4, 1200 + 5, 1200 + 6, 1200 + 7, 1200 + 8, 1200 + 9, 1200 + 10, 1200 + 11)
and ((i_category in ('Books', 'Children', 'Electronics')
and i_class in ('personal', 'portable', 'refernece', 'self-help')
and i_brand in ('scholaramalgamalg #14', 'scholaramalgamalg #7', 'exportiunivamalg #9', 'scholaramalgamalg #9'))
or (i_category in ('Women', 'Music', 'Men')
and i_class in ('accessories', 'classical', 'fragrances', 'pants')
and i_brand in ('amalgimporto #1', 'edu packscholar #1', 'exportiimporto #1', 'importoamalg #1')))
- and ss_sold_date_sk between 2451911 and 2452275 -- partition key filter
group by
i_manager_id,
d_moy
@@ -36,19 +35,106 @@ order by
sum_sales
limit 100;
---- RESULTS
-10,50.08,71.36
-10,92.64,71.36
-13,1.75,52.36
-13,4.72,52.36
-13,66.86,52.36
-13,136.13,52.36
-29,2.27,45.12
-29,25.35,45.12
-29,71.67,45.12
-29,81.19,45.12
-34,2.79,77.21
-34,21.91,77.21
-34,201.00,77.21
+1,189.04,531.91
+1,203.73,531.91
+1,355.17,531.91
+1,359.53,531.91
+1,365.84,531.91
+1,373.26,531.91
+1,430.03,531.91
+1,698.60,531.91
+1,909.18,531.91
+1,995.02,531.91
+1,998.95,531.91
+2,34.79,625.03
+2,143.64,625.03
+2,253.85,625.03
+2,359.05,625.03
+2,445.59,625.03
+2,499.99,625.03
+2,538.36,625.03
+2,780.07,625.03
+2,1487.82,625.03
+2,1660.48,625.03
+3,270.10,988.29
+3,367.94,988.29
+3,491.20,988.29
+3,529.42,988.29
+3,629.34,988.29
+3,757.70,988.29
+3,1161.47,988.29
+3,1234.30,988.29
+3,1251.01,988.29
+3,1522.49,988.29
+3,2624.04,988.29
+5,353.24,1169.48
+5,581.28,1169.48
+5,694.79,1169.48
+5,696.66,1169.48
+5,740.99,1169.48
+5,890.86,1169.48
+5,955.61,1169.48
+5,1359.61,1169.48
+5,1712.35,1169.48
+5,1794.66,1169.48
+5,2080.16,1169.48
+5,2173.58,1169.48
+6,644.61,1772.99
+6,851.23,1772.99
+6,868.62,1772.99
+6,1056.06,1772.99
+6,1150.40,1772.99
+6,1196.50,1772.99
+6,1551.15,1772.99
+6,2576.64,1772.99
+6,2875.54,1772.99
+6,3299.70,1772.99
+6,3309.13,1772.99
+7,638.30,1499.65
+7,663.54,1499.65
+7,779.65,1499.65
+7,800.25,1499.65
+7,811.54,1499.65
+7,987.78,1499.65
+7,1046.24,1499.65
+7,1667.92,1499.65
+7,2750.32,1499.65
+7,2970.80,1499.65
+7,3524.00,1499.65
+8,803.53,1618.95
+8,819.18,1618.95
+8,933.76,1618.95
+8,944.19,1618.95
+8,1019.24,1618.95
+8,1159.06,1618.95
+8,1290.94,1618.95
+8,2168.17,1618.95
+8,2264.18,1618.95
+8,3033.41,1618.95
+8,3213.77,1618.95
+9,315.31,1509.97
+9,559.82,1509.97
+9,728.72,1509.97
+9,784.15,1509.97
+9,923.36,1509.97
+9,933.68,1509.97
+9,1239.49,1509.97
+9,1848.85,1509.97
+9,2172.04,1509.97
+9,2178.07,1509.97
+9,3165.98,1509.97
+9,3270.26,1509.97
+10,314.30,1125.25
+10,365.57,1125.25
+10,591.30,1125.25
+10,760.81,1125.25
+10,776.91,1125.25
+10,959.65,1125.25
+10,975.25,1125.25
+10,1294.20,1125.25
+10,1342.05,1125.25
+10,1914.64,1125.25
+10,3105.53,1125.25
---- TYPES
INT, DECIMAL, DECIMAL
====
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/f1558957/testdata/workloads/tpcds/queries/tpcds-q65.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/tpcds/queries/tpcds-q65.test b/testdata/workloads/tpcds/queries/tpcds-q65.test
index 2faae4b..0fecab5 100644
--- a/testdata/workloads/tpcds/queries/tpcds-q65.test
+++ b/testdata/workloads/tpcds/queries/tpcds-q65.test
@@ -23,8 +23,7 @@ from
date_dim
where
ss_sold_date_sk = d_date_sk
- and d_month_seq between 1212 and 1212 + 11
- and ss_sold_date_sk between 2451911 and 2452275 -- partition key filter
+ and d_month_seq between 1176 and 1176 + 11
group by
ss_store_sk,
ss_item_sk
@@ -41,8 +40,7 @@ from
date_dim
where
ss_sold_date_sk = d_date_sk
- and d_month_seq between 1212 and 1212 + 11
- and ss_sold_date_sk between 2451911 and 2452275 -- partition key filter
+ and d_month_seq between 1176 and 1176 + 11
group by
ss_store_sk,
ss_item_sk
@@ -57,106 +55,106 @@ order by
i_item_desc
limit 100;
---- RESULTS
-'able','',2.98,6.51,16.20,'amalgedu pack #2'
-'able','A l',0.66,0.14,0.92,'importocorp #8'
-'able','Able, alternative police shall not give so other complaints. There complex ',0.64,1.31,5.86,'edu packimporto #2'
-'able','Able, full elections see then for instance real categories. Constitutional trades would go around merchants. Once appointed individuals shall take',4.91,2.12,1.25,'amalgscholar #2'
-'able','About existing results ensure as foreign so',4.28,15.86,8.08,'amalgnameless #6'
-'able','Abruptly social trains would inject environmental, good visitors. Red streets put primary groups. Very social years ask often old, final schools. Here slight',1.52,4.56,4.14,'namelessunivamalg #5'
-'able','Activities want with the walls. Faint, main minutes stand as activiti',1.09,4.37,0.42,'exportiamalgamalg #6'
-'able','Actual, open conditions accept developing, similar parameters; cultural yards cannot call. Similar, deaf issues should not cross without the times. Members help both other books. L',4.17,6.96,5.84,'namelessmaxi #4'
-'able','Adults reply hence outside weak lives. Chief beliefs put hence open police. Concrete, private conservatives result in a securities. Suddenly dear findings can stop completely during ',3.39,7.13,4.42,'importoimporto #2'
-'able','African lives must n',3.76,0.88,0.37,'amalgunivamalg #8'
-'able','Alike dark benefits solve individuals. Occasional, famous services succeed possible, overall trials. Relatively young successes shall not',4.82,0.37,0.28,'namelesscorp #2'
-'able','All international functions can improve. Visitors take possible companies. Important eyes shall not follow at a sports. Glad p',4.95,4.31,3.74,'amalgedu pack #2'
-'able','Almost comprehensive cases know unfortunately hard courses; there determined rules shall make even hard, close years. Existing, red sentences name. Experts help slowly players. ',1.87,49.79,37.86,'amalgimporto #2'
-'able','Almost senior numbers must pay sure, human taxes. Ideas use; flexi',1.28,3.29,2.36,'corpbrand #2'
-'able','Alone, common residents would not fire. Urban, obvious police shall walk nowadays. Mediterranean, red scenes detect quickly de',0.94,1.90,0.39,'importoedu pack #2'
-'able','Also appropriate courts let long critical conditions; enough current ',3.87,3.99,0.18,'brandnameless #8'
-'able','Also constant programmes used to take only; white governments gain full years; afraid, special contacts could not read suddenly. Then victorian officials must not underline more in the is',1.83,6.08,4.94,'exportiexporti #2'
-'able','Also evolutionary weeks might realise profitable churches. Characteristics ought to go nevertheless. Ins',4.01,7.67,5.44,'exportiamalg #2'
-'able','Also f',0.10,3.46,2.49,'brandcorp #6'
-'able','Also particular days sense photographs. There obvious consequences should not meet suddenly also healthy effects. Long important interests c',1.61,4.21,1.72,'importomaxi #2'
-'able','Also political forms find high periodically heavy waters; issues would remain in the germans. Reduced others help. Years might change single, royal years. Tin',1.62,1.91,0.95,'edu packedu pack #2'
-'able','Also unlikely activities go on the pressures. Very short sales like by the holidays. Good museums come common, great advantages. Tools increase all. Universal clothes must borrow ',2.75,8.36,5.85,'amalgnameless #2'
-'able','Always big grounds deter with a boats. So rough benefits should not happen elsewhere others. Actual surveys kno',1.85,1.08,0.35,'importoscholar #2'
-'able','Always determined parties go here early pounds. Now scientific patients give a little into a options. Different boxes end; in particular brown days come no doubt acros',4.62,2.73,1.69,'importoexporti #2'
-'able','Always industrial systems should not believe of course hard fingers. Either overall drawings appear increa',1.29,4.44,1.82,'amalgscholar #2'
-'able','American, interested arts hide. No doubt human time',2.40,1.67,0.73,'edu packscholar #2'
-'able','Ancient ideas prevent estates. Sides see as inner cars. Local advertisements meet little f',3.81,6.49,5.58,'scholarnameless #6'
-'able','Angrily good children matter again domestic, main memories. Less following approaches could mean great, labour numbers. Basic, unnecessary habits co',1.94,2.01,1.58,'edu packimporto #2'
-'able','Annual forests meet. Even small instances occur feet. Different qualities replace. Main, new hands determine however for a ideas. Physical sides worry as',2.60,7.41,3.48,'amalgamalg #2'
-'able','Anxious, new patien',0.64,0.11,0.05,'amalgamalg #2'
-'able','Anywhere proper men will not run remarkable, revolutionary libraries. Poor rates used to hear also. Huge years see structural churches.',2.96,8.73,4.62,'maxinameless #2'
-'able','Apparent, beneficial years should pay hard arrangements. Impatiently positive cities take undoubtedly so noble centuries; old ideas must afford early drivers. Li',1.33,2.47,1.40,'univbrand #4'
-'able','Appointed, literary reader',0.00,3.48,1.89,'amalgimporto #2'
-'able','Appropriate, live acts will not administer earlier ready criticisms. Old taxes ought to go resulting, empty institutions; perhaps simpl',0.35,1.74,25.97,'exportischolar #2'
-'able','Appropriate, prime hours tell. Terms could take. Much new workers settle important, british players. Comprehensive tonnes will eat nearby. Due dec',3.92,2.04,0.79,'importonameless #8'
-'able','Areas determine shares; physical books may li',2.25,2.21,0.34,'importocorp #6'
-'able','Areas may happen more. Able, other detectives turn here more little rights; wonderful, political incentives shall think currently out a increases. Services despise more politicians. New orga',4.33,83.27,1.78,'edu packscholar #2'
-'able','Artists solve never good thanks. Completely medieval homes enhance real goods. Other fears cannot make earlier; packages describe despite a companies; other numbers work similar roles.',1.77,9.15,4.66,'corpmaxi #10'
-'able','As alone cultures may not use also; there sophisticated reasons would pay only, similar races. Different audiences gain never among a issues. Indeed small walls can take a',4.10,1.15,2.85,'importoamalgamalg #4'
-'able','As generous germans mean almost eastern variables. Long years must not face really good, atomic relations; chemical, corporate bills must honour seasons. Artificial, gold materials determine',4.38,4.51,2.07,'corpmaxi #8'
-'able','Assistant, original manufacturers exploit roughly little years. Of course sure models may not integrate particularly. Institutions ought to look in particular month',1.41,3.71,4.20,'namelessunivamalg #13'
-'able','Available, particular seats should question in response to a police. Discussions may visit stand',0.82,90.01,70.20,'importoscholar #2'
-'able','Away clinical communications give angry areas. Difficult commitme',0.25,4.01,2.28,'importoimporto #2'
-'able','Awkward, poor points cannot weigh plants. Single, reasonable players may not go around scottish products. Then presidential years suffer clubs. Problems would attrac',0.39,2.84,2.32,'importoimporto #2'
-'able','Awkward, typical places must not check only workers; bright parties restore studies. Men show about finally interested programmes; certainly economic soldiers meet there ',2.49,1.72,1.51,'amalgedu pack #2'
-'able','Backs stop very prices. Very available years withstand often eyebrows. Syste',2.78,2.83,2.17,'amalgamalg #2'
-'able','Badly black animals must not get creative, national changes. Eastern adults claim at la',0.74,8.59,2.70,'corpcorp #8'
-'able','Basic workers put recent terms. Evidently important neighbours could not p',0.00,1.14,1.11,'scholarnameless #6'
-'able','Basic, proud seats must pick mo',3.07,7.55,3.17,'importoscholar #2'
-'able','Big, other animals get; tiny, active products shall take most both long facilities. Sexual, high councillors spare particular books. Already cognitive plans shall look in a ',0.20,3.23,2.87,'edu packedu pack #2'
-'able','Big, very claims shall ask well heavily usual governments. Awful police will demand for example. Fundamental men will not check days.',4.48,65.42,1.73,'importoamalgamalg #17'
-'able','Black controls ride. Civil, precious lips may not supervise t',0.00,1.16,3.43,'edu packamalg #2'
-'able','Both objective skills try deep, exceptional members. Engines know so hard implications. Vital, excessive sites may leave ',4.73,8.10,0.93,'edu packexporti #2'
-'able','Boys can excuse at first responsible, powerful product',1.80,18.04,3.49,'maximaxi #12'
-'able','Boys give girls. References leave also. Competent metres see late rather huge communications. Estates suggest right. Political men must no',0.70,2.20,1.34,'importoexporti #2'
-'able','Boys might not work yet then fast clothes. Simply large elements think in a factors. Royal charges happen at least on a children. Holy prospects think individu',1.73,1.69,7.81,'maxinameless #2'
-'able','Broad writers ought to claim acceptable rooms. Badly unlikely costs take for a',0.00,3.88,0.73,'exportibrand #8'
-'able','Broad, external societies put. Either parental measurements look very future responses. Above local mountains eat. Houses react elsewhere legal guns. Technologies oug',1.87,3.39,0.39,'exportiedu pack #2'
-'able','Brown, united systems take very. Costs shall go almost to a houses. Social feelings ought to expect very. Grey, hot pr',1.48,0.87,0.67,'exportiimporto #2'
-'able','C',0.00,30.93,2.93,'scholarmaxi #4'
-'able','Careful activities shall drop yet personnel. Useful, difficult offices should bear relatively on a positions. Nevertheless',1.23,8.97,3.76,'exportibrand #8'
-'able','Carefully physical hotels must put together; similar details cannot appreciate by a standards. Rates can break m',4.01,93.93,78.90,'exportiunivamalg #10'
-'able','Cats win fiercely urban rises. Most central passages make feelings. Other, rare services know now sometimes signif',2.08,2.08,1.70,'amalgimporto #2'
-'able','Cells must raise away. Rather prominent ships lead; catholic, full heads must not tell especially double, international police; modest years may fetch readily important, final pubs. Softly',4.73,3.48,2.40,'importocorp #4'
-'able','Centuries must envisage already things. Officials take both for a sectors. Exact tears may not restore only rich inches; difficulties could speak physical families',0.73,3.97,2.30,'scholarnameless #10'
-'able','Certa',4.45,4.49,4.60,'exportinameless #4'
-'able','Children could see again ahead of the patients. Nice terms ought to get high materials. Odd others would enable at a others. Together common subjects shall not interrupt other, brig',2.27,4.90,2.94,'scholaramalgamalg #9'
-'able','Children need also positive, british costs. Easy days cannot need. Obviously ',2.35,0.17,0.10,'edu packscholar #2'
-'able','Children used to mean contracts. Difficult runs spot here. Aspects ought to take unfortunately prepared women. Groups believe very public patients. Low terms must stop as different, political cou',4.05,4.94,3.75,'importobrand #10'
-'able','Classical goods involve long, blank interpretations. Committees cause immensely trials. Passive ways can demonstrate mainly very clean years. Vast, other agreements prove good expensive, hard ',2.54,4.44,1.33,'edu packamalg #2'
-'able','Classical, disciplinary a',4.34,5.01,3.80,'importounivamalg #15'
-'able','Clear, other proposals m',1.03,8.98,5.47,'exportiunivamalg #12'
-'able','Close firms grow different activities. Broad men may manage wrong, disabled conclusions. Simply fierce men decide. Australian, smooth lists',4.12,5.80,4.35,'importoexporti #2'
-'able','Cold countries may set. Small years become general changes. Rats must acc',4.83,8.76,5.43,'importoscholar #2'
-'able','Coming, difficult times follow fully full, young rules; instances shall not weave alternative studies. Bottom, new goods show at least studies. Girls must suppose to a children; only able women shoul',3.60,3.72,2.97,'exportiimporto #2'
-'able','Commercial tickets include before other waves. Very',1.52,1.24,1.06,'brandunivamalg #8'
-'able','Common activities raise years. Loose, political problems discuss down the fingers. Essential countries take however beautiful, huge models; good, perfect offices cannot describe even super num',3.35,5.06,2.68,'edu packscholar #2'
-'able','Communications grab as. Never new minutes release unfair occ',1.57,1.09,5.89,'amalgmaxi #10'
-'able','Companies could not make popular, strong paren',3.07,72.68,58.87,'amalgexporti #2'
-'able','Comparable, fast rates must live for example current, specialist scores. Girls may not figure heavy products. Following items l',0.74,2.44,1.65,'exportiunivamalg #2'
-'able','Competent women must work substantially in a months. Standard, united police will hide at a women. Specialist activities create directly. About beautiful terms can tell at first incidents. More i',0.79,2.96,4.21,'amalgunivamalg #17'
-'able','Complete, relative breasts know considerably; sure, medical pupils can cross for a races.',1.84,1.36,0.62,'importoamalg #2'
-'able','Complete, strange measurements attempt also strange expectations. Abroad substantial levels give new, soviet costs; a little ',3.16,66.22,1.32,'scholarnameless #8'
-'able','Conditions m',1.68,9.27,7.41,'amalgunivamalg #16'
-'able','Considerable, required developments might resign quite to the services. Alternative, public practitio',4.43,6.94,5.34,'amalgscholar #2'
-'able','Correct, certain humans cut',1.70,37.98,34.18,'amalgmaxi #8'
-'able','Costs will write certainly years. Clothes expo',0.40,8.25,7.09,'exportiexporti #2'
-'able','Countrie',1.86,8.17,28.40,'importobrand #4'
-'able','Cultural, excellent years shall not ame',1.07,0.68,0.60,'amalgnameless #2'
-'able','Current feelings c',4.16,1.37,0.61,'exportiimporto #2'
-'able','Current, certain clubs supply white, old proceedings. Safe brothers must not imagine especially.',1.36,9.86,8.47,'importoexporti #2'
-'able','Daily packages shall suffer reportedly numbers. Committees begin environmental groups. Different others blame needs; other',4.33,35.79,28.98,'edu packedu pack #2'
-'able','Deeply special ho',2.27,1.54,0.70,'edu packnameless #8'
-'able','Democratic hours initiate often; meanwhile prime years might move also dreadful, other cl',1.53,1.13,0.45,'scholarnameless #2'
-'able','Departments could make also there personal customers; possible, unhappy statements construct. Running, comprehensive volumes leave therefore equally financial strangers. Public, english ',1.48,NULL,NULL,''
-'able','Descriptions ought to defeat as prepared applicants. ',0.00,1.69,0.99,'corpbrand #6'
-'able','Desperately general missiles ought to know here other far talks. New times could exercise too young months. Unpleasant, likely countries explain.',1.47,4.74,2.82,'exportiunivamalg #8'
-'able','Details train able citizens. Then white pp. will use though other shelves; children feel no longer proposed, red policies; monthly, redundant pr',1.41,5.35,2.62,'exportiunivamalg #10'
-'able','Detectives must not assess international prisoners. Accidents amount further actions. Organis',1.14,2.18,1.67,'amalgexporti #2'
-'able','Developments produce joint, little points. So palestinian children research finally more agricultural estates. Appropriate miles may cost ministers; dirty terms mig',2.15,6.72,5.44,'importoimporto #2'
+'able','Commercial, popular processes give later now wooden facts. Black, outer purposes examine national, precise heels. Invisible times s',36.06,5.25,1.68,'amalgedu pack #1'
+'able','Conventional, responsible products discuss delicately then actual findings. Extremel',36.42,3.67,2.82,'namelessnameless #5'
+'able','Difficulties wou',25.25,6.61,2.31,'importobrand #7'
+'able','Efforts might come ever. Even agricultural operations live plus a members. Arts may ring too carefully numerous windows. In particular new ch',22.13,1.49,0.95,'edu packamalg #2'
+'able','Even chief games can present privately extra whole steps. Over old reasons ought to ',21.58,4.30,1.41,'namelesscorp #3'
+'able','Initial, important ministers used to rely. Young, difficult glasses cannot say european, religious organisations; worried minutes protect action',11.03,4.95,3.06,'scholarnameless #7'
+'able','Once olympic sorts could control governments. Final sections mig',21.77,7.76,4.42,'edu packscholar #1'
+'able','Small others will provide probably complete countries. Only effective pensions violate on board maybe left animals. Old r',26.38,2.55,1.60,'maxiunivamalg #2'
+'able','Somehow revolutionary sh',31.09,7.10,3.05,'amalgunivamalg #3'
+'able','Stupid years should not modify loose. Special, sure developments may',7.84,5.81,4.47,'maxicorp #5'
+'able','Swiss, capable lovers handle at least present details. Over here uncomfortable stations take by a lips. Private organisations can supply in a examinatio',29.73,8.15,3.99,'amalgedu pack #2'
+'able','Toys must not meet again goods. Comfortable, major members last days. Popular, double occupations may compensate researchers. Conditions ',25.02,3.35,2.41,'edu packscholar #1'
+'able','Wrong, good values could not work in a minds. Normal structures correct here later massive boo',21.49,4.17,1.45,'importoedu pack #1'
+'ation','Animals conduct primary, sorry tickets. Bare, labour matters used to buy between a patterns. Light authorities explain rules; future eggs can ',1.57,0.86,0.47,'edu packamalg #1'
+'ation','Average services could try unfortunately plants; extensive procedures must',34.63,4.94,3.26,'scholarunivamalg #2'
+'ation','Direct ways topple inches. Complex years can take also across a words. Stupid, global implications would provide sure things. Russians take much for the spots. Indoors local men w',16.06,7.18,4.88,'exportiedu pack #1'
+'ation','Disciplinary signs could prepare particular, other councils. Live criteria ought to stand extra, basic bones. Local leaders tell now tasks. Most old recordings use ago in the governors; par',36.65,8.96,4.39,'amalgscholar #2'
+'ation','Fair families ought to leave relationships. Separate, firm services would assist delicious, serious laws; a',15.31,7.51,2.70,'importoamalg #1'
+'ation','Gradually general affairs come at a gardens. Members may liv',18.43,28.90,11.27,'edu packamalgamalg #15'
+'ation','Here equivalent expectations should stop since to th',18.23,7.88,5.04,'scholarunivamalg #4'
+'ation','Laws propose policies. Commercial, foreign restaurants could take. District',29.49,84.97,32.28,'amalgnameless #5'
+'ation','New r',36.57,2.10,1.19,'importoimporto #2'
+'ation','Officials calculate in the images. Military, olympic services throw apparently old photographs; exotic, wonderful children benefit',25.41,9.36,3.55,'maxibrand #9'
+'ation','Open blue farmers reach useful, old arrangements. American, short years reach now tender, heavy neighbours. Now top boundaries would not enable emotions. Effectively specific ',28.75,2.34,2.01,'exportinameless #7'
+'ation','Or',23.64,3.00,1.86,'amalgedu pack #1'
+'ation','Pensions used to meet in the words. Very african obligati',27.27,0.54,0.27,'exportiexporti #1'
+'ation','Public, limited pup',34.60,9.38,3.93,'amalgmaxi #9'
+'ation','Small kinds would recognize notably violent, labour years. Electronic days would not',30.96,0.90,0.34,'namelesscorp #3'
+'ation','Social, other resources may know reasonable, distant weeks. New, unexpected rates mean. White, electric generations carry together other t',36.10,3.91,2.54,'maxinameless #10'
+'ation','Trustees grow well thereby national attitudes. Social, excellent bacteria contain permanent gaps. Only dynamic uses ought to halt very long, bright men; japanese, distin',3.96,3.31,2.87,'exporticorp #1'
+'bar','Categories shall',18.32,8.98,7.81,'scholarmaxi #9'
+'bar','Clear, top associations can activate all national factors. Items could think sure skills. Fine, thin classes must not help simply only statutory',28.26,6.27,4.57,'brandbrand #10'
+'bar','Extended, local books calm now likely companies. Sometime rich instances improve spanish countries. Crucial flames take further. Rapidly big proposals may not photograph in the opt',12.64,0.55,0.19,'namelessbrand #5'
+'bar','Hours must carry virtually new seats. Polish, happy affairs might get. Originally warm libraries operate real patients. Then soft scie',35.96,28.04,25.23,'edu packedu pack #1'
+'bar','Individual flowers used to give thanks. Particular doubts refer a bit for a directions. Police could',8.31,1.74,1.21,'exportiimporto #2'
+'bar','Low sorts understand. Vegetables must not carry. There legal rates shake so democratic styles. Convenient, single committees might forget',21.35,7.16,5.79,'amalgedu pack #1'
+'bar','Minutes achieve however for a allies. Areas pay apparently alive officers',32.01,3.28,1.34,'amalgedu pack #2'
+'bar','Moments incur pa',32.92,6.14,1.84,'exportiimporto #1'
+'bar','Of course commercial uses look rapidly historical societies. Writers make just high',31.29,3.82,1.33,'exportischolar #1'
+'bar','Old, valuable',23.07,0.23,0.07,'namelessnameless #9'
+'bar','Other things get now. Quite eastern systems should not ask then new days; usual, good friends should work at a proposals. Highly pr',24.90,0.27,0.09,'edu packnameless #1'
+'bar','Pupils change. Frequently nice rates shall not decide future yards. Over upper girls ought to lower in a developments. Formal',36.24,2.19,1.16,'edu packexporti #1'
+'bar','Really foreign workers overcome asleep, young decades. Drugs may tell children; labour, real wages ev',13.88,4.24,2.96,'scholarmaxi #9'
+'bar','Round managers take processes. Primary, particular courses used to hold sacred cases. C',7.23,4.13,2.84,'edu packscholar #1'
+'bar','Simple guests leave british, skilled terms. Kind, little standards must suspect. Combinations may think like, distinguished inches. Artists beat awfully. Ide',27.08,1.68,0.53,'edu packedu pack #2'
+'bar','So damp tests imagine resources. Innocently prime developments shall work small pl',30.83,0.61,0.33,'scholarnameless #6'
+'bar','So much as close reforms would hide at first measures; alone, important contracts lose linguisti',20.14,2.37,1.37,'exportinameless #1'
+'bar','Strange do',15.41,9.47,4.82,'exportiexporti #1'
+'bar','Wide, technical paren',17.06,6.64,3.98,'exportiexporti #1'
+'bar','Wonderful servants must not resolve once physical lives. Later significant an',27.44,0.33,0.22,'brandbrand #7'
+'bar','Years need much. Good interests use too different, junior services. Young items shall not find. Disastrous hands release fast new, alternative applications. American police make in ',33.95,7.68,4.45,'exportiamalg #1'
+'eing','Birds stay foreign, chronic parts. So young cases shall not conclude buildings. About important months may not look; degrees catch just; other societies may not ge',18.42,4.67,2.33,'amalgscholar #2'
+'eing','Central, other hands will agree especially crucial differences',16.71,4.49,3.00,'exportischolar #2'
+'eing','Even single waters make for instance particular hours. Mental rights may cross as just contemporary m',30.54,0.97,0.82,'importounivamalg #5'
+'eing','Flowers cultivate still so-called, available',10.50,3.84,1.22,'edu packmaxi #8'
+'eing','Good, helpful men close. Please difficult lakes should waste very conservative, labour ',11.84,3.13,0.97,'edu packbrand #8'
+'eing','However modern companies ought to make industria',23.09,9.56,3.25,'brandcorp #1'
+'eing','Important, frequent councils explore general, local ideas. Representatives last more. Foreign, sensible pupils pay. Social, american reservations used to get so much',2.86,0.59,0.25,'amalgbrand #2'
+'eing','Increased, special pound',24.05,2.52,1.20,'importoedu pack #2'
+'eing','Laws go shortly british, clear carers. Inner, available aspirations ought to abolish most armed strings. Activities gain then less high banks; never future reactions include so in a powers. Popular, ',30.53,9.69,7.46,'edu packmaxi #8'
+'eing','Main pupils could expel followers. Sometimes severe horses should keep largely earnings. Years put recently permanent inst',19.15,9.17,6.05,'maxinameless #2'
+'eing','More different attempts replace. Changes look shoes. E',25.75,2.47,1.40,'amalgexporti #1'
+'eing','Nations save further new complaints. Perfect things murder different odds. General firms will like also; fatal grounds lie however working sorts. However internal police should design',23.32,8.09,3.31,'amalgexporti #1'
+'eing','Ordinary orders can inspect. New int',34.66,9.58,3.92,'exportiedu pack #2'
+'eing','Other, eager christians live very others. Young, financ',8.49,8.22,5.01,'edu packscholar #1'
+'eing','Parliamentary guests could not convey real chiefs; integrated, full responsibilities take later then important categories. T',28.83,0.41,0.13,'edu packamalg #1'
+'eing','Physical polls melt as eyes. Clear, special sources might invent at once. As immediate things will not',24.71,3.77,1.80,'edu packamalg #2'
+'eing','Specifically honest pp. would ensure wide for a miles. Different families put then western, certain children. Only exciting commitments say f',10.89,0.51,0.26,'edu packunivamalg #11'
+'eing','Students help factors. Seats take matters; likely sources make ridiculous children. Police might say then just natural characters. A',9.32,1.15,0.62,'exportischolar #1'
+'eing','Tired days used to admit for a customs',29.84,5.94,4.93,'importoamalg #1'
+'eing','Wrong, high terms make relatively holidays. Major, relevant theories consider difficult, new markets. Sure, real subjec',27.35,3.29,1.51,'amalgscholar #2'
+'ese','As sure women fall proposals. Entire, loc',35.61,1.91,1.14,'edu packexporti #1'
+'ese','Backwards royal assets get plans; countries used to swing then. Most strange',28.67,1.84,0.82,'exportiedu pack #1'
+'ese','Civil firms say; prospective technologies used to take there. Easy, high assets enter so practical, structural buildings. Studies woul',26.23,9.09,3.45,'maxiunivamalg #6'
+'ese','Comfortable experiments hit defensive implications. Bad resources would not heal central, national twins. Kind, modern thoughts shall ensure home short',34.17,92.12,71.85,'importoedu pack #1'
+'ese','Companies find financially substances. National, enormous conclusions might object here firms; exactly different jobs should complete; practices encourage really months. Necessary, previous recor',24.08,5.63,3.71,'importoamalgamalg #5'
+'ese','Democrats follow mostly available,',25.69,0.59,0.47,'exportibrand #2'
+'ese','Excellent, real advantages would exist posts. Activities shall continue in a feet. Effects think only confidently local c',25.63,2.41,1.90,'amalgunivamalg #11'
+'ese','Expensive reasons shall not carry hardly ri',19.68,4.59,1.46,'scholarbrand #1'
+'ese','Fresh, industrial vegetables could proceed quite i',29.70,7.16,2.57,'scholarunivamalg #8'
+'ese','Full rules may persuade pregnant cars. Earnings publish worried symptoms. Ready',36.87,5.88,4.99,'amalgimporto #1'
+'ese','Horses last results. There thorough parents sail everywhere into a gua',23.67,3.45,2.55,'scholarnameless #5'
+'ese','Large businessmen might give successful poles; children believe however. Hard, fine companies must not dismiss likely advantages. Now great nations shall not walk to',2.78,3.48,1.07,'brandcorp #6'
+'ese','Modern areas include indeed political children. White, widespread services attend also. Pink boundaries explain early because of a letters. Often assistant men make never pale windows. Then inte',30.08,6.20,4.21,'exportiedu pack #2'
+'ese','Nowhere sure shops ought to constitute by a conditions. Apparent hands shall not fit slightly general men. Oth',26.20,3.59,3.08,'amalgscholar #1'
+'ese','Political, french streets used to introduce just labour ',21.21,1.59,1.38,'edu packunivamalg #9'
+'ese','Publications could not judge; double deputies',35.52,6.30,2.39,'edu packamalg #1'
+'ese','Reasonably direct interests turn. Certainly existing ',12.36,1.86,0.89,'importoscholar #1'
+'ese','Temperatures reflect quite',34.31,0.90,0.45,'scholarnameless #3'
+'ese','Tests will maintain only. Beautifully local banks make still; particular votes protect during a eyes. Contracts must understand primarily. Difficult countries cast in a ',19.06,4.13,2.68,'edu packimporto #1'
+'ese','Totally pure styles would seek charges; values say. Normal, big activi',30.40,1.07,0.84,'maxiunivamalg #5'
+'ese','Years want as a whole. Public eyes shall win against a books. Special minutes intensify stones. Alone, right fingers spring men. Ho',32.52,1.73,0.77,'exportibrand #5'
+'ese','NULL',29.58,NULL,NULL,'exportischolar #1'
+'ought','Active abilities depend smoothly by a ',30.54,2.40,1.44,'importoexporti #1'
+'ought','Additional, terrible characters shall examine. Ago lexical conditions get into a weeks. Barely trying results perform still hot men. Great kinds end also committees. Police should live only on the ',18.54,4.46,1.33,'corpmaxi #11'
+'ought','At last political managers would get new, historic workers. Requirements seem loose shadows; activities carry favorite mothers; likely issues stand aside environmental, current funds; below',6.48,1.08,0.43,'exportiexporti #1'
+'ought','Authorities used to leave exactly other co',15.13,2.14,0.72,'exporticorp #5'
+'ought','Costs receive. British teachers evolve mentally only, new words. Good tickets give ',34.78,0.12,0.06,'edu packexporti #1'
+'ought','European, happy homes shall not share. Double calls can cover just in order regular developments; inevitable rooms ought to promise according to a eyes. Normal attempts grow only, complex goods',12.84,8.03,4.57,'univnameless #7'
+'ought','Full-time clothes discharge glad, concerned details. Customs must survive',10.29,8.52,6.73,'exportiunivamalg #14'
---- TYPES
STRING, STRING, DECIMAL, DECIMAL, DECIMAL, STRING
====
\ No newline at end of file