Hi there, hope you are doing good.

We were trying to implement Monetdb/python i.e. embedded python and tried the following code but its giving an error. (We have tried it on Linux)

CREATE FUNCTION python_times_two(i INTEGER) RETURNS INTEGER LANGUAGE PYTHON {

    return i * 2

};

CREATE TABLE integers(i INTEGER);

INSERT INTO integers VALUES (1), (2), (3), (4), (5);

SELECT python_times_two(i) AS result FROM integers;

Error:

TypeException:user.s12_1[10]:'pyapi.eval' undefined in: X_18:int := pyapi.eval(0x7f051006a340:ptr,"{\n    return i * 2\n};":str,X_17:int);

Please help us on what should be done in order to code to work.

Also need clarification on  following points:

1. Does embedded R or embedded python work on windows?

2. Does it take data in memory  when we use machine learning with Numpy and Scikitlearn?

Awaiting for your response.

Warm Regards,

Ganesh Anbhule

Data Scientist