You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "Habeeb556 (via GitHub)" <gi...@apache.org> on 2023/11/04 22:12:52 UTC
[I] sqllab with duplicate column name in inner join [superset]
Habeeb556 opened a new issue, #25862:
URL: https://github.com/apache/superset/issues/25862
When query one table no issue, but when query two tables with inner join and the table duplicated in the column names, sql editor didn't identify that and I got the below error.
### Actual results
And I need to add alias name `SELECT bi.id as id1, bd.* FROM obs.bill bi inner join obs.billdetails bd ...`
### Expected results
For large tables with a lot of columns, I need to mention all columns. So, I am wondering if there is an auto solution from SuperSet SQL Lab, like having a SQL developer generate a default name?
#### Screenshots
### Environment
(please complete the following information):
- browser type and version:
- superset version: `1.4.1`
- python version: `3.8.3`
--
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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] SQL lab with duplicate column name in inner join [superset]
Posted by "Habeeb556 (via GitHub)" <gi...@apache.org>.
Habeeb556 closed issue #25862: SQL lab with duplicate column name in inner join
URL: https://github.com/apache/superset/issues/25862
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] SQL lab with duplicate column name in inner join [superset]
Posted by "Habeeb556 (via GitHub)" <gi...@apache.org>.
Habeeb556 commented on issue #25862:
URL: https://github.com/apache/superset/issues/25862#issuecomment-1966716449
Solved in superset version 2.1.3
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org