30 May
2016
30 May
'16
2:37 p.m.
Hello,
I have the following query:
CREATE TABLE mytable AS ( SELECT <fields….> 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