Closed Ritakang0451 closed 2 years ago
Solution: enter the / etc / MySQL directory and modify my CNF file add code under [mysqld]: sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Search before asking
Linkis Component
linkis-commons
What happened + What you expected to happen
_8_codeExec_8 com.webank.wedatasphere.linkis.orchestrator.ecm.exception.ECMPluginErrorException: errCode: 12003 ,desc: uathadoop01:9101_8 Failed to async get EngineNode MySQLSyntaxErrorException: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dss_linkis.si.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ,ip: uathadoop01 ,port: 9104 ,serviceKind: linkis-cg-entrance Cause: this error occurs in MySQL version 5.7 and above. The problem is that the configuration strictly implements the "SQL92 standard".
Relevent platform
。
Reproduction script
。
Anything else
This question comes from the QA documentation of the Linkis community
Are you willing to submit a PR?