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