[
https://issues.apache.org/jira/browse/DRILL-7926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17376323#comment-17376323
]
ASF GitHub Bot commented on DRILL-7926:
---------------------------------------
dzamo commented on pull request #2268:
URL: https://github.com/apache/drill/pull/2268#issuecomment-875319179
The current AGE function is completely half-baked, look at the transcript
below. A total replacement is the surely the best route and further attempts
at calendar arithemetic using DateUtilities are probably inadvisable. Can
`java.time` not provide what Joda is being used for in this first version of a
fix?
```
apache drill> select age('2021-01-01', '2021-01-01');
+---------------------------------+
| EXPR$0 |
+---------------------------------+
| 0 years 0 months 0 days 0:00:00 |
+---------------------------------+
1 row selected (0.179 seconds)
apache drill> select age('2021-02-01', '2021-01-01');
+-------------------------------+
| EXPR$0 |
+-------------------------------+
| 0 years 1 month 1 day 0:00:00 |
+-------------------------------+
1 row selected (0.159 seconds)
apache drill> select age('2021-03-01', '2021-01-01');
+---------------------------------+
| EXPR$0 |
+---------------------------------+
| 0 years 1 month 29 days 0:00:00 |
+---------------------------------+
1 row selected (0.158 seconds)
apache drill> select age('2022-01-01', '2021-01-01');
+--------------------------------+
| EXPR$0 |
+--------------------------------+
| 1 year 0 months 5 days 0:00:00 |
+--------------------------------+
1 row selected (0.12 seconds)
```
--
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]
> The " age " function is not working properly.
> ---------------------------------------------
>
> Key: DRILL-7926
> URL: https://issues.apache.org/jira/browse/DRILL-7926
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 1.17.0, 1.18.0
> Reporter: Александр Глухов
> Priority: Blocker
> Attachments: image-2021-05-13-16-17-21-154.png, screenshot-1.png,
> screenshot-2.png
>
>
> The " age " function is not working properly.
> *Playback steps*
> {code:sql}
> select extract(year from m. "years") `years` from (select age('2021-05-13',
> '2007-07-02') `years") m{code}
> *Expected result* 13.
> *Actual result* 14.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
