在hive表前1000行里，过滤出不重复的refid,imsi。错误的写法：select distinct refid,imsi from HIVE_D_MT_UU_H_SPARK limit 1000;会去读取全表，把0~1000行的不重复refid,imsi显示出来。正确的写法：select distinct refid,imsi from (select * from H...

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