[datatable-help] Fwd: Does it worth a feature request ?
Matthew Dowle
mdowle at mdowle.plus.com
Tue Mar 26 12:11:52 CET 2013
Hi,
Yes, please file it.
Auto converting x=='A' & y==23 to the
relevant join syntax internally might be possible in the distant furture
as well (declarative i rather than imperative i). And might be needed
sooner rather than later depending on how we implement the syntax for
joining using secondary keys (creating set2key is the easy part).
Matthew
On 25.03.2013 08:52, stat quant wrote:
> Hello
data.tablers,
> I am aware of binary search using J in data.table
selects, this works for "AND" if your table is keyed by 2 columns like
>
> setkey(DT,x,y)
> DT[J('A',23),] DT[x=='A' & y==23] #but binary search
is much faster for big/large tables
>
> But does it work with "OR" ??
>
There is a post on SO along those lines
http://stackoverflow.com/questions/15597971/can-we-do-binary-search-in-data-table-with-or-select-queries
[1]
> What about a feature request ?
>
> Cheers
> Colin
Links:
------
[1]
http://stackoverflow.com/questions/15597971/can-we-do-binary-search-in-data-table-with-or-select-queries
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/datatable-help/attachments/20130326/6e583cd1/attachment.html>
More information about the datatable-help
mailing list