turboFei commented on issue #3723: URL: https://github.com/apache/kyuubi/issues/3723#issuecomment-3049086574
Hi @z1131392774 thanks for the proposal, it sounds good. You can persist the interactive session info into `metadata` table, see https://github.com/apache/kyuubi/blob/master/kyuubi-server/src/main/resources/sql/mysql/metadata-store-schema-1.8.0.mysql.sql Below columns should be sufficient. ``` key_id bigint PRIMARY KEY AUTO_INCREMENT COMMENT 'the auto increment key id', identifier varchar(36) NOT NULL COMMENT 'the identifier id, which is an UUID', session_type varchar(32) NOT NULL COMMENT 'the session type, SQL or BATCH', real_user varchar(255) NOT NULL COMMENT 'the real user', user_name varchar(255) NOT NULL COMMENT 'the user name, might be a proxy user', ip_address varchar(128) COMMENT 'the client ip address', kyuubi_instance varchar(1024) COMMENT 'the kyuubi instance that creates this', state varchar(128) NOT NULL COMMENT 'the session state', resource varchar(1024) COMMENT 'the main resource', class_name varchar(1024) COMMENT 'the main class name', request_name varchar(1024) COMMENT 'the request name', request_conf mediumtext COMMENT 'the request config map', request_args mediumtext COMMENT 'the request arguments', create_time BIGINT NOT NULL COMMENT 'the metadata create time', engine_type varchar(32) NOT NULL COMMENT 'the engine type', cluster_manager varchar(128) COMMENT 'the engine cluster manager', engine_open_time bigint COMMENT 'the engine open time', engine_id varchar(128) COMMENT 'the engine application id', engine_name mediumtext COMMENT 'the engine application name', engine_url varchar(1024) COMMENT 'the engine tracking url', engine_state varchar(32) COMMENT 'the engine application state', engine_error mediumtext COMMENT 'the engine application diagnose', end_time bigint COMMENT 'the metadata end time', ``` Thanks, have assigned this ticket to you. -- 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: notifications-unsubscr...@kyuubi.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@kyuubi.apache.org For additional commands, e-mail: notifications-h...@kyuubi.apache.org
