spark sql 报错：attribute name “count(1)“ contains invalid charater(s) among

现象：

spark sql 运行时报错 attribute name "count(1)" contains invalid charater(s) among ，please use alias to rename it

解决：

将 count(1) 起个别名，如 select a , count(1) num from ...