yaooqinn commented on a change in pull request #26412: [SPARK-29774][SQL] Date
and Timestamp type +/- null should be null as Postgres
URL: https://github.com/apache/spark/pull/26412#discussion_r352598951
##########
File path:
sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/Analyzer.scala
##########
@@ -246,6 +247,54 @@ class Analyzer(
CleanupAliases)
)
+ /**
+ * 1. Turns Add/Subtract of DateType/TimestampType/StringType and
CalendarIntervalType
Review comment:
Update a bit
```scala
/**
* For [[UnresolvedAdd]]:
* 1. If one side is timestamp/date/string and the other side is interval,
turns it to
* [[TimeAdd]];
* 2. else if one side is date, turns it to [[DateAdd]] ;
* 3. else turns it to [[Add]].
*
* For [[UnresolvedSubtract]]:
* 1. If the left side is timestamp/date/string and the right side is an
interval, turns it to
* [[TimeSub]];
* 2. else if one side is timestamp and the other side is date/timestamp,
turns it to
* [[SubtractTimestamps]];
* 3. else if both side are dates, turns it to
[[DateDiff]]/[[SubtractDates]];
* 4. else if the left side is date, turns it to [[DateSub]];
* 5. else turns it to [[Subtract]].
*
* For [[UnresolvedMultiply]]:
* 1. If one side is interval and the other side is numeric, turns it to
[[MultiplyInterval]];
* 2. otherwise, turns it to [[Multiply]].
*
* For [[UnresolvedDivide]]:
* 1. If the left side is interval and the right side is numeric, turns it
to
* [[DivideInterval]];
* 2. otherwise, turns it to [[Divide]].
*/
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
