embedded R function not working

30 May 2016

      Hello,

I have the following query:

CREATE TABLE mytable AS
(
    SELECT 
    FROM
        table1 AS a,
        my_R_function(a.field1, ...) AS asd
    WHERE <some conditions>

)   WITH DATA;

MonetDB says:
	SELECT: no such column ‘a.field1’

The issue is in how I call the R function, since when I remove it everything’s just fine.
My aim is to call the function for each row of table1. The new table will have a couple of fields from table1 and a bunch of other fields computed from the R function. How am I supposed to do that?

Thank you,

Stefano

embedded R function not working

Stefano Fioravanzo