Non equi joins Q on SO

Arun Srinivasan edited this page Nov 18, 2017 · 26 revisions

This is an internal list for me to get an idea of the type of Q that come up often, and how many Q could potentially benefit from non-equi joins.. (+ aggregate/update feature of data.table). These are the Q I've come across so far.

Date Link Type
29.06.2014 http://stackoverflow.com/q/24480031/559784
01.10.2014 http://stackoverflow.com/q/26134707/559784
21.10.2014 http://stackoverflow.com/q/26482559/559784
15.11.2014 http://stackoverflow.com/q/26944565/559784
21.11.2014 https://stackoverflow.com/q/27059924/3817004 replace combn() by non-equi join
01.10.2015 http://stackoverflow.com/q/32893022/559784
24.11.2015 http://stackoverflow.com/q/33905020/559784
22.02.2016 http://stackoverflow.com/q/35565149/559784 range join, nomatch=0L
01.03.2016 http://stackoverflow.com/q/35713958/559784 range join, nomatch=0L
23.03.2016 http://stackoverflow.com/q/36190921/559784
29.03.2016 http://stackoverflow.com/q/36284173/559784
06.04.2016 http://stackoverflow.com/q/36454565/559784
10.04.2016 http://stackoverflow.com/q/36533139/559784
09.06.2016 http://stackoverflow.com/q/37727617/559784
22.06.2016 http://stackoverflow.com/q/37978658/559784
22.06.2016 http://stackoverflow.com/q/37956665/559784 range join
24.06.2016 http://stackoverflow.com/q/38017753/559784
25.06.2016 http://stackoverflow.com/q/37163070/559784
27.06.2016 http://stackoverflow.com/q/38061961/559784
30.06.2016 http://stackoverflow.com/q/38112514/559784 >, mult="first"
10.07.2016 http://stackoverflow.com/q/38297148/559784
12.07.2016 http://stackoverflow.com/q/38327158/559784
12.07.2016 http://stackoverflow.com/q/38333140/559784
18.07.2016 http://stackoverflow.com/q/38433873/559784
18.07.2016 http://stackoverflow.com/q/38426821/559784
18.07.2016 http://stackoverflow.com/q/38424301/559784
18.07.2016 http://stackoverflow.com/q/38432826/559784
19.07.2016 http://stackoverflow.com/q/38445864/559784
20.07.2016 http://stackoverflow.com/q/38479187/559784 range join
24.07.2016 http://stackoverflow.com/q/38542811/559784 range join
26.07.2016 http://stackoverflow.com/q/38594118/559784 range join
27.07.2016 http://stackoverflow.com/q/38617840/559784 interval join, mult="first", which=TRUE
29.07.2016 http://stackoverflow.com/q/38649349/559784 >, by=.EACHI
29.07.2016 http://stackoverflow.com/q/38661284/559784 range join, .N, by=.EACHI
07.10.2016 http://stackoverflow.com/q/39917890/559784 multiple conditions, by=.EACHI
14.10.2016 http://stackoverflow.com/q/40052232/559784 range join
18.10.2016 http://stackoverflow.com/q/40111264/559784 multiple conditions, :=
21.10.2016 http://stackoverflow.com/q/40180244/559784 range join, nomatch=0L
14.11.2016 http://stackoverflow.com/q/40583186/559784 non-equi join, PERFORMANCE (TODO)
17.11.2016 http://stackoverflow.com/q/40658775/559784 non-equi join, feature request (TODO)
19.11.2016 http://stackoverflow.com/q/40689539/559784 multiple conditions
02.12.2016 http://stackoverflow.com/q/40932231/559784 non-equi join, #1991 Fixed 🐞 (TODO)
06.12.2016 http://stackoverflow.com/q/41007099/559784 multiple conditions, by=.EACHI, nomatch=0L
07.12.2016 http://stackoverflow.com/q/41024867/559784 multiple conditions
08.12.2016 http://stackoverflow.com/q/41043047/559784 multiple conditions, nomatch=0L
15.12.2016 http://stackoverflow.com/q/41164723/559784 multiple conditions, :=
22.12.2016 http://stackoverflow.com/q/41279229/559784 multiple conditions
03.01.2017 http://stackoverflow.com/q/41450543/559784 multiple conditions, by=.EACHI
08.01.2017 http://stackoverflow.com/q/41537187/559784 multiple conditions, by=.EACHI
12.01.2017 http://stackoverflow.com/q/41615967/559784 multiple conditions, by=.EACHI
13.01.2017 http://stackoverflow.com/q/41641813/559784 multiple conditions, by=.EACHI
13.01.2017 http://stackoverflow.com/q/41637736/559784 multiple conditions, nomatch=0L
14.01.2017 http://stackoverflow.com/q/41644471/559784 range join, by=.EACHI
16.01.2017 http://stackoverflow.com/q/41684012/559784 >=, by=.EACHI
16.02.2017 http://stackoverflow.com/q/42274151/559784 non-equi join, by=.EACHI, multiple conditions
16.03.2017 http://stackoverflow.com/q/42833132/559784 non-equi join, by=.EACHI, multiple conditions
24.03.2017 http://stackoverflow.com/a/42994872/559784 range join
28.03.2017 http://stackoverflow.com/q/43072063/559784 non-equi join, by=.EACHI, allow.cartesian=TRUE, FR
30.03.2017 http://stackoverflow.com/q/43106465/559784 non-equi, by=.EACHI, multiple conditions
03.04.2017 http://stackoverflow.com/q/43180227/559784 non equi join, update by reference
21.09.2017 https://stackoverflow.com/q/46339638/3817004 range join, multiple conditions
17.10.2017 https://stackoverflow.com/q/46800031/3817004 range join, by=.EACHI
28.10.2017 https://stackoverflow.com/q/46985193/3817004 non-equi join, by=.EACHI, nomatch=0L
02.11.2017 https://stackoverflow.com/q/47054497/3817004 replace combn() by non-equi join
09.11.2017 https://stackoverflow.com/q/47195329/559784 multiple conds, by=.EACHI
10.11.2017 https://stackoverflow.com/q/47220223/559784 multiple conds
13.11.2017 https://stackoverflow.com/q/47249098/559784 multiple conds, mult="last"
14.11.2017 https://stackoverflow.com/q/47281855/559784 range join, by=.EACHI
14.11.2017 https://stackoverflow.com/q/47281089/559784 range join (not strictly), update by reference
17.11.2017 https://stackoverflow.com/q/47336129/559784 non-equi, 1 condition, allow.cartesian and by=.EACHI
17.11.2017 https://stackoverflow.com/q/47327214/559784 range join, allow.cartesian and by=.EACHI versions
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.