The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Adding design table query is not working

HyeontaeJuHyeontaeJu Vertica Customer
edited August 2020 in General Discussion

I'm trying to work this Query to make design table
SELECT DESIGNER_ADD_DESIGN_TABLES('juhyeontae_1', '[schema.tableName]');

and result is 1

But, when i was trying to process to check the adding table but, design table is not made
SELECT * FROM design_tables;

Best Answers

  • moshegmosheg Vertica Employee Administrator
    Answer ✓

    Please try:
    SELECT * FROM vs_design_tables;

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    Answer ✓

    @HyeontaeJu - Attached is an example deck showing the set up how to run the DBD functions manually.

    And here is another example:

    dbadmin=> \c - ma_dbd
    You are now connected as user "ma_dbd".
    
    dbadmin=> \dt ma
                  List of tables
     Schema | Name | Kind  | Owner  | Comment
    --------+------+-------+--------+---------
     public | ma   | table | ma_dbd |
    (1 row)
    
    dbadmin=> SELECT designer_create_design('ma2');
     designer_create_design
    ------------------------
                          0
    (1 row)
    
    dbadmin=> SELECT designer_add_design_tables('ma2', 'public.ma', TRUE);
     designer_add_design_tables
    ----------------------------
                              1
    (1 row)
    
    dbadmin=> SELECT * FROM design_tables;
     design_name | design_table_id | table_schema |     table_id      | table_name
    -------------+-----------------+--------------+-------------------+------------
     ma2         |               1 | public       | 45035996273855326 | ma
    (1 row)
    
    dbadmin=> SELECT designer_add_design_tables('ma2', 'public.zero', TRUE);
    WARNING 5390:  User has insufficient privileges on table zero
    HINT:  User must be owner of the design table
     designer_add_design_tables
    ----------------------------
                              0
    (1 row)
    
    dbadmin=> SELECT * FROM design_tables;
     design_name | design_table_id | table_schema |     table_id      | table_name
    -------------+-----------------+--------------+-------------------+------------
     ma2         |               1 | public       | 45035996273855326 | ma
    (1 row)
    

Answers

  • HyeontaeJuHyeontaeJu Vertica Customer

    @Jim_Knicely Oh.. Thank you very much sincerly..
    My Question is solved.. Thanks your answer
    I wanna more thankful phrase to you but, my English skill is rookie.. haha..

    anyway, Thank very much

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file