[
https://issues.apache.org/jira/browse/YARN-11349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17687675#comment-17687675
]
ASF GitHub Bot commented on YARN-11349:
---------------------------------------
slfan1989 commented on PR #5244:
URL: https://github.com/apache/hadoop/pull/5244#issuecomment-1427244187
### 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
