fix(schema-compiler): hierarchies to respect prefix value #19994

Job	Run time
latest-tag-sha	20s
build	11m 10s
build-cubestore	17m 56s
lint	4m 42s
Build & Test :dev for Debian without pushing	24m 13s
unit (20.x, 3.11, false, false)	21m 30s
unit (20.x, 3.11, false, true)	20m 29s
unit (20.x, 3.11, true, false)	20m 55s
unit (22.x, 3.11, false, false)	20m 4s
unit (22.x, 3.11, false, true)	20m 3s
unit (22.x, 3.11, true, false)	21m 2s
docker-image-latest-set-tag	5s
integration-smoke (20.x, 3.11)	22m 20s
integration-cubestore (20.x)	14m 40s
integration (20.x, clickhouse)	11m 57s
integration (20.x, druid)	11m 40s
integration (20.x, elasticsearch)	11m 13s
integration (20.x, mssql)	11m 38s
integration (20.x, mysql)	12m 15s
integration (20.x, postgres)	11m 15s
integration (20.x, prestodb)	11m 22s
integration (20.x, mysql-aurora-serverless)	11m 5s
integration (20.x, crate)	10m 47s
integration (20.x, mongobi)	10m 49s
integration (20.x, firebolt)	10m 56s
integration (20.x, dremio)	12m 38s
integration (20.x, vertica)	13m 28s
	6h 10m 32s

Provide feedback