[R] Using R with Netezza

rusernetezza jferraro at edmunds.com
Thu Feb 16 00:36:59 CET 2012

We've recently installed a Netezza server and I am trying to integrate the R
GUI with this server and run functions using the server itself.  I am able
to successfully connect to the server, but cannot get any of the
Netezza-specific R functions to work that exist in the package called "nza".

Specifically I am trying to start with a simple function from this package,
for example "nz.corr".

I am typing the syntax as given in the manual as follows:
nz.corr(intable="mytable", X="x", Y="y", outtable="anothertable")
Here is my syntax:

but I receive the following error:

Error in nz.corr(intable = "JMF_TEST_LOOP2", x = "PAGE_REFRESH_ID", y =
  unused argument(s) (x = "PAGE_REFRESH_ID", y = "PAGE_REFRESH_ID2")

I've tried many combinations of syntax using lowercase/uppercase,
single/double quotes, with and without the x=, y= references, etc., but I
still get the same error.

Has anyone worked with this "nza" package and have any advice on the syntax?

One other question I have that may or may not be related is - is the
"outtable" something that can exist in Netezza or does it have to exist in
R?  Also, I'm assuming the "outtable" is a table that has not already been
created - is that a correct assumption?

Thanks for any help you can give.

View this message in context: http://r.789695.n4.nabble.com/Using-R-with-Netezza-tp4392417p4392417.html
Sent from the R help mailing list archive at Nabble.com.

More information about the R-help mailing list