[
https://issues.apache.org/jira/browse/YARN-11290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17600835#comment-17600835
]
ASF GitHub Bot commented on YARN-11290:
---------------------------------------
slfan1989 commented on PR #4846:
URL: https://github.com/apache/hadoop/pull/4846#issuecomment-1238308788
@goiri Please help to review the code again, thank you very much!
This PR changes the execution script of the stored procedure, I will check
the script against the major version of the database.
**SQLServer**
The change script of the stored procedure has been verified on SQL Server
2012 Enterprise And SQL Server 2008 R2 Enterprise, I will verify it on the
following version as soon as possible
- [ ] SQL Server 2008 R2 Enterprise
- [ ] SQL Server 2012 Enterprise
SQL Server 2016 Enterprise
SQL Server 2017 Enterprise
SQL Server 2019 Enterprise
**MySQL**
MySQL 5.7 and above must be required, MySQL 5.5 and MySQL 5.6 cannot be
supported.
MySQL-5.5 and MySQL-5.6 Can't Create Table membership and policies, for the
following reasons:
1.The primary key of the membership table is subClusterId varchar(256) ,
Mysql will prompt the following error:
Specified key was too long; max key length is 767 bytes.
2.The primary key of the policies table is subClusterId varchar(256) , Mysql
will prompt the following error:
Specified key was too long; max key length is 767 bytes.
- [ ] MySQL 5.7
- [ ] MySQL 8.0
> Improve Query Condition of FederationStateStore#getApplicationsHomeSubCluster
> -----------------------------------------------------------------------------
>
> Key: YARN-11290
> URL: https://issues.apache.org/jira/browse/YARN-11290
> Project: Hadoop YARN
> Issue Type: Improvement
> Components: federation
> Affects Versions: 3.4.0
> Reporter: fanshilun
> Assignee: fanshilun
> Priority: Minor
> Labels: pull-request-available
> Attachments: SqlServer-StoredProc.png
>
>
> 1. Currently this interface returns the number of apps in all sub-clusters,
> increasing the limit on the number of query apps, limited to 1000 apps.
> 2. Allows to query the App based on the specified HomeSubCluster.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: yarn-issues-unsubscr...@hadoop.apache.org
For additional commands, e-mail: yarn-issues-h...@hadoop.apache.org
