Hey Imad,

Unfortunately Python 3 support was never ported to Windows, and only works on Unix systems. By changing the Python directory as you are doing you are linking Python 2 code to the Python 3 libraries, which will not work and result in strange errors. There is no easy way to use Python 3 UDFs on Windows currently, although we may add support in a future version. Apologies for that.

Regards,

Mark

On 10 Aug 2017, at 18:48, imad hajj chahine <imad.hajj.chahine@gmail.com> wrote:

Hi Jennie,

Actually I tried to edit the file pyapi_locatepython.bat as it is called from the M5server.bat to handle python loading options.

Please note that i uninstalled python 2.7 and i only have python 3.6 installed.

new pyapi_locatepython.bat content:

set LOCALPYTHONHOME=C:\Python36

set LOCALPYTHONPATH=C:\Python36\Lib

IF defined LOCALPYTHONHOME (

    endlocal & (

        set PYTHONHOME=%LOCALPYTHONHOME%

        set PYTHONPATH=%LOCALPYTHONPATH%

        set MONETDBPYTHONUDF=embedded_py=true

        set "PATH=%LOCALPYTHONHOME%;%PATH%"

    )

) ELSE (

    @echo MonetDB/Python Disabled: Python 3.6 installation not found.

    endlocal

)

I am having this error:

!SyntaxException:parseError:

!LoaderException:loadLibrary:Loading error failed to open library pyapi (from wi

thin file 'C:\Program Files\MonetDB\MonetDB5\lib\monetdb5\lib_pyapi.dll'):

!SyntaxException:parseError:

!<identifier> expected

Thank you.

On Thu, Aug 10, 2017 at 5:51 PM, Ying Zhang <Y.Zhang@cwi.nl> wrote:

Hai Imad,

You can pass different values to the embedded_py option of mserver5:

--set embedded_py=2
--set embedded_py=3
--set embedded_py=true

Or if you use merovingian:
$ monetdb set embedded_py=2 <database name>
$ monetdb set embedded_py=3 <database name>
$ monetdb set embedded_py=true <database name>

The value 2 or 3 obviously tell mserver5 to use Python 2 or Python 3, respectively.  The value “true” will cause your default Python version to be loaded.

Does this help?

Best,
Jennie

> On 10 Aug 2017, at 09:52, imad hajj chahine <imad.hajj.chahine@gmail.com> wrote:
>
> Hi,
>
> I have been successfully using monetdb (11.25.3) on windows with embedded python 2.7, recently I needed a library that is only supported on python 3.6, is it possible somehow to point monetdb to the python 3.6 folder?
>
> I know this is possible on linux, but my dev environment is on windows.
>
> Thank you.

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

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

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

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