Hi,

     While trying to use Monet/Python Loader function,we are getting the following error

pymonetdb.exceptions.OperationalError: 'pyapi.eval_loader' undefined in: pyapi.eval_loader(0x7f34f01f2c60:ptr, "{_emit.emit( { 'event_date': '2019-10-10', 'status': 1})};":str);

Followed the below steps for installation

Python installation steps:

            We have installed python 3.6

1)yum install autoconf

2)yum install automake

3)yum install libtool

4)yum install openssl

5)yum install openssl-devel

6)yum install python-devel

7)Configured environment path settings for python        

export PYTHONPATH=$PATH:/usr/local/lib/python3.6/site-packages

Monet installation steps:

1)git clone https://github.com/MonetDB/MonetDB.git

2)cd /MonetDB

3)./bootstrap

4)cd..

5)mkdir testdir

6)cd testdir

7)../MonetDB/configure --enable-pyintegration=yes

While configuring we get the following

py3integration is enabled

8)make

9)make install

10)monetdbd create /path/to/mydbfarm

11)monetdbd start /path/to/mydbfarm

12)monet stop -a

13)monet set embedpy=true

14)monet start -a

13)Enabled numpy(pip install numpy)

Created a loader by using the below python script

import pymonetdb

import sys

import os

connection = pymonetdb.connect(username="xyz", password="xyz123", hostname="ipaddress", database="testdb")

cursor = connection.cursor()

cursor.execute("CREATE LOADER myloader() LANGUAGE PYTHON {_emit.emit( { 'event_date': '2019-10-10', 'status': 1})};") #create loader

cursor.execute("COPY LOADER INTO store FROM myloader();") #append the row from loader to table

connection.commit()

While running the above script getting the following error

pymonetdb.exceptions.OperationalError: 'pyapi.eval_loader' undefined in: pyapi.eval_loader(0x7f34f01f2c60:ptr, "{_emit.emit( { 'event_date': '2019-10-10', 'status':1})};":str);

Please, help us to fix this issue.

Thanks & Regards

Kalaiarasi A