The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
SELECT all data such that a single-node query plan is maintained
Assume I have a table defined as
CREATE TABLE checkout ( id INT ENCODING RLE, transaction_timestamp TIMESTAMP ENCODING DELTAVAL, transaction_amount DOUBLE PRECISION ) ORDER BY transaction_timestamp SEGMENTED BY hash(id) ALL NODES;
My Vertica cluster has 3 nodes. I want to go to one of those nodes and
SELECT * FROM checkout; such that the data is present locally and the query is executed only on that node. Is there a way to do this?