[R] dbWriteTable(con, access_log, overwrite = F).....

[Poul Kristensen]

I am new to R.

My goal is to make a crosstable from a Apache access.log, which I want
to load into PostgreSQL database at first to
learn more abour R and DBI and datatypes. When the I have got the
access.log in the database I will try to make the
crosstable!

Trying to load the Apache access.log into PostgreSQL I get an error.

dbWriteTable(con, access_log, overwrite = F);

returns

Error in .Internal(is.vector(x, mode)) : 'x' is missing?

Thanks

Poul

Poul Kristensen
IT-Konsulent / Consultant


Det Kongelige Bibliotek | The Royal Library IT-afdelingen |
Information Technology

P.O. Box 2149 | DK-1016 København K
tel +45 3347 4586 | p...@kb.dk | www.kb.dk


Besøgsadresse | Visiting address | Søren Kierkegaards Plads 1 Leveringsadresse
Delivery address | Christians Brygge 8 | 1219 København K

EAN 5798 000 79 52 97 | Bank 8109 10-4 | CVR 28 98 88 42 IBAN
DK988109000104 | Swiftcode JYBADKKK

__
R-help@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.

[R] unable to find an inherited method for function "make.db.names", for signature "character", "missing"

[Poul Kristensen]

Hi !

I am new to R and I am using Rstudio on Linux.

Have I missed some library() ?

and if so does anyone have the time to write which?

I am trying to create some PostqreSQL tables from comma separated files.

I am a bit surpriced that character is a problem. The missing value
could be NULL.


Thanks

Poul

__
R-help@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.

Re: [R] R help

[Poul Kristensen]

Hello Catarina Maia

I'm a beginner too!

And I ask questions and people are answering very kindly.
>From what I know up til now is that R is a competitor to the
very expensive SAS statistical software. R is free to use and is
developed by professors and Ph.d's.
As of my interest right now is R's interacting with databases like
PostgreSQL(free and opensource) and Oracle(_not_ free) getting
data in and out.
Furthermore I am trying to make R usefull handling Apachelogs.
R does not consume as much machine resources(RAM,CPU) as SAS software as
is faster handling "Big data".

I hope you are encouraged to stay with the list.

Regards
Poul


2012/1/18 Berend Hasselman :
>
> On 18-01-2012, at 12:53, Catarina Maia wrote:
>
>> hello!
>>
>> A few days ago I subscribed the R mailing list in order to ask for some
>> help. The thing is that now I am receiving a lot of mails with doubts from
>> other users but i am just a "R begginer" and i will not able to give useful
>> help.
>
> This is the purpose of a mailing list.
> You don't have to reply to those mails.
> Read and learn.
>
>> So,  i would like to quit the from the mainling list. I'm so sorry for
>> the inconvenience.
>>
>
> Go to the web page mentioned at the bottom of each mail to R-help. 
> https://stat.ethz.ch/mailman/listinfo/r-help
> Is the same page where you subscribed.
>
> Berend
>
>> best regards,
>>
>> Catarina Maia
>>
>>       [[alternative HTML version deleted]]
>>
>> __
>> R-help@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.
>
> __
> R-help@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.

__
R-help@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.