sql
sql copied to clipboard
Published
20 hours ago •
opensearch-project
opensearch-project
SQL ingestion and ops - standup
Is your feature request related to a problem? A clear and concise description of what the problem is, e.g. I'm always frustrated when [...]
What solution would you like? A clear and concise description of what you want to happen.
What alternatives have you considered? A clear and concise description of any alternative solutions or features you've considered.
Do you have any additional context? Add any other context or screenshots about the feature request here.
August 30, 2022 Status Updates
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | None | Refactor tests and support null for invalid input | Address review feedback | None | |
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | In Review | None | Waiting for opensearch-project/sql#746 to be merged | --- | Code dependency on opensearch-project/sql#746 | |
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused | paused | paused | Depends on PR opensearch-project/sql#754 | ||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | Paused | Yury is working on .NET release and addressing PR feedback | ---- | --- | -- | |
| Support highlight function in PPL query engine opensearch-project/sql#636 | @forestmvey | In Progress | - | Finalize design. | Make adjustments based on finalized design. | - | |
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Progress | - | Investigation and test implementation for using DOT . notation for accessing nested fields. | Fixing quotation behavior | ||
| Refactor implementation of relevance queries opensearch-project/sql#746 | @MaxKsyunz | In Progress | - | - | Address PR feedback | -- | |
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Progess | Addressing PR feedback | Implementation rework | Keep reworking + update tests | None | Aug 31 |
| SQL Ingest -- JDBC support opensearch-project/sql-jdbc#25 | @MaxKsyunz | In Progress | Meeting to align ingest priorities | Finalize ingest priorities |
August 31, 2022 Status Updates
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | None | Increased test coverage and manual testing | Finish addressing review feedback | None | |
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | Paused | None | --- | --- | Waiting for opensearch-project/sql#746 to be merged | |
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused | paused | paused | Depends on PR opensearch-project/sql#754 | ||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | Paused | Yury is working on .NET release and addressing PR feedback | ---- | --- | -- | |
| Support highlight function in PPL query engine opensearch-project/sql#636 | @forestmvey | In Review | - | - | - | - | |
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Progress | - | Fixed quotation behavior | support multiple highlight requests in a single statement | ||
| Refactor implementation of relevance queries opensearch-project/sql#746 | @MaxKsyunz | In Progress | - | Investigated how to address PR feedback | Discuss design proposal with reviewer | -- | |
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Progess | .NET release is higher priority | Created POC for new design and discussed with reviewer | implement new design | None | Aug 31 |
| SQL Ingest -- JDBC support opensearch-project/sql-jdbc#25 | @MaxKsyunz | Paused | Paused due a change in priorities | - | - |
September 01, 2022 Status Updates
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Generated integration test report with v1 engine disabled. | Create list features missing from v2 SQL engine based on test report. | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | Paused | Yury is working on .NET release and addressing PR feedback | ||||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | Paused | None | Waiting for opensearch-project/sql#746 to be merged | |||
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Review | None | code cleanup, PR cleanup, pass all GH actions | Address any new PR comments. | ||
| Wildcard demo | @forestmvey | In Progress | None | Do. | |||
| Wildcard add optional arguments | @forestmvey | In Progress | None | Implement. | |||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Progress | .NET release is higher priority | Implement new design | Code clean up and test rework | None | |
| Refactor implementation of relevance queries opensearch-project/sql#746 | @MaxKsyunz | In Progress | Discuss design proposal with reviewer | -- | |||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | None | Added support for local time zone to be default in tests. Added null return for invalid datetime entry. | Address any new PR comments. | None | |
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | N/A | Merge and relevant PRs and start adding new functions. | Depends on PR opensearch-project/sql#754 |
September 02, 2022 Status Updates
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Began analyzing test results of running integration tests on v2 engine only | Create GitHub issue to capture discussion. | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | Paused | Yury is working on .NET release and addressing PR feedback | Nothing. | |||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | Paused | None | Nothing. | Waiting for opensearch-project/sql#746 to be merged | ||
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Review | None | Nothing. | Address any new PR comments. | ||
| Wildcard demo | @forestmvey | In Progress | None | Do if time. | |||
| Wildcard add optional arguments | @forestmvey | In Progress | None | Implement | Code cleanup, add tests, create PR. | ||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Progress | Update tests | Fix test coverage validation | None | ||
| Refactor implementation of relevance queries opensearch-project/sql#746 | @MaxKsyunz | In Progress | Discuss design proposal with reviewer | -- | |||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | None | Got PR to stage with new PRs requested, addressed many of the concerns around naming, missing javadocs and more | Fix datetime invalid date being treated as last day of the month. (Feb 30 is a valid date, but when converted it treats it like it was Feb 28th). | None | |
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused | Merged relevant PRs | Will be working on different topic today | Depends on PR opensearch-project/sql#754 |
September 06, 2022 Status Updates
Note: Monday, September 5th, was a stat holiday.
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Nothing. | Create GitHub issue to capture discussion. | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Progress | Implementation done, need to update tests | Nothing. | Working on tests | ||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | Paused | None | Nothing. | Waiting for opensearch-project/sql#746 to be merged | ||
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Review | None | Address PR feedback. | Address any new PR comments. | ||
| Wildcard demo | @forestmvey | In Progress | None | Nothing | Do if time. | ||
| Wildcard add optional arguments | @forestmvey | In Review | None | Nothing. | Address PR feedback. | ||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Progress | On review opensearch-project/sql#113 | Finished | Address PR review | None | |
| Refactor implementation of relevance queries opensearch-project/sql#746 | @MaxKsyunz | In Progress | Responded to PR comment with results of addressing suggestions. | Follow-up with Peng re: moving relevance functions from :core to :opensearch as a separate ticket. | -- | ||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | None | Addressed PR comments. | Working on fixing date validation for invalid dates. Breaking up more tests and adding more doc test, tests. | None | |
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused | Paused | Paused | Depends on PR opensearch-project/sql#754 |
September 07, 2022 Status Updates
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Nothing. | Create GitHub issue to capture discussion. | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Progress | Implementation done, need to update tests | Nothing. | Working on tests | ||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | Paused | None | Nothing. | Waiting for opensearch-project/sql#746 to be merged | ||
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Review | None | Address PR feedback. | Address any new PR comments. | ||
| Wildcard demo | @forestmvey | In Progress | None | Nothing | Do if time. | ||
| Wildcard add optional arguments | @forestmvey | In Review | None | Nothing. | Address PR feedback. | ||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Progress | On review #113 | Finished | Address PR review | None | |
| Refactor implementation of relevance queries opensearch-project/sql#746 | @MaxKsyunz | In Progress | Responded to PR comment with results of addressing suggestions. | Follow-up with Peng re: moving relevance functions from :core to :opensearch as a separate ticket. | -- | ||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | None | Added invalid date test cases. Working on date validation. | Working on fixing date validation for invalid dates. | None | |
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused | Paused | Paused | Depends on PR opensearch-project/sql#754 |
Updates for September 8th
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Updated GitHub issue with test results. | Rework error handling for easier review. | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Progress | Implementation done, need to update tests | Working on tests | Doctest, code style fixes, publish PR | ||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | In queue | None | Waiting for opensearch-project/sql#746 to be merged | |||
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Review | None | complete PR. | Nothing. | ||
| Wildcard demo | @forestmvey | In Progress | None | Nothing | Finish. | ||
| Wildcard add optional arguments | @forestmvey | In Review | None | Address PR feedback. | Cleanup PR, request review. | ||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Progress | On review #113 | Address PR review | Merge PR if no changes requested | None | |
| Refactor implementation of relevance queries opensearch-project/sql#746 | @MaxKsyunz | Done | -- | ||||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | None | Finished date validation. Tidied up test cases. | Adding more doc tests and adding descriptions | None | |
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused | Paused | Paused | Depends on PR opensearch-project/sql#754 |
Updates for September 9th
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Reworked error handling for easier review. | Review new and publish results. | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Review | Ready for review #114 | Finished development | Address PR feedback | ||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | In Review | Ready for review #108 | Finished development | |||
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Review | None | Nothing. | Nothing. | ||
| Wildcard demo | @forestmvey | In Progress | None | Nothing | Finish. | ||
| Highlight add optional arguments | @forestmvey | In Review | None | Address PR feedback. | Minor revisions. | ||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Review | On review #113 | Address PR review | Merge PR if no changes requested | None | |
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | None | finalized addressing PR reviews. | Tidy up code then submit for new PR. Address new feedback. | None | |
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused | Paused | Paused | Depends on PR opensearch-project/sql#754 | ||
| Prototype using aliases in SELECT clauses | @Andrew Carbonetto | In Progress | Just starting investigation | N/A | Test/Code Investigation |
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Reviewed join, tophit and histogram related failures. | Continue reviewing results | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Review | Ready for review #114 | ||||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | In Review | Ready for review #108 | ||||
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Review | None | Nothing. | Nothing. | ||
| Wildcard demo | @forestmvey | In Progress | None | Began. | Finish. | ||
| Highlight add optional arguments | @forestmvey | In Review | None | Address PR feedback. | Cleanup IT tests, Submit PR when feedback for PPL syntax. | ||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Review | On review #113 | Address PR review | None | ||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | None | finalized addressing PR reviews. | Get new PR comments and address. | None | |
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused | N/A | rebase off upstream main and build test cases. | Depends on PR opensearch-project/sql#754 | ||
| Prototype using aliases in SELECT clauses | @Yury Fridlyand | In Progress | Just starting investigation | N/A | Test/Code Investigation |
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Reviewed v2 parser integration test failures | Compile and share results. Review uncategoried failures (20 tests) | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Review | On team review #114 | Address PR feedback. | |||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | In Review | On team review #108 | Address PR feedback. | |||
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Review | On team review #112 | Address PR feedback. | Merge PR and raise upstream PR. | ||
| Wildcard demo | @forestmvey | In Progress | Created draft demo | Edit and post. | |||
| Highlight add optional arguments | @forestmvey | Internal review approved, Cleanup and upstream PR needed | Cleanup IT tests, rework syntax for PPL to conform with other commands. | Finish cleanup, make upstream PR. | |||
| Update Jetty dependency to latest version | @forestmvey | in-progress | Nothing. | Begin task. | |||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Review | On team review #113 | Address PR review | |||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On team review #109 | Addressed PR comments. | Move strict date validation to exprdatetimevalue. | ||
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused - waiting on convert_tz and datetime function | rebase off upstream main and build test cases. | Depends on PR opensearch-project/sql#754 | |||
| Prototype using aliases in SELECT clauses | @Yury-Fridlyand | Done | Investigation report |
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Finished review and published results. | Cross reference with existing issues. | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Review | On team review #114 | Address PR feedback. | |||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | In Review | On team review #108 | Address PR feedback. | |||
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Review | On upstream review opensearch-project/sql#827 | Nothing. | Nothing. | ||
| Wildcard demo | @forestmvey | Complete. | Post demo: Support highlighting function in SQL/PPL query engine · Issue opensearch-project/sql#636 · opensearch-project/sql | Nothing | |||
| Highlight add optional arguments | @forestmvey | In Review | On upstream review opensearch-project/sql#827 | Finished cleanup, make PR to upstream. | Nothing. | ||
| Update Jetty dependency to latest version | @forestmvey | in-progress | Nothing. | Begin task. | |||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Review | On team review #113 | Address PR review | |||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On team review #109 | Move strict date validation to exprdatetimevalue. | Tidy up final concerns. | ||
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused - waiting on convert_tz and datetime function | Start on implementation | Depends on PR opensearch-project/sql#754 | |||
| Reorganize github workflows | @Yury-Fridlyand | In Progress | Workflow cleanup, reactivate forgotten ones | Update the rest workflows |
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Finished review and published results. | Cross reference with existing issues. | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Review | On team review #114 | Address PR feedback. | |||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | In Review | On team review #108/#116 | Address PR feedback. | |||
| Support for wildcard in highlight opensearch-project/sql#636 | @forestmvey | In Review | On upstream review opensearch-project/sql#827 | Nothing. | Nothing. | ||
| Wildcard demo | @forestmvey | Complete. | Post demo: link | Nothing | |||
| Highlight add optional arguments | @forestmvey | In Review | On upstream review opensearch-project/sql#827 | Finished cleanup, make PR to upstream. | Nothing. | ||
| Update Jetty dependency to latest version | @forestmvey | In Progress | Update Jetty and fix some errors raised | Fix remaining compilation errors and issues due to deprecated API usage | |||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#754 | Merged requested changes | |||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On team review #109 | finished ticket | Rebase and merge | ||
| Add get UTC date/time functions | @MitchellGale-BitQuill | Paused - waiting on convert_tz and datetime function | Start on implementation | Add new functions into plugin | Depends on PR opensearch-project/sql#754 | ||
| Reorganize github workflows | @Yury-Fridlyand | In Review | On team review #118 | Done | |||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Progress | Just started |
September 16, 2022 Status Updates
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Updated github ticket with results opensearch-project/sql#787 | Cross reference with existing issues. See project | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#835 | Publish PR to upstream | |||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | In Review | On team review #108/#116 | Review done | Publish PR to upstream | ||
| Update Jetty dependency to latest version | @forestmvey | In Progress | Out of office | Fix remaining compilation errors and issues due to deprecated API usage. Determine if further work is needed if tests not passing. | |||
| Datetime NOW function opensearch-project/sql#754 | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#754 | ||||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On team review #109 | finished review | Publish PR to upstream | ||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | continue to add new functions into plugin | Depends on PR opensearch-project/sql#754 | |||
| Reorganize github workflows | @Yury-Fridlyand | In Review | On team review #118 | Review done | Publish PR to upstream | ||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Progress | Update DATE_ADD function | ||||
| Relevance search and highlight demo | @MaxKsyunz | In Progress | Found sample data and demo outline | Finalize demo script, record video | |||
| Highlight, refactor PPL operator to function | @Forest Vey | In Progress | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. |
September 19, 2022 Status Updates
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | In Progress | Updated github ticket with results opensearch-project/sql#787 | Cross reference with existing issues. See project | Plan next step. | ||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#835 | Publish PR to upstream | Address PR feedback | ||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | Publish PR to upstream | |||
| Update Jetty dependency to latest version | @forestmvey | Complete. | Assessed test failures and groomed follow up ticket. | Nothing. | |||
| Resolve EqualsAndHash warnings with new team member. | @forestmvey | In Progress | Implement fix and test. | ||||
| Datetime NOW function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#754 | ||||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On team review #109 | finished review | Publish PR to upstream | ||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | continue to add new functions into plugin | Depends on PR opensearch-project/sql#754 | |||
| Reorganize github workflows | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#837 | Publish PR to upstream | |||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Progress | Update DATE_ADD function | Update DATE_SUB function | |||
| Relevance search and highlight demo | @MaxKsyunz | In Progress | Finalize demo script, record video | Edit and publish the demo | |||
| Highlight, refactor PPL operator to function | @forestmvey | In Progress | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Begin if time is available. |
September 20, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | Done | Updated github ticket with results opensearch-project/sql#787 | Cross reference with existing issues. See project | |||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#835 | Apply fix requested on review | |||
| Revise Error Reporting Improvements PR to Utilize QueryContext | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | ||||
| Update Jetty dependency to latest version | @forestmvey | Complete | Assessed test failures and groomed follow up ticket. | Nothing. | |||
| Resolve EqualsAndHash warnings with new team member. | @forestmvey | Complete | Resolve. | Nothing. | |||
| Update MacOS version for GHA | @forestmvey | In Progress | Begin | ||||
| Datetime NOW function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#754 | Apply fix requested on review | |||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On team review #109 | Pushed PR to upstream opensearch-project/sql#848 | Nothing | ||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | Added utc_date, utc_time, utc_timestamp | Add implementation for utc_date, utc_time, utc_timestamp. | |||
| Reorganize github workflows | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#837 | Add new test job | |||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Progress | Update DATE_SUB function | Add DATEDIFF function | |||
| Relevance search and highlight demo | @MaxKsyunz | Done | Edited the demo | ||||
| Highlight, refactor PPL operator to function | @forestmvey | In Progress | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Begin if time is available. |
September 22, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| V1/V2 Engine Gap Analysis / Integration Tests | @MaxKsyunz | Done | Updated github ticket with results opensearch-project/sql#787 | Cross reference with existing issues. See project | At OpenSearch Conference | ||
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions (#722) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#835 | ||||
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | ||||
| Update Jetty dependency to latest version | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | ||||
| Resolve EqualsAndHash warnings with new team member. | @forestmvey | Complete | Upstream PR merged opensearch-project/sql#847 | ||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | ||||
| Datetime NOW function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#754 | ||||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On upstream review opensearch-project/sql#848 | Address PR comments | |||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | Added functionality for utc functions | Adding tests for UTC_Date, UTC_time | |||
| Reorganize github workflows | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#837 | ||||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Progress | Functions in scope of this task:TIMEDIFF, DATE_ADD, ADDDATE, DATE_SUB, SUBDATE, DATEDIFF, PERIOD_ADD, PERIOD_DIFF, ADDTIME, SUBTIME | Finished implementation for all functions, added unit tests for some of them | Continue with tests | ||
| Relevance search and highlight demo | @MaxKsyunz | Done | Edited the demo | ||||
| Highlight, refactor PPL operator to function | @forestmvey | In Progress | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Continued implementation. | Working on PPL portion with testing. |
September 23, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions (#722) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#835 | ||||
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | ||||
| Update Jetty dependency to latest version | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | ||||
| Resolve EqualsAndHash warnings with new team member. | @forestmvey | Complete | Upstream PR merged opensearch-project/sql#847 | ||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | ||||
| Datetime NOW function | @Yury-Fridlyand | Completed | opensearch-project/sql#754 merged | ||||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On upstream review opensearch-project/sql#848 | Address PR comments | |||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | Added functionality for utc functions | Adding tests for UTC_Date, UTC_time | |||
| Reorganize github workflows | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#837 | ||||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Progress | Functions in scope of this task: TIMEDIFF, DATE_ADD, ADDDATE, DATE_SUB, SUBDATE, DATEDIFF, PERIOD_ADD, PERIOD_DIFF, ADDTIME, SUBTIME |
Working on unit tests | Remove ambiguous signatures, continue with tests | ||
| Highlight, refactor PPL operator to function | @forestmvey | In Progress | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Working on PPL portion with testing. | PPL revisions and testing. |
September 26, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions (#722) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#835 | rebased | |||
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | ||||
| Update Jetty dependency to latest version | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | ||||
| Resolve EqualsAndHash warnings with new team member. | @forestmvey | Complete | Upstream PR merged opensearch-project/sql#847 | ||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | ||||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On upstream review opensearch-project/sql#848 | Address PR comments | Blocked by opensearch-project/sql#722 | ||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | Added functionality for utc functions | Adding tests for UTC_Date, UTC_time | |||
| Reorganize github workflows | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#837 | ||||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Progress | Functions in scope of this task:TIMEDIFF, DATE_ADD, ADDDATE, DATE_SUB, SUBDATE, DATEDIFF, PERIOD_ADD, PERIOD_DIFF, ADDTIME, SUBTIME | Finished unit tests | Documentation, integration tests | Blocked by opensearch-project/sql#848 and opensearch-project/sql#722 | |
| Highlight, refactor PPL operator to function | @forestmvey | In Progress | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | PPL revisions and testing. | Updating test suite. | ||
| Update Jetty in JDBC driver to address CVE | @MaxKsyunz | In Progress | Find non-vulenrable Jetty and Wiremock versions, create a branch. |
September 27, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions (#722) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#835 | rebased | |||
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | ||||
| Update Jetty dependency to latest version | @forestmvey@MaxKsyunz | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | Find non-vulnerable Jetty and Wiremock versions, create a branch. | Validate the branch with security scanner. | ||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | ||||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On upstream review opensearch-project/sql#848 | Addressed PR comments | Rebase and make last PR change that was blocked by 835 (now merged) | Blocked by opensearch-project/sql#722 | |
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | Adding tests for UTC_Date, UTC_time | Add variable tests to cover that testing current time might change during test, adds some margin of variation in result. | |||
| Reorganize github workflows | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#837 | ||||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Progress | Blocked by opensearch-project/sql#722 - Implementation done, but require minor fix after rebaseIT blocked by opensearch-project/sql#856/#853 or opensearch-project/sql#848 - all done, but few tests with DATETIME don’t work without it | Finished doctest and integration tests | Code clean-up & self-review and publish PR | ||
| Highlight, refactor PPL operator to function | @forestmvey | In Progress | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Updating test suite. | Cleanup code and make PR. |
September 27, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA | |
|---|---|---|---|---|---|---|---|---|
| Add FROM_UNIXTIME, UNIX_TIMESTAMP functions (#722) | @Yury-Fridlyand | Completed | opensearch-project/sql#835 | |||||
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | Address PR feedback | ||||
| Update Jetty dependency to latest version | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | Validate the branch with security scanner. | Debug failing test after dependency upgrade. | |||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | |||||
| convert_tz and datetime function | @MitchellGale-BitQuill | In Review | On upstream review opensearch-project/sql#848 | Rebased and make last PR change that was blocked by opensearch-project/sql#835 (now merged) | push and wait for new comments. Move formatter to separate file for date time | Blocked by opensearch-project/sql#722 | ||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | Adding tests for UTC_Date, UTC_time | Replace Date and Time UTC with call and parse of UTC_TIMESTAMP | ||||
| Reorganize github workflows | @Yury-Fridlyand | Completed | opensearch-project/sql#837 | Address PR feedback | ||||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | Blocked by opensearch-project/sql#722 - Implementation done, but require minor fix after rebaseIT blocked by opensearch-project/sql#856/#853 or opensearch-project/sql#848 - all done, but few tests with DATETIME don’t work without it On team review #122 | Code clean-up & self-review and publish PR | Blocked by opensearch-project/sql#722, opensearch-project/sql#856/#853 or opensearch-project/sql#848 | |||
| Highlight, refactor PPL operator to function | @forestmvey | In Review | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Cleanup code and make PR. | Revise if necessary for PR comments. | |||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Progress | Just started | Analyze and investigate the scope | ||||
| v2 and v1 engine gap analysis | @MaxKsyunz | In Progress | Prepare for triage session |
September 29, 2022
note: 2 Developers are off today; the team is off on the 30th;
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA | |
|---|---|---|---|---|---|---|---|---|
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | |||||
| Update Jetty dependency to latest version | @forestmvey | In Review | initial investigation is complete; next steps is to implement the solution and raise a PR | Debug failing test after dependency upgrade. | Fixed issue with failing tests and create internal PR. | |||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | |||||
| convert_tz and datetime function | @MitchellGale-BitQuill | Completed | opensearch-project/sql#848 | Move formatter to separate file for date time, rebase | ||||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | Replace Date and Time UTC with call and parse of UTC_TIMESTAMP | 29.09 - vacation, 30.09 - holiday | ||||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | On team review #122 | Rebase and update, since blockers resolved | ||||
| Highlight, refactor PPL operator to function | @forestmvey | In Review | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Minor PR revisions. | Finish off minor revisions based on PR comments, and merge internal PR. Should complete by end of day. | |||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Progress | Just started | |||||
| v2 and v1 engine gap analysis | @MaxKsyunz | In Progress | Prepare for triage session | |||||
| Add TYPEOF function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#867 | Address PR feedback, rebase, publish | ||||
| Fix bug where multiplication in queries is treated as alias | @GabeFernandez310 | In Progress | Studied antlr4 and finished writing tests | Change Lexer and Parser to implement fix |
Status Report - October 3rd, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA | |
|---|---|---|---|---|---|---|---|---|
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | |||||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | Vacation | Push PR and add doctests | ||||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | On team review #122 | Rebase and update, since blockers resolved | ||||
| Highlight, refactor PPL operator to function | @forestmvey | In Review | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Minor PR revisions. | Cleanup PR, address any comments. | |||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Progress | Just started | |||||
| v2 and v1 engine gap analysis | @MaxKsyunz | In Progress | Prepare for triage session | |||||
| Add TYPEOF function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#867 | Address PR feedback, rebase, publish | ||||
| Fix bug where multiplication in queries is treated as alias | @GabeFernandez310 | In Progress | Studied antlr4 and finished writing tests | Change Lexer and Parser to implement fix |
October 4th, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA | |
|---|---|---|---|---|---|---|---|---|
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | Address PR feedback | ||||
| Update Jetty dependency to latest version | @forestmvey | Complete | initial investigation is complete; next steps is to implement the solution and raise a PR | PR merged. | ||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | |||||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | Vacation | Push PR and add doctests | ||||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | On team review #122 | Update docs | ||||
| Highlight, refactor PPL operator to function | @forestmvey | In Review | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Cleanup PR, address any comments. | Cleanup PR, address any comments. | |||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Progress | Just started | |||||
| v2 and v1 engine gap analysis | @MaxKsyunz | Done | Prepare for triage session | |||||
| Add TYPEOF function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#867 | Address PR feedback | ||||
| Fix bug where multiplication in queries is treated as alias | @GabeFernandez310 | In Progress | Implemented Fix (Fix failed some checks) | Fix failing checks |
October 5rd, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA | |
|---|---|---|---|---|---|---|---|---|
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | |||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | |||||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | On team review #127 | Push PR and add doctests | Move over tests to use nowLikeFunctions test suite | |||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | On team review #122 | |||||
| Highlight, refactor PPL operator to function | @forestmvey | In Review | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Cleanup PR, address any comments. | Remove PPL portion, plan way forward with PPL, update PR. | |||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Progress | ||||||
| Add TYPEOF function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#867 | Address PR feedback | ||||
| Fix bug where multiplication in queries is treated as alias | @GabeFernandez310 | In Progress | Investigate failing tests | Continued investigation | ||||
| Fix CI workflows in 1.x | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#888 | Finished this fix | ||||
| Update docs for datetime functions | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#884 | |||||
| Bump OpenSearch version to 3.x | @MaxKsyunz | In Progress | Bringing this PR to completion. | Review results, flag next steps. |
October 6th, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA | |
|---|---|---|---|---|---|---|---|---|
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | |||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | Begin implementing fix. | ||||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | On team review #127 | Moved over tests to use nowLikeFunctions test suite | Fix IT tests for PPL tests to use UTC time. Ask for PR review again. | |||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | On team review #122 | Address PR review | ||||
| Highlight, refactor PPL operator to function | @forestmvey | In Review | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Remove PPL portion, plan way forward with PPL, update PR. | Discuss PPL portion. | |||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Progress | Implementation, started tests | Fix test coverage, integration test | ||||
| Add TYPEOF function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#867 | Address PR feedback | ||||
| Fix bug where multiplication in queries is treated as alias | @GabeFernandez310 | In Progress | Investigated possible solutions | Bring up blocking issues at talk about next steps | ||||
| Fix CI workflows in 1.x | @Yury-Fridlyand | Done | opensearch-project/sql#888 | |||||
| Update docs for datetime functions | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#884 | |||||
| Bump OpenSearch version to 3.x | @MaxKsyunz | In Progress | Bringing this PR to completion. | Review results, flag next steps. |
October 7, 2022
note: Monday is a holiday
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | ||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | ||||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | On team review #127 | Moved over tests to use nowLikeFunctions test suite | Fix IT tests for PPL tests to use UTC time. Ask for PR review again. | ||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | On team review #122 #130 #131 #132 | Split PR into 4 smaller ones | |||
| Highlight, refactor PPL operator to function | @forestmvey | In Review | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Remove PPL portion, plan way forward with PPL, update PR. | Discuss PPL portion. | ||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Progress | On team review #129 | Finished unit tests and coverage fixes | Integration test | ||
| Add TYPEOF function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#867 | ||||
| Fix bug where multiplication in queries is treated as alias | @GabeFernandez310 | In Progress | PoC on team review for discussion opensearch-project/sql#128 | Started implementing potential fix (with potentially breaking changes that need to be reviewed) | Finish implementation and discuss next steps | ||
| Update docs for datetime functions | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#884 | ||||
| Bump OpenSearch version to 3.x | @MaxKsyunz | In Progress | Fix IT tests for this PR | Review results, investigate failures:BWC – ml-commons 2.4.0 plugin is not available.Gradle fails to build on macOS intel because it can’t find opensearch.pluginzip gradle plugin | Find out what’s the status of 2.4 SNAPSHOTS is. note: resolving to use 2.3 as a fallback. |
October 11, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | ||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | resolve dependency errors to fix compilation errors. | |||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Progress | On team review #127 | Moved over tests to use nowLikeFunctions test suite | Fix IT tests for PPL tests to use UTC time. Ask for PR review again. | ||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | On team review #122 #130 #131 #132 | Address review feedback | |||
| Highlight, refactor PPL operator to function | @forestmvey | In Review | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Remove PPL portion, plan way forward with PPL, update PR. | Discuss PPL portion. | ||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Progress | On team review #129 | Integration tests for PPL ~1/2 scope | Continue with integration tests | ||
| Add TYPEOF function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#867 | ||||
| Fix bug where multiplication in queries is treated as alias | @GabeFernandez310 | In Progress | PoC on team review for discussion #128 | Started implementing potential fix (with potentially breaking changes that need to be reviewed) | Finish implementation and discuss next steps | ||
| Update docs for datetime functions | @Yury-Fridlyand | Done | opensearch-project/sql#884 merged | ||||
| Bump OpenSearch version to 3.x | @MaxKsyunz | In Progress | Fix IT tests for this PR | Build OpenSearch locally to get opensearch.pluginzip | Investigate if opensearch-sql 2.4 plugin is built already by CI – need to look into BWC test failures. |
October 12, 2022
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | ||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | Debugging compilation errors. | Find aws-sdk-cpp version that doesn’t have broken googletest dependency. | ||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Review | On team review #127 | Cleaned up code based on PR comments | |||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | On team review #122 #130 #131 #132 | Address review feedback | |||
| Highlight, refactor PPL operator to function | @forestmvey | Complete | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | PR Merged. | Create follow up issue for PPL portion. Update original highlight issue. | ||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Progress | On team review #129 | Continue with integration testsReview other PRs | Continue with integration tests | ||
| Add TYPEOF function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#867 | ||||
| Fix bug where multiplication in queries is treated as alias | @GabeFernandez310 | In Progress | PoC on team review for discussion #128 | Implemented potential fix (with potentially breaking changes that need to be reviewed) | Clean up and discuss implementation | ||
| Bump OpenSearch version to 3.x | @MaxKsyunz | In Progress | Updated mapping json files to resolve unit test failures | Run integration tests and review test results | |||
| Update Date function | @MitchellGale-BitQuill | In Progress | #126 opensearch-project/sql#709 opensearch-project/sql#580 Also makes Date eval as strict. | Started ticket work | Added scope to fix out of range date issue by using strict. Adding fix. |
October 13, 2022
October 14: department meeting all day
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | ||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | Find aws-sdk-cpp version that doesn’t have broken googletest dependency. | Planning way forward to allow aws-c-common dependency with MacOS version 11 or 12. | ||
| Add get UTC date/time functions | @MitchellGale-BitQuill | In Review | On team review #127 | Cleaned up code based on PR comments | |||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | On team review #122 #130 #131 #132 | Address review feedback | |||
| Highlight, refactor PPL operator to function | @forestmvey | Complete | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Nothing. | Create follow up issue for PPL portion. Update original highlight issue. | ||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Review | On team review #129 | Complete integration test, code clean up | |||
| Add TYPEOF function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#867 | ||||
| Fix bug where multiplication in queries is treated as alias | @GabeFernandez310 | In Progress | PoC on team review for discussion #128 | Implemented potential fix (with breaking changes that need to be reviewed) | Discuss implementation | ||
| Bump OpenSearch version to 3.x | @MaxKsyunz | In Progress | Updated mapping json files to resolve unit test failures | Run integration tests and review test results | |||
| Update Date function | @MitchellGale-BitQuill | In Progress | #134 opensearch-project/sql#709 opensearch-project/sql#580 Also makes Date eval as strict. | Started ticket work | Added scope to fix out of range date issue by using strict. Adding fix. | ||
| Rework timestamp function | @Yury-Fridlyand | In Progress | just started | update TIMESTAMP, add tests |
Oct 17, 2022 Updates
| Topic | Dev | Status | Comments | What have you done yesterday? | What are you going to do today? | Any impediments? | ETA |
|---|---|---|---|---|---|---|---|
| Revise Error Reporting Improvements PR to Utilize QueryContext (#838) | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#839 | ||||
| Update MacOS version for GHA | @forestmvey | In Progress | initial investigation is complete; next steps is to implement the solution and raise a PR | Resolve dependencies using vcpkg for odbc driver as fix. | Fixing compilation errors after updating aws-sdk-cpp dependency through vcpkg. | ||
| Add/update date/time calculation functions | @Yury-Fridlyand | In Review | On team review #122 #130 #131 #132 | Address review feedback | |||
| Highlight, refactor PPL operator to function | @forestmvey | Complete | Upstream review changed scope to make PPL highlight to a fetch function. Refactoring and will update opensearch-project/sql#827 when ready. | Create follow up issue for PPL portion. Update original highlight issue. | |||
| Fix/add date/time comparison functions | @Yury-Fridlyand | In Review | On team review #129 | Complete integration test, code clean up | |||
| Add TYPEOF function | @Yury-Fridlyand | In Review | On upstream review opensearch-project/sql#867 | ||||
| Fix bug where multiplication in queries is treated as alias | @GabeFernandez310 | In Progress | PoC on team review for discussion #128 | Investigated root cause of failing tests | Continued investigation | ||
| Bump OpenSearch version to 3.x | @MaxKsyunz | In Progress | Updated mapping json files to resolve unit test failures | Run integration tests and review test results | |||
| Update Date function | @MitchellGale-BitQuill | In Progress | #134 opensearch-project/sql#709 opensearch-project/sql#580 Also makes Date eval as strict. | Added null case. cherry pick PRs and cont work on finishing fix. | |||
| Rework timestamp function | @Yury-Fridlyand | In Progress | update TIMESTAMP | add tests | |||
| Enable passing SQL plugin tests | @GumpacG | In progress | Almost ready for a PR to upstream. Just need to investigate ML plugin test. | Ran legacy integration tests and added issues regarding failing tests. | Create a PR upstream once the ML plugin test has been resolved. | ||
| SQL CLI fix for session token | @Yury-Fridlyand | In Review | PR opensearch-project/sql#918 fixes opensearch-project/sql#854 |