Go Echo API调用ClickHouse查询报错：无法从SQL获取表名

算力阿峰

2026-7-14

问题分析与解决方案

错误PrepareContext error: cannot get table name from query是因为你使用的ClickHouse Go驱动在执行Prepare操作时，无法解析这种将嵌套子查询作为SELECT列的语句结构——驱动需要提取查询关联的表名，但原查询没有顶层FROM子句，导致解析失败。

以下是几种可行的解决办法：

1. 跳过Prepare直接执行查询

ClickHouse对Prepare语句的支持有限，尤其是复杂查询场景。可以直接使用Query方法执行带参数的查询，绕过Prepare阶段：

func ExecuteQuery(query string, values []interface{}) *sql.Rows {
    rows, err := conn.Query(query, values...)
    if err != nil {
        log.Println(err)
        return nil
    }
    return rows
}

2. 重构查询语句，让驱动能识别表名

把嵌套子查询改成CTE（公共表表达式）结构，让驱动可以明确识别到关联的表：

WITH 
current_data AS (
    SELECT round(sum(amount), 2) AS val
    FROM activity
    WHERE created_at >= FROM_UNIXTIME(?) AND created_at <= FROM_UNIXTIME(?)
        AND account_id = ? AND funnel_id = ? AND event_id = 2
),
old_data AS (
    SELECT round(sum(amount), 2) AS val
    FROM activity
    WHERE created_at >= FROM_UNIXTIME(?) AND created_at <= FROM_UNIXTIME(?)
        AND account_id = ? AND funnel_id = ? AND event_id = 2
)
SELECT current_data.val AS value, old_data.val AS old_value
FROM current_data, old_data;