Hello,
How do I run DBD on a single table? Do I just provide it a "SELECT * FROM table_name;" query?
Thank you
How do I run DBD on a single table?
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: How do I run DBD on a single table?
I wrote about how to accomplish this in my blog post, Table Level Database Design.
Checkout vertica.tips for more Vertica resources.
Re: How do I run DBD on a single table?
norbertk, thanks for your response. I had the same question as Brett. When I try you suggestion in Vertica 7.0.1 I get an error in DBD.
I created a new topic for the error:
http://www.vertica-forums.com/viewtopic.php?f=3&t=1890
I created a new topic for the error:
http://www.vertica-forums.com/viewtopic.php?f=3&t=1890
Thank, Fred
Re: How do I run DBD on a single table?
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:18 pm, edited 1 time in total.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: How do I run DBD on a single table?
Unless you're not using 7.0+sKwa wrote:The simplest way to run DBD on table - its by following DBD API.
Checkout vertica.tips for more Vertica resources.
Re: How do I run DBD on a single table?
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:18 pm, edited 1 time in total.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: How do I run DBD on a single table?
How do you mean?sKwa wrote:Do you think it differ in 6? Vertica just opened API in 7, but it will work with 6 too.
Code: Select all
dbadmin=> SELECT DESIGNER_CREATE_DESIGN('my_design');
ERROR 3457: Function DESIGNER_CREATE_DESIGN(unknown) does not exist, or permission is denied for DESIGNER_CREATE_DESIGN(unknown)
HINT: No function matches the given name and argument types. You may need to add explicit type casts
Checkout vertica.tips for more Vertica resources.