Skip to content
HeliosDB HeliosDB Full

HeliosDB SQL Commands Quick Reference

HeliosDB SQL Commands Quick Reference

Fast reference for HeliosDB SQL command extensions.

GPU Operations

-- Enable/Disable GPU
SET gpu_enabled = true | false;


-- Set Memory Limit
SET gpu_memory_limit = '4GB' | '8GB' | '16GB';


-- Show Status
SHOW gpu_status;
SHOW gpu_devices;

Multi-Region

-- View Regions
SHOW REGIONS;
SHOW REGION STATUS;


-- Configure Region
SET preferred_region = 'region-id';


-- Set Consistency
SET consistency_level = 'eventual' | 'strong' | 'quorum';

Autoscaling

-- Enable/Disable
SET autoscale_enabled = true | false;


-- Configure Scaling
SET autoscale_target_cu = 100;
SET autoscale_min_instances = 1;
SET autoscale_max_instances = 10;


-- Monitor
SHOW AUTOSCALE STATUS;
SHOW COMPUTE NODES;

Change Data Capture

-- Create CDC Stream
CREATE CHANGE DATA CAPTURE ON table_name
  TO KAFKA 'broker' TOPIC 'topic'
  [FORMAT JSON|AVRO]
  [AS 'stream_name'];


CREATE CHANGE DATA CAPTURE ON table_name
  TO KINESIS 'stream' REGION 'region'
  [FORMAT JSON|AVRO];


-- Manage Streams
SHOW CDC STREAMS;
SHOW CDC STREAM STATUS stream_name;
ALTER CDC STREAM stream_name PAUSE | RESUME;
DROP CHANGE DATA CAPTURE stream_name;

Common Patterns

GPU Analytics

SET gpu_enabled = true;
SELECT region, SUM(sales) FROM orders GROUP BY region;

Multi-Region Read

SET preferred_region = 'us-west';
SET consistency_level = 'eventual';
SELECT * FROM products;

Auto-Scale Configuration

SET autoscale_enabled = true;
SET autoscale_target_cu = 100;
SHOW AUTOSCALE STATUS;

CDC Pipeline

CREATE CHANGE DATA CAPTURE ON users
  TO KAFKA 'localhost:9092' TOPIC 'users'
  FORMAT JSON;

Error Codes

  • 42601: Syntax error
  • 22023: Invalid parameter value
  • 42704: Resource not found
  • 23505: Resource already exists

See Also