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


Adding design table query is not working — Vertica Forum

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