[R] R strange behaviour when building huge concatenation
Jagat.K.Sheth at wellsfargo.com
Jagat.K.Sheth at wellsfargo.com
Wed Nov 28 16:31:58 CET 2012
The buffer limit is an X11/xterm issue, not an R problem.
Regarding your main motivation to read data from a db, several options exist for communication between R and relational database management systems - RODBC, RJDBC, RMySQL, ROracle, RPostgreSQL, RSQLite, RMonetDB, ...
In the R Data Import/Export Manual have a look at the section on relational databases
http://cran.r-project.org/doc/manuals/r-release/R-data.html#Relational-databases
Cheers,
Jagat
> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> project.org] On Behalf Of angeloimm
> Sent: Wednesday, November 28, 2012 2:12 AM
> To: r-help at r-project.org
> Subject: Re: [R] R strange behaviour when building huge concatenation
>
> Hello John
> Thank you for the tips
> I already tried by using RKWard and RStudio and I got the same
> error...so I
> passed to the R console
> Maybe it's the buffer limit but, since I'm really newbie to R, I'ld
> like to
> know how to configure this limit
> In any case in my application I'ld like to avoid to write data in a csv
> file (by using java) and then use R in order to import these
> data....I'ld
> like to read data from DB and then pass them to R (well it'ld be good
> also
> if R read data from DB...but I'm afraid I can do a great mistake in
> handling connection and so on in R and my time is really short)
> Is there any way in order to read data from db (in Java) and pass all
> the
> data to R without write them in a csv file?
>
> Thank you to all you
> Cheers,
> Angelo
>
>
> 2012/11/27 John Kane [via R] <ml-node+s789695n4651040h45 at n4.nabble.com>
>
> > I am currently getting the very strange results that if I paste your
> > orginal data from your first message into my R terminal I get the
> same
> > errors you do. By the way that ";" is not needed in R.
> >
> > If I paste the same data into Rstudo, either into the editor or the
> > console it works fine.
> >
> > If I paste the data into gedit and send it to the console it works
> fine
> > but if I paste it into the gedita console I get your error messages
> again.
> > A quick try, pasting it into an R buffer in EMACS seems to work just
> fine.
> >
> > I have no idea what is happening unless jagat.k.sheth is correct and
> we
> > are hitting a buffer limit of some kind.
> >
> > I'd suggest getting a decent editor and going with it. Working
> directly
> > in an R terminal is enough to drive most people crazy.
> >
> > Any of the editiors/ides mentioned above are good with different
> > strengtsts etc. At a guess, Rstudio is the easiest to install and
> get
> > running on Ubuntu, gedit is pretty easy but you need to install the r
> gedit
> > plug-in. EMACS as far as I can tell is very good and very powerful
> but I
> > have not used it enough to really comment on it.
> >
> > In any case one way or the other they can read in the data. I'd also
> > suggest not even 'thinking' about writing a vector statement that
> long. It
> > would be much easier to do something like write the numbers in a
> column in
> > a spreadsheet and import from there. There are various ways to do
> this but
> > the simplist would be to just save the file as a csv file and import
> it
> > using read.table or read.csv.
> >
> > I'm sorry that I cannot be of more help. Perhaps one of the R gurus
> can
> > comment on the possible buffer problem.
> >
> > John Kane
> > Kingston ON Canada
> >
> >
> > > -----Original Message-----
> > > From: [hidden
> email]<http://user/SendEmail.jtp?type=node&node=4651040&i=0>
> > > Sent: Tue, 27 Nov 2012 07:04:13 -0800 (PST)
> > > To: [hidden
> email]<http://user/SendEmail.jtp?type=node&node=4651040&i=1>
> > > Subject: Re: [R] R strange behaviour when building huge
> concatenation
> > >
> > > Hello John
> > > It seems correct to me too but in my R console it seems to not be
> > working
> > > Here there is what I did:
> > > i copied the statement on one row (leaving and removing the final
> > useless
> > > semi colomn)
> > > i tried to execute it in the R console (in order to open my R
> console I
> > > simply opened a terminal window on my ubuntu machine and I typed
> "R")
> > > when I click "enter" the inserted statement doesn't not run...I
> simply
> > > see
> > > the cursor on a new line and this new line starts with "+"
> > >
> > > Here there is a little stack of what I see on my terminal:
> > > , 1, 1, 2, 2, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 17,
> 2, 2,
> > > 0,
> > > 2, 0, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0,
> 1, 0,
> > > 0,
> > > 1, 0, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 7, 0, 0, 1, 0, 0, 3, 0,
> 0, 2,
> > > 4,
> > > 0, 1, 0, 0, 0, 0, 2, 1, 0, 4, 2, 0, 0, 1, 3, 0, 0, 1, 0, 0, 1, 0,
> 1, 1,
> > > 0,
> > > 0, 0, 0, 0, 0, 0, 0, 0, 2, 3, 0, 1, 0, 1, 1, 3, 3, 0, 0, 0, 0, 1,
> 0, 2,
> > > 0,
> > > 1, 0, 0, 0, 1, 1, 0, 2, 0, 2, 0, 3, 0, 4, 0, 1, 1, 0, 0, 1, 0, 3,
> 0, 0,
> > > 0,
> > > 1, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 3, 0, 6, 0, 0, 0, 0, 3, 0, 0, 0,
> 2, 5,
> > > 0,
> > > 1, 0, 0, 1, 0, 1, 0, 0, 2, 0, 1, 2, 0, 0, 7, 0, 0, 2, 0, 2, 2, 0,
> 0, 0,
> > > 0,
> > > 0, 2, 0, 8, 0, 0, 5, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 3, 0, 2, 0, 0,
> 0, 2,
> > > 1,
> > > 0, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 2, 0, 0, 1, 0, 1, 2, 0, 0, 1, 0,
> 2, 0,
> > > 0,
> > > 3, 0, 0, 0, 1, 0, 0, 0, 1, 0, 9, 3, 0, 0, 0, 0, 0, 0, 3, 0, 0, 2,
> 0, 1,
> > > 1,
> > > 1, 0, 0, 0, 2, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0,
> 0, 0,
> > > 0,
> > > 1, 4, 0, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 2, 0,
> 1, 0,
> > > 0,
> > > 6, 0, 0, 0, 0, 1, 0, 0, 2, 6, 0, 1, 0, 0, 0, 0, 2, 0, 7, 0, 1, 2,
> 1, 1,
> > > 1,
> > > 0, 0, 1, 5, 0, 1, 0, 0, 2, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 1, 0,
> 5, 1,
> > > 0,
> > > 1, 2, 0, 0, 1, 2, 0, 1, 0, 2, 0, 1, 2, 7, 1, 2, 0, 0, 0, 5, 0, 4,
> 0))
> > > +
> > > +
> > > +
> > > +
> > > +
> > >
> > > Each time i click enter i go on a new line starting with "+"
> > > Then if i start in tying some character I get an error like this:
> > >
> > > +
> > > +
> > > + q
> > > +
> > > + q
> > > Errore: unexpected symbol in:
> > > "
> > > q"
> > >
> > > Sometimes this error (Errore: unexpected symbol in:) appears in the
> > > statement execution
> > >
> > > Here there are my sessionInfo() result:
> > >> sessionInfo()
> > > R version 2.14.1 (2011-12-22)
> > > Platform: i686-pc-linux-gnu (32-bit)
> > >
> > > locale:
> > > [1] LC_CTYPE=it_IT.UTF-8 LC_NUMERIC=C
> > > [3] LC_TIME=it_IT.UTF-8 LC_COLLATE=it_IT.UTF-8
> > > [5] LC_MONETARY=it_IT.UTF-8 LC_MESSAGES=it_IT.UTF-8
> > > [7] LC_PAPER=C LC_NAME=C
> > > [9] LC_ADDRESS=C LC_TELEPHONE=C
> > > [11] LC_MEASUREMENT=it_IT.UTF-8 LC_IDENTIFICATION=C
> > >
> > > attached base packages:
> > > [1] stats graphics grDevices utils datasets methods
> base
> > >
> > >
> > > I really don't know why this happens....above all because it seems
> to me
> > > a
> > > very very simple statement...
> > > Thank to all you for the support
> > >
> > >
> > >
> > >
> > > --
> > > View this message in context:
> > >
> > http://r.789695.n4.nabble.com/R-strange-behaviour-when-building-huge-
> concatenation-tp4650817p4650970.html
> > > Sent from the R help mailing list archive at Nabble.com.
> > >
> > > ______________________________________________
> > > [hidden email]
> <http://user/SendEmail.jtp?type=node&node=4651040&i=2>mailing list
> > > https://stat.ethz.ch/mailman/listinfo/r-help
> > > PLEASE do read the posting guide
> > > http://www.R-project.org/posting-guide.html
> > > and provide commented, minimal, self-contained, reproducible code.
> >
> > ____________________________________________________________
> > FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!
> >
> > ______________________________________________
> > [hidden email]
> <http://user/SendEmail.jtp?type=node&node=4651040&i=3>mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> > http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
> >
> >
> > ------------------------------
> > If you reply to this email, your message will be added to the
> discussion
> > below:
> >
> > http://r.789695.n4.nabble.com/R-strange-behaviour-when-building-huge-
> concatenation-tp4650817p4651040.html
> > To unsubscribe from R strange behaviour when building huge
> concatenation, click
> >
> here<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsub
> scribe_by_code&node=4650817&code=YW5nZWxvaW1tQGdtYWlsLmNvbXw0NjUwODE3fC
> 04MTM3OTMwMDg=>
> > .
> >
> NAML<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro
> _viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespac
> es.BasicNamespace-nabble.view.web.template.NabbleNamespace-
> nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%2
> 1nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-
> send_instant_email%21nabble%3Aemail.naml>
> >
>
>
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/R-strange-
> behaviour-when-building-huge-concatenation-tp4650817p4651094.html
> Sent from the R help mailing list archive at Nabble.com.
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-
> guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help
mailing list