simo

Show grants in version 2.3 can't display authentication information

1

## Enhancement In version 2.3, the `show grants` command can't display authentication information anymore. We need another way to check those information.

[Doc] add the max role number and depth to User_privilege.md

2

## Why I'm doing: ## What I'm doing: Fixes #issue ## What type of PR is this: - [ ] BugFix - [ ] Feature - [ ] Enhancement -...

[Doc] add two privilege FE config

2

## Why I'm doing: ## What I'm doing: Fixes #issue ## What type of PR is this: - [ ] BugFix - [ ] Feature - [ ] Enhancement -...

[function] inverse_normal_cdf and normal_cd

1

in trino's compatibility issues, we need the following functions. https://trino.io/docs/current/functions/math.html?highlight=normal_cdf#normal_cdf inverse_normal_cdf(mean, sd, p) → double[#](https://trino.io/docs/current/functions/math.html?highlight=normal_cdf#inverse_normal_cdf) Compute the inverse of the Normal cdf with given mean and standard deviation (sd) for...

function any_value doesn't support array<map>

3

``` StarRocks > select id,any_value(value) from anyvalue; ERROR 1064 (HY000): Getting analyzing error from line 1, column 10 to line 1, column 25. Detail message: No matching function with signature:...

[Good First Issue]StarRocks Hands-on Tasks 2024

7

Hi Rockstars, This is a list of proposed Hands-on tasks. If you're new to StarRocks and eager to engage with the community, here are some issues that are well-suited for...

[window function] array_agg in window function

2

starrocks support array_agg as a agg function. https://docs.starrocks.io/docs/sql-reference/sql-functions/array-functions/array_agg/ but starrocks doesn't support it as a window function

[function]cardinality(HLL)

1

StarRocks support hll_cardinality https://docs.starrocks.io/docs/sql-reference/sql-functions/scalar-functions/hll_cardinality/ however, in trino's compatibility, trino support hll type's cardinality in function cardinality(). if starrocks support hll input in cardinality(), it will make starrocks be more compatible...

function rand(seed) cannot return fixed result. ``` StarRocks > select rand(1); +---------------------+ | rand(1) | +---------------------+ | 0.18517100684872181 | +---------------------+ 1 row in set (0.00 sec) StarRocks > select rand(1);...