Hey Ganesh,
Did you enable embedded Python by starting the server with either "mserver5 --set embedded_py=true" or “monetdb set embedpy=true” as mentioned in the blogpost? You also need to install MonetDB/Python (on Linux there should be a package for it, or you can get it by compiling MonetDB with “--enable-pyintegration”. The startup messages of the server should contain “# MonetDB/Python module loaded”, otherwise something has gone wrong while loading.
On Windows, the module is included with the default installer but you need to install Python 2 using the standard installer for it to work. Also, Python 2 should have the NumPy library installed. Embedded R does not work on Windows.
Data will indeed be taken in memory when you use machine learning with NumPy/Sci-Kit learn.
Regards,
Mark
On 08 May 2017, at 10:40, Ganesh ganesh@g-square.in wrote:
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:
Does embedded R or embedded python work on windows?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
users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list https://www.monetdb.org/mailman/listinfo/users-list