TD Trino performance optimization including CTAS (5x faster), UDP bucketing for ID lookups, magic comments for join distribution, REGEXP_LIKE vs LIKE, and approx functions.
安装
npx skills add treasure-data/td-skills --skill trino-optimizernpx skills add treasure-data/td-skills --skill trino-optimizer -a claude-code -gnpx skills add treasure-data/td-skills --skill trino-optimizer -a codex -ggemini skills install https://github.com/treasure-data/td-skills.git --path sql-skills/trino-optimizergh skill install treasure-data/td-skills trino-optimizergit clone --depth 1 https://github.com/treasure-data/td-skills /tmp/treasure-data__td-skills
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/treasure-data__td-skills/sql-skills/trino-optimizer ~/.claude/skills/trino-optimizer # Claude Code
cp -R /tmp/treasure-data__td-skills/sql-skills/trino-optimizer ~/.agents/skills/trino-optimizer # Codex, Cursor, Gemini CLI, Copilot, OpenCode