# Update Keyword Engine Lists

> Update ALLOWED_KEYWORD_ALIASES in ClickHouseSqlUtils.java and ENGINE_TO_TABLE_TYPE in DatabaseMetaDataImpl.java from failing test output. Use when StatementSQLTest.testAllowedKeywordAliasesMatchSystemKeywords or DatabaseMetaDataTest.testAllTableEnginesFromSystemTableEnginesAreMapped fails.

- Skill: `clickhouse/update-keyword-engine-lists` (Agent Skill)
- Install (CLI): `npx skillmds@latest add clickhouse/update-keyword-engine-lists`
- Raw SKILL.md: https://api.skillmd.com/api/skills/clickhouse/update-keyword-engine-lists/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ClickHouse (https://skillmd.com/u/clickhouse)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/clickhouse/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.java`
— `initAllowedKeywordAliases()`, append after the last `// Appended` comment block.

**Engines:**
`jdbc-v2/src/main/java/com/clickhouse/jdbc/metadata/DatabaseMetaDataImpl.java`
— `ENGINE_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:
   ```java
   // 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:
   ```java
   // <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"
```