heronshoes commented on issue #15287:
URL: https://github.com/apache/arrow/issues/15287#issuecomment-1378781524
I think it will work as long as C++ join() is correct :-)
```ruby
left = Arrow::Table.new(KEY: ["A", "B", nil], X1: [1, 2, 3])
right = Arrow::Table.new(KEY: ["A", "C", nil], X2: [4, 5, 6])
left.join(right, :KEY, type: :left_outer)
#=>
#<Arrow::Table:0x116f5d158 ptr=0x7fa61e50bc50>
KEY X1 KEY X2
0 A 1 A 4
1 B 2 (null) (null)
2 (null) 3 (null) (null)
left.join(right, :KEY, type: :right_outer)
#=>
#<Arrow::Table:0x116f51bf0 ptr=0x7fa61e50bd40>
KEY X1 KEY X2
0 A 1 A 4
1 (null) (null) C 5
2 (null) (null) (null) 6
left.join(right, :KEY, type: :full_outer)
#=>
#<Arrow::Table:0x116f18378 ptr=0x7fa61e06f0e0>
KEY X1 KEY X2
0 A 1 A 4
1 B 2 (null) (null)
2 (null) 3 (null) (null)
3 (null) (null) C 5
4 (null) (null) (null) 6
left.join(right, :KEY, type: :inner)
#=>
#<Arrow::Table:0x11a048128 ptr=0x7fa61d5edd10>
KEY X1 KEY X2
0 A 1 A 4
left.join(right, :KEY, type: :left_semi)
#=>
#<Arrow::Table:0x11a0ea748 ptr=0x7fa61d531cb0>
KEY X1
0 A 1
left.join(right, :KEY, type: :right_semi)
#=>
#<Arrow::Table:0x11a0e2c00 ptr=0x7fa61d581190>
KEY X2
0 A 4
left.join(right, :KEY, type: :left_anti)
#=>
#<Arrow::Table:0x11a0cbb40 ptr=0x7fa61e3dde50>
KEY X1
0 B 2
1 (null) 3
left.join(right, :KEY, type: :right_anti)
#=>
#<Arrow::Table:0x11a0c56f0 ptr=0x7fa61e3ddee0>
KEY X2
0 C 5
1 (null) 6
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscr...@arrow.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
