VValdar
Employee
VValdar Employee
Reactions
-
Re: Get new records from dataview
Hi ramik_allakhverdiev, Well that would be a basic filter: select * from MyTable where greatest(etl_created_at, etl_updated_at)::date >= current_date - 1 and greatest(etl_created_at, etl_updated_a… (View Post)1 -
Re: argmax_agg function usage
Hi Igor, Beside the opening of a support ticket, maybe you could try to rewrite your query using a topK mechanism: select field_1, field_2, Moment, KeyStart, SKey, Name, CSKey from table_1 limit 1 ov… (View Post)1 -
Re: SALT in Segmentation Clause
Hi mferrall, I was giving some thoughts around this use case, can't the utc_time column be serving as salt? It should give proper distribution accross the nodes, maybe you can use just a part of the … (View Post)1