We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


How Vertica take the right projecton when view using in query? — Vertica Forum

How Vertica take the right projecton when view using in query?

I've got view created like select * from table1.
I've got two projections on table1: projection1 and projection2
I've got query which joins table1 with table2.
When I use view for join operation Vertica takes projection1 (not the right projection for query optimization) but when I use table1 in sql query Vertica take projection2.

What is the point?


PS
I know that I can use select * from projection2 in my view expression and it works.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file