kn3jox
06/06/2025, 10:34 AMkn3jox
06/06/2025, 10:35 AMSELECT *
FROM your_table
WHERE __time >= (
SELECT MAX(__time)
FROM your_table
WHERE __time < CURRENT_TIMESTAMP
)kn3jox
06/06/2025, 10:35 AMAR
06/06/2025, 4:07 PMSELECT *
FROM your_table
WHERE __time >=
FLOOR(TIME_SHIFT(SELECT MAX(__time)
FROM your_table, 'P1D', -1) TO DAY)
This will give you all records from start of day of the prev day to the max timestamp in the table.kn3jox
06/18/2025, 2:21 PMkn3jox
06/18/2025, 2:21 PM__time >=
FLOOR(TIME_SHIFT(SELECT MAX(__time)
FROM "druid"."My Rawdata", "P1D", -1) TO DAY)kn3jox
06/18/2025, 2:22 PMkn3jox
06/18/2025, 2:22 PMError: druidException (INVALID_INPUT): Received an unexpected token [-] (line [7], column [65]), acceptable options: [<IDENTIFIER>, <HYPHENATED_IDENTIFIER>, <QUOTED_IDENTIFIER>, <BACK_QUOTED_IDENTIFIER>, <BIG_QUERY_BACK_QUOTED_IDENTIFIER>, <BRACKET_QUOTED_IDENTIFIER>, <UNICODE_QUOTED_IDENTIFIER>, "LATERAL", "(", "UNNEST", "TABLE"]kn3jox
06/18/2025, 2:23 PM