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