Buggy attempt at MonetDB-rmath
I am trying to adapt MonetDB-gsl to use the rmath library. My code is at: https://github.com/mclements/MonetDB-rmath Under Ubuntu 16.04 LTS, I used: sudo apt install r-mathlib git clone https://github.com/mclements/MonetDB-rmath cd MonetDB-rmath make sudo make install // start up MonetDB server with a test database mclient -d test -s "select sys.pchisq(20.0,5.0);" This compiles but when I try "select sys.pchisq(20.0,5.0);" I get the error: SELECT: no such binary operator 'pchisq(decimal,decimal)' Any guidance would be appreciated. (You may ask why one would want to do this when one could use embedded R - I wanted to see how fast and easy it was to use the rmath library.) Kindly, Mark.
Without having looked at your code, have you tried it with a fresh database? The scripts in the .../createdb directory are executed only once when a new database is created. On 2018-05-03 08:51, Mark Clements wrote:
I am trying to adapt MonetDB-gsl to use the rmath library. My code is at: https://github.com/mclements/MonetDB-rmath
Under Ubuntu 16.04 LTS, I used: sudo apt install r-mathlib git clone https://github.com/mclements/MonetDB-rmath cd MonetDB-rmath make sudo make install // start up MonetDB server with a test database mclient -d test -s "select sys.pchisq(20.0,5.0);"
This compiles but when I try "select sys.pchisq(20.0,5.0);" I get the error: SELECT: no such binary operator 'pchisq(decimal,decimal)'
Any guidance would be appreciated.
(You may ask why one would want to do this when one could use embedded R - I wanted to see how fast and easy it was to use the rmath library.)
Kindly, Mark. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sjoerd Mullender
Ah, a beginner's mistake! Destroying and re-creating the database did the trick. Is there any way to re-execute those scripts on an existing database? It would be useful for development of extensions. Kindly, Mark. On 05/03/2018 03:39 PM, Sjoerd Mullender wrote:
Without having looked at your code, have you tried it with a fresh database? The scripts in the .../createdb directory are executed only once when a new database is created.
On 2018-05-03 08:51, Mark Clements wrote:
I am trying to adapt MonetDB-gsl to use the rmath library. My code is at: https://github.com/mclements/MonetDB-rmath
Under Ubuntu 16.04 LTS, I used: sudo apt install r-mathlib git clone https://github.com/mclements/MonetDB-rmath cd MonetDB-rmath make sudo make install // start up MonetDB server with a test database mclient -d test -s "select sys.pchisq(20.0,5.0);"
This compiles but when I try "select sys.pchisq(20.0,5.0);" I get the error: SELECT: no such binary operator 'pchisq(decimal,decimal)'
Any guidance would be appreciated.
(You may ask why one would want to do this when one could use embedded R - I wanted to see how fast and easy it was to use the rmath library.)
Kindly, Mark. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
They are just SQL queries that you can execute (as user monetdb), but beware that if something is created (a function or a table, for instance), they will already exist if you execute those queries again, so you may need to drop them first. One way to execute the queries is just mclient -d$DATABASE -umonetdb .../createdb/script.sql On 2018-05-03 16:30, Mark Clements wrote:
Ah, a beginner's mistake! Destroying and re-creating the database did the trick.
Is there any way to re-execute those scripts on an existing database? It would be useful for development of extensions.
Kindly, Mark.
On 05/03/2018 03:39 PM, Sjoerd Mullender wrote:
Without having looked at your code, have you tried it with a fresh database? The scripts in the .../createdb directory are executed only once when a new database is created.
On 2018-05-03 08:51, Mark Clements wrote:
I am trying to adapt MonetDB-gsl to use the rmath library. My code is at: https://github.com/mclements/MonetDB-rmath
Under Ubuntu 16.04 LTS, I used: sudo apt install r-mathlib git clone https://github.com/mclements/MonetDB-rmath cd MonetDB-rmath make sudo make install // start up MonetDB server with a test database mclient -d test -s "select sys.pchisq(20.0,5.0);"
This compiles but when I try "select sys.pchisq(20.0,5.0);" I get the error: SELECT: no such binary operator 'pchisq(decimal,decimal)'
Any guidance would be appreciated.
(You may ask why one would want to do this when one could use embedded R - I wanted to see how fast and easy it was to use the rmath library.)
Kindly, Mark. _______________________________________________ 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
-- Sjoerd Mullender
participants (2)
-
Mark Clements -
Sjoerd Mullender