Exception Error

Erie, Rob rob.erie at jmfamily.com
Thu Apr 7 13:06:15 CEST 2016


Stefan,

One point to add is that I am using AWS.

Thanks,
Rob


*--*

Rob Erie
Manager, Enterprise Competency Center

JMSC
700 Jim Moran Blvd
Deerfield Beach, FL 33442
p: 954-418-5239
c: 561-985-3716



Please consider the environment before printing this e-mail.

On Thu, Apr 7, 2016 at 6:54 AM, Stefan Manegold <Stefan.Manegold at cwi.nl>
wrote:

> Hi,
>
> this is a bug --- either we should support corr() correctly,
> or we should given a proper error message that we do not support it.
>
> Please file a bug report via http://bugs.monetdb.org/
>
> Thanks!
>
> Stefan
>
> ----- On Apr 7, 2016, at 12:43 PM, Erie, Rob rob.erie at jmfamily.com 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
>
> --
> | Stefan.Manegold at CWI.nl | DB Architectures   (DA) |
> | www.CWI.nl/~manegold/  | Science Park 123 (L321) |
> | +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>

-- 
--------------------------------------------------
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/9c416de2/attachment.html>


More information about the users-list mailing list