Hive-MR3 0.2 vs Hive-LLAP

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1		Indigo Cluster										Gold Cluster										Red Cluster
2		Hive-MR3						Hive-LLAP				Hive-MR3						Hive-LLAP				Hive-MR3		Hive-LLAP		Hive-MR3		Hive-LLAP
3		Hive 2.2.0										Hive 2.2.0										Hive 2.2.0				Hive 2.2.0
4		Tez 0.9.1										Tez 0.9.1										Tez 0.9.1				Tez 0.9.1
5		query 18 to 20, repeat 10, 8 Beelines										query 18 to 20, repeat 10, 8 Beelines										query 18 to 20, repeat 10, 8 Beelines				query 12 to 27, repeat 10, 8 Beelines
6	Container/daemon memory	5GB	80GB	80GB	8GB	80GB	80GB	80GB	80GB	80GB	80GB	5GB	80GB	80GB	8GB	80GB	80GB	80GB	80GB	80GB	80GB	160GB	160GB	160GB	160GB	160GB	160GB	160GB	160GB
7	Number of executors	x1	x16	x16	x1	x10	x10	x16	x16	x10	x10	x1	x16	x16	x1	x10	x10	x16	x16	x10	x10	x10	x10	x10	x10	x10	x10	x10	x10
8	Headroom memory	1GB	6GB	8GB	1.6GB	6GB	8GB	6GB	8GB	6GB	8GB	1GB	6GB	8GB	1.6GB	6GB	8GB	6GB	8GB	6GB	8GB	8GB	8GB	8GB	8GB	8GB	8GB	8GB	8GB
9	Cache size for LLAP I/O																						80GB		80GB		80GB		80GB
10	Running time (seconds)	2722.223	2894.819	2915.338	2988.41	3270.127	3256.403	3384.206	3412.802	3322.156	3353.746		4619.151	4653.207	5015.487	5410.935	5514.532		5804.862		4756.629	2241.237	2129.726		2565.164	12025.346	13442.872		13469.037
11	Best running time with no failures	2722.223								3322.156			4619.151								4756.629		2129.726		2565.164	12025.346			13469.037
12	Speed-up against Hive-LLAP (%)	22.04											2.98										20.45			12.01
13	query 18	297.228	246.654	261.685	243.81	275.835	276.623	205.386	210.974	211.523	210.455	FAIL	317.243	344.937	342.488	350.73	398.926	FAIL	297.135	FAIL	304.371	271.555	186.039	FAIL	159.398	94.887	132.084	FAIL	43.434	query 12
14	query 19	93.854	78.436	74.087	114.652	106.639	101.946	98.913	89.89	89.364	92.773		157.694	135.766	188.791	200.302	200.063		204.978		160.841	51.79	41.652		70.4	105.082	121.09		87.819	query 15
15	query 20	66.362	79.378	59.589	70.135	136.366	52.619	23.793	13.568	13.024	16.185		138.928	146.25	50.611	84.234	48.653		23.381		21.579	11.13	27.435		10.347	369.186	346.283		323.396	query 17
16	query 18	149.044	121.138	135.246	139.25	108.244	154.149	133.533	150.846	156.101	156.086		211.102	222.848	288.192	258.814	286.474		259.351		248.293	96.764	87.357		109.026	127.858	116.393		114.11	query 18
17	query 19	52.723	49.687	50.146	92.905	46.537	92.029	83.686	89.612	86.745	95.015		172.758	191.137	207.185	186.905	196.144		245.818		220.292	48.093	42.249		64.822	47.902	41.714		65.25	query 19
18	query 20	79.911	73.535	84.34	67.02	134.772	139.427	32.828	19.015	12.841	17.261		101.981	149.823	197.074	164.633	116.495		15.588		17.856	24.002	85.313		16.089	7.481	10.559		15.77	query 20
19	query 18	124.812	140.828	138.481	146.02	125.197	114.311	198.248	205.794	205.699	203.287		166.092	144.036	226.87	239.073	264.484		246.412		252.829	108.74	88.501		154.294	8.463	144.365		19.149	query 21
20	query 19	59.081	55.482	82.04	83.111	46.26	48.487	115.686	118.485	115.276	117.052		171.688	100.487	90.809	129.777	182.005		224.606		158.275	62.05	46.839		92.011	204.154	169.492		209.826	query 22
21	query 20	65.214	77.75	55.645	110.594	154.743	153.528	24.195	24.061	29.503	24.087		124.443	123.023	173.012	166.296	198.802		43.751		28.299	19.042	64.536		13.118	196.888	163.782		261.549	query 25
22	query 18	125.604	156.737	150.437	110.109	131.467	120.216	212.443	214.064	199.561	209.009		199.815	203.287	222.429	238.701	219.799		285.1		285.304	131.004	102.953		158.836	47.439	65.753		65.162	query 26
23	query 19	54.338	57.945	92.947	78.496	64.745	54.509	99.502	116.645	112.647	116.03		111.377	260.717	178.4	109.054	152.114		245.939		158.828	69.41	85.22		94.116	70.206	60.05		81.368	query 27
24	query 20	70.789	67.549	44.613	98.518	135.676	124.618	28.879	23.148	23.326	28.905		107.197	127.844	105.333	150.441	158.146		44.846		28.706	13.629	74.875		13.351	9.173	24.227		10.76	query 12
25	query 18	126.49	149.064	152.632	103.168	135.694	136.167	215.236	209	205.174	198.84		208.941	96.471	201.657	258.509	248.794		297.087		283.52	140.468	76.899		159.79	87.229	71.233		89.643	query 15
26	query 19	65.908	97.596	90.737	77.585	63.955	78.37	114.076	118.522	115.285	117.237		101.43	213.785	149.299	138.254	122.419		177.571		152.049	67.998	70.402		95.712	344.236	379.25		369.278	query 17
27	query 20	72.778	35.723	50.931	74.41	127.993	102.12	13.436	22.363	22.134	24.809		127.091	129.927	93.345	112.183	137.27		27.328		27.026	16.485	83.947		15.065	132.063	151.43		158.103	query 18
28	query 18	116.736	161.292	150.848	125.919	123.935	143.412	223.798	212.056	208.258	205.457		218.622	123.787	226.219	275.674	244.098		350.693		285.105	139.703	71.62		153.976	66.387	53.132		94.771	query 19
29	query 19	95.359	109.271	92.084	68.126	59.959	75.882	118.592	115.03	116.335	116.911		231.556	159.151	175.931	257.968	227.04		461.308		158.427	71.778	66.117		96.237	11.701	17.644		15.905	query 20
30	query 20	87.706	92.098	43.698	80.154	137.229	104.416	22.993	25.18	23.681	21.834		149.578	125.991	55.933	217.044	22.921		49.089		27.279	32.93	56.51		30.096	14.605	127.249		12.97	query 21
31	query 18	85.452	122.701	157.308	132.871	126.768	138.651	211.398	215.799	206.029	206.481		154.97	160.369	252.825	176.592	275.875		265.14		286.823	125.938	79.126		135.679	222.82	159.807		234.497	query 22
32	query 19	80.961	73.986	83.265	80.838	63.669	75.62	118.976	117.909	114.219	111.522		137.673	146.493	171.372	154.653	244.141		238.618		163.219	68.934	58.924		100.091	201.984	206.441		230.54	query 25
33	query 20	102.711	62.464	49.423	79.496	132.073	116.684	23.479	24.708	23.096	23.985		115.285	112.907	49.605	181.211	187.165		36.268		27.728	83.91	56.227		12.094	46.748	55.724		62.088	query 26
34	query 18	77.214	139.089	151.573	144.044	125.195	137.345	215.106	215.396	208.543	209.802		149.562	172.465	231.004	187.55	168.365		272.563		288.506	97.097	90.18		156.613	64.932	76.828		70.987	query 27
35	query 19	80.249	55.138	96.254	90.257	66.364	50.484	103.118	114.11	115.382	115.93		143.739	179.659	225.06	163.074	235.967		286.598		158.026	44.753	55.946		95.133	10.053	30.545		20.988	query 12
36	query 20	94.007	64.711	44.292	52.215	133.13	137.462	35.3	29.083	21.153	21.849		131.678	34.293	212.102	178.589	155.936		33.556		27.596	78.272	75.708		15.629	83.099	65.198		88.785	query 15
37	query 18	108.981	153.064	153.111	155.251	131.053	142.926	214.77	214.984	205.564	208.722		193.544	235.822	156.888	198.466	165.022		357.584		284.813	98.418	100.142		161.158	345.115	376.39		369.681	query 17
38	query 19	56.076	72.007	104.762	95.006	91.98	72.075	120.376	118.576	114.73	115.014		169.699	225.18	137.958	159.567	193.419		195.371		199.068	44.395	50.249		94.217	132.383	144.58		158.699	query 18
39	query 20	91.879	51.998	71.13	45.124	108.483	114.848	21.587	26.238	29.654	26.358		117.783	154.977	153.299	186.338	149.429		29.532		29.358	73.6	66.082		15.682	68.214	59.663		91.209	query 19
40	query 18	92.029	167.832	131.078	159.064	124.849	138.967	212.839	212.94	195.632	201.454		173.607	134.539	171.973	175.172	195.968		349.214		285.072	101.059	99.042		153.036	11.811	17.468		14.997	query 20
41	query 19	41.935	72.068	53.187	63.784	42.898	49.864	119.091	119.493	118.163	114.078		103.108	85.418	70.895	100.642	109.438		195.332		157.209	40.646	31.322		97.452	10.349	132.15		6.797	query 21
42	query 20	6.792	9.598	9.769	6.478	8.419	8.648	22.943	25.313	23.514	27.318		10.967	11.818	8.928	10.489	9.16		45.105		30.332	7.644	8.314		21.696	237.142	186.682		191.135	query 22
43																										197.077	181.137		276.992	query 25
44																										48.446	66.794		63.049	query 26
45																										63	50.132		76.576	query 27
46																										9.482	46.784		13.618	query 12
47																										84	191		84.842	query 15
48																										346.335	281.217		371.377	query 17
49																										131.598	111.654		899.706	query 18
50																										66.299	45.936		187.546	query 19
51																										12.835	141.076		106.964	query 20
52																										10	110		18.307	query 21
53																										226.354	191.359		107.799	query 22
54																										196.712	133.412		119.747	query 25
55																										47.913	73.845		36.247	query 26
56																										63.106	29.314		61.112	query 27
57																										11.197	57.087		7.393	query 12
58																										86.873	220.761		191.439	query 15
59																										338.618	266.77		235.104	query 17
60																										130.707	100.661		115.709	query 18
61																										67.889	98.471		85.156	query 19
62																										10.602	116.672		22.382	query 20
63																										152.685	102.764		28.593	query 21
64																										188.707	207.88		101.718	query 22
65																										133.35	94.463		315.301	query 25
66																										54.54	28.304		56.066	query 26
67																										34.583	66.228		80.694	query 27
68																										48.259	281.395		19.977	query 12
69																										167.668	147.912		87.64	query 15
70																										268.282	125.436		269.187	query 17
71																										107.545	102.689		210.649	query 18
72																										45	205		81.487	query 19
73																										9.69	134.273		51.372	query 20
74																										95.476	112.299		15.349	query 21
75																										198.468	115.313		79.004	query 22
76																										150.955	88.1		227.361	query 25
77																										54.402	247.957		137.542	query 26
78																										41.885	170.944		39.794	query 27
79																										34.972	75.271		40.208	query 12
80																										139.504	63.462		85.696	query 15
81																										293.106	343.167		135.69	query 17
82																										116.892	210.519		235.815	query 18
83																										59.555	77.468		76.359	query 19
84																										63.725	66.395		43.035	query 20
85																										90.635	7.755		63.399	query 21
86																										161.813	99.352		166.249	query 22
87																										138.227	308.551		97.891	query 25
88																										53.831	157.278		51.469	query 26
89																										40.397	69.083		74.978	query 27
90																										33.204	21.008		108.277	query 12
91																										137.968	162.718		157.25	query 15
92																										292.24	238.049		154.527	query 17
93																										116.849	158.5		72.332	query 18
94																										48.626	94.52		72.787	query 19
95																										13.603	24.819		14.579	query 20
96																										90.472	19.182		15.012	query 21
97																										190.488	105.521		244.361	query 22
98																										156.942	304.054		227.537	query 25
99																										52.353	159.464		65.233	query 26
100																										48.583	73.461		82.999	query 27