DB Designer failing to deploy projections
I created table in my vertica cluster, loaded it with data, created queries file with the list of queries we are using in our application and started DB designer (Comprehencive, optimized for queries). Designer finished but not deployed projections. See output below:
Database Designer started.
For large databases a design session could take a long time; allow it to complete uninterrupted.
Use Ctrl+C if you must cancel the session.
Setting up design session...
Examining table data...
Loading queries from '/home/ec2-user/q'.
Processed 7 SQL statement(s), all accepted and considered in the design.
No existing projections found.
Creating design and deploying projections...
[100%] Analyzing data statistics... Completed of .
[100%] Optimizing query performance... Completed of .
[100%] Design in progress... Completed of .
[100%] Optimizing storage footprint... Completed of .
Query optimization results...ent script...
Query 1 optimization ratio or status is 1
Query 2 optimization ratio or status is 1
Query 3 optimization ratio or status is 1
Query 4 optimization ratio or status is 1
Query 5 optimization ratio or status is 1
Query 6 optimization ratio or status is 1
Query 7 optimization ratio or status is FULLY OPTIMIZED BY EXISTING PROJECTIONS
Deploying and generating deployment script...
[ 0%] Deploying/Dropping projections... Completed 0 of 9 projections.
Completed 0 of 9 projections.
WARNING: Count mismatch. Some tables/projections could have been dropped by user before deployment or while deploying
Design script is located in /home/ec2-user/designer/admp_design.sql
Deployment script is located in /home/ec2-user/designer/admp_deploy.sql
Database Designer finished.
Press <Enter> to return to the Administration Tools menu.
What should I do now in order to make projections deployed. Why this is happenning ?