Error while compiling statement: FAILED: ParseException line 86:6 missing EOF at ‘by‘ near ‘group‘

Error while compiling statement: FAILED: ParseException line 86:6 missing EOF at ‘by‘ near ‘group‘ 问题描述：

在hive中

Error while compiling statement: FAILED: ParseException line 86:6 missing EOF at ‘by‘ near ‘group‘

---

原因分析：

是因为SQL语句在执行中，子查询结果并未给其取别名

---

解决方案：

ps

select
	cellid
from
	(select
		cellid
		,tacid
	from
		user_hour_day
	where 
		day=${yesterday}
	union all
	select
		cellid
		,tacid
	from 
		user_info_day
	where 
		day=${yesterday}) da//(我是别名)
group by
	...

在倒数第二行da取别名，这样错误就解决了，同时如果需要再进行左连接或者右连接是非常方便的。

注：如有错误部分忘指正。