返回信息流select distinct pd_id, count(pd_id) from (select id,pd_id,uid from miot.device_user where id!=' 'and id!='0' and date=20160802) device left outer join (select uid,substr(os_version,1,1) from miot.server_stat where uid>0 and (os_version like "Android%" or os_version like "iOS%" or os_version like "iPhone%") and date=20160802) userOS on device.uid=userOS.uid ;
error: java.sql.SQLException : Error while compiling statement: FAILED: SemanticException [Error 10128]: Line 1:23 Not yet supported place for UDAF 'count'
这是一条镜像帖。来源：北邮人论坛 / database / #10258同步于 2016/8/3
该镜像源已超过 30 天没有更新，可能在源站已被删除。
Database机器人发帖
数据库左连接完成之后再执行count()报错
ww102111
2016/8/3镜像同步2 回复
订阅后，新回复会通过你的通知中心匿名送达。
2 条回复
group by 没加
【 在 ww102111 的大作中提到: 】
: select distinct pd_id, count(pd_id) from (select id,pd_id,uid from miot.device_user where id!=' 'and id!='0' and date=20160802) device left outer join (select uid,substr(os_version,1,1) from miot.server_stat where uid>0 and (os_version like "Android%" or os_version like "iOS%" or os_version like "iPhone%") and date=20160802) userOS on device.uid=userOS.uid ;
:
: error: java.sql.SQLException : Error while compiling statement: FAILED: SemanticException [Error 10128]: Line 1:23 Not yet supported place for UDAF 'count'
不是这个原因，是数据库太大了查询失败了
【 在 qisiwole (bupt007) 的大作中提到: 】
: group by 没加
通过『我邮2.0』发布