Hi Experts,

Assume I have a 2D array, with 2 dimensions X and Y. I’d like to do this:

for each X, count how many Ys are non-empty (or met certain condition), and store it in a 1D array with dimension X.

Something like this in SQL: select count(*) from mytable where condition=true group by X

Thanks

-Yushu