[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:
nz.corr(intable="JMF_TEST_LOOP2",x="PAGE_REFRESH_ID",
y="PAGE_REFRESH_ID2",outtable="JMF_TEST_LOOP3")
but I receive the following error:
Error in nz.corr(intable = "JMF_TEST_LOOP2", x = "PAGE_REFRESH_ID", y =
"PAGE_REFRESH_ID2", :
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