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 | pok at 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 101111-4 | CVR 28 98 88 42 IBAN DK9881090001011114 | Swiftcode JYBADKKK
dbWriteTable(con, access_log, overwrite = F).....
2 messages · Poul Kristensen, Milan Bouchet-Valat
Le lundi 16 janvier 2012 ? 14:14 +0100, Poul Kristensen a ?crit :
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?
I don't know anything about this function, but from its documentation, it seems you forgot to pass a name for the table. Maybe something like that would work: dbWriteTable(con, "access_log", access_log, overwrite = F) Cheers