Hi,
I am running database designer programmatically in Vertica Analytic Database v7.0.1-3 , all steps complete successfully but DESIGNER_RUN_POPULATE_DESIGN_AND_DEPLOY creates empty designer and deployment scripts. Can someone please guide me , if there is something I am missing.
csi_owner=> \i call_dbd.sql
SET
DESIGNER_DROP_DESIGN
----------------------
0
(1 row)
DESIGNER_CREATE_DESIGN
------------------------
0
(1 row)
DESIGNER_ADD_DESIGN_TABLES
----------------------------
11
(1 row)
DESIGNER_SET_DESIGN_KSAFETY
-----------------------------
0
(1 row)
DESIGNER_SET_DESIGN_TYPE
--------------------------
0
(1 row)
DESIGNER_SET_OPTIMIZATION_OBJECTIVE
-------------------------------------
0
(1 row)
DESIGNER_ADD_DESIGN_QUERY
---------------------------
1
(1 row)
DESIGNER_ADD_DESIGN_QUERIES
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Number of accepted queries =21
Number of queries referencing non-design tables =0
Number of unsupported queries =0
Number of illegal queries =0
(1 row)
DESIGNER_WAIT_FOR_DESIGN
--------------------------
0
(1 row)
DESIGNER_RUN_POPULATE_DESIGN_AND_DEPLOY
-----------------------------------------
0
(1 row)
Using DBD programmatically --> no output generated
Moderator: NorbertKrupa
Re: Using DBD programmatically --> no output generated
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:19 pm, edited 1 time in total.
Re: Using DBD programmatically --> no output generated
There is no error while adding query. The count 1 means, it has added 1 query. If the query has syntax error , error will be spit out.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Using DBD programmatically --> no output generated
Have you followed the Workflow for Running Database Designer Programmatically, checked permissions, and dropped the designer workspace if necessary?
Checkout vertica.tips for more Vertica resources.
Re: Using DBD programmatically --> no output generated
Yes. I followed the same document. On the other note, when I use DESIGNER_DESIGN_PROJECTION_ENCODINGS , it does spit out the output.