Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG] earliest/latest not supported with where command #1020

Closed
currantw opened this issue Jan 24, 2025 · 0 comments · Fixed by #1021
Closed

[BUG] earliest/latest not supported with where command #1020

currantw opened this issue Jan 24, 2025 · 0 comments · Fixed by #1021
Labels
bug Something isn't working untriaged

Comments

@currantw
Copy link
Contributor

currantw commented Jan 24, 2025 •
edited
Loading

What is the bug?

The earliest and latest relative time functions (see #957) do not work with the where command:

source=timestamps | where earliest("now", timestamp)
source=timestamps | where latest("-1hr", timestamp)

How can one reproduce the bug?

Steps to reproduce the behaviour:
Execute either of the example PPL queries above.

What is the expected behaviour?

where command can be used with earliest and/or latest to filter data based on relative timestamps.

What is your host/environment?

Not applicable.

Do you have any screenshots?

Not applicable.

Do you have any additional context?

See #957 for more on relative date times.
@currantw currantw added bug Something isn't working untriaged labels Jan 24, 2025
@currantw currantw changed the title [BUG] earliest/latest no supported with where command. [BUG] earliest/latest not supported with where command Jan 24, 2025
@currantw currantw mentioned this issue Jan 24, 2025
Merged
5 tasks
YANG-DB pushed a commit that referenced this issue Jan 27, 2025
@currantw
#1020: earliest/latest not supported with where command (#1021)
3832906 
* Add earliest/latest to `conditionFunctionBase`.

Signed-off-by: currantw <[email protected]>

* Update doc and integ tests

Signed-off-by: currantw <[email protected]>

* Update/fix doc tests

Signed-off-by: currantw <[email protected]>

* Rename variable

Signed-off-by: currantw <[email protected]>

* scalafmtAll

Signed-off-by: currantw <[email protected]>

* Fix failing integ test

Signed-off-by: currantw <[email protected]>

* More scalafmt. Grrr...

Signed-off-by: currantw <[email protected]>

---------

Signed-off-by: currantw <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working untriaged
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

#1020: earliest/latest not supported with where command Bit-Quill/opensearch-spark
1 participant
@currantw