Query Based Projections

Moderator: NorbertKrupa

Post Reply
rajasekhart
Intermediate
Intermediate
Posts: 87
Joined: Wed Apr 25, 2012 8:10 am

Query Based Projections

Post by rajasekhart » Wed May 09, 2012 11:12 am

Hi,

How can i create Query based projections in vertica Database?

Thank you,
Raj
Rajasekhar.T|HP ATP Vertica Big Data Solutions V1

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: Query Based Projections

Post by nnani » Fri May 18, 2012 12:39 pm

Buddy,

You can easily create Query based Projections with the help of admintool.

While running the DBD with some exsiting data in a table try to go with the query specific design.
Make sure you put the correct path of your query file.
Note - With the Latest release of Vertica 5.1 it can accept up to 100 queries in the query input file for a query-specific design.

Let me know i this works for you.
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “Vertica Database Development”