You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@linkis.apache.org by GitBox <gi...@apache.org> on 2022/03/13 12:36:08 UTC
[GitHub] [incubator-linkis] Ritakang0451 opened a new issue #1667: Linkis cli submit task, prompt GROUP BY clause; sql_mode=only_full_group_by error
Ritakang0451 opened a new issue #1667:
URL: https://github.com/apache/incubator-linkis/issues/1667
### Search before asking
- [X] I searched the [issues](https://github.com/apache/incubator-linkis/issues) and found no similar issues.
### 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?
- [X] Yes I am willing to submit a PR!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@linkis.apache.org
For additional commands, e-mail: dev-help@linkis.apache.org
[GitHub] [incubator-linkis] Ritakang0451 closed issue #1667: Linkis cli submit task, prompt GROUP BY clause; sql_mode=only_full_group_by error
Posted by GitBox <gi...@apache.org>.
Ritakang0451 closed issue #1667:
URL: https://github.com/apache/incubator-linkis/issues/1667
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@linkis.apache.org
For additional commands, e-mail: dev-help@linkis.apache.org
[GitHub] [incubator-linkis] Ritakang0451 commented on issue #1667: Linkis cli submit task, prompt GROUP BY clause; sql_mode=only_full_group_by error
Posted by GitBox <gi...@apache.org>.
Ritakang0451 commented on issue #1667:
URL: https://github.com/apache/incubator-linkis/issues/1667#issuecomment-1066092443
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
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@linkis.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@linkis.apache.org
For additional commands, e-mail: dev-help@linkis.apache.org