hive使用遇到的问题 cannot recognize input near in subquery

cannot recognize input near in subquery1、HQL子查询别名问题备注：子查询需要加上别名否则报错。HQL的书写，select * from (select * from table) ;执行此HQL，应该会报错：ql.Driver (SessionState.java:printError(960)) - FAILED:...

weixin_42201058

70258人浏览 · 2018-09-07 11:49:36

weixin_42201058 · 2018-09-07 11:49:36 发布

cannot recognize input near in subquery

1、HQL子查询别名问题
备注：子查询需要加上别名否则报错。
HQL的书写，select * from (select * from table) ;

 执行此HQL，应该会报错：ql.Driver (SessionState.java:printError(960)) - FAILED: ParseException line 48:52 cannot recognize input near '<EOF>' '<EOF>' '<EOF>' in subquery source

 此时，修改HQL为select * from (select * from table) a，执行成功。