search

apache / linkis

Apache Linkis builds a computation middleware layer to facilitate connection, governance and orchestration between the upper applications and the underlying data engines.
https://linkis.apache.org/
Apache License 2.0
3.3k stars 1.17k forks source link

Linkis cli submit task, prompt GROUP BY clause; sql_mode=only_full_group_by error #1667

Closed Ritakang0451 closed 2 years ago

Ritakang0451 commented 2 years ago

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

Relevent platform

。

Reproduction script

。

Anything else

This question comes from the QA documentation of the Linkis community

Are you willing to submit a PR?

Ritakang0451 commented 2 years ago

Cause: this error occurs in MySQL version 5.7 and above. The problem is that the configuration strictly implements the "SQL92 standard". 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