DataWorks数据服务查询失败：You have an error in your SQL...

【问题小结】用户问题：DataWorks数据服务api执行sql报错 {   "apiLog": null,   "data": null,   "errCode": 1108110622,   "errMsg": "数据源查询失败:[Failed to query from data source:[PreparedStatementCallback; bad SQL grammar [SELECT `xxx` AS `yyy`  ,row_number() OVER (PARTITION BY `uuuu` ORDER BY SUM(`tttt`) DESC) AS `pppp`  ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' (PARTITION BY `uuuu` ORDER BY SUM(`tttt`) DESC) AS `pppp` ",   "requestId": "0a98a79416692734116618001e4f66" }

解决方案：经核实是数据库版本问题导致的客户版本5.6，OVER函数 8.0才开始支持的   升级大版本，点此参考。