| ==== |
| ---- QUERY: primitive_many_fragments |
| -- Description : Query with a large number of shuffle joins |
| -- Target test case : Run a query with a large number of fragments |
| -- stressing query startup, connection creation and query teardown |
| select /* +straight_join */ count(*),a.c_nationkey, max(b.c_comment) from customer A join /* +shuffle */ customer B on A.c_custkey = B.c_custkey join /* +shuffle */ customer C on c.c_custkey = B.c_custkey join /* +shuffle */ customer D on d.c_custkey = B.c_custkey join /* +shuffle */ customer E on e.c_custkey = B.c_custkey join /* +shuffle */ customer F on f.c_custkey = B.c_custkey join /* +shuffle */ customer G on g.c_custkey = B.c_custkey join /* +shuffle */ customer H on h.c_custkey = B.c_custkey join /* +shuffle */ customer I on i.c_custkey = B.c_custkey join /* +shuffle */ customer J on j.c_custkey = B.c_custkey join /* +shuffle */ customer K on k.c_custkey = B.c_custkey join /* +shuffle */ customer L on l.c_custkey = B.c_custkey join /* +shuffle */ customer M on m.c_custkey = B.c_custkey join /* +shuffle */ customer N on n.c_custkey = B.c_custkey join /* +shuffle */ customer O on o.c_custkey = B.c_custkey join /* +shuffle */ customer P on p.c_custkey = B.c_custkey join /* +shuffle */ customer R on R.c_custkey = B.c_custkey join /* +shuffle */ customer S on S.c_custkey = B.c_custkey join /* +shuffle */ customer T on T.c_custkey = B.c_custkey join /* +shuffle */ customer U on U.c_custkey = B.c_custkey join /* +shuffle */ customer V on V.c_custkey = B.c_custkey join /* +shuffle */ customer W on W.c_custkey = B.c_custkey join /* +shuffle */ customer X on X.c_custkey = B.c_custkey join /* +shuffle */ customer Y on Y.c_custkey = B.c_custkey join /* +shuffle */ customer Z on Z.c_custkey = B.c_custkey join /* +shuffle */ customer z1 on Z1.c_custkey = B.c_custkey join /* +shuffle */ customer z2 on Z2.c_custkey = B.c_custkey join /* +shuffle */ customer z3 on Z3.c_custkey = B.c_custkey join /* +shuffle */ customer z4 on Z4.c_custkey = B.c_custkey join /* +shuffle */ customer z5 on Z5.c_custkey = B.c_custkey join /* +shuffle */ customer z6 on Z6.c_custkey = B.c_custkey join /* +shuffle */ customer z7 on Z7.c_custkey = B.c_custkey join /* +shuffle */ customer z8 on Z8.c_custkey = B.c_custkey join /* +shuffle */ customer z9 on Z9.c_custkey = B.c_custkey join /* +shuffle */ customer z10 on Z10.c_custkey = B.c_custkey join /* +shuffle */ customer z11 on Z11.c_custkey = B.c_custkey join /* +shuffle */ customer z12 on Z12.c_custkey = B.c_custkey join /* +shuffle */ customer z13 on Z13.c_custkey = B.c_custkey join /* +shuffle */ customer z14 on Z14.c_custkey = B.c_custkey join /* +shuffle */ customer z15 on Z15.c_custkey = B.c_custkey join /* +shuffle */ customer z16 on Z16.c_custkey = B.c_custkey join /* +shuffle */ customer z17 on Z17.c_custkey = B.c_custkey join /* +shuffle */ customer z18 on Z18.c_custkey = B.c_custkey join /* +shuffle */ customer z19 on Z19.c_custkey = B.c_custkey join /* +shuffle */ customer z20 on Z20.c_custkey = B.c_custkey join /* +shuffle */ customer z21 on Z21.c_custkey = B.c_custkey join /* +shuffle */ customer z22 on Z22.c_custkey = B.c_custkey join /* +shuffle */ customer z23 on Z23.c_custkey = B.c_custkey join /* +shuffle */ customer z24 on Z24.c_custkey = B.c_custkey join /* +shuffle */ customer z25 on Z25.c_custkey = B.c_custkey join /* +shuffle */ customer z26 on Z26.c_custkey = B.c_custkey join /* +shuffle */ customer z27 on Z27.c_custkey = B.c_custkey join /* +shuffle */ customer z28 on Z28.c_custkey = B.c_custkey join /* +shuffle */ customer z29 on Z29.c_custkey = B.c_custkey join /* +shuffle */ customer z30 on Z30.c_custkey = B.c_custkey join /* +shuffle */ customer z31 on Z31.c_custkey = B.c_custkey join /* +shuffle */ customer z32 on Z32.c_custkey = B.c_custkey join /* +shuffle */ customer z33 on Z33.c_custkey = B.c_custkey join /* +shuffle */ customer z34 on Z34.c_custkey = B.c_custkey join /* +shuffle */ customer z35 on Z35.c_custkey = B.c_custkey join /* +shuffle */ customer z36 on Z36.c_custkey = B.c_custkey join /* +shuffle */ customer z37 on Z37.c_custkey = B.c_custkey join /* +shuffle */ customer z38 on Z38.c_custkey = B.c_custkey join /* +shuffle */ customer z39 on Z39.c_custkey = B.c_custkey join /* +shuffle */ customer z40 on Z40.c_custkey = B.c_custkey join /* +shuffle */ customer z41 on Z41.c_custkey = B.c_custkey join /* +shuffle */ customer z42 on Z42.c_custkey = B.c_custkey join /* +shuffle */ customer z43 on Z43.c_custkey = B.c_custkey join /* +shuffle */ customer z44 on z44.c_custkey = B.c_custkey join /* +shuffle */ customer z45 on z45.c_custkey = B.c_custkey join /* +shuffle */ customer z46 on z46.c_custkey = B.c_custkey join /* +shuffle */ customer z47 on z47.c_custkey = B.c_custkey join /* +shuffle */ customer z48 on z48.c_custkey = B.c_custkey join /* +shuffle */ customer z49 on z49.c_custkey = B.c_custkey join /* +shuffle */ customer z50 on z50.c_custkey = B.c_custkey join /* +shuffle */ customer z51 on z51.c_custkey = B.c_custkey join /* +shuffle */ customer z52 on z52.c_custkey = B.c_custkey join /* +shuffle */ customer z53 on z53.c_custkey = B.c_custkey join /* +shuffle */ customer z54 on z54.c_custkey = B.c_custkey join /* +shuffle */ customer z55 on z55.c_custkey = B.c_custkey join /* +shuffle */ customer z56 on z56.c_custkey = B.c_custkey join /* +shuffle */ customer z57 on z57.c_custkey = B.c_custkey join /* +shuffle */ customer z58 on z58.c_custkey = B.c_custkey join /* +shuffle */ customer z59 on z59.c_custkey = B.c_custkey join /* +shuffle */ customer z60 on z60.c_custkey = B.c_custkey join /* +shuffle */ customer z61 on z61.c_custkey = B.c_custkey join /* +shuffle */ customer z62 on z62.c_custkey = B.c_custkey join /* +shuffle */ customer z63 on z63.c_custkey = B.c_custkey join /* +shuffle */ customer z64 on z64.c_custkey = B.c_custkey join /* +shuffle */ customer z65 on z65.c_custkey = B.c_custkey join /* +shuffle */ customer z66 on z66.c_custkey = B.c_custkey join /* +shuffle */ customer z67 on z67.c_custkey = B.c_custkey join /* +shuffle */ customer z68 on z68.c_custkey = B.c_custkey join /* +shuffle */ customer z69 on z69.c_custkey = B.c_custkey join /* +shuffle */ customer z70 on z70.c_custkey = B.c_custkey join /* +shuffle */ customer z71 on z71.c_custkey = B.c_custkey join /* +shuffle */ customer z72 on z72.c_custkey = B.c_custkey join /* +shuffle */ customer z73 on z73.c_custkey = B.c_custkey join /* +shuffle */ customer z74 on z74.c_custkey = B.c_custkey join /* +shuffle */ customer z75 on z75.c_custkey = B.c_custkey join /* +shuffle */ customer z76 on z76.c_custkey = B.c_custkey join /* +shuffle */ customer z77 on z77.c_custkey = B.c_custkey join /* +shuffle */ customer z78 on z78.c_custkey = B.c_custkey join /* +shuffle */ customer z79 on z79.c_custkey = B.c_custkey join /* +shuffle */ customer z80 on z80.c_custkey = B.c_custkey join /* +shuffle */ customer z81 on z81.c_custkey = B.c_custkey join /* +shuffle */ customer z82 on z82.c_custkey = B.c_custkey join /* +shuffle */ customer z83 on z83.c_custkey = B.c_custkey join /* +shuffle */ customer z84 on z84.c_custkey = B.c_custkey join /* +shuffle */ customer z85 on z85.c_custkey = B.c_custkey join /* +shuffle */ customer z86 on z86.c_custkey = B.c_custkey join /* +shuffle */ customer z87 on z87.c_custkey = B.c_custkey join /* +shuffle */ customer z88 on z88.c_custkey = B.c_custkey join /* +shuffle */ customer z89 on z89.c_custkey = B.c_custkey join /* +shuffle */ customer z90 on z90.c_custkey = B.c_custkey join /* +shuffle */ customer z91 on z91.c_custkey = B.c_custkey join /* +shuffle */ customer z92 on z92.c_custkey = B.c_custkey join /* +shuffle */ customer z93 on z93.c_custkey = B.c_custkey join /* +shuffle */ customer z94 on z94.c_custkey = B.c_custkey join /* +shuffle */ customer z95 on z95.c_custkey = B.c_custkey join /* +shuffle */ customer z96 on z96.c_custkey = B.c_custkey join /* +shuffle */ customer z97 on z97.c_custkey = B.c_custkey join /* +shuffle */ customer z98 on z98.c_custkey = B.c_custkey join /* +shuffle */ customer z99 on z99.c_custkey = B.c_custkey join /* +shuffle */ customer z100 on z100.c_custkey = B.c_custkey and b.c_custkey < 10000 group by a.c_nationkey; |
| ---- RESULTS |
| ---- TYPES |
| ==== |
