View return more data than the base table.
The view is a sub set of a base table. But sometimes it return more data than the base table. Sounds impossible. But happened to us 4 times in Vertica. Had open a case with support. No vail. We load data to a staging schema. At the end we swap the schema. So we will always have data available even the load fail (too damn often). I am not sure how the view get more data (may be the previous schema) or where it gets from. But our users can find out from online report and tell us from time to time. Once we refresh the view (recreate or replace), everything back to normal. This is not good for our credibility. Hope someone might have some insights. Thanks, Yongzhi