SQL ingestion and ops - standup

[anirudha]

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.

[MaxKsyunz]

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 #746 to be merged	---	Code dependency on #746
Add get UTC date/time functions	@MitchellGale-BitQuill	Paused		paused	paused	Depends on PR #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 #636	@forestmvey	In Progress	-	Finalize design.	Make adjustments based on finalized design.	-
Support for wildcard in highlight #636	@forestmvey	In Progress	-	Investigation and test implementation for using DOT . notation for accessing nested fields.	Fixing quotation behavior
Refactor implementation of relevance queries #746	@MaxKsyunz	In Progress	-	-	Address PR feedback	--
Datetime NOW function #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

[MaxKsyunz]

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 #746 to be merged
Add get UTC date/time functions	@MitchellGale-BitQuill	Paused		paused	paused	Depends on PR #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 #636	@forestmvey	In Review	-	-	-	-
Support for wildcard in highlight #636	@forestmvey	In Progress	-	Fixed quotation behavior	support multiple highlight requests in a single statement
Refactor implementation of relevance queries #746	@MaxKsyunz	In Progress	-	Investigated how to address PR feedback	Discuss design proposal with reviewer	--
Datetime NOW function #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	-	-

[MaxKsyunz]

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 #746 to be merged
Support for wildcard in highlight #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 #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 #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 #754

[MaxKsyunz]

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 #746 to be merged
Support for wildcard in highlight #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 #754	@Yury-Fridlyand	In Progress		Update tests	Fix test coverage validation	None
Refactor implementation of relevance queries #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 #754

[MaxKsyunz]

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 #746 to be merged
Support for wildcard in highlight #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 #754	@Yury-Fridlyand	In Progress	On review #113	Finished	Address PR review	None
Refactor implementation of relevance queries #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 #754

[acarbonetto]

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 #746 to be merged
Support for wildcard in highlight #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 #754	@Yury-Fridlyand	In Progress	On review #113	Finished	Address PR review	None
Refactor implementation of relevance queries #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 #754

[acarbonetto]

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 #746 to be merged
Support for wildcard in highlight #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 #754	@Yury-Fridlyand	In Progress	On review #113	Address PR review	Merge PR if no changes requested	None
Refactor implementation of relevance queries #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 #754

[acarbonetto]

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 #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 #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 #754
Prototype using aliases in SELECT clauses	@andrew Carbonetto	In Progress	Just starting investigation	N/A	Test/Code Investigation

[MitchellGale]

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 #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 #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 #754
Prototype using aliases in SELECT clauses	@yury Fridlyand	In Progress	Just starting investigation	N/A	Test/Code Investigation

[acarbonetto]

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 #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 #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 #754
Prototype using aliases in SELECT clauses	@Yury-Fridlyand	Done		Investigation report

[MitchellGale]

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 #636	@forestmvey	In Review	On upstream review #827	Nothing.	Nothing.
Wildcard demo	@forestmvey	Complete.		Post demo: Support highlighting function in SQL/PPL query engine · Issue #636 · opensearch-project/sql	Nothing
Highlight add optional arguments	@forestmvey	In Review	On upstream review #827	Finished cleanup, make PR to upstream.	Nothing.
Update Jetty dependency to latest version	@forestmvey	in-progress		Nothing.	Begin task.
Datetime NOW function #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 #754
Reorganize github workflows	@Yury-Fridlyand	In Progress		Workflow cleanup, reactivate forgotten ones	Update the rest workflows

[Yury-Fridlyand]

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 #636	@forestmvey	In Review	On upstream review #827	Nothing.	Nothing.
Wildcard demo	@forestmvey	Complete.		Post demo: link	Nothing
Highlight add optional arguments	@forestmvey	In Review	On upstream review #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 #754	@Yury-Fridlyand	In Review	On upstream review #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 #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

[acarbonetto]

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 #787		Cross reference with existing issues. See project
Add FROM_UNIXTIME, UNIX_TIMESTAMP functions	@Yury-Fridlyand	In Review	On upstream review #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 #754	@Yury-Fridlyand	In Review	On upstream review #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 #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 #827 when ready.

[Yury-Fridlyand]

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 #787	Cross reference with existing issues. See project	Plan next step.
Add FROM_UNIXTIME, UNIX_TIMESTAMP functions	@Yury-Fridlyand	In Review	On upstream review #835	Publish PR to upstream	Address PR feedback
Revise Error Reporting Improvements PR to Utilize QueryContext	@Yury-Fridlyand	In Review	On upstream review #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 #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 #754
Reorganize github workflows	@Yury-Fridlyand	In Review	On upstream review #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 #827 when ready.		Begin if time is available.

[acarbonetto]

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 #787	Cross reference with existing issues. See project
Add FROM_UNIXTIME, UNIX_TIMESTAMP functions	@Yury-Fridlyand	In Review	On upstream review #835	Apply fix requested on review
Revise Error Reporting Improvements PR to Utilize QueryContext	@Yury-Fridlyand	In Review	On upstream review #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 #754	Apply fix requested on review
convert_tz and datetime function	@MitchellGale-BitQuill	In Review	On team review #109	Pushed PR to upstream #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 #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 #827 when ready.		Begin if time is available.

