<div dir="ltr">I figure it means that -- if I set2key(DT,V1,V2) -- you store the integer vectors order(V1), order(V1,V2) ...(are both needed?)...with the object and somehow use that information to permit the use of the secondary key just like (from the user's perspective) the primary key (joining on it with appropriate syntax, automatically speeding up anything ending in by='V1,V2' or by=V1 and whatever else).<div>
<br></div><div>Matt says in the FR: "<span style="color:rgb(68,68,68);font-family:verdana,sans-serif;font-size:14px;line-height:16px">add secondary order vectors as attribute to DT"</span></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Wed, Oct 9, 2013 at 12:04 AM, Chinmay Patil <span dir="ltr"><<a href="mailto:chinmay.patil@gmail.com" target="_blank">chinmay.patil@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">I just used the terminology that was used in issue <a href="https://r-forge.r-project.org/tracker/index.php?func=detail&aid=1007&group_id=240&atid=978" target="_blank">https://r-forge.r-project.org/tracker/index.php?func=detail&aid=1007&group_id=240&atid=978</a> by Matt.<div>
<br></div><div>Essentially, it would mean that whole table is also pre-sorted by some other column than it's primary key and that sort order is also saved. Perhaps, Matt would shed some light on it?</div></div><div class="HOEnZb">
<div class="h5"><div class="gmail_extra">
<br><br><div class="gmail_quote">On Wed, Oct 9, 2013 at 11:56 AM, Eduard Antonyan <span dir="ltr"><<a href="mailto:eduard.antonyan@gmail.com" target="_blank">eduard.antonyan@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<p dir="ltr">I understand the problem you want solved (fast search by e.g. second key element), but I don't understand what secondary keys would mean/be...?</p><div><div>
<div class="gmail_quote">On Oct 8, 2013 10:48 PM, "Chinmay Patil" <<a href="mailto:chinmay.patil@gmail.com" target="_blank">chinmay.patil@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Eduard, <div><br></div><div>Details of the issue raised are in this question.</div><div><br></div><div><a href="http://stackoverflow.com/questions/15769837/" target="_blank">http://stackoverflow.com/questions/15769837/</a><br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Oct 8, 2013 at 10:47 PM, Eduard Antonyan <span dir="ltr"><<a href="mailto:eduard.antonyan@gmail.com" target="_blank">eduard.antonyan@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I don't think I understand what secondary keys are (supposed to be), can someone who knows please elaborate?</div>
<div class="gmail_extra"><br><br><div class="gmail_quote"><div><div>On Sun, Oct 6, 2013 at 12:17 AM, Chinmay Patil <span dir="ltr"><<a href="mailto:chinmay.patil@gmail.com" target="_blank">chinmay.patil@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">Hi devs,<div><br></div><div>I was wondering if there are any plans to implement this feature. </div>
<div>
<br></div><div><a href="https://r-forge.r-project.org/tracker/index.php?func=detail&aid=1007&group_id=240&atid=978" target="_blank">https://r-forge.r-project.org/tracker/index.php?func=detail&aid=1007&group_id=240&atid=978</a><br>
</div><div><br></div><div>Alternatively, is there a way to refer to key of the data.table object in "J" function used for subsetting?</div></div>
<br></div></div>_______________________________________________<br>
datatable-help mailing list<br>
<a href="mailto:datatable-help@lists.r-forge.r-project.org" target="_blank">datatable-help@lists.r-forge.r-project.org</a><br>
<a href="https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help" target="_blank">https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help</a><br></blockquote></div><br></div>
</blockquote></div><br></div>
</blockquote></div>
</div></div></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
datatable-help mailing list<br>
<a href="mailto:datatable-help@lists.r-forge.r-project.org">datatable-help@lists.r-forge.r-project.org</a><br>
<a href="https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help" target="_blank">https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help</a><br></blockquote></div><br></div>