Skip to content

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