Yukang-Lian commented on issue #17806: URL: https://github.com/apache/doris/issues/17806#issuecomment-1469467881
> Hi @Yukang-Lian , I found a description of this function in clickhouse[1], but it doesn't support null values in arrays, so I think we should discuss whether to handle `NULL` values, for example: > > ``` > case 1. contains null & null as 0 > SELECT array_cum_sum_noneg([1, NULL, -4, 1]) AS res > except: 1 1 0 1 > > case 2. contains null & null as null > SELECT array_cum_sum_noneg([1, NULL, -4, 1]) AS res > except: 1 NULL NULL NULL > > case 3. contains null & throw unsupport exception > SELECT array_cum_sum_noneg([1, NULL, -4, 1]) AS res > except: throw unsupport exception > ``` > > so, what do you think of which case more reasonable? > > [1] https://clickhouse.com/docs/en/sql-reference/functions/array-functions/#arraycumsumnonnegativearr I don't quiet sure, maybe you can contact @xiaokang or @eldenmoon for some help. -- 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
