good first issuetype/feature-requestversion:3.2.9version:3.3.0version:3.4
Métricas do repositório
- Stars
- (5.717 stars)
- Métricas de merge de PR
- (Mesclagem média 1d 8h) (999 fundiu PRs em 30d)
Description
- https://github.com/StarRocks/starrocks/pull/47233
- https://github.com/StarRocks/starrocks/pull/46448
- https://github.com/StarRocks/starrocks/pull/45406
Feature request
Is your feature request related to a problem? Please describe.
STRUCT type is more performant that JSON in terms of query, but which use the fixed schema and annoying to construct.
If it's possible to convert JSON to STRUCT directly, like to_struct(JSON), it can be much easier to use.
Describe the solution you'd like
- Use a function to convert JSON to STRUCT:
- Example:
select to_struct(parse_json("{"a": 1}")) - Difficulty: cannot inference the schema of struct before parsing the JSON
- Example:
- Specify the STRUCT schema and convert:
- Example:
select to_struct<a int, b int>(parse_json("a": 1, "b": 2)) - Difficulty: not easy to use
- Example:
Describe alternatives you've considered
Additional context