Hello,
I am trying to write a subquery that can serve as a poor man's median function.
However I am running into issues every angle I try and cannot find any details
about this in the docs or list archives.
Question 1:
Currently I can calculate the median manually as two steps:
sql> select c
> Ok, this error indicates that the server is running, but
> the sql module
> has not been properly loaded (it may not have finished
> loading).
Interesting. Is there a way I can make merovingian not return until modules are
loaded? This way I can put the commands in succession like I have them a
> Please look into your merovingian.log file, it will contain
> more
> information why the database "does not allow
> connections".
The logs simply have this:
error.log:
TME 2008-06-17 16:06:43
ERR merovingian[941]: client error: database 'mydb' does not allow connections
msg.log:
TME 2008-06
Hello,
I have a start up script as part of a server image that runs the first time a
new instance of the server is started.
It performs the following:
# start the monetdb server
/usr/bin/merovingian
# create and start the db
monetdb create mydb
monetdb st
I am using the nightly stable build of monetdb5. All outside of perl->monetdb
seems to be working just fine. I just can't get perl to talk to the db.
Here's what I did:
- installed from nightly stable source on Fedora 8
- copied the source from
http://homepages.cwi.nl/~mk/MonetDB/The-Perl-Li
I am building Monetdb using the stable nightly builds.
I would like to write queries against Monetdb using PHP. I came across this in
the docs and have two questions about it:
The unix configure process normally tries to detect if you have PHP including
developer packages insta
To get a median I want to use this:
select myIntCol from mytable order by myIntCol limit half_table_size,1;
This works in mySQL. However I get an error when I use limit with x,y params.
If I just use limit x then it limits the return results to just x rows. But
what I need to do is tell it to
Hi - I use a SSH client to access my Fedora 8 core box. When I was using the
RELEASE built I was able to use left/right/up/down/home/end keys within mclient
to edit the line. For instance I could push up arrow to have it automatically
cycle through the previous lines, and then use left arrow t
> Great. Then it is exactly what I thought: a bug I already
> solved. You
> can interchange the jdbcclient.jar with your
> monetdb-jdbc-1.X.jar file.
> The former contains the latter, and in your case, the
> latter is
> outdated.
Thank you - I'm using your jdbcclient.jar instead of the 1.7 drive
When working with RELEASE version of MonetDB5 every once in a while I would
enter in a bad query into mclient and it would crash the entire server hard -
it would not even reboot.
I did notice, however, that in the nightly stable release this same issue is
handled better, in that it no longer c
Does the very latest version of MonetDB support built-in queries for the
mathematical standard deviation and variance functions stdev() and var()? When
I try these queries it returns "no such unary operator".
I was under the impression that these were fairly standard in the SQL syntax so
I am
> > If I run merovingian and then try to connect to my
> database using JDBC through my Java app, I get this error
> returned by JDBC:
> >
> >"Maximum number of redirects reached, aborting
> connection attempt. Sorry."
>
> Please run:
> java -jar jdbcclient.jar --database=yourdb -Xdebug
> he
I found that the nightly stable build of MonetDB5/sql apparently does not like
empty values in tbl text records for importing when using Copy Into, even
though the field is defined to allow nulls.
This is different behavior compared to the RELEASE version, which did allow
this.
Please allow me
OK I have a strange problem that I have FINALLY narrowed down and hoping
someone can help me resolve please.
I am using the latest stable nightly MonetDB5 with SQL on Fedora core 8.
If I run merovingian and then try to connect to my database using JDBC through
my Java app, I get this error retu
>
> There should be a ".vaultkey" file as well when
> created with `monetdb`.
> Merovingian uses that file.
>
Thanks. I edited that file by deleting what was there, and replacing it simply
with "monetdb" (without the quotes). Then I saved it off. Then I restart
merovingian but it still says
> Are you sure no dbs exist? Have you removed your entire
> dbfarm?
Yes I am certain because I am starting with a fresh clean build image for the
server. This image has our base installation of our application without any
monetdb every being installed.
> > 2) run the .sh to install / build f
> in each database dir in the dbfarm, there is a file
> (*.secret I think)
> that stores the secret, which is exactly the argument that
> merovingian
> passes to mserver5.
Thank you! That is what I've been trying to figure out.
And so it passes the value in the .secret file as the password that
> username/password properly for jdbc when using merovingian.
> I realize that is not related to this bug, but something
> I'll need to understand once the bug is fixed so
> I'd like to know this in advance. Thank you.
>
> either: use a new database (or remove the old one), or use
> merovingian
> merovingian sets the vault key, the thing that mserver5
Sets it to what exactly? And where is it set? A cryptic message in the .conf
says something.secret is for mserver5 but ignored if using merovingian, but
then does not go on to say what you are supposed to do/set if ineed using
merovngian
> > The problem with the JDBC driver is that when running
> with merovingian I get:
> >Maximum number of redirects reached, aborting
> connection attempt. Sorry.
>
> Please try with
> http://www.ins.cwi.nl/~monet/tars/latest/stable/jdbcclient.jar
> and file
> a bug if the problem persists.
H
> This sounds indicative enough to me that it is not our
> software at
> fault. However, what would be interesting to know is if
> when you kill
> merovingian manually (as in: not in the shutdown sequence)
> does the same
> problem happen?
It may have indeed been a bug in MonetDB because when I u
> This is to be expected, since databases created with
> monetdb/merovingian
> are not compatible with manually started databases.
> Merovingian adds a
> layer of security to your databases, using an encryption
> key.
>
Thanks. I asked on the list previously but did not see any answer - can some
>Probably you aren't but the binpkgs you use are. You'll probably have
>less frustrations at this point if you just compile from source, using
>the monetdb-install.sh script. What seems wrong here is that the
>default path is set to the builddir instead of the target dir.
Thanks for the suggesti
Its been a day of great frustration trying to get this going so I hope someone
will have some ideas here.
I decided to take a shot at upgrading just by running yum again pointing at the
stable night - the upgrade process appeared to run just fine.
However it was all downhill from there. Once I
OK this is very odd...
I do this:
mkdir -p /mnt/MonetDB5/dbfarm
merovingian
monetdb create demo
monetdb start demo
and then start mclient:
mclient -lsql --time --database=demo
at that point everything is just fine and I can enter sql commands and all
works great. I am using the default monet
I am running a server instance under Amazon EC2 with MonetDB 5 (latest released
version) installed.
If I boot up the instance and do NOT start or use Monetdb, then I can issue a
reboot command at any time, and the system reboots just fine and comes back up.
However if I issue the commands:
mkd
I have a Java app that needs to write single inserts into the db in an
extremely fast manner (it is receiving data in real time, and buffering it,
then doing single inserts to feed the data into the db as fast as it will
insert it). I am doing this using JDBC and this resides on the same physic
Hi - how can I tell how much disk storage space on of my tables is using?
I tried one rough way but not sure if it is accurate. Basically I did a linux
du command and looked at the farmdb dir root, then imported about 2M rows, then
looked a tthe du number again. But it only went up about 1.5MB
Any ideas why the following query would result in a division by zero exception?
sql> select prodcode, avg(price) from sales group by prodcode;
!ArithmeticException:batcalc./:Division by zero
Timer 24326.296 msec 0 rows
Thank you.
I was going crazy trying to figure out why my COPY RECORDS command wasn't
working. Turns out it is caused from funny (encoded?) characters in the string
for one of the fields.
For instance one of the fields contained this "?a?as?e??, 18 ?a??? 2001
10:24:00 pµ"
How did the data get this way? W
Hi - I have an int column with several million rows of data. What is the
fastest way to write a query to get the median value of the column? Apparently
there is no median() function in SQL. A web search revealed lots of various
talk about using stored procedures and fancy functions. None of
31 matches
Mail list logo
