yangzhg opened a new issue #6242:
URL: https://github.com/apache/incubator-doris/issues/6242
Currently, we have supported ARRAY type of syntax analysis, storage and
query, but if the array can be really used, it needs more work.
## Important Feature
Assuming that there is a table test, the data is as follows
```
+------+----------------+
| name | arr |
+------+----------------+
| abc | [1, 2, 3] |
+------+----------------+
1 row in set (0.01 sec)
```
- [ ] Subscript access: `select arr[0] from test` returns `1`
- [ ] array join: `SELECT name, arr from test ARRAY JOIN arr`
```
+------+-----+
| name | arr |
+------+-----+
| abc | 1 |
| abc | 2 |
| abc | 3 |
+------+-----+
3 rows in set (0.01 sec)
```
- [ ] Efficient contains function `select contains(arr, 1) from test`
- [ ] size function `select size(arr) from test`
- [ ] broker load, stream load, routine load support array type import
- [ ] Support importing parquet/orc file array type
## Other Feature
- [ ] Support nested array
- [ ] Support array as value column of AGG/unique table, support
repalce/append aggregation function
--
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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
