update-keyword-engine-lists

作者: clickhouse

Update ALLOWED_KEYWORD_ALIASES in ClickHouseSqlUtils.java and ENGINE_TO_TABLE_TYPE in DatabaseMetaDataImpl.java from failing test output. Use when…

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
我们要求翻译一段文本,目标语言是繁体中文。文本内容是关于ClickHouse最佳实践的规则,包括模式设计、查询优化和数据摄取策略。需要保留名称"clickhouse-best-practices"(但名称不在<text>内,所以不翻译)。注意不要添加额外内容,只翻译<text>内的文字。 翻译时注意专业术语:schema design -> 模式設計,query optimization -> 查詢優化,data ingestion strategy -> 數據攝取策略,primary key -> 主鍵,data type selection -> 數據類型選擇,immutable design decisions -> 不可變設計決策,JOIN -> JOIN(保留),insert batching -> 插入批次處理,mutation avoidance -> 避免突變,columnar storage -> 列式存儲,sparse index mechanics -> 稀疏索引機制,structured review procedures -> 結構化審查程序。 注意繁体中文用词:规则、组织、涵盖、关键、标记、提供等。 文本末尾有"for...",但原文是"for..."后面没有完整
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 上的 Managed ClickStack 服務時使用,無論是透過部署新的本地 collector…
official
infra-clickhouse
clickhouse
使用clickhousectl CLI設定及管理ClickHouse——安裝並執行本機ClickHouse伺服器以利開發,同時建立受管理的ClickHouse Cloud…
official
infra-postgres
clickhouse
使用 clickhousectl CLI 設定並管理 Postgres — 執行本機 Docker 支援的 Postgres 以進行開發,並建立及操作受管理的 ClickHouse…
official
clickhouse-best-practices
clickhouse
審查 ClickHouse 結構、查詢或配置時必須使用。包含 31 條規則,在提供建議前必須檢查。務必閱讀…
official
setup
clickhouse
引導用戶設定與此插件捆綁的 ClickHouse MCP 伺服器連線。當用戶首次安裝插件或遇到問題時使用…
official