select count(*) on a vectorwise view

[martymonster]

Hi There,

I have a vectorwise table with several thousand rows.

I create a view on this table. The view is clearly working in the vectorwise database and returns lots of rows (>5000).

On a distributed database on another node I register this view.

Then in the distributed database....
If I select count(*) from my_view I get the answer zero.

If I select * from my_view I get all the thousands of rows returned.

Marty

[makni01]

Hi Marty,

As you probably already know, STAR is not supported with Vectorwise.