Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug - data table join doesnt work #5324

Closed
vk111 opened this issue Feb 3, 2022 · 3 comments
Closed

Bug - data table join doesnt work #5324

vk111 opened this issue Feb 3, 2022 · 3 comments

Comments

@vk111
Copy link

vk111 commented Feb 3, 2022

Unfortunately I cannot create any reproducible example

The issue is:

dt1 - 100 cols, 50000 rows
dt2 - 2 cols (character): a, b

dt1[dt2, a := i.a, on=.(c = b)] - it doesnt work, c - character column

I have found out that it works only when I run
dt1 = dt1[, 1:length(colnames(dt1))]
before join

#1 doesnt work
dt1[dt2, a := i.a, on=.(c = b)]

#2 works
dt1 = dt1[, 1:length(colnames(dt1))]
dt1[dt2, a := i.a, on=.(c = b)]

It happens not always - I just found one place in my code where it behaves like this
I dont know what can I add just if you have any guesses please let me know

Thanks

data.table_1.10.4-3

platform x86_64-w64-mingw32
arch x86_64
os mingw32
system x86_64, mingw32
status
major 3
minor 4.0
year 2017
month 04
day 21
svn rev 72570
language R
version.string R version 3.4.0 (2017-04-21)

@OfekShilon
Copy link
Contributor

Perhaps you can save and attach the offending dt's?

@ben-schwen
Copy link
Member

First thing to try would be to update data.table to 1.14.3 since 1.10.4 is already 4 years old.

@MichaelChirico
Copy link
Member

@vk111 as mentioned your version of data.table is quite old. We are happy to try and help if you can reproduce your issue on the current version of data.table. It will be much easier to provide help if you can provide a reproducible example. Please re-open at your discretion.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants