[ https://issues.apache.org/jira/browse/YARN-11349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17680522#comment-17680522 ]
ASF GitHub Bot commented on YARN-11349: --------------------------------------- slfan1989 commented on PR #5244: URL: https://github.com/apache/hadoop/pull/5244#issuecomment-1403352045 > SQL Server 2008 R2 Enterprise > select @@version ``` Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19 2014 12:21:34 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) ``` > FederationStateStoreDatabase.sql ``` master> IF DB_ID ( '[FederationStateStore]') IS NOT NULL DROP DATABASE [FederationStateStore] [2023-01-25 17:22:05] completed in 41 ms master> CREATE database FederationStateStore [2023-01-25 17:22:05] completed in 106 ms ``` > FederationStateStoreUser.sql ``` master> USE [FederationStateStore] [2023-01-25 17:23:20] [S0001][5701] Changed database context to 'FederationStateStore'. [2023-01-25 17:23:20] completed in 41 ms master> CREATE LOGIN FederationUser with password = 'Federation@Password', default_database=[FederationStateStore] [2023-01-25 17:23:21] completed in 51 ms master> CREATE USER FederationUser FOR LOGIN FederationUser WITH default_schema=dbo [2023-01-25 17:23:21] completed in 41 ms master> EXEC sp_addrolemember 'db_owner', 'FederationUser' [2023-01-25 17:23:21] completed in 41 ms ``` > FederationStateStoreTables.sql ``` .... Table delegationTokens exists, no operation required... [2023-01-25 17:24:34] completed in 44 ms FederationStateStore> IF NOT EXISTS ( SELECT * FROM [FederationStateStore].sys.tables WHERE name = 'sequenceTable' AND schema_id = SCHEMA_ID('dbo')) BEGIN PRINT 'Table sequenceTable does not exist, create it...' SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON SET ANSI_PADDING ON CREATE TABLE [dbo].[sequenceTable]( sequenceName VARCHAR(255) NOT NULL, nextVal bigint NOT NULL CONSTRAINT [pk_sequenceName] PRIMARY KEY ( [sequenceName] ) ) SET ANSI_PADDING OFF PRINT 'Table sequenceTable created.' END ELSE PRINT 'Table sequenceTable exists, no operation required...' Table sequenceTable does not exist, create it... Table sequenceTable created. ``` ``` USE [FederationStateStore] GO SELECT Name FROM SysObjects Where XType='U' ORDER BY Name applicationsHomeSubCluster delegationTokens masterKeys membership policies reservationsHomeSubCluster sequenceTable ``` > FederationStateStoreStoredProcs.sql ``` [2023-01-25 17:53:48] completed in 39 ms FederationStateStore> CREATE PROCEDURE [dbo].[sp_deleteDelegationToken] @sequenceNum_IN bigint, @rowCount_OUT int OUTPUT AS BEGIN DECLARE @errorMessage nvarchar(4000) BEGIN TRY BEGIN TRAN DELETE FROM [dbo].[delegationTokens] WHERE [sequenceNum] = @sequenceNum_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, - > [Federation] Router Support DelegationToken With SQL > ---------------------------------------------------- > > Key: YARN-11349 > URL: https://issues.apache.org/jira/browse/YARN-11349 > Project: Hadoop YARN > Issue Type: Sub-task > Components: federation, router > Affects Versions: 3.4.0 > Reporter: Shilun Fan > Assignee: Shilun Fan > Priority: Major > Labels: pull-request-available > > Router Support DelegationToken With SQLFederationStateStore. -- 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