update-keyword-engine-lists

作者: clickhouse

根据失败的测试输出,更新ClickHouseSqlUtils.java中的ALLOWED_KEYWORD_ALIASES和DatabaseMetaDataImpl.java中的ENGINE_TO_TABLE_TYPE。当……时使用。

npx skills add https://github.com/clickhouse/clickhouse-java --skill update-keyword-engine-lists

Update keyword and engine lists from test failures

Files

Keywords: jdbc-v2/src/main/java/com/clickhouse/jdbc/internal/parser/javacc/ClickHouseSqlUtils.javainitAllowedKeywordAliases(), append after the last // Appended comment block.

Engines: jdbc-v2/src/main/java/com/clickhouse/jdbc/metadata/DatabaseMetaDataImpl.javaENGINE_TO_TABLE_TYPE static block, insert a new group before // Special.

Steps

  1. Parse the failing test message to extract the list of missing items.

  2. For keywords (StatementSQLTest failure — e.g. ["CURSOR", "DETERMINISTIC", ...]): Append a new dated comment + entries at the end of buildKeywordSet(...), after the last existing // Appended block:

    // Appended MM/DD/YYYY
    "KEYWORD1", "KEYWORD2", ...
    

    The previous entry must have a trailing comma. Keep alphabetical order within the new block.

  3. For engines (DatabaseMetaDataTest failure — e.g. [Paimon, PaimonAzure, ...]): Add a new named group before // Special in the static block:

    // <GroupName> (appended MM/DD/YYYY)
    map.put("Engine1", TableType.REMOTE_TABLE.getTypeName());
    

    Choose TableType by analogy:

    • External storage (S3/Azure/HDFS variants, lake formats) → REMOTE_TABLE
    • MergeTree family or local engines → TABLE

Output

After editing, output this git commit command:

git commit -m "jdbc-v2: update <keywords|engines|keywords and engines> in JDBC"

来自 clickhouse 的更多技能

clickhouse-best-practices
clickhouse
28条ClickHouse最佳实践规则,按模式设计、查询优化和数据摄入策略组织。涵盖三个关键领域:主键与数据类型选择(不可变设计决策)、JOIN与查询优化、批量插入与避免突变。包含28条按影响程度排序的规则,其中模式设计和查询优化规则因ClickHouse的列式存储和稀疏索引机制被标记为关键。提供结构化审查流程用于...
official
clickhouse-js-node-coding
clickhouse
Write idiomatic application code with the ClickHouse Node.js client (`@clickhouse/client`). Use this skill whenever a user is *building* against the Node.js…
official
clickhousectl-cloud-deploy
clickhouse
当用户希望将ClickHouse部署到云端、投入生产环境、使用ClickHouse Cloud、托管托管式ClickHouse服务,或从本地迁移时使用…
official
clickstack-otel-collector
clickhouse
当用户希望将OpenTelemetry collector接入ClickHouse Cloud上的托管ClickStack服务时使用,无论是通过部署新的本地collector…
official
infra-clickhouse
clickhouse
使用 clickhousectl CLI 设置并管理 ClickHouse — 安装并运行本地 ClickHouse 服务器用于开发,以及创建托管的 ClickHouse Cloud…
official
infra-postgres
clickhouse
Sets up and manages Postgres using the clickhousectl CLI — runs a local Docker-backed Postgres for development, and creates and operates managed ClickHouse…
official
clickhouse-best-practices
clickhouse
在审查ClickHouse模式、查询或配置时必须使用。包含31条在提供建议前必须检查的规则。始终阅读…
official
setup
clickhouse
引导用户完成此插件附带的ClickHouse MCP服务器连接的设置。在用户首次安装插件或遇到问题时使用…
official