[acarbonetto]

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 #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 #835
Revise Error Reporting Improvements PR to Utilize QueryContext (#838)	@Yury-Fridlyand	In Review	On upstream review #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 #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 #754
convert_tz and datetime function	@MitchellGale-BitQuill	In Review	On upstream review #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 #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 #827 when ready.	Continued implementation.	Working on PPL portion with testing.

[Yury-Fridlyand]

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 #835
Revise Error Reporting Improvements PR to Utilize QueryContext (#838)	@Yury-Fridlyand	In Review	On upstream review #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 #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	#754 merged
convert_tz and datetime function	@MitchellGale-BitQuill	In Review	On upstream review #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 #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 #827 when ready.	Working on PPL portion with testing.	PPL revisions and testing.

[MaxKsyunz]

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 #835	rebased
Revise Error Reporting Improvements PR to Utilize QueryContext (#838)	@Yury-Fridlyand	In Review	On upstream review #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 #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 #848		Address PR comments	Blocked by #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 #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 #848 and #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 #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.

[acarbonetto]

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 #835	rebased
Revise Error Reporting Improvements PR to Utilize QueryContext (#838)	@Yury-Fridlyand	In Review	On upstream review #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 #848	Addressed PR comments	Rebase and make last PR change that was blocked by 835 (now merged)	Blocked by #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 #837
Add/update date/time calculation functions	@Yury-Fridlyand	In Progress	Blocked by #722 - Implementation done, but require minor fix after rebaseIT blocked by #856/#853 or #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 #827 when ready.	Updating test suite.	Cleanup code and make PR.

[acarbonetto]

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	#835
Revise Error Reporting Improvements PR to Utilize QueryContext (#838)	@Yury-Fridlyand	In Review	On upstream review #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 #848	Rebased and make last PR change that was blocked by #835 (now merged)	push and wait for new comments. Move formatter to separate file for date time	Blocked by #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	#837	Address PR feedback
Add/update date/time calculation functions	@Yury-Fridlyand	In Review	Blocked by #722 - Implementation done, but require minor fix after rebaseIT blocked by #856/#853 or #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 #722, #856/#853 or #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 #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

[acarbonetto]

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 #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	#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 #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 #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

[acarbonetto]

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 #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 #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

[Yury-Fridlyand]

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 #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 #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 #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

[Yury-Fridlyand]

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 #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 #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 #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 #888	Finished this fix
Update docs for datetime functions	@Yury-Fridlyand	In Review	On upstream review #884
Bump OpenSearch version to 3.x	@MaxKsyunz	In Progress	Bringing this PR to completion.		Review results, flag next steps.

[acarbonetto]

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 #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 #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 #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	#888
Update docs for datetime functions	@Yury-Fridlyand	In Review	On upstream review #884
Bump OpenSearch version to 3.x	@MaxKsyunz	In Progress	Bringing this PR to completion.		Review results, flag next steps.

[acarbonetto]

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 #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 #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 #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	In Review	On upstream review #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.

[acarbonetto]

Status Review | March 2nd, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Progress		Add code coverage tests.	Add code coverage tests continued.
Investigate failing ODBC driver MacOS build.	@forestmvey	In Progress		Begin investigation.
Get NESTED POC feature branch ready	@GumpacG	In Progress		Fixed unit tests	Remove aggregation implementation and fix integration tests
Rework on OpenSearchDataType	@Yury-Fridlyand	In Review	On upstream review #1314
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Progress	WIP, #226	Add unit tests	More unit tests for the god of the unit tests	Blocked by CI build issue
(design) Planning for JOINs development	@acarbonetto	Paused		Determine scope for JOINs development; writing test cases.	Continue adding test cases to determine legacy scope.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Progress	Internal PR #288	Demo’d to Amazon and internal team - added unit tests and doctests
Update arithmetic functions from legacy engine	@mattrwells	In Progress		Addressing comments	Continue addressing comments
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315	Fix failing CI	Fix failing CI	Blocked by CI build issue
OpenTelemetry Exporter	@MaxKsyunz	In Progress		Created a branch with a separate component for the exporter and cleaned up the code.	Adding support for trace schema from SSO.
Add support for JSON output on the V2 engine #1317	@GumpacG	In Progress	Internal PR for the Spike #217Internal PR for legacy fall back #237	Add unit tests for refactored fall back logic	Address PR comments
Add support for last_day, sec_to_time, str_to_date, weekofyear, time_to_sec, weekday, yearweek, to_seconds	@GabeFernandez310	In Progress		Addressed PR feedback/comments	Address any new comments. Add more tests as requested on some PRs.	Blocked by CI build issue

[acarbonetto]

Status Update | Mar 3rd, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Progress		Add code coverage tests continued.	Add code coverage tests continued.
Investigate failing ODBC driver MacOS build.	@forestmvey	In Progress		Begin investigation.	Debug failing build.
Get NESTED POC feature branch ready	@GumpacG	In Progress		Fixed unit tests	Remove aggregation implementation and fix integration tests
Rework on OpenSearchDataType	@Yury-Fridlyand	In Review	On upstream review #1314
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Progress	WIP, #226	Add unit tests	More unit tests for the god of the unit tests	Blocked by CI build issue
(design) Planning for JOINs development	@acarbonetto	Paused		Determine scope for JOINs development; writing test cases.	Continue adding test cases to determine legacy scope.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Progress	Internal PR #288	Demo’d to Amazon and internal team - added unit tests and doctests
Update arithmetic functions from legacy engine	@mattrwells	In Progress		Added parameter test	Implement performance test
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315	Fix failing CI	Fix failing CI	Blocked by CI build issue
OpenTelemetry Exporter	@MaxKsyunz	In Progress		Created a branch with a separate component for the exporter and cleaned up the code.	Adding support for trace schema from SSO.
Add support for JSON output on the V2 engine #1317	@GumpacG	In Progress	Internal PR for the Spike #217Internal PR for legacy fall back #237	Address PR comments	Continue to address PR comments and make GH Actions pass
Add support for last_day, sec_to_time, str_to_date, weekofyear, time_to_sec, weekday, yearweek, to_seconds	@GabeFernandez310	In Progress		Reworked to_seconds formatters. Code walkthrough. Addressed PR feedback.	Wait for Review. Address any new comments	Blocked by CI build issue

[acarbonetto]

Status Update - Mar 06, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Progress		Add code coverage tests continued.	Add code coverage tests continued for jacoco.
Investigate failing ODBC driver MacOS build.	@forestmvey	In Progress		Debug failing build.	Figure out why libiodbc is now failing compilation for intel mac.
Rework on OpenSearchDataType	@Yury-Fridlyand	In Review	On upstream review #1314
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Progress	WIP, #226	Add unit tests	More unit tests for the god of the unit tests
(design) Planning for JOINs development	@acarbonetto	Paused		Determine scope for JOINs development; writing test cases.	Continue adding test cases to determine legacy scope.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Progress	Internal PR #288	Demo’d to Amazon and internal team - added unit tests and doctests
Update arithmetic functions from legacy engine	@mattrwells	In Progress		Reverted code improvements as the hit to performance was too big	Clean up code and submit
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315	Fix failing CI	Fix failing CI
OpenTelemetry Exporter	@MaxKsyunz	In Progress		Created a branch with a separate component for the exporter and cleaned up the code.	Adding support for trace schema from SSO.
Add support for JSON output on the V2 engine #1317	@GumpacG	In Progress	Internal PR for the Spike #217Internal PR for legacy fall back #237	Address PR comments	Continue to address PR comments and make GH Actions pass
Add support for last_day, sec_to_time, str_to_date, weekofyear, time_to_sec, weekday, yearweek, to_seconds	@GabeFernandez310	In Progress		Addressed comments on all PRs.	CI no longer failing. Will rebase and fix any remaining issues on all PRs.

[acarbonetto]

Status Update | March 07, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Progress		Add code coverage tests continued.	Add code coverage tests continued for jacoco.
Investigate failing ODBC driver MacOS build.	@forestmvey	In Progress		Debug failing build.	Figure out why libiodbc is now failing compilation for intel mac.
Rework on OpenSearchDataType	@Yury-Fridlyand	In Review	On upstream review #1314
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Progress	WIP, #226	Add unit tests	More unit tests for the god of the unit tests
(design) Planning for JOINs development	@acarbonetto	Paused		Determine scope for JOINs development; writing test cases.	Continue adding test cases to determine legacy scope.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	Internal PR #288	Submitted code for review
Update arithmetic functions from legacy engine	@mattrwells	In Review		Reverted code improvements as the hit to performance was too big	Clean up code and submit
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315	Fix failing CI	Fix failing CI
Add support for JSON output on the V2 engine #1317	@GumpacG	In Progress	Internal PR for the Spike #217Internal PR for legacy fall back #237	Addressing PR comments	Continue to rework the solution to address PR comments and add unit tests
Add support for last_day, sec_to_time, str_to_date, weekofyear, time_to_sec, weekday, yearweek, to_seconds	@GabeFernandez310	In Review		Fixed JaCoCo and other issues on 2 PRs.	Rebase and fix any remaining issues on remaining PRs.

[acarbonetto]

Status Update | Mar 13, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Progress		Code cleanup and make PR.	Fixing bug where non-nested fields cannot be selected alongside nested.
Investigate failing ODBC driver MacOS build.	@forestmvey	In Progress			Attempt specific versions for non keg-only libiodbc and unixodbc to fix build.
Rework on OpenSearchDataType	@Yury-Fridlyand	In Review	On upstream review #1314
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Progress	WIP, #226	Add unit tests	More unit tests for the god of the unit tests
(design) Planning for JOINs development	@acarbonetto	Paused		Determine scope for JOINs development; writing test cases.	Continue adding test cases to determine legacy scope.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	Internal PR #288	Submitted code for review
Add RINT to new engine	@mattrwells	In Review		Fix failing github actions	Continue fixing failing github actions
Add COSH to new engine	@mattrwells	In Progress		Fix failing github actions	Continue fixing failing github actions
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	In Progress	Internal PR for the Spike #217Internal PR for legacy fall back #237	Made all tests pass	Clean up internal PR for the Spike #217
Add support for last_day, sec_to_time, str_to_date, weekofyear, time_to_sec, weekday, yearweek, to_seconds	@GabeFernandez310	In Upstream Review			Wait for review and address any PR comments.

[acarbonetto]

Status Update | Mar 15, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Progress		Fixing push down logic to allow project push down with nested push down.	Continued resolving push down issue with project and nested plans.
Investigate failing ODBC driver MacOS build.	@forestmvey	In Progress			De-prioritized over nested implementation.
Rework on OpenSearchDataType	@Yury-Fridlyand	In Review	On upstream review #1314
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Progress	WIP, #226	Add unit tests	More unit tests for the god of the unit tests
(design) Planning for JOINs development	@acarbonetto	Paused		Determine scope for JOINs development; writing test cases.	Continue adding test cases to determine legacy scope.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	Internal PR #288	Moved table metafields to OpenSearch module	Code waiting for review
Add RINT to new engine	@mattrwells	In Review		Fix failing github actions	Continue fixing failing github actions
Add COSH to new engine	@mattrwells	In Progress		Fix failing github actions	Continue fixing failing github actions
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	In Progress	Internal PR for the Spike #217Internal PR for legacy fall back #237	Made all tests pass	Clean up internal PR for the Spike #217
Add support for last_day, sec_to_time, str_to_date, weekofyear, time_to_sec, weekday, yearweek, to_seconds	@GabeFernandez310	In Upstream Review			Wait for review and address any PR comments.
Add support for timestampadd function	@GabeFernandez310	In Progress		Wrote tests. Implemented basic implementation.	Fix and continue working on implementation.

[acarbonetto]

Status Report | Mar 16, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Progress		Continued resolving push down issue with project and nested plans.	Continued resolving push down issue with project and nested plans.
Investigate failing ODBC driver MacOS build.	@forestmvey	In Progress		De-prioritized over nested implementation.
Rework on OpenSearchDataType	@Yury-Fridlyand	In Review	On upstream review #1314
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	Team review #226	Final fixes	Ready for review
(design) Planning for JOINs development	@acarbonetto	Paused		Determine scope for JOINs development; writing test cases.	Continue adding test cases to determine legacy scope.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	Internal PR #288	Moved table metafields to OpenSearch module	Code waiting for review
Add RINT to new engine	@mattrwells	In Review		Fix failing github actions	Continue fixing failing github actions
Add COSH to new engine	@mattrwells	In Progress		Fix failing github actions	Continue fixing failing github actions
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	In Progress	Internal PR for the Spike #217Internal PR for legacy fall back #237	Clean up internal PR for the Spike #217	Address comments for Internal PR for the Spike #217
Add support for last_day, sec_to_time, str_to_date, weekofyear, time_to_sec, weekday, yearweek, to_seconds	@GabeFernandez310	Done	Merged into main
Add support for timestampadd function	@GabeFernandez310	In Progress		Addressed all comments. Cleaned code and added tests.	Address any new feedback and comments.
Conduct datetime performance tests	@mattrwells	In Progress			conduct tests on current version
Add support for timestampdiff function	@GabeFernandez310	In Progress		Initial investigation	Begin writing tests

[acarbonetto]

Status Update | Mar 20, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Progress		Continued resolving push down issue with project and nested plans.	Make internal PR.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Progress		Added integration tests	Implement solution
Investigate failing ODBC driver MacOS build.	@forestmvey	On-Hold		De-prioritized over nested implementation.
Rework on OpenSearchDataType	@Yury-Fridlyand	In Review	On upstream review #1314
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	Team review #226	Final fixes	Ready for review
(design) Planning for JOINs development	@acarbonetto	Paused		Determine scope for JOINs development; writing test cases.	Continue adding test cases to determine legacy scope.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	Internal PR #288	Moved table metafields to OpenSearch module	Code waiting for review
Add RINT to new engine	@mattrwells	In Review		Fix failing github actions	Continue fixing failing github actions
Add COSH to new engine	@mattrwells	In Progress		Fix failing github actions	Continue fixing failing github actions
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	In Review	Internal PR for the Spike #217
Add support for last_day, sec_to_time, str_to_date, weekofyear, time_to_sec, weekday, yearweek, to_seconds	@GabeFernandez310	Done	Merged into main
Add support for timestampadd function	@GabeFernandez310	In Upstream Review		Raised PR upstream	Address any new feedback and comments.
Conduct datetime performance tests	@mattrwells	In Progress			conduct tests on current version
Add support for timestampdiff function	@GabeFernandez310	In Progress		Finished writing tests and began implementation	Continue implementation

[mattheww]

I don't know who's supposed to be conducting these datetime performance tests, but I'm pretty sure it isn't me.

[acarbonetto]

Status Update | March 23, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Review		Fix incorrect data types returned and add tests.	Address any new PR comments.
Add support for selecting nested types in the SELECT clause without nested function.	@forestmvey	In Progress			Beginning implementation.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Progress		Implement solution	Continue to implement solution
Investigate failing ODBC driver MacOS build.	@forestmvey	On-Hold		De-prioritized over nested implementation.
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	Team review #226
(design) Planning for JOINs development	@acarbonetto	In Progress	First step is same-table JOIN #1441	Writing scope and syntax;Proposal submitted to #opensearch_bq channel for discussion	Continue to develop feature prototype and determine feasibility
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	On upstream review #1456		Code waiting for review
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	In Review	On upstream review #1464
Conduct datetime performance tests	@matthewryanwells	In Progress		Collected results on 2.4	Collect final test results
Add support for timestampdiff function	@GabeFernandez310	In Review		Continued addressing comments.	Address comments. Merge and raise PR upstream.
Further improvements on pagination	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs are in #253, #252, #249, #250	Rework serialization	Support for LIMIT, WHERE, ORDER BY clauses and expressions

[acarbonetto]

Status Update | Mar 24, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Review		Address any new PR comments.
Add support for selecting nested types in the SELECT clause without nested function.	@forestmvey	In Progress		Beginning implementation.	Fixing doctest and adding more tests.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Progress		Implement solution	Continue to implement solution
Investigate failing ODBC driver MacOS build.	@forestmvey	On-Hold		De-prioritized over nested implementation.
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310		Address PR feedback
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	Team review #226
(design) Planning for JOINs development	@acarbonetto	In Progress	First step is same-table JOIN #1441	Writing scope and syntax;Proposal submitted to #opensearch_bq channel for discussion	Continue to develop feature prototype and determine feasibility
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	On upstream review #1456		Code waiting for review
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	In Review	On upstream review #1464
Conduct datetime performance tests	@matthewryanwells	In Progress		Collected results on 2.4	Collect final test results
Fix SUMbug	@matthewryanwells	In Progress			begin investigating bug
Add support for timestampdiff function	@GabeFernandez310	In Upstream Review		Raised PR upstream. Addressed Comments.	Wait for reviews.
Further improvements on pagination	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs are in #253, #252, #249, #250	Support for LIMIT, WHERE, ORDER BY and HAVING clauses and expressions, tests
Test JDBC with V2 pagination	@Yury-Fridlyand	WIP	#254

[acarbonetto]

Status Update | March 28th, 2023

opic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Review		Fix bug with multiple nested calls with same path.	Awaiting further review.
Add nested support in WHERE clause.	@forestmvey	In Progress		Begin implementation.
Add support for selecting nested types in the SELECT clause without nested function.	@forestmvey	In Progress		Fixing arrays parsing in V2 engine.	Fixing arrays parsing in V2 engine.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Progress	Blocked on cartesian product for all columns in the same nested field	Implement solution
Investigate failing ODBC driver MacOS build.	@forestmvey	On-Hold		De-prioritized over nested implementation.
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310		Address PR feedback
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	On upstream review #1483	Address PR feedback	Final fixes, rebase and publish to upstream
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Writing scope and syntax;Proposal submitted to #opensearch_bq channel for discussion	Update proposal and PoC and link to proposal for PartiQL/Nested work with Lateral JOINs.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	On upstream review #1456		Address Peng/Chen’s code review comments
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	In Review	On upstream review #1464		Address upstream PR comments
Conduct datetime performance tests	@matthewryanwells	In Progress		Collected all results	Present results
Fix SUMbug	@matthewryanwells	In Progress		investigated bug	Continue investigating bug
Further improvements on pagination	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs are in #253, #252, #249, #250	Support for LIMIT, WHERE, ORDER BY and HAVING clauses and expressions, tests
Test JDBC with V2 pagination	@Yury-Fridlyand	WIP	#254
Support reading different date formats	@GabeFernandez310	In Progress		Investigation and some refactoring	Update OpenSearch datatypes to support complex data types (dates, objects, text)

[acarbonetto]

Status report | Mar 29, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested feature branch for nested in SELECT clause.	@forestmvey	In Review		Awaiting further review.	Awaiting further review.
Add nested support in WHERE clause.	@forestmvey	In Progress		Begin implementation.	Implementing nested in WHERE clause.
Add support for selecting nested types in the SELECT clause without nested function.	@forestmvey	In Review		Fixing arrays parsing in V2 engine.	Awaiting review.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Progress		Implement solution	Implement solution with the bug fix
Investigate failing ODBC driver MacOS build.	@forestmvey	On-Hold		De-prioritized over nested implementation.
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	On upstream review #1483	Final fixes, rebase and publish to upstream	Address PR comments
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Writing scope and syntax;Proposal submitted to #opensearch_bq channel for discussion	Update proposal and PoC and link to proposal for PartiQL/Nested work with Lateral JOINs.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	On upstream review #1456		Address Peng/Chen’s code review comments
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	In Review	On upstream review #1464		Address upstream PR comments
Conduct datetime performance tests	@matthewryanwells	In Progress		Collected all results	Present results
Fix SUMbug	@matthewryanwells	In Progress		investigated bug	Continue investigating bug
Further improvements on pagination	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs are in #253, #252, #249, #250
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #253
Support reading different date formats	@GabeFernandez310	In Progress		Planning/design to support pre-defined formats. Planning for tests.	Update OpenSearch datatypes to support complex data types (dates, objects, text). Add tests where applicable.

[acarbonetto]

Status Update, Apr 4, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested for nested in SELECT clause.	@forestmvey	Upstream Review			Address PR comments and update PR.
Add nested support in WHERE clause.	@forestmvey	In Progress		Continued implementation.	Continued implementation.
Add support for selecting nested types in the SELECT clause without nested function.	@forestmvey	Upstream Review		In review with Nested PR upstream.
Add support for nested function as function arguments in SELECT clause	@GumpacG	In Progress		Implemented solution	Add integration and unit tests
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Progress	Paused on upstream PR for Nested in SELECT getting merged	Implemented solution
Investigate failing ODBC driver MacOS build.	@forestmvey	On-Hold		De-prioritized over nested implementation.
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	On upstream review #1483	Address PR comments	Address PR comments: push down
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Writing scope and syntax;Proposal submitted to #opensearch_bq channel for discussion	Update proposal and PoC and link to proposal for PartiQL/Nested work with Lateral JOINs.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	On upstream review #1456		Address Peng/Chen’s code review comments
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	In Review	On upstream review #1464		Address upstream PR comments
Conduct datetime performance tests	@matthewryanwells	In Progress			Presenting at Tuesday Sync-up
Fix SUMbug	@matthewryanwells	In Progress		Addressed Comments	Add tests
Further improvements on pagination	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs in #253
Rework cursor serialization	@Yury-Fridlyand	In Review	On team review #252	Complete fixes and tests	Address Comments
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #253
Support reading different date formats	@GabeFernandez310	In Progress		Fixed support for custom and predefined formats. Started investigating a bug.	Continue with bug fixing and implementation

[acarbonetto]

Status Update | April 7th & weekend, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Implement first PR to nested for nested in SELECT clause.	@forestmvey	Upstream Review		Address PR comments and revise PR.	Address PR comments and revise PR.
Add nested support in WHERE clause.	@forestmvey	In Progress		Continued implementation.	Integrating with new changes from SELECT clause PR.
Add support for selecting nested types in the SELECT clause without nested function.	@forestmvey	Upstream Review		In review with Nested PR upstream.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Progress		Rebased and refactor based on upstream changes	Continue to refactor
Investigate failing ODBC driver MacOS build.	@forestmvey@MaxKsyunz	In Review	On upstream review odbc#38
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	On upstream review #1497
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Writing scope and syntax;Proposal submitted to #opensearch_bq channel for discussion	Update proposal and PoC and link to proposal for PartiQL/Nested work with Lateral JOINs.
Allow metadata fields with _ (#639, #339, #432, #1133)	@acarbonetto	In Review	On upstream review #1456		Waiting to merge
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	In Review	On upstream review #1464		Address upstream PR comments
Conduct datetime performance tests #237	@matthewryanwells	In Progress			Presenting at Tuesday Sync-up
Fix SUM bug #1052, OpenSearch#5537	@matthewryanwells	In Progress	PoC is up to discuss a solution: OpenSearch#6484	Addressed Comments	Add tests
Further improvements on pagination: ORDER BY, LIMIT	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs in #253
WHERE in pagination	@Yury-Fridlyand	In Review	On upstream review #1500	Publish PR
Rework cursor serialization	@Yury-Fridlyand	In Review	On upstream review #1498	Publish PR
Rework pagination push down	@Yury-Fridlyand	In Progress	WIP in #1499	Publish PR
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #253
Support reading different date formats	@GabeFernandez310	In Progress		Continued to fix support for predefined formats.	Fix any failing formats. Support function properties to be passed to the TIME type when reading some formats.

[acarbonetto]

Status Update Apr 11, 2023

Add nested support in WHERE clause.	@forestmvey	In Progress		Integrating with new changes from SELECT clause PR.	Continued development.
Add support for selecting nested types in the SELECT clause without nested function.	@forestmvey	Upstream Review		In review with Nested PR upstream.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Progress		Rebased and refactor based on upstream changes	Continue to refactor
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	On upstream review #1497
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Writing scope and syntax;Proposal submitted to #opensearch_bq channel for discussion	Update proposal and PoC and link to proposal for PartiQL/Nested work with Lateral JOINs.
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Add support for JSON output on the V2 engine #1317	@GumpacG	Paused	On upstream review #1464		Address upstream PR comments
Fix SUM bug #1052, OpenSearch#5537	@matthewryanwells	In Progress	PoC is up to discuss a solution: OpenSearch#6484	Addressed Comments	Add tests
Further improvements on pagination: ORDER BY, LIMIT	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs in #253
WHERE in pagination	@Yury-Fridlyand	In Review	On upstream review #1500	Publish PR
Rework cursor serialization	@Yury-Fridlyand	In Review	On upstream review #1498	Publish PR
Rework pagination push down	@Yury-Fridlyand	In Progress	WIP in #1499	Publish PR
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #253
Support reading different date formats	@GabeFernandez310	In Progress		Fixed Issues with returned ExprCoreType.	Fix tests.

[acarbonetto]

Status Update | April 14, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	In Progress		Pushed branch changes for internal review.	Allow filter push down with select clause bool query.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	Paused	Waiting for nested upstream to get merged
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	On upstream review #1497		Address PR comments
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Writing scope and syntax;Proposal submitted to #opensearch_bq channel for discussion	Update proposal and PoC and link to proposal for PartiQL/Nested work with Lateral JOINs.
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Support preemptive authentication for #28	@GumpacG	In Progress		Investigated	Implement a secure and sound solution for preemptive authentication
Fix SUM bug #1052, OpenSearch#5537	@matthewryanwells	In Progress	PoC is up to discuss a solution: OpenSearch#6484	Implemented solution	Test to confirm solution works
Further improvements on pagination: ORDER BY, LIMIT	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs in #253
WHERE in pagination	@Yury-Fridlyand	In Review	On upstream review #1500
Rework cursor serialization	@Yury-Fridlyand	In Review	On upstream review #1498
Rework pagination push down	@Yury-Fridlyand	In Progress	WIP in #1499
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #253
Rework Logical Plan Optimizer for pagination	@MaxKsyunz	In Review	On upstream review #1516
Support reading different date formats	@GabeFernandez310	In Progress		Continued Fixing IT Tests	Continue with testing and address any comments on PoC. Rework implementation if necessary.

[acarbonetto]

Status Update | Apr 17th, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	In Progress		Allow filter push down with select clause bool query.	Fix inner hits in DSL push down to allow querying of inner fields of array types.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Progress			Rebase upstream main and refactor
Clean up code	@Yury-Fridlyand	In Review	On upstream review #1310
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	On upstream review #1497	Rebase and resolve conflicts
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Writing scope and syntax;Proposal submitted to #opensearch_bq channel for discussion	Update proposal and PoC and link to proposal for PartiQL/Nested work with Lateral JOINs.
Add cursor IT with JDBC	@Yury-Fridlyand	In Review	On upstream review #1315
Support preemptive authentication for #28	@GumpacG	In Internal Review	POC for review #4	Created POC
Fix SUM bug #1052, OpenSearch#5537	@matthewryanwells	In Progress	PoC is up to discuss a solution: OpenSearch#6484	Tested solution	Continue testing
Further improvements on pagination: ORDER BY, LIMIT	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs in #253
WHERE in pagination	@Yury-Fridlyand	In Review	On upstream review #1500	Rebase and resolve conflicts
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #253
Rework Logical Plan Optimizer for pagination	@MaxKsyunz	Done	On upstream review #1516
Support reading different date formats	@GabeFernandez310	In Progress		Fixed IT Tests caused by OpenSearchDataType rework	Rework implementation to fix incorrect type being reported for some tests.

[acarbonetto]

Status Update | Apr 24, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	On Hold		re-visit design to create documentation.
Nested support in SELECT clause design documentation.	@forestmvey	In Progress		Begin documentation.	Documentation continued.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Progress			Add unit tests and discuss desired implementation
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	On upstream review #1497	Add docs	Add more docs & new demo
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441
Support preemptive authentication for #28	@GumpacG	In Internal Review	POC for review #4
Investigate possible bug in arithmetic functions	@matthewryanwells	In Progress			Investigate
Further improvements on pagination: ORDER BY, LIMIT	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs in #253
WHERE in pagination	@Yury-Fridlyand	In Review	On upstream review #1500
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #253
Support reading different date formats	@GabeFernandez310	In Progress		Fixed all IT and Unit Tests. Added tests to address JaCoCo issues and fixed Checkstyle.	Continue Addressing Comments. Update Documentation.
Investigate ODBC issue with AWS_SIGv4 authentication	@Yury-Fridlyand	In Progress

[acarbonetto]

Status Update | Apr 25, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	On Hold		re-visit design to create documentation.
Nested support in SELECT clause design documentation.	@forestmvey	In Progress		Documentation continued.	Documentation continued.
Nested SELECT clause demo video.	@forestmvey	In Progress			Record and Post demo.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	In Internal Review		Added unit tests and discuss desired implementation
Pagination in v2 sql engine	@MaxKsyunz@Yury-Fridlyand	In Review	On upstream review #1497	Add docs	Add more docs & new demo
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Putting together a github proposal for same-table design
Support preemptive authentication for #28	@GumpacG	In Internal Review	POC for review #4
Investigate possible bug in arithmetic functions	@matthewryanwells	In Progress	Upstream PoC review OpenSearch#6984		Investigate solution
Further improvements on pagination: ORDER BY, LIMIT	@Yury-Fridlyand@MaxKsyunz	WIP	PoCs in #253
WHERE in pagination	@Yury-Fridlyand	In Review	On upstream review #1500
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #253
Support reading different date formats	@GabeFernandez310	In Progress		Fixed all IT and Unit Tests. Added tests to address JaCoCo issues and fixed Checkstyle.	Continue Addressing Comments. Update Documentation.
Investigate ODBC issue with AWS_SIGv4 authentication	@Yury-Fridlyand	In Review	Raised issue: sql-odbc#39Most recent fixes are not in the v1.4 driver (also, it is not yet signed)Will need to release a new driver on completion

[acarbonetto]

Status Update | May 4th, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	On Hold		re-visit design to create documentation.
Nested support in SELECT clause design documentation.	@forestmvey	Internal Review		Documentation continued.
Nested WHERE clause documentation proposal.	@forestmvey	In Progress		Begin.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	Paused
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Putting together a github proposal for same-table design
Update anonymizer to now engine	@matthewryanwells	In Progress		Investigated legacy annonymizer	Continue investigating legacy annonymizer
Update documentation for pagination	@Yury-Fridlyand	In Review	On upstream review #1592		Update docs according to team review
WHERE and HAVING in pagination	@Yury-Fridlyand	In Review	On upstream review #1500
ORDER BY and LIMIT in pagination	@Yury-Fridlyand	On hold	On upstream review #1599, depends on #1500
Merge index scans for pagination	@MaxKsyunz	In Progress	On upstream review #1600
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #1599 and #1500
Support reading different date formats	@GabeFernandez310@GumpacG	In Progress			Refactor to remove support for user defined formats
Investigate ODBC issue with AWS_SIGv4 authentication	@Yury-Fridlyand	In Review	Raised issue: sql-odbc#39Most recent fixes are not in the v1.4 driver (also, it is not yet signed)Will need to release a new driver on completion

[acarbonetto]

Status Update - May 8, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	On Hold		re-visit design to create documentation.
Nested support in SELECT clause design documentation.	@forestmvey	Internal Review		Documentation continued.	Revise based on internal review.
Nested WHERE clause documentation proposal.	@forestmvey	In Progress		Continue design for both syntax options to make decision based on design for implementation priority.	Design Continued.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	Paused
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Putting together a github proposal for same-table design
Update anonymizer to now engine	@matthewryanwells	In Progress		Begun setting up tests for new data anonymizer	Compare new anonymizer results to legacy anonymization
Update documentation for pagination	@Yury-Fridlyand	In Review	On upstream review #1592		Update docs according to the team review
WHERE and HAVING in pagination	@Yury-Fridlyand	In Review	On upstream review #1500
ORDER BY and LIMIT in pagination	@Yury-Fridlyand	On hold	On upstream review #1599, depends on #1500
Merge index scans for pagination	@MaxKsyunz	In Review	On upstream review #1600
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #1599 and #1500
Support reading different date formats	@GabeFernandez310@GumpacG	In Progress		Removed support for time only or date only formats	Address PR comments and modify IT to only include supported formats
Investigate ODBC issue with AWS_SIGv4 authentication	@Yury-Fridlyand	In Review	Raised issue: sql-odbc#39Most recent fixes are not in the v1.4 driver (also, it is not yet signed)Will need to release a new driver on completion	Try to reproduce customer environment with VPC	Continue experiments

[acarbonetto]

Status Update | May 10, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	On Hold		re-visit design to create documentation.
Nested support in SELECT clause design documentation.	@forestmvey	Upstream Review
Nested WHERE clause documentation proposal.	@forestmvey	In Progress		Design Continued.	Design Continued.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	Paused
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Design up for review
Update anonymizer to now engine	@matthewryanwells	In Progress		Set up tests to test new anonymizer against	Begin updating PPL anonymizer to SQL
Update documentation for pagination	@Yury-Fridlyand	In Review	On upstream review #1592		Update docs according to the team review
WHERE and HAVING in pagination	@Yury-Fridlyand	In Review	On upstream review #1500
ORDER BY and LIMIT in pagination	@Yury-Fridlyand	On hold	On upstream review #1599, depends on #1500
Merge index scans for pagination	@MaxKsyunz	In Review	On upstream review #1600
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #1599 and #1500
Support reading different date formats	@GabeFernandez310@GumpacG	In Progress		Addressed PR comments and modified IT to only include supported formats	Continue to address PR comments
Investigate ODBC issue with AWS_SIGv4 authentication	@Yury-Fridlyand	In Review	Raised issue: sql-odbc#39Most recent fixes are not in the v1.4 driver (also, it is not yet signed)Will need to release a new driver on completion	Try to reproduce customer environment with VPC	Continue experiments

[acarbonetto]

Status Update | May 15th, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	On Hold		re-visit design to create documentation.
Nested support in SELECT clause design documentation.	@forestmvey	Upstream Review
Nested WHERE clause documentation proposal.	@forestmvey	In Progress		Design Continued.	Design Continued.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	Paused
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Design up for review
Update anonymizer to now engine	@matthewryanwells	In Progress		Updated SQL anonymizer	Continue updating SQL anonymizer
Update documentation for pagination	@Yury-Fridlyand	In Review	On upstream review #1592		Update docs according to the team review
WHERE and HAVING in pagination	@Yury-Fridlyand	In Review	On upstream review #1500
ORDER BY and LIMIT in pagination	@Yury-Fridlyand	On hold	On upstream review #1599, depends on #1500
Merge index scans for pagination	@MaxKsyunz	In Review	On upstream review #1600
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #1599 and #1500
Support reading different date formats	@GabeFernandez310@GumpacG	In Progress		Addressed PR comments and modified IT to only include supported formats	Continue to address PR comments
Investigate ODBC issue with AWS_SIGv4 authentication	@Yury-Fridlyand	In Progress	Raised issue: odbc#39, odbc#41Fix PoC in odbc#42	Find the root cause and make a PoC	Continue testing
Release JDBC driver	@Yury-Fridlyand	In Review	jdbc#75	Complete release preparations

[acarbonetto]

Status Update | May 18, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	In Progress		Continued implementation of WHERE clause nested function in predicate expression.	Add test coverage.
Nested support in SELECT clause design documentation.	@forestmvey	Upstream Review
Nested WHERE clause documentation proposal.	@forestmvey	Internal Review			Revise based on comments.
Add field.* functionality to nested function in SELECT clause.	@GumpacG	Paused
(design) Planning for JOINs development	@acarbonetto	In Progress	Same-table JOIN #1441	Design up for review
Update anonymizer to now engine	@matthewryanwells	In Progress		Submitted PR	Address comments
Update documentation for pagination	@Yury-Fridlyand	In Review	On upstream review #1592		Update docs according to the team review
WHERE and HAVING in pagination	@Yury-Fridlyand	In Review	On upstream review #1500	Demo
ORDER BY and LIMIT in pagination	@Yury-Fridlyand	On hold	On upstream review #1599, depends on #1500
Merge index scans for pagination	@MaxKsyunz	In Review	On upstream review #1600
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #1599 and #1500
Support reading different date formats	@GabeFernandez310@GumpacG@acarbonetto	In Progress		Addressed PR comments and modified IT to only include supported formats	Continue to address PR comments
Investigate ODBC issue with AWS_SIGv4 authentication	@Yury-Fridlyand	In Progress	Raised issue: odbc#39, odbc#41Fix PoC in odbc#42	Continue testing	Continue testing

[acarbonetto]

Status Update | May 26, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	In Review		Make upstream PR.	Awaiting PR feedback.
Add nested all fields support.	@forestmvey	In Progress		Begin implementing.	Development continued.
Nested support in WHERE clause design documentation.	@forestmvey	In Review	On upstream review #1640
Update anonymizer to new engine	@matthewryanwells	In Review	In review #226	Addressed comments	Continue addressing comments
WHERE and HAVING in pagination	@Yury-Fridlyand	In Review	On upstream review #1500
ORDER BY and LIMIT in pagination	@Yury-Fridlyand	On hold	On upstream review #1599, depends on #1500
Merge index scans for pagination	@MaxKsyunz	In Review	On upstream review #1600		WIP
Pagination docs update	@MaxKsyunz	In Review	On upstream review #1644
Remove getTotalHits feature	@Yury-Fridlyand	In Review	On upstream review #1649
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #1599 and #1500
Support reading different date formats	@GumpacG@acarbonetto	In Review	Internal review #268	Completed unit test coverage, checkstyle, and added more integration tests.	Address PR comments
Investigate ODBC issue with AWS_SIGv4 authentication	@Yury-Fridlyand	In Review	FIX: odbc#42		Verify the fix
Close cursor API in V2	@Yury-Fridlyand	In Progress	#1660	WIP	WIP
Fixing prometheus start issue when last run was crashed	@MitchellGale	In Progress	Fixing issue: #1083	Attempted at changing dependencies in build.gradle for doctest and integ-test

[MitchellGale]

May 30th, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Add nested support in WHERE clause.	@forestmvey	In Review	On upstream review #1657		Awaiting PR feedback.
Add nested all fields support.	@forestmvey	In Progress		Development continued.	Adding code coverage and cleaning up implementation.
Nested support in WHERE clause design documentation.	@forestmvey	In Review	On upstream review #1640
Update anonymizer to new engine	@matthewryanwells	In Review	On upstream review #1665	Passed tests	Get merged
WHERE and HAVING in pagination	@Yury-Fridlyand	In Review	On upstream review #1500		Rebase and resolve conflicts
ORDER BY and LIMIT in pagination	@Yury-Fridlyand	On hold	On upstream review #1599, depends on #1500
Merge index scans for pagination	@MaxKsyunz	Complete	On upstream review #1600	Done
Pagination docs update	@MaxKsyunz	Complete	On upstream review #1644	Done
Remove getTotalHits feature	@Yury-Fridlyand	In Review	On upstream review #1649		Rebase and resolve conflicts
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #1599 and #1500
Support reading different date formats	@GumpacG@acarbonetto	In Review	On upstream review #1664
Investigate ODBC issue with AWS_SIGv4 authentication	@Yury-Fridlyand	In Review	FIX: odbc#42
Close cursor API in V2	@Yury-Fridlyand	Done	On upstream review #1660		Rebase and resolve conflicts
Fixing prometheus start issue when last run was crashed	@MitchellGale	In Review	Fixing issue: #1083	Finished as forked PR Made changes to build.gradle for doctest and integ-test to make stop Prometheus by MitchellGale · Pull Request #270 · Bit-Quill/opensearch-project-sql
Fix sql-cli folder delete issuie	@MitchellGale	In Progress	1675		Working on fix for [BUG] delete of sql-cli is not run if build does not complete · Issue #1675 · opensearch-project/sql

[acarbonetto]

Status Update | June 2nd

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Support inner_hits ExprValue construction.	@forestmvey	In Progress		Beginning ticket.
Add nested all fields support.	@forestmvey	On Hold
Website Documentation for nested in 2.8 release.	@forestmvey	In Progress		Documenting changes for release.
WHERE and HAVING in pagination	@Yury-Fridlyand	In Review	On upstream review #1500		Rebase and resolve conflicts
ORDER BY and LIMIT in pagination	@Yury-Fridlyand	On hold	On upstream review #1599, depends on #1500
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #1599 and #1500
Fixing prometheus start issue when last run was crashed	@MitchellGale	In Review	Fixing issue: #1083
Fix sql-cli folder delete issue	@MitchellGale	Paused	1675
Fix ODBC installer	@Yury-Fridlyand	In Review	odbc#44	WIP, verification	Completed
ODBC driver release preparations	@Yury-Fridlyand	In Review	odbc#45odbc#46odbc#47odbc#48odbc#49		Completed
Fix JDBC driver for VPC + SSH tunnel case	@Yury-Fridlyand	In Progress	jdbc#83	WIP	WIP
Update OpenSearch Improving website link	@matthewryanwells	In Review	1639	Address Comments	Wait to be merged
Fix byte divide/modulus bug	@matthewryanwells	In Review	272	Address Comments	Address Comments
Update OpenSearch website arithmetic documentation	@matthewryanwells	In Review	4232	Addressed Comments	Post upstream PR
Spike on supporting user-defined datetime formats	@GumpacG	In Review	Possible solution in internal review #273	Implemented a possible solution	Discuss solution
Spike on adding new type for text	@GumpacG	In Progress			Ramp-up on the issue at hand
OpenTelemetry Exporter for OpenSearch	@MaxKsyunz	In Progress		Setup public fork, transferred code, issues, and project to it	Submit first PR to opentelemetryUpdate exporter code to latest

[acarbonetto]

Status Update | June 5th, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Support inner_hits ExprValue construction.	@forestmvey	In Progress		Beginning ticket.	Finding way to support for nested and non-nested data response.
Add nested all fields support.	@forestmvey	On hold
Website Documentation for nested in 2.8 release.	@forestmvey @andrew Carbonetto	In Progress			Adding documentation for score and metafields
WHERE and HAVING in pagination	@Yury-Fridlyand	In Review	On upstream review #1500		Rebase and resolve conflicts
ORDER BY and LIMIT in pagination	@Yury-Fridlyand	On hold	On upstream review #1599, depends on #1500
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #1599 and #1500
Fixing prometheus start issue when last run was crashed	@MitchellGale	In Review	Fixing issue: #1083		Continue bug fixing issues in GHA after PR review comments were addressed
Fix sql-cli folder delete issue	@MitchellGale	Paused	1675
Fix ODBC installer	@Yury-Fridlyand	In Review	odbc#44	WIP, verification	Completed
ODBC driver release preparations	@Yury-Fridlyand	In Review	odbc#45odbc#46odbc#47odbc#48odbc#49		Completed
Fix JDBC driver for VPC + SSH tunnel case	@Yury-Fridlyand	In Progress	jdbc#83	WIP	WIP
Update OpenSearch Improving website link	@matthewryanwells	In Review	1639	Waiting to be merged	Waiting to be merged
Fix byte divide/modulus bug	@matthewryanwells	In Review	272	Address Comments	Address Comments
Update OpenSearch website arithmetic documentation	@matthewryanwells	In Review	4232	Waiting to be merged	Waiting to be merged
Dev Sum fix	@matthewryanwells	In Progress			Familiarize self with code and start work	Fork doesn’t have imports working
Spike on supporting user-defined datetime formats	@GumpacG	In Review	Possible solution in internal review #273	Implemented a possible solution	Discuss solution
Spike on adding new type for text	@GumpacG	In Progress			Ramp-up on the issue at hand
OpenTelemetry Exporter for OpenSearch	@MaxKsyunz	In Progress		Setup public fork, transferred code, issues, and project to it	Submit first PR to opentelemetryUpdate exporter code to latest
2.8 Release checklist	@andrew Carbonetto	In Review		All testing and sanity checks are complete. Checklist is in final stages.	Setup post-release items (retrospective) with team and complete checklist items (documentation)

[acarbonetto]

Status Update - June 9, 2023

Topic	Dev	Status	Comments	What have you done yesterday?	What are you going to do today?	Any impediments?	ETA
Support inner_hits ExprValue construction.	@forestmvey	In Progress		Add IT tests, cleanup code, make internal PR.	Revise based on PR feedback.
Add nested all fields support.	@forestmvey	On hold
Website Documentation for nested in 2.8 release.	@forestmvey@acarbonetto	In Progress		Adding documentation for score and metafields	Continue documentation for nested.
WHERE and HAVING in pagination	@Yury-Fridlyand	In Review	On upstream review #1500
ORDER BY and LIMIT in pagination	@Yury-Fridlyand	On hold	On upstream review #1599, depends on #1500		Rebase and resolve conflicts
Test JDBC with V2 pagination	@Yury-Fridlyand	On hold	#254, depends on #1599 and #1500
Fixing prometheus start issue when last run was crashed	@MitchellGale	In Review	Fixing issue: #1083		Continue bug fixing issues in GHA after PR review comments were addressed
Fix sql-cli folder delete issue	@MitchellGale	Paused	1675
Fix ODBC installer	@Yury-Fridlyand	In Review	odbc#44
ODBC driver release preparations	@Yury-Fridlyand	In Review	odbc#45odbc#46odbc#47odbc#48odbc#49odbc#50odbc#51
Fix JDBC driver for VPC + SSH tunnel case	@Yury-Fridlyand	In Review	jdbc#83
JDBC driver release preparations	@Yury-Fridlyand	In Review	jdbc#85jdbc#86jdbc#87jdbc#88jdbc#89
Fix byte divide/modulus bug	@matthewryanwells	In Review	1716	Upstream PR	Waiting to be merged
Update OpenSearch website arithmetic documentation	@matthewryanwells	In Review	4232	Waiting to be merged	Address Comments
Dev Sum fix	@matthewryanwells	In Progress	6984	Set up optional parameter on the sum function	Fix bug using new optional parameter
Spike on supporting user-defined datetime formats	@GumpacG	In Review	Possible solution in internal review #273	Implemented a possible solution	Discuss solution
Make Tableau connector submission	@GumpacG	In Progress		Conducted testing	Set up docker with multiple nodes to attempt to make test results more consistent
OpenTelemetry Exporter for OpenSearch	@MaxKsyunz	In Progress		Submit first PR to opentelemetryUpdate exporter code to latest	Add opensearchexporter to otelcolcontribRecord demo
2.8 Release checklist	@acarbonetto	In Review		All testing and sanity checks are complete. Checklist is in final stages.	Setup post-release items (retrospective) with team and complete checklist items (documentation)