Skip to main content

Syntax error during execution of database designer

  • May 9, 2014
  • 1 reply
  • 10 views

Nicholas_Chamma
Forum|alt.badge.img+1
I'm trying to run the database designer to fix my cluster's K-safety. I got the following error, which seems like a bug in the designer.
The deployment error is Deployment did not complete successfully.  ERROR - Deployment did not complete because of error -- Error querying: select dp.deployment_id, dp.deployment_projection_id, dp.design_name, dp.deployment_projection_name, dp.anchor_table_schema, dp.anchor_table_name, dp.deployment_operation, dp.deployment_projection_type, dp.deploy_weight, dp.estimated_size_on_disk, sum(deploy_weight) over() as sumweight, stmt.statement_id, stmt.statement, table_id from v_dbd_test-design.vs_deployment_projections as dp left outer join v_dbd_test-design.vs_deployment_projection_statements as stmt using (deployment_id, deployment_projection_id) join v_catalog.tables on (anchor_table_schema=table_schema and anchor_table_name=table_name)  DETAIL:Syntax error at or near "-"
The syntax error appears to be due to a dash I put in the design name. I suggest updating the designer to alert the administrator beforehand that dashes are not allowed in the design name.

1 reply

Nicholas_Chamma
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • May 9, 2014
Btw, I'm running Vertica Analytic Database v6.1.2-0.