[
https://issues.apache.org/jira/browse/ARROW-10732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17240287#comment-17240287
]
Andy Grove commented on ARROW-10732:
------------------------------------
Thanks [~nevi_me] and [~alamb] for the feedback so far. I am working on a PR
now and I think I have a workable approach.
In the SQL Planner, instead of dealing directly with LogicalPlan, I have
introduced SQLRelation which is a wrapper for LogicalPlan that also contains
name/alias information, and SQLSchema, which is a wrapper for Schema along with
name/alias information.
This isolates the SQL aliasing to the SQL planner, which seems to make sense.
> [Rust] [DataFusion] Add SQL support for table/relation aliases and compound
> identifiers
> ---------------------------------------------------------------------------------------
>
> Key: ARROW-10732
> URL: https://issues.apache.org/jira/browse/ARROW-10732
> Project: Apache Arrow
> Issue Type: New Feature
> Components: Rust - DataFusion
> Affects Versions: 3.0.0
> Reporter: Andy Grove
> Assignee: Andy Grove
> Priority: Major
>
> We need to support referencing columns in queries using table name and/or
> alias prefixes so that we can support use cases such as joins between tables
> that have duplicate column names.
> For example:
> {code:java}
> SELECT t1.id, t1.name, t2.name FROM t1 JOIN t2 ON t1.id = t2.id {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
