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


Syntax error during execution of database designer — Vertica Forum

Syntax error during execution of database designer

Nicholas_ChammaNicholas_Chamma
in General Discussion
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.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...