View returns only 1000 rows. But underlying SQL returns much more.
I use Vertica CE 6.1.2. I've created table "test.TABLE1" and inserted 3123 rows. Afterwards I created view "test2.VIEW1" in another schema - create view TEST2.VIEW1 as select * from test.TABLE1; But "select count(1) from test2.VIEW1" return only 1000 rows. What can it be???