search for: netezza

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 s...

Full_Name: Kenneth Cater Version: 2.9.1 OS: Linux x86_64 Submission from: (NULL) (171.159.192.10) It appears that R closes my connection to the Netezza device before the Netezza has completed its return of data, below are two files clean_test.log which tracks the systems call made when running the test.r file, and clean_test.out which is the output generated when test.r is executed. Notice how the second select systems call times out before all t...

Is there a package or a command that does window aggregation like select sum(col1) over (partition by col2, col3 order by col4 rows between unbounded preceding and current row) as sum1 from table1 ; the above is Netezza syntax, but Postgre has same capability. Stephen B [[alternative HTML version deleted]]

...y so other people can access my system. Can I do that? Can someone either tell me how or point me in the right direction in the docs (which Samba tool would be used, for example)? Thanks! -- ----------------------------------------------------------------------------- Paul D. Smith <psmith@netezza.com> http://netezza.com "Please remain calm--I may be mad, but I am a professional."--Mad Scientist ----------------------------------------------------------------------------- These are my opinions--Netezza takes no responsibility for them.

I've been having some issues with sqlSave, and I think I've found an clue that may identify the problem. In the code at http://pastebin.com/vTAKt4bL<http://pastebin.com/W6UGKep9>, I connect to a Netezza instance, make a simple table, and query it. Despite sqlSave succeeding without error, sqlQuery tells me the table doesn't exist. Also, when I query the database outside of R, I see that the table doesn't exist. However, using sqlFetch works, and (perhaps, as expected) the table is droppe...

...th, Engineering, or related field. - Local candidates only (Bay Area). *Additional Qualifications (Nice to have):* - Some experience with other commercial data analysis packages such as SAS, SPSS, JMP, or Matlab. - Additional experience with one or more of the following: Hadoop, Netezza, Relational database management systems, Talend, Ab Initio, Python, Java, PMML, BI tools, web services, cloud computing. *Experience the energy and excitement of a start-up company with solid financial backing ??? * *join Revolution Analytics.* At a time when many companies are cutting back, w...

I've been having some issues with sqlSave, and I think I've found an clue that may identify the problem. In the code at http://pastebin.com/W6UGKep9, I connect to a Netezza instance, make a simple table, and query it. Despite sqlSave succeeding without error, sqlQuery tells me that the table doesn't exist. Also, when I query the database outside of R, I see that the table doesn't exist. However, using sqlFetch works, and (perhaps, as expected) the table is d...

...are some articles related to R from the month of March: New features in the latest version of ggplot2 include choropleths, violin plots, and improved annotations: http://bit.ly/wHYCbS A video demonstration of big-data Naive Bayes and Classification Tree models with Revolution R Enterprise for IBM Netezza: http://bit.ly/HylxcS A collection of two-minute video tutorials for R beginners: http://bit.ly/HylyO9 A bad infographic from Kony 2012 redrawn as a bar chart in R: http://bit.ly/HylxcT Sanjiv Das uses R to analyze when banks should modify distressed home loans, and which banks are still too big...

...ering team reviews the functions in the RevoScaleR package for Big Data: http://bit.ly/gaXChr Amanda Cox presented at the New Your R User Group on how the New York Times uses R for visualization, and you can watch it on video: http://bit.ly/gJM5tH Revolution Analytics announces a partnership with Netezza, to bring R to the TwinFin data warehouse appliance: http://bit.ly/dTuIqD Register your opinions about open-source software in the 2011 Future of Open Source Survey: http://bit.ly/dZG5Oy Robert Muenchen has updated his analysis of popularity of data analysis software, featuring R: http://bit.ly/e...

...of R in industry: http://bit.ly/KLbHzr Bob Muenchen has updated his list of R package equivalents to SAS and SPSS procedures: http://bit.ly/KLbHzt A history of Data Science, including Bill Cleveland's 2001 paper: http://bit.ly/KLbHzs Researchers at SUNY Buffalo are using Revolution R and IBM Netezza with genetic data to research a cure for Multiple Sclerosis http://bit.ly/KLbJY5 , and the story has been reported in Forbes, eWeek and other media: http://bit.ly/KLbJY4 Pairach Piboonrungroj has compiled a list of 20 free R tutorials from around the world: http://bit.ly/KLbJY3 The annual Rmetric...

...able for viewing online: http://bit.ly/neExPe How to speed up R "for" loops by recoding the body in C++ with help from the Rcpp package: http://bit.ly/qGcopC A review of the June edition of the R Journal: http://bit.ly/os5KAe Revolution Analytics demonstrated integrating R with the IBM Netezza data warehouse appliance at the EnZee Universe conference: http://bit.ly/nC3nYi The blog Heuristically Andrew ran some benchmarks of Revolution R for data mining applications: http://bit.ly/pepJ65 A brief overview of the changes in R 2.13.1: http://bit.ly/nhTxac Other non-R-related stories in th...

...or music, design, art, game and many other kinds of projects: http://bit.ly/oxmVgU We congratulate Uwe Ligges on joining the R Core Group: http://bit.ly/nrgSSS A couple of fun applications of R: reading XKCD comics, and creating an animated elephant from complex numbers: http://bit.ly/rgWVJm IBM Netezza sings the praises of R: http://bit.ly/pHRHBi We profile Jeff Ryan, creator of the xts and quantmod packages: http://bit.ly/oVQNPW The program for useR! 2011 at the University of Warwick includes five talks from the Revolution Analytics team: http://bit.ly/oImIkX InformationWeek looks at Revoluti...

...ey link between the source of our raw data and the analytics team. Our data can come from many different sources in different formats and has often had minimal cleaning or processing before we receive it. The data providers often provide it as flat files though are moving to holding data on ORACLE, Netezza and other platforms. Our analytics team comprises machine learning specialists, biostatisticians and epidemiologists. Key attributes are good interpersonal skills and an ability to communicate clearly, experience with a relational database management package such as MySQL and familiarity with the L...

Hi, I am new to xen and needed some help doing a networking setup on xen. I am using a Centos host with the xen modules installed. I have created a dom1 which contains another centos machine. I want the interface eth1 of dom1 to receive all traffic that is seen for eth0 on the physical machine. The interfaces of dom1 are bridged to xenbr0. I have set eth1 to promiscuous mode on dom1. On doing an