lvshaokang commented on issue #17806: URL: https://github.com/apache/doris/issues/17806#issuecomment-1469417711
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 -- 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
