LinhongLiu commented on a change in pull request #26134: [SPARK-29486][SQL]
CalendarInterval should have 3 fields: months, days and microseconds
URL: https://github.com/apache/spark/pull/26134#discussion_r335418684
##########
File path: sql/core/src/test/resources/sql-tests/results/ansi/interval.sql.out
##########
@@ -238,7 +238,7 @@ from interval_arithmetic
-- !query 17 schema
struct<tsval:timestamp,CAST(tsval - interval 14 weeks 1 days 11 hours 22
minutes 33 seconds 123 milliseconds 456 microseconds AS
TIMESTAMP):timestamp,CAST(tsval - interval -14 weeks -1 days -11 hours -22
minutes -33 seconds -123 milliseconds -456 microseconds AS
TIMESTAMP):timestamp,CAST(tsval + interval 14 weeks 1 days 11 hours 22 minutes
33 seconds 123 milliseconds 456 microseconds AS TIMESTAMP):timestamp,CAST(tsval
+ interval -14 weeks -1 days -11 hours -22 minutes -33 seconds -123
milliseconds -456 microseconds AS TIMESTAMP):timestamp,CAST(tsval + (- interval
14 weeks 1 days 11 hours 22 minutes 33 seconds 123 milliseconds 456
microseconds) AS TIMESTAMP):timestamp,CAST(tsval + interval 14 weeks 1 days 11
hours 22 minutes 33 seconds 123 milliseconds 456 microseconds AS
TIMESTAMP):timestamp>
-- !query 17 output
-2012-01-01 00:00:00 2011-09-23 13:37:26.876544 2012-04-09
12:22:33.123456 2012-04-09 12:22:33.123456 2011-09-23 13:37:26.876544
2011-09-23 13:37:26.876544 2012-04-09 12:22:33.123456
+2012-01-01 00:00:00 2011-09-23 12:37:26.876544 2012-04-09
11:22:33.123456 2012-04-09 11:22:33.123456 2011-09-23 12:37:26.876544
2011-09-23 12:37:26.876544 2012-04-09 11:22:33.123456
Review comment:
as you know it's caused by daylight saving
----------------------------------------------------------------
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:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
