Exception Error

Erie, Rob rob.erie at jmfamily.com
Thu Apr 7 12:43:34 CEST 2016

I am in the process of evaluating databases for analysis at my
organization.  I have installed MonetDB and loaded some data.  I was
attempting to compare results both in performance and accuracy between
MySQL and MonetDB.  I have been receiving Overflow in Calculation errors
from MonetDB.  I am a total novice with MonetDB.

Here is the information about my system:
Red Hat Enterprise Linux Server release 7.2 (Maipo) (Linux
3.10.0-327.el7.x86_64 #1 SMP Thu Oct 29 17:29:29 EDT 2015 x86_64 x86_64
x86_64 GNU/Linux)
MySQL Server version: 5.7.11-log MySQL Community Server
Java version "1.8.0_74"; Java(TM) SE Runtime Environment (build
1.8.0_74-b02); Java HotSpot(TM) 64-Bit Server VM (build 25.74-b02, mixed
Apache Tomcat 7.0.54
Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015-SP3)
Database: MonetDB v11.21.17 (Jul2015-SP3),

Issue Description:  I would like to know the correlation between two
variables group by a variable.

select milageRange, sys.corr(numberOfTheseParts,avgHomeValue) FROM
aPartsByZipRange INNER JOIN avgHomeValueZipPeriod ON zipCode = zip where
numberOfTheseParts <> 0 and avgHomeValue <>0 group by milageRange;

TypeException:user.s78_2[44]:'aggr.subcorr' undefined in:
X_75:bat[:any,:int] :=
program contains errors

This e-mail transmission contains information intended only for the use of 
the recipient(s) named above. Further, it contains information that may be 
privileged and confidential.  If you are not the intended recipient, you 
are hereby notified that any dissemination, distribution, or copying of 
this message (including any attachments) is strictly prohibited.  If you 
have received this e-mail in error, please notify the sender by reply 
e-mail and then delete this message from your mail system. Thank you for 
your compliance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20160407/694e856a/attachment.html>

More information about the users-list mailing list