On 09/05/18 13:32, Mark Clements wrote:
Sjoerd: than you for your earlier guidance.
As a follow-up: first, can I write the random number functions to give a different value for each row (see example below)? Second, is there a
It may work if you declare the MAL function (rpois here) as "unsafe": unsafe command rpois(v:dbl) :dbl ... By default, functions are assumed to return the same value every time, so multiple calls with the same parameters can be removed. But if the function is unsafe, the optimizer knows this is an unsafe assumption.
simple pair type available - or is there a better way to return multiple columns (e.g. as per MADlib)?
MAL functions can return multiple values, including multiple BATs. If the BATs are aligned (same length, same hseqbase), the SQL layer can be coerced into turning the result into a SQL table. See e.g. the SQL function sys.storage() and its MAL implementation sql.storage in the MonetDB sources. Or is this not what you're asking?
Kindly, Mark.
On 05/08/2018 09:36 AM, Mark Clements wrote:
select rpois(100) from sys.generate_series(1,10); -- repeats the value
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sjoerd Mullender