sql-mcp: hierarchy adopt · role_playing reject+strip
decision: partial (research 8709c016 → intent:pass → done). DW 표면(describe_table)은 dim/fact 컬럼 중심; libSQL에 hierarchy/role_playing 자식 테이블이 없으면 스키마만 넣어도 round-trip 소실·노이즈.
hierarchy — adopt (단계)
$defs.hierarchy:name+levels(≥2 unique, coarse→fine dimension names) + optional description;cube.hierarchies[]optional; AP:false.- libSQL
meta_cube_hierarchies+ store 분해/재조립; links 검증levels ⊆ dimension names. describe_tableoptionalhierarchies[]= drill GROUP BY 순서 힌트 (컴파일러 auto-expand 없음).- 증거: unit
hierarch+ httpapi_meta_cube_hierarchies_roundtrip; sql-mcp **PR 2.
role_playing — reject + strip
- 쿼리 가능 컬럼을 만들지 않음. sql-mcp는 별도 dimension + view join alias(다중 FK role-play)로 표현.
- uni-semantic → sql-mcp emit:
cube.role_playing[]strip (스키마 추가 없음). 허브 IR 필드는 유지 (PR #18 ·8066ed99). - 후속(선택): emit 전 dimension+join alias 전개 — MCP 본구현 티켓 아님.
semantic-ui hierarchy 편집 (PR #3)
- CubeMappingEditor Hierarchies: ordered dim multi-select (coarse→fine); Apply validates name + levels≥2 unique + levels⊆dims (
hierarchyLevelsError/hierarchyErrorinsemantic-ui/src/model.ts). - Empty hierarchy list omits
hierarchieskey (additive clear compatibility). - No role_playing UI (Non-goal). Consumes FU1 schema/store (PR #2).
- Evidence:
cd semantic-ui && npm test103 passed; mergef9564d11PR #3; head deleted. - Dup close:
f3582e2ccancelled; canonical UI ticketa506b29f.
Follow-ups (backlog)
- schema+$defs+skills+libSQL+store round-trip + levels⊆dims 검증 —
546582a6(schema+store+describe 축은 PR 2로 일부 닫힘) - describe_table + skill/client 힌트
semantic-ui 편집— done PR #3 / canonicala506b29f(dupf3582e2ccancelled)