Exception Error

Martin Kersten martin.kersten at cwi.nl
Thu Apr 7 12:48:53 CEST 2016

Corr() is *not* a predefined operation

On 07/04/16 12:47, Martin Kersten wrote:
> Hi
> Corr() is a predefined operation in MonetDB/SQL.
> There are functional difference between the two systems you are comparing.
> See:
> https://www.monetdb.org/Documentation/Manuals/SQLreference/Features/Compability
> regards, Martin
> On 07/04/16 12:43, Erie, Rob wrote:
>> 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 mode).
>> Apache Tomcat 7.0.54
>> Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015-SP3)
>> Database: MonetDB v11.21.17 (Jul2015-SP3), 'mapi:monetdb://ip-10-153-0-5.ec2.internal:50000/set_mktng'
>> Issue Description:  I would like to know the correlation between two variables group by a variable.
>> SQL:
>> select milageRange, sys.corr(numberOfTheseParts,avgHomeValue) FROM aPartsByZipRange INNER JOIN avgHomeValueZipPeriod ON zipCode = zip where numberOfTheseParts <> 0 and avgHomeValue <>0 group by milageRange;
>> Error:
>> TypeException:user.s78_2[44]:'aggr.subcorr' undefined in:     X_75:bat[:any,:int] := aggr.subcorr(X_72:bat[:oid,:int],X_74:bat[:oid,:int],X_67:bat[:oid,:oid],r1_67:bat[:oid,:oid],true:bit);
>> 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.
>> _______________________________________________
>> users-list mailing list
>> users-list at monetdb.org
>> https://www.monetdb.org/mailman/listinfo/users-list
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

More information about the users-list mailing list