How do I run DBD on a single table?

Moderator: NorbertKrupa

Post Reply
Brett
Beginner
Beginner
Posts: 49
Joined: Fri Oct 11, 2013 1:19 am

How do I run DBD on a single table?

Post by Brett » Fri Jun 13, 2014 11:54 am

Hello,

How do I run DBD on a single table? Do I just provide it a "SELECT * FROM table_name;" query?

Thank you

NorbertKrupa
GURU
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?

Post by NorbertKrupa » Fri Jun 13, 2014 5:54 pm

I wrote about how to accomplish this in my blog post, Table Level Database Design.
Checkout vertica.tips for more Vertica resources.

User avatar
fsalvelt
Intermediate
Intermediate
Posts: 54
Joined: Sun Mar 18, 2012 1:34 am

Re: How do I run DBD on a single table?

Post by fsalvelt » Fri Jun 13, 2014 6:48 pm

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
Thank, Fred

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: How do I run DBD on a single table?

Post by id10t » Sun Jun 15, 2014 8:49 am

Hi!

[DELETED]
Last edited by id10t on Wed May 06, 2015 5:18 pm, edited 1 time in total.

NorbertKrupa
GURU
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?

Post by NorbertKrupa » Sun Jun 15, 2014 9:09 pm

sKwa wrote:The simplest way to run DBD on table - its by following DBD API.
Unless you're not using 7.0+
Checkout vertica.tips for more Vertica resources.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: How do I run DBD on a single table?

Post by id10t » Sun Jun 15, 2014 11:15 pm

Hi!

[DELETED]
Last edited by id10t on Wed May 06, 2015 5:18 pm, edited 1 time in total.

NorbertKrupa
GURU
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?

Post by NorbertKrupa » Fri Jun 20, 2014 12:15 am

sKwa wrote:Do you think it differ in 6? Vertica just opened API in 7, but it will work with 6 too.
How do you mean?

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.

Post Reply

Return to “New to Vertica Database Administration”