[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