richtia commented on issue #10815:
URL: https://github.com/apache/datafusion/issues/10815#issuecomment-2155139457
> > same column names with different aliases
>
> Isn't the repro trying to alias _different column names_ (PS_PARTKEY,
PS_SUPPKEY) to _same alias_ (K1)? Why would you want to do that? 😅
Ahh...that was my mistake. One of those should be k2. I was trying to get
a more simple repro of a much larger query with multiple joins. However...now
that I have a more proper query, I am running into a different issue.
This is the query I have now:
```
SELECT p1.PS_PARTKEY supp_key, p2.PS_PARTKEY cust_key
FROM
'partsupp' p1,
'partsupp' p2
```
And this is the substrait error from that:
```
DataFusion error: NotImplemented("Unsupported operator: CrossJoin:\\n
SubqueryAlias: p1\\n TableScan: partsupp projection=[ps_partkey]\\n
SubqueryAlias: p2\\n TableScan: partsupp projection=[ps_partkey]")')
```
So the original issue that I was hitting was datafusion trying to run a
substrait plan generated from DuckDB. And the error from that is the same
error as I put in the description.
--
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...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
