Hybrid tables: tracking

[mkmkme]

Related to __aliasMarker

• Hybrid table fails with subquery referencing itself (UNKNOWN_TABLE error) #1208 -- possibly will be fixed with __aliasMarker PR
  • Recheck on all versions
• Join fails with hybrid table #1209 -- possibly will be fixed with __aliasMarker PR
  • Recheck on all versions
• Hybrid engine generates duplicate ALIAS expressions when ALIAS type is manually misspecified #1335 -- will be fixed with __aliasMarker PR
  • Double-check on 26.6 when __aliasMarker lands
  • Check if fix on 26.3 and 25.8 is needed
• IN is not working with hybrid tables #1422
  • Recheck on all versions
• Cannot find column exception when using function on alias column in subquery #1424
  • Recheck on all versions
• Avoid app code changes for hybrid MergeTree/Iceberg queries on tables that sort by array elements #1288
  • Might be related to aliases as well, need to double-check

PRs:

• 26.3: __aliasMarker refactoring to cover complex cases with ALIASes (antalya-26.3) #1844 -- probably needs another run of review and verification, after which it can be merged
• 26.6: Antalya 26.6: __aliasMarker refactoring to cover complex cases with ALIASes #2409 -- still in development

UX issues

• Hybrid table should convert ALIAS columns to regular columns during schema inference #1295 -- marked by Mikhail as "low priority, small fix"
  • Recheck on 25.8
  • Check on 26.3
  • Check on 26.6 when __aliasMarker lands
• Unexpected hint when one of segments in hybrid table dropped #1336 -- UX issue, low priority
  • Recheck on all versions
• Hybrid engine — currentDatabase() in engine arguments breaks server restart #1993
  • Fixed in 25.8 by Antalya 25.8 hybrid: resolve currentDatabase() in hybrid segment metadata #2285
  • Fixed in 26.3 by Antalya-26.3: Resolve currentDatabase() in Hybrid segment metadata #1995
  • Needs fix on 26.6
  • Needs frontport to 26.8

Others / Unsorted

• Hybrid table fails to load on ATTACH/server restart when segment table was dropped #1347
  • Seems related to Hybrid table that references to remote cluster can't be attached if remote cluster was offline during server restart #1510
  • Need to recheck on all versions
• Some queries with constant in SELECT section fails #1511
  • Recheck on all versions
• Hybrid table engine fails to merge data in some cases between MergeTree and Iceberg sections #2102
  • Need to reproduce and check on all versions
• Hybrid: WHERE fails with DATA_TYPE_CANNOT_BE_USED_IN_KEY when table has a JSON column #2122
  • Need to reproduce and check on all versions
• Hybrid: support Nullable null-map / IS NULL like MergeTree (remote segments) #2158
  • Need to reproduce and check on all versions
• Table system.hybrid_watermarks already exists when upgrading to 26.3 #2152
  • Needs a fix for 26.3 and frontports
• Distributed cluster queries with interserver secret fail for JWT-authenticated users #2105
  • Might need some changes in Hybrid, need to double-check