starrocks
starrocks copied to clipboard
Struct/Map support roadmap
Backgroud
At present, starrocks already supports static Struct/Map types in the external table, and can query external tables (hive/parquet/....) through related expressions. Some user will load the external data into starrocks, but starrocks has not supported the storage and import process of Struct/Map in the OLAP table.
Target
- Internal tables support DDL operations on static Struct/Map type columns
- Support importing Struct/Map types from external data sources to starrocks
- Support querying Struct/Map and related expressions
- Optimize Struct/Map query performance as much as appearance
Currently supported
- Struct/Map storage of internal tables (the code is ready, but needs to be test & review)
- Memory column structure of Struct/Map
- Some simple expressions
Phase 1.
- Internal tables support DDL operations on static Struct/Map type columns
- [x] Table schema create
- [x] Stuct/Map type syntax
- Support load Struct/Map types
- [x] Data source format (Parquet, ORC)
- [x] Import ways (Insert Into, Broker Load)
- [x] Test & review Struct/Map storage of internal tables
- Optimize Struct/Map query performance
- [x] Struct/Map column access performance optimization
- [x] Structure internal column prune design & implement
Phase 2.
- Internal tables support DDL operations on static Struct/Map type columns
- [ ] Table schema change
- Support load Struct/Map types
- [ ] Data source format (CSV)
- [ ] Import ways (Stream Load, Rotinue Load)
- Support querying Struct/Map and related expressions
- [x] Struct/Map data type conversion
- Optimize Struct/Map query performance
- [ ] Expression performance optimization