Michael, You should be using `CJ`. This is no different from the post from Garrett See http://lists.r-forge.r-project.org/pipermail/datatable-help/2014-June/002619.html just last week, IIUC.
Arun From: Michael Smith [email protected] Reply: Michael Smith [email protected] Date: June 21, 2014 at 9:40:17 AM To: [email protected] [email protected] Subject: [datatable-help] Self-Join: Potential Bug? I'm getting a warning when I run the following code in 1.9.2, dev-1.9.3-master, and dev-1.9.3-issue_700 (b/c I thought it looks similar to that issue, but it turns out it's different). In contrast, I do not get this warning in 1.8.10. Not sure whether this is a bug or whether I'm missing something: X <- data.table( structure(list(ID = c(45063L, 45066L, 45172L), date = structure(c(14548, 14487, 14395), class = "Date"), price = c(17.56, 12.49, 10.04 )), .Names = c("ID", "date", "price"), row.names = c(NA, -3L), class = "data.frame"), key = "ID,date") X[J(unique(ID), as.Date(c("2009-05-31", "2010-05-31")))] The data and the warning message look like this: > X ID date price 1: 45063 2009-10-31 17.56 2: 45066 2009-08-31 12.49 3: 45172 2009-05-31 10.04 > X[J(unique(ID), as.Date(c("2009-05-31", "2010-05-31")))] ID date price 1: 45063 2009-05-31 NA 2: 45066 2010-05-31 NA 3: 45172 2009-05-31 10.04 Warning message: In as.data.table.list(i) : Item 2 is of size 2 but maximum size is 3 (recycled leaving a remainder of 1 items) Thanks, M _______________________________________________ datatable-help mailing list [email protected] https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
_______________________________________________ datatable-help mailing list [email protected] https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
