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
