• Home
• io.trino.gateway
• gateway-ha
• 11
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

way.gateway-ha.11.source-code.00-resource_groups.sql Maven / Gradle / Ivy

-- Schema inlined in trino in:
-- io/trino/gateway/ha/persistence/dao/ResourceGroups.java
CREATE TABLE IF NOT EXISTS resource_groups (
    resource_group_id BIGINT NOT NULL AUTO_INCREMENT,
    name VARCHAR(250) NOT NULL UNIQUE,

    -- OPTIONAL POLICY CONTROLS
    parent BIGINT NULL,
    jmx_export BOOLEAN NULL,
    scheduling_policy VARCHAR(128) NULL,
    scheduling_weight INT NULL,

    -- REQUIRED QUOTAS
    soft_memory_limit VARCHAR(128) NOT NULL,
    max_queued INT NOT NULL,
    hard_concurrency_limit INT NOT NULL,

    -- OPTIONAL QUOTAS
    soft_concurrency_limit INT NULL,
    soft_cpu_limit VARCHAR(128) NULL,
    hard_cpu_limit VARCHAR(128) NULL,
    environment VARCHAR(128) NULL,

    PRIMARY KEY(resource_group_id),
--    KEY(name),
    FOREIGN KEY (parent) REFERENCES resource_groups (resource_group_id)
)