The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
flattened tables question

Hi!
I have a flattened tables question:
Can I create live aggregate projections on flattened tables ? If I want to groupby or create aggregations on the columns? is it possible somehow?
Thanks!
Keren
0
Answers
And another issue regarding the flattened tables: Can I use the default or SET USING constraint to populate a column that is aggregate function?
something like -
CREATE TABLE public.spins_flattened
(
...
cid int REFERENCES public.spins(id),
PlayerId_f int DEFAULT (SELECT PlayarId FROM public.spins
WHERE public.spins(id) = spins_flattened.cid);
,
registered_time timestamp SET USING (
SELECT min(time) FROM public.spins WHERE (spins.playerId = spins_flattened.PlayerId_f) group by 1 ),
...
Can you cretae a LAP on a Flattened Table? Sure!
Can I use the default or SET USING / DEFAULT constraint to populate a column that is aggregate function? Sure!
Wow SUPERB!
Thank!!!!
And if I want to refresh_columns every 24 hours can I do it automatically somehow through the vertica or do I need a third party app?
Vertica doesn't have a built-in scheduler like that. But you could easily add a SQL command to refresh every 24 hours via crontab.
That sounds like a plan
Many thanks for all your help!
awesome support !