Analytic functions with an empty PARTITION BY clause will cause all records to be transferred to the initiator node. (Vertica documentation warns about this somewhere.) You can try doing an EXPLAIN p… (View Post)