Re: Issue in using Monet/Python loader

On 29 Nov 2019, at 06:06, Kalaiarasi Gowtham kalaiarasigowthamcivil@gmail.com wrote:

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 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

You’re using Python 3, so you need to set embedpy3. Please try the following:

monetdb set embedpy=false <your db> monetdb set embedpy3=true <your db> monetdbd stop <you db> monetdbd start <you db>

With "monetdb get all”, you can get a list of all supported properties you can set.

- Jennie

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

---

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list