slfan1989 commented on PR #5663: URL: https://github.com/apache/hadoop/pull/5663#issuecomment-1556879293
> SQLServer2008 - sp_addApplicationHomeSubCluster ``` FederationStateStore> CREATE PROCEDURE [dbo].[sp_addApplicationHomeSubCluster] @applicationId_IN VARCHAR(64), @homeSubCluster_IN VARCHAR(256), @applicationContext_IN VARBINARY(MAX), @storedHomeSubCluster_OUT VARCHAR(256) OUTPUT, @rowCount_OUT int OUTPUT AS BEGIN DECLARE @errorMessage nvarchar(4000) BEGIN TRY BEGIN TRAN -- If application to sub-cluster map doesn't exist, insert it. -- Otherwise don't change the current mapping. IF NOT EXISTS (SELECT TOP 1 * FROM [dbo].[applicationsHomeSubCluster] WHERE [applicationId] = @applicationId_IN) INSERT INTO [dbo].[applicationsHomeSubCluster] ( [applicationId], [homeSubCluster], [createTime], [applicationContext]) VALUES ( @applicationId_IN, @homeSubCluster_IN, GETUTCDATE(), @applicationContext_IN); -- End of the IF block SELECT @rowCount_OUT = @@ROWCOUNT; SELECT @storedHomeSubCluster_OUT = [homeSubCluster] FROM [dbo].[applicationsHomeSubCluster] WHERE [applicationId] = @applicationId_IN; COMMIT TRAN END TRY BEGIN CATCH ROLLBACK TRAN SET @errorMessage = dbo.func_FormatErrorMessage(ERROR_MESSAGE(), ERROR_LINE()) /* raise error and terminate the execution */ RAISERROR(@errorMessage, --- Error Message 1, -- Severity -1 -- State ) WITH log END CATCH END; [2023-05-22 17:22:37] completed in 49 ms ``` - sp_updateApplicationHomeSubCluster ``` [2023-05-22 17:22:37] completed in 49 ms FederationStateStore> IF OBJECT_ID ( '[sp_updateApplicationHomeSubCluster]', 'P' ) IS NOT NULL DROP PROCEDURE [sp_updateApplicationHomeSubCluster]; [2023-05-22 17:22:37] completed in 49 ms FederationStateStore> CREATE PROCEDURE [dbo].[sp_updateApplicationHomeSubCluster] @applicationId_IN VARCHAR(64), @homeSubCluster_IN VARCHAR(256), @applicationContext_IN VARBINARY(MAX), @rowCount_OUT int OUTPUT AS BEGIN DECLARE @errorMessage nvarchar(4000) BEGIN TRY BEGIN TRAN UPDATE [dbo].[applicationsHomeSubCluster] SET [homeSubCluster] = @homeSubCluster_IN, [applicationContext] = @applicationContext_IN WHERE [applicationId] = @applicationId_IN; SELECT @rowCount_OUT = @@ROWCOUNT; COMMIT TRAN END TRY BEGIN CATCH ROLLBACK TRAN SET @errorMessage = dbo.func_FormatErrorMessage(ERROR_MESSAGE(), ERROR_LINE()) /* raise error and terminate the execution */ RAISERROR(@errorMessage, --- Error Message 1, -- Severity -1 -- State ) WITH log END CATCH END; [2023-05-22 17:22:37] completed in 48 ms ``` - sp_getApplicationHomeSubCluster ``` [2023-05-22 17:22:38] completed in 53 ms FederationStateStore> IF OBJECT_ID ( '[sp_getApplicationHomeSubCluster]', 'P' ) IS NOT NULL DROP PROCEDURE [sp_getApplicationHomeSubCluster]; [2023-05-22 17:22:38] completed in 49 ms FederationStateStore> CREATE PROCEDURE [dbo].[sp_getApplicationHomeSubCluster] @applicationId_IN VARCHAR(64), @homeSubCluster_OUT VARCHAR(256) OUTPUT, @createTime_OUT datetime OUT, @applicationContext_OUT VARBINARY(MAX) OUTPUT AS BEGIN DECLARE @errorMessage nvarchar(4000) BEGIN TRY SELECT @homeSubCluster_OUT = [homeSubCluster], @createTime_OUT = [createTime], @applicationContext_OUT = [applicationContext] FROM [dbo].[applicationsHomeSubCluster] WHERE [applicationId] = @applicationId_IN; END TRY BEGIN CATCH SET @errorMessage = dbo.func_FormatErrorMessage(ERROR_MESSAGE(), ERROR_LINE()) /* raise error and terminate the execution */ RAISERROR(@errorMessage, --- Error Message 1, -- Severity -1 -- State ) WITH log END CATCH END; [2023-05-22 17:22:38] completed in 48 ms ``` -- 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: common-issues-unsubscr...@hadoop.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: common-issues-unsubscr...@hadoop.apache.org For additional commands, e-mail: common-issues-h...@hadoop.apache.org