Skip to content

[Feature] StarRocks 查询支持 SET 用户变量并在后续 SQL 中引用 #173

Description

@201811510411lw

Issue type

Feature request

Summary

希望 CloudDM 的 StarRocks 查询控制台支持通过 SET @变量名 = 值 定义用户变量,并允许在同一查询会话或同一批 SQL 的后续语句中引用该变量。

在日常数据查询中,经常需要设置开始日期、结束日期等参数。如果无法使用用户变量,同一个条件需要在多处重复修改,容易遗漏,也不利于保存和复用 SQL。

示例:

sql
SET @start_date = '2026-01-01';
SET @end_date = '2026-02-01';

SELECT
stat_date,
dim_a,
dim_b,
SUM(metric_value) AS total_value
FROM demo_db.sample_table
WHERE stat_date >= @start_date
AND stat_date < @end_date
AND category LIKE 'sample%'
GROUP BY stat_date, dim_a, dim_b;

Actual behavior

在 CloudDM 查询控制台中执行包含用户变量的 StarRocks SQL 时,变量定义或变量引用无法正常执行。

执行上述 SQL 后,页面提示:

UnsupportedOperationException: unsupported SQL: @start_date

Environment

  • CloudDM version: 4.0.1
  • Deployment mode: Alone
  • Operating system: Linux
  • Browser and version: Google Chrome
  • Database type and version: StarRocks 3.3.13

Logs or screenshots

Image

执行包含 SET @start_date 和变量引用的 SQL 时,CloudDM 返回:

UnsupportedOperationException: unsupported SQL: @start_date

### Additional context

_No response_

### Checklist

- [x] I searched existing issues and did not find a duplicate.
- [x] I removed passwords, tokens, connection strings, and other sensitive data.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions