The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
- Last Active
- Vertica Employee, Member
Are flow_id and comp_id integers? And - I'd create super projections (any projection containing all columns of the anchor table is a super one), all ordered by flow_idand then comp_id (or the other w… (View Post)1
No, I don't think that 20 array tables for one main table should hurt too much. I would not, actually, expect a report to always include all 20 of those tables, so it wouldn't hurt too much at query … (View Post)1
Never tried that design, really. It can become awkward if the size of the arrays can change. What do you do if you have , in the example above, 5 refunds and 5 installments, and then installment 3 ne… (View Post)1
Your questions seems misleading in many respects: * With "load balancer", do you mean Connection Load Balancer? * Where do you see, from the query you issue, a node name? Connection Load Ba… (View Post)1
ROWS MATCH FIRST EVENT refers to the events in the DEFINE clause, in the order in which you specify them in there, not to the events in the pattern you're searching. (View Post)1