Node Requirements for SingleStore Helios Commands

SingleStore Helios commands must be run on the appropriate type(s) of node in a SingleStore Helios workspace.

When sync_permissions and enable_query_forwarding are set to ON, all Data Definition Language (DDL) commands can be forwarded from child aggregator to master. This list of requirements reflects this behavior.

  • X = recommended to run on this type of node

  • P = possible (but not recommended) to run on this type of node

  • blank = cannot run on this type of node

SingleStore Helios Command

Master Aggregator

Child Aggregator

Leaf

ANALYZE

X

X

ALTER DATABASE

X

X

ALTER RESOURCE POOL

X

X

ALTER TABLE

X

X

P

ALTER VIEW

X

X

P

ALTER USER

X

X

ALTER PIPELINE

X

X

BACKUP DATABASE

X

X

BEGIN

X

X

P

COMMIT

X

X

P

CREATE AGGREGATE

X

X

CREATE DATABASE

X

X

P

CREATE FUNCTION

X

X

CREATE GROUP

X

X

CREATE INDEX

X

X

P

CREATE PIPELINE

X

X

CREATE PROCEDURE

X

X

CREATE RESOURCE POOL

X

X

CREATE ROLE

X

X

CREATE TABLE

X

X

P

CREATE USER

X

X

CREATE VIEW

X

X

DELETE

X

X

P

DESCRIBE

X

X

X

DROP AGGREGATE

X

X

DROP DATABASE

X

X

P

DROP FUNCTION

X

X

DROP GROUP

X

X

DROP INDEX

X

X

P

DROP PIPELINE

X

X

DROP PROCEDURE

X

X

DROP RESOURCE POOL

X

X

DROP ROLE

X

X

DROP TABLE

X

X

P

DROP USER

X

X

X

DROP VIEW

X

X

P

DROP … FROM PLANCACHE

X

X

P

EXPLAIN

X

X

X

FLUSH TABLES

X

P

GRANT

X

X

X

GRANT GROUP

X

X

X

GRANT ROLE

X

X

X

INSERT

X

X

P

KILL CONNECTION

X

X

P

KILLALL QUERIES

X

X

P

LOAD DATA

X

X

P

OPTIMIZE TABLE

X

X

P

PROFILE PIPELINE

X

X

REPAIR DATABASE

X

X

X

REPLACE

X

X

P

RESTORE DATABASE

X

X

ROLLBACK

X

X

P

REVOKE

X

X

REVOKE GROUP

X

X

REVOKE ROLE

X

X

SELECT

X

X

P

SHOW COLUMNS

X

X

SHOW CREATE TABLE

X

X

P

SHOW DATABASES

X

X

P

SHOW GRANTS

X

X

X

SHOW INDEX

X

X

P

SHOW INDEXES

X

X

P

SHOW KEYS

X

X

SHOW PLANCACHE

X

X

X

SHOW PROCESSLIST

X

X

X

SHOW REPLICATION STATUS

X

X

X

SHOW SCHEMAS

X

X

P

SHOW GLOBAL STATUS

X

X

X

SHOW GLOBAL VARIABLES

X

X

X

SHOW RESOURCE POOLS

X

X

P

SHOW SESSION STATUS

X

X

X

SHOW SESSION VARIABLES

X

X

X

SHOW STATUS EXTENDED

X

X

X

SHOW TABLE STATUS

X

X

X

SHOW TABLES

X

X

X

SHOW VARIABLES

X

X

X

SHOW WARNINGS

X

X

X

SHOW ERRORS

X

X

X

START PIPELINE

X

X

STOP PIPELINE

X

X

TRUNCATE

X

X

UNLOCK TABLES

X

UPDATE

X

X

P

USE

X

X

P

Last modified: June 22, 2022

Was this article helpful?