VValdar
Employee
VValdar Employee
Reactions
-
Re: Scheduling DROP_PARTITIONS on vertica
Hi prad33p2301, You can put your logic into a stored procedure then schedule it in-database: https://docs.vertica.com/24.1.x/en/extending/stored-procedures/executing-stored-procedures/triggers/schedu… (View Post)2 -
Re: Optimizing Vertica Schemas for a Low Latency Application
It depends the kind of query you'll run, but you want the data to be preprocessed (either using a datamart or specific LAP projections). You'll probably want some partitioning (probably your dashboar… (View Post)1 -
Re: Expert advice on slow running query
I'm a bit worried on the max over() without any partition by. You should also publish DDL and explain of this query. Profiling will also give you a nice view of the consuming part of the query. (View Post)1 -
Re: Other special values besides NULL?
Hi Pieter_Sheth-Vo, You're only lacking the knowledge of the grouping function that let you know if it's a base line row or a rolled up one. with cte_base (numeral, name) as(select 1 , 'one' union al… (View Post)1 -
Re: Median in the moving window
Hi Ralf_S, You can do the trick involving a complementary self-join. This is far from perfect I agree but still working: select t1.symbol, t1.date, t1.volume , approximate_median(t2.volume) from MyTa… (View Post)1