[jira] [Commented] (DRILL-7781) NearestDate function returns an incorrect result when calculating the quarter
[
https://issues.apache.org/jira/browse/DRILL-7781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17183674#comment-17183674
]
ASF GitHub Bot commented on DRILL-7781:
---
cgivre commented on pull request #2098:
URL: https://github.com/apache/drill/pull/2098#issuecomment-679458929
Thanks for the fix.
LGTM +1
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
> NearestDate function returns an incorrect result when calculating the quarter
> -
>
> Key: DRILL-7781
> URL: https://issues.apache.org/jira/browse/DRILL-7781
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.16.0, 1.17.0
>Reporter: Oleg Zinoviev
>Priority: Major
>
> ||SQL||Expected||Actual||
> |nearestDate('2019-03-01 00:00:00', 'quarter')|2019-01-01 00:00:00|2019-04-01
> 00:00:00|
> |nearestDate('2019-06-01 00:00:00', 'quarter')|2019-04-01 00:00:00|2019-07-01
> 00:00:00|
> |nearestDate('2019-09-01 00:00:00', 'quarter')|2019-07-01 00:00:00|2019-10-01
> 00:00:00|
> |nearestDate('2019-12-01 00:00:00', 'quarter')|2019-10-01 00:00:00|SYSTEM
> ERROR: DateTimeException: Invalid value for MonthOfYear (valid values 1 -
> 12): 13|
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Commented] (DRILL-7784) Add Abhishek's GPG Keys
[ https://issues.apache.org/jira/browse/DRILL-7784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17183547#comment-17183547 ] Abhishek Girish commented on DRILL-7784: - Public GPG Keys signed by Vova - Uploaded to https://dist.apache.org/repos/dist/release/drill/KEYS by Vova > Add Abhishek's GPG Keys > --- > > Key: DRILL-7784 > URL: https://issues.apache.org/jira/browse/DRILL-7784 > Project: Apache Drill > Issue Type: Sub-task >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Closed] (DRILL-7784) Add Abhishek's GPG Keys
[ https://issues.apache.org/jira/browse/DRILL-7784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-7784. -- > Add Abhishek's GPG Keys > --- > > Key: DRILL-7784 > URL: https://issues.apache.org/jira/browse/DRILL-7784 > Project: Apache Drill > Issue Type: Sub-task >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Resolved] (DRILL-7784) Add Abhishek's GPG Keys
[ https://issues.apache.org/jira/browse/DRILL-7784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish resolved DRILL-7784. Resolution: Fixed > Add Abhishek's GPG Keys > --- > > Key: DRILL-7784 > URL: https://issues.apache.org/jira/browse/DRILL-7784 > Project: Apache Drill > Issue Type: Sub-task >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (DRILL-7784) Add Abhishek's GPG Keys
Abhishek Girish created DRILL-7784: -- Summary: Add Abhishek's GPG Keys Key: DRILL-7784 URL: https://issues.apache.org/jira/browse/DRILL-7784 Project: Apache Drill Issue Type: Sub-task Reporter: Abhishek Girish Assignee: Abhishek Girish -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7782) Update the copyright year in NOTICE
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7782: --- Parent: DRILL-7783 Issue Type: Sub-task (was: Task) > Update the copyright year in NOTICE > --- > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Sub-task > Components: Tools, Build Test >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Labels: ready-to-commit > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2019, we should update it to 2020. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7783) Apache Drill 1.18.0 Release Activities
[ https://issues.apache.org/jira/browse/DRILL-7783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7783: --- Description: Source - https://github.com/apache/drill/blob/master/docs/dev/Release.md 1.18.0 Dashboard: https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12335942 Kanban Board - https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=185 was: Source - https://github.com/parthchandra/drill/wiki/Drill-Release-Process 1.17.0 Dashboard - https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333934 Kanban Board - https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=185 > Apache Drill 1.18.0 Release Activities > -- > > Key: DRILL-7783 > URL: https://issues.apache.org/jira/browse/DRILL-7783 > Project: Apache Drill > Issue Type: Task >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Fix For: 1.18.0 > > > Source - https://github.com/apache/drill/blob/master/docs/dev/Release.md > 1.18.0 Dashboard: > https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12335942 > Kanban Board - > https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=185 -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Assigned] (DRILL-7783) Apache Drill 1.18.0 Release Activities
[ https://issues.apache.org/jira/browse/DRILL-7783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish reassigned DRILL-7783: -- Assignee: Abhishek Girish (was: Vova Vysotskyi) > Apache Drill 1.18.0 Release Activities > -- > > Key: DRILL-7783 > URL: https://issues.apache.org/jira/browse/DRILL-7783 > Project: Apache Drill > Issue Type: Task >Affects Versions: 1.17.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Fix For: 1.17.0 > > > Source - https://github.com/parthchandra/drill/wiki/Drill-Release-Process > 1.17.0 Dashboard - > https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333934 > Kanban Board - > https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=185 -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7783) Apache Drill 1.18.0 Release Activities
[ https://issues.apache.org/jira/browse/DRILL-7783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7783: --- Fix Version/s: (was: 1.17.0) 1.18.0 > Apache Drill 1.18.0 Release Activities > -- > > Key: DRILL-7783 > URL: https://issues.apache.org/jira/browse/DRILL-7783 > Project: Apache Drill > Issue Type: Task >Affects Versions: 1.17.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Fix For: 1.18.0 > > > Source - https://github.com/parthchandra/drill/wiki/Drill-Release-Process > 1.17.0 Dashboard - > https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333934 > Kanban Board - > https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=185 -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7783) Apache Drill 1.18.0 Release Activities
[ https://issues.apache.org/jira/browse/DRILL-7783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7783: --- Affects Version/s: (was: 1.17.0) 1.18.0 > Apache Drill 1.18.0 Release Activities > -- > > Key: DRILL-7783 > URL: https://issues.apache.org/jira/browse/DRILL-7783 > Project: Apache Drill > Issue Type: Task >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Fix For: 1.18.0 > > > Source - https://github.com/parthchandra/drill/wiki/Drill-Release-Process > 1.17.0 Dashboard - > https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333934 > Kanban Board - > https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=185 -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (DRILL-7783) Apache Drill 1.18.0 Release Activities
Abhishek Girish created DRILL-7783: -- Summary: Apache Drill 1.18.0 Release Activities Key: DRILL-7783 URL: https://issues.apache.org/jira/browse/DRILL-7783 Project: Apache Drill Issue Type: Task Affects Versions: 1.17.0 Reporter: Abhishek Girish Assignee: Vova Vysotskyi Fix For: 1.17.0 Source - https://github.com/parthchandra/drill/wiki/Drill-Release-Process 1.17.0 Dashboard - https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333934 Kanban Board - https://issues.apache.org/jira/secure/RapidBoard.jspa?rapidView=185 -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Closed] (DRILL-7782) Update the copyright year in NOTICE
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-7782. -- > Update the copyright year in NOTICE > --- > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Labels: ready-to-commit > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2019, we should update it to 2020. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Resolved] (DRILL-7782) Update the copyright year in NOTICE
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish resolved DRILL-7782. Resolution: Fixed > Update the copyright year in NOTICE > --- > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Labels: ready-to-commit > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2019, we should update it to 2020. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (DRILL-7782) Update the copyright year in NOTICE
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17183537#comment-17183537 ] ASF GitHub Bot commented on DRILL-7782: --- Agirish merged pull request #2100: URL: https://github.com/apache/drill/pull/2100 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 > Update the copyright year in NOTICE > --- > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Labels: ready-to-commit > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2019, we should update it to 2020. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7782) Update the copyright year in NOTICE
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7782: --- Reviewer: Vova Vysotskyi Labels: ready-to-commit (was: ) > Update the copyright year in NOTICE > --- > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Labels: ready-to-commit > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2019, we should update it to 2020. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (DRILL-7782) Update the copyright year in NOTICE
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17183536#comment-17183536 ] ASF GitHub Bot commented on DRILL-7782: --- Agirish opened a new pull request #2100: URL: https://github.com/apache/drill/pull/2100 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 > Update the copyright year in NOTICE > --- > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2019, we should update it to 2020. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7782) Update the copyright year in NOTICE
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7782: --- Summary: Update the copyright year in NOTICE (was: Update the copyright year in NOTICE.txt file) > Update the copyright year in NOTICE > --- > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2019, we should update it to 2020. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7782) Update the copyright year in NOTICE.txt file
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7782: --- Fix Version/s: (was: 1.16.0) 1.18.0 > Update the copyright year in NOTICE.txt file > > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.16.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Labels: ready-to-commit > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2018, we should update it to 2019. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7782) Update the copyright year in NOTICE.txt file
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7782: --- Description: Copyright year in NOTICE.txt file is until 2019, we should update it to 2020. (was: Copyright year in NOTICE.txt file is until 2018, we should update it to 2019.) > Update the copyright year in NOTICE.txt file > > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2019, we should update it to 2020. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7782) Update the copyright year in NOTICE.txt file
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7782: --- Affects Version/s: (was: 1.16.0) 1.18.0 > Update the copyright year in NOTICE.txt file > > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.18.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2018, we should update it to 2019. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7782) Update the copyright year in NOTICE.txt file
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7782: --- Reviewer: (was: Boaz Ben-Zvi) > Update the copyright year in NOTICE.txt file > > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.16.0 >Reporter: Abhishek Girish >Assignee: Sorabh Hamirwasia >Priority: Major > Labels: ready-to-commit > Fix For: 1.16.0 > > > Copyright year in NOTICE.txt file is until 2018, we should update it to 2019. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Assigned] (DRILL-7782) Update the copyright year in NOTICE.txt file
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish reassigned DRILL-7782: -- Assignee: Abhishek Girish (was: Sorabh Hamirwasia) > Update the copyright year in NOTICE.txt file > > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.16.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Labels: ready-to-commit > Fix For: 1.16.0 > > > Copyright year in NOTICE.txt file is until 2018, we should update it to 2019. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (DRILL-7782) Update the copyright year in NOTICE.txt file
[ https://issues.apache.org/jira/browse/DRILL-7782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-7782: --- Labels: (was: ready-to-commit) > Update the copyright year in NOTICE.txt file > > > Key: DRILL-7782 > URL: https://issues.apache.org/jira/browse/DRILL-7782 > Project: Apache Drill > Issue Type: Task > Components: Tools, Build Test >Affects Versions: 1.16.0 >Reporter: Abhishek Girish >Assignee: Abhishek Girish >Priority: Major > Fix For: 1.18.0 > > > Copyright year in NOTICE.txt file is until 2018, we should update it to 2019. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Created] (DRILL-7782) Update the copyright year in NOTICE.txt file
Abhishek Girish created DRILL-7782: -- Summary: Update the copyright year in NOTICE.txt file Key: DRILL-7782 URL: https://issues.apache.org/jira/browse/DRILL-7782 Project: Apache Drill Issue Type: Task Components: Tools, Build Test Affects Versions: 1.16.0 Reporter: Abhishek Girish Assignee: Sorabh Hamirwasia Fix For: 1.16.0 Copyright year in NOTICE.txt file is until 2018, we should update it to 2019. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (DRILL-7781) NearestDate function returns an incorrect result when calculating the quarter
[
https://issues.apache.org/jira/browse/DRILL-7781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17183366#comment-17183366
]
ASF GitHub Bot commented on DRILL-7781:
---
oleg-zinovev opened a new pull request #2098:
URL: https://github.com/apache/drill/pull/2098
…culating the quarter
# [DRILL-7781](https://issues.apache.org/jira/browse/DRILL-7781): PR Title
## Description
|SQL|Expected|Actual|
|---|---|---|
|nearestDate('2019-03-01 00:00:00', 'quarter')|2019-01-01
00:00:00|2019-04-01 00:00:00|
|nearestDate('2019-06-01 00:00:00', 'quarter')|2019-04-01
00:00:00|2019-07-01 00:00:00|
|nearestDate('2019-09-01 00:00:00', 'quarter')|2019-07-01
00:00:00|2019-10-01 00:00:00|
|nearestDate('2019-12-01 00:00:00', 'quarter')|2019-10-01 00:00:00|SYSTEM
ERROR: DateTimeException: Invalid value for MonthOfYear (valid values 1 - 12):
13|
## Testing
unit test has been added
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
> NearestDate function returns an incorrect result when calculating the quarter
> -
>
> Key: DRILL-7781
> URL: https://issues.apache.org/jira/browse/DRILL-7781
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.16.0, 1.17.0
>Reporter: Oleg Zinoviev
>Priority: Major
>
> ||SQL||Expected||Actual||
> |nearestDate('2019-03-01 00:00:00', 'quarter')|2019-01-01 00:00:00|2019-04-01
> 00:00:00|
> |nearestDate('2019-06-01 00:00:00', 'quarter')|2019-04-01 00:00:00|2019-07-01
> 00:00:00|
> |nearestDate('2019-09-01 00:00:00', 'quarter')|2019-07-01 00:00:00|2019-10-01
> 00:00:00|
> |nearestDate('2019-12-01 00:00:00', 'quarter')|2019-10-01 00:00:00|SYSTEM
> ERROR: DateTimeException: Invalid value for MonthOfYear (valid values 1 -
> 12): 13|
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Created] (DRILL-7781) NearestDate function returns an incorrect result when calculating the quarter
Oleg Zinoviev created DRILL-7781:
Summary: NearestDate function returns an incorrect result when
calculating the quarter
Key: DRILL-7781
URL: https://issues.apache.org/jira/browse/DRILL-7781
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.17.0, 1.16.0
Reporter: Oleg Zinoviev
||SQL||Expected||Actual||
|nearestDate('2019-03-01 00:00:00', 'quarter')|2019-01-01 00:00:00|2019-04-01
00:00:00|
|nearestDate('2019-06-01 00:00:00', 'quarter')|2019-04-01 00:00:00|2019-07-01
00:00:00|
|nearestDate('2019-09-01 00:00:00', 'quarter')|2019-07-01 00:00:00|2019-10-01
00:00:00|
|nearestDate('2019-12-01 00:00:00', 'quarter')|2019-10-01 00:00:00|SYSTEM
ERROR: DateTimeException: Invalid value for MonthOfYear (valid values 1 - 12):
13|
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Commented] (DRILL-7745) Add storage plugin for IPFS
[
https://issues.apache.org/jira/browse/DRILL-7745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17183206#comment-17183206
]
ASF GitHub Bot commented on DRILL-7745:
---
vvysotskyi commented on a change in pull request #2084:
URL: https://github.com/apache/drill/pull/2084#discussion_r475563244
##
File path:
contrib/storage-ipfs/src/main/java/org/apache/drill/exec/store/ipfs/IPFSGroupScan.java
##
@@ -0,0 +1,452 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+
+package org.apache.drill.exec.store.ipfs;
+
+
+import com.fasterxml.jackson.annotation.JacksonInject;
+import com.fasterxml.jackson.annotation.JsonCreator;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.fasterxml.jackson.annotation.JsonProperty;
+import com.fasterxml.jackson.annotation.JsonTypeName;
+import io.ipfs.api.MerkleNode;
+import io.ipfs.cid.Cid;
+import io.ipfs.multihash.Multihash;
+import org.apache.drill.common.PlanStringBuilder;
+import org.apache.drill.common.exceptions.UserException;
+import org.apache.drill.common.expression.SchemaPath;
+import org.apache.drill.common.util.DrillVersionInfo;
+import org.apache.drill.exec.coord.ClusterCoordinator;
+import org.apache.drill.exec.physical.EndpointAffinity;
+import org.apache.drill.exec.physical.base.AbstractGroupScan;
+import org.apache.drill.exec.physical.base.PhysicalOperator;
+import org.apache.drill.exec.physical.base.ScanStats;
+import org.apache.drill.exec.proto.CoordinationProtos.DrillbitEndpoint;
+import org.apache.drill.exec.store.StoragePluginRegistry;
+import org.apache.drill.exec.store.schedule.AffinityCreator;
+import org.apache.drill.exec.store.schedule.AssignmentCreator;
+import org.apache.drill.exec.store.schedule.CompleteWork;
+import org.apache.drill.exec.store.schedule.EndpointByteMap;
+import org.apache.drill.exec.store.schedule.EndpointByteMapImpl;
+import org.apache.drill.shaded.guava.com.google.common.base.Preconditions;
+import org.apache.drill.shaded.guava.com.google.common.base.Stopwatch;
+import org.apache.drill.shaded.guava.com.google.common.cache.LoadingCache;
+import
org.apache.drill.shaded.guava.com.google.common.collect.ArrayListMultimap;
+import org.apache.drill.shaded.guava.com.google.common.collect.ImmutableList;
+import org.apache.drill.shaded.guava.com.google.common.collect.ListMultimap;
+import org.apache.drill.shaded.guava.com.google.common.collect.Lists;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+import java.io.IOException;
+import java.util.ArrayList;
+import java.util.LinkedHashMap;
+import java.util.List;
+import java.util.Map;
+import java.util.Optional;
+import java.util.Random;
+import java.util.concurrent.ForkJoinPool;
+import java.util.concurrent.RecursiveTask;
+import java.util.concurrent.TimeUnit;
+import java.util.stream.Collectors;
+
+
+@JsonTypeName("ipfs-scan")
+public class IPFSGroupScan extends AbstractGroupScan {
+ private static final Logger logger =
LoggerFactory.getLogger(IPFSGroupScan.class);
+ private final IPFSContext ipfsContext;
+ private final IPFSScanSpec ipfsScanSpec;
+ private final IPFSStoragePluginConfig config;
+ private List columns;
+
+ private static final long DEFAULT_NODE_SIZE = 1000L;
+ public static final int DEFAULT_USER_PORT = 31010;
+ public static final int DEFAULT_CONTROL_PORT = 31011;
+ public static final int DEFAULT_DATA_PORT = 31012;
+ public static final int DEFAULT_HTTP_PORT = 8047;
+
+ private ListMultimap assignments;
+ private List ipfsWorkList = Lists.newArrayList();
+ private ListMultimap endpointWorksMap;
+ private List affinities;
+
+ @JsonCreator
+ public IPFSGroupScan(@JsonProperty("IPFSScanSpec") IPFSScanSpec ipfsScanSpec,
+ @JsonProperty("IPFSStoragePluginConfig")
IPFSStoragePluginConfig ipfsStoragePluginConfig,
+ @JsonProperty("columns") List columns,
+ @JacksonInject StoragePluginRegistry pluginRegistry) {
+this(
+pluginRegistry.resolve(ipfsStoragePluginConfig,
IPFSStoragePlugin.class).getIPFSContext(),
+ipfsScanSpec,
+columns
+);
+ }
+
+ public IPFSGroupScan(IPFSContext ipfsContext,
