dengziming commented on code in PR #51686:
URL: https://github.com/apache/spark/pull/51686#discussion_r2244465881
##########
sql/core/src/main/scala/org/apache/spark/sql/execution/datasources/v2/V2ScanRelationPushDown.scala:
##########
@@ -226,10 +195,54 @@ object V2ScanRelationPushDown extends Rule[LogicalPlan]
with PredicateHelper {
}
}
- def generateJoinOutputAlias(name: String): String =
- s"${name}_${java.util.UUID.randomUUID().toString.replace("-", "_")}"
+ private def generateColumnAliasesForDuplicatedName(
+ leftSideRequiredColumnNames: Array[String],
+ rightSideRequiredColumnNames: Array[String]
+ ): (Array[SupportsPushDownJoin.ColumnWithAlias],
+ Array[SupportsPushDownJoin.ColumnWithAlias]) = {
+ // Count occurrences of each column name across both sides to identify
duplicates.
+ val allRequiredColumnNames = leftSideRequiredColumnNames ++
rightSideRequiredColumnNames
+ val allNameCounts: Map[String, Int] =
+ allRequiredColumnNames.groupBy(identity).view.mapValues(_.size).toMap
Review Comment:
No, I thought they were case sensitive at first, but I tested locally and
found that SqlServer is not case sensitive, so I have updated this PR, please
review my latest commit and latest comment here:
https://github.com/apache/spark/pull/51686#issuecomment-3138451218
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
