if i have 300 tables and want to use DBD to create projections, since vertica has limit of 100 queries how will it create optimal projections.
Should we split per 100 tables and run 3 times and have 1 query per table and also have at least 1 row inserted per table .
DBD suggestion
+2
+2Hi,
You do not need to submit an individual query for all three hundred tables!
Typically, you first create a "Comprehensive" design which runs against all of the tables. You can also supply queries for Vertica to create query specific projections. Those queries are the one that folks are running in the DB should table joins, where clause predicates, order by statements and group by statements.
Did you create a "Comprehensive" design yet?
+2not yet. planning to do.Found we can have more than 100 when using comprehensive mode,Incremental has limit of 100
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
