Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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?