How to get Data from Single Node
I have a table with segmented and i have loaded the data .i have 3 node cluster and the data is spread across cluster and i want to fetch the data which is only resides in Node1.Is it possible to get.
Create table ABC( A Int,B Varchar); ## segmentation is on A and B
i have inserted 20 rows..and the rows are distributed across and i can see that in Projection_storage
Lets the data reside like this.
Node 1--- 7 rows
Node 3-- 7 rows
Now i want to extract only Node 1 data which are 7 rows only.
Can it be possible???