soda-core icon indicating copy to clipboard operation
soda-core copied to clipboard

Freshness does not work with date datatype

Open albinkjellin opened this issue 2 years ago • 2 comments

Freshness does not work with a date datatype.

albinkjellin avatar Apr 15 '22 09:04 albinkjellin

Getting this Error log as well,

Could not evaluate freshness: max(PARTITION_DATE) is not a datetime: date

Freshness Check [NOT EVALUATED]
INFO   |         max_column_timestamp: 2022-08-10
INFO   |         max_column_timestamp_utc: None
INFO   |         now_variable_name: NOW
INFO   |         now_timestamp: 2022-08-10T22:58:08.875657+00:00
INFO   |         now_timestamp_utc: 2022-08-10 22:58:08.875657+00:00
INFO   |         freshness: None

jrsalazar14 avatar Aug 11 '22 16:08 jrsalazar14

Adding another +1 from a new user who would wish to use a column with just date to check for freshness.

janet-can avatar Aug 17 '22 22:08 janet-can

Adding a +1 as well, we bump into this in several places

geertjan-garvis avatar Oct 25 '22 19:10 geertjan-garvis

CORE-335

janet-can avatar Nov 01 '22 16:11 janet-can

Closed by #1667

vijaykiran avatar Nov 03 '22 10:11 vijaykiran

Closed by #1667

Fantastic, thank you Vijay!

geertjan-garvis avatar Nov 03 '22 10:11 geertjan-garvis

@geertjan-garvis - merged but not yet released! Just FYI :)

janet-can avatar Nov 03 '22 17:11 janet-can

@janet-can - understood :-)

geertjan-garvis avatar Nov 04 '22 08:11 geertjan-garvis