0xqq opened a new issue, #24494: URL: https://github.com/apache/doris/issues/24494
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.0.1 ### What's Wrong? CREATE TABLE `t_json_array` ( `id` varchar(1024) NULL, `array_int` array<int(11)> NULL, `array_float` array<float> NULL, `array_double` array<double> NULL, `array_string` array<text> NULL, `array_date` array<datev2> NULL, `array_datetime` array<datetimev2(0)> NULL, `array_decimal` array<decimalv3(9, 0)> NULL, `json1` json NULL ) ENGINE=OLAP DUPLICATE KEY(`id`) COMMENT '数组JSON测试' DISTRIBUTED BY HASH(`id`) BUCKETS 3 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "is_being_synced" = "false", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" ); select a.id,a.array_int,a.json1 from db_demos.t_json_array a union select b.id,b.array_int,b.json1 from db_demos.t_json_array b : errCode = 2, detailMessage = Doris hll, bitmap, array, map, struct, jsonb column must use with specific function, and don't support filter, group by or order by. please run 'help hll' or 'help bitmap' or 'help array' or 'help map' or 'help struct' or 'help jsonb' in your mysql client. ### What You Expected? Union support JSON and arrays ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
