1 给表起别名:
语句如下
USE anticheat;
select * from (
select * from anticheat.ods_af_pull_api_blocked_installs_report_all limit 10
)
报错
failed in parse sql :org.apache.hadoop.hive.ql.parse.ParseException: line 3:1 cannot recognize input near '<EOF>' '<EOF>' '<EOF>' in subquery source
给表起了一个别名
USE anticheat;
select * from (
select * from anticheat.ods_af_pull_api_blocked_installs_report_all limit 10
) a
给每一个sub_sequence 一个别名。
解决问题