[
https://issues.apache.org/jira/browse/ARROW-14417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jonathan Keane resolved ARROW-14417.
------------------------------------
Fix Version/s: (was: 7.0.0)
6.0.0
Resolution: Fixed
Issue resolved by pull request 11503
[https://github.com/apache/arrow/pull/11503]
> [R] Joins ignore projection on left dataset
> -------------------------------------------
>
> Key: ARROW-14417
> URL: https://issues.apache.org/jira/browse/ARROW-14417
> Project: Apache Arrow
> Issue Type: Bug
> Components: R
> Reporter: Neal Richardson
> Assignee: Neal Richardson
> Priority: Major
> Labels: pull-request-available, query-engine
> Fix For: 6.0.1, 6.0.0
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> {code}
> left <- Table$create(
> one = c("a", "b"),
> two = 1:2
> )
> right <- Table$create(
> three = TRUE,
> dos = 2L
> )
> left %>%
> rename(dos = two)
> # InMemoryDataset (query)
> # one: string
> # dos: int32
> # See $.data for the source Arrow object
> left %>%
> rename(dos = two) %>%
> left_join(right)
> # InMemoryDataset (query)
> # one: string
> # dos: int32
> # three: bool
> # See $.data for the source Arrow object
> left %>%
> rename(dos = two) %>%
> left_join(right) %>%
> collect()
> # Error: Invalid: No match or multiple matches for key field reference
> FieldRef.Name(dos) on left side of the join
> # ../src/arrow/compute/exec/hash_join_node.cc:95 ValidateSchemas(join_type,
> left_schema, left_keys, left_output, right_schema, right_keys, right_output,
> left_field_name_prefix, right_field_name_prefix)
> # ../src/arrow/compute/exec/hash_join_node.cc:311 schema_mgr->Init(
> join_options.join_type, *(inputs[0]->output_schema()),
> join_options.left_keys, join_options.left_output,
> *(inputs[1]->output_schema()), join_options.right_keys,
> join_options.right_output, join_options.output_prefix_for_left,
> join_options.output_prefix_for_right)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
