Re: Monetdb on windows with embedded python 3.6

Hi Mark, The library I want to use is pystan and as you can check it requires python 3.5 or higher: http://pystan.readthedocs.io/en/latest/windows.html You mentioned earlier that you may add support in future version, do you have an estimate for this. Thanks On Fri, Aug 11, 2017 at 2:55 PM, imad hajj chahine < imad.hajj.chahine@gmail.com> wrote:

Thank you, Mark.

On Fri, Aug 11, 2017 at 2:06 PM, Mark Raasveldt wrote:

...

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 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\mon etdb5\lib_pyapi.dll'): !SyntaxException:parseError: !<identifier> expected

Thank you.

On Thu, Aug 10, 2017 at 5:51 PM, Ying Zhang 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