UDF created by user in user_functions

Moderator: NorbertKrupa

Post Reply
User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

UDF created by user in user_functions

Post by nnani » Tue Apr 29, 2014 11:21 am

Hello All,

Is there a way we can say which function is a user_defined(created by user) function in user_functions table.

Currently I am seeing many functions in my user_functions system table

Example
ApproxCountDistinctLong

Also, I can see procedure type as Stored Procedure....are these nothing but External procedures.

Thanks
nnani........
Long way to go

You can check out my blogs at vertica-howto

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

Re: UDF created by user in user_functions

Post by id10t » Tue Apr 29, 2014 1:20 pm

Hi!

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

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: UDF created by user in user_functions

Post by nnani » Tue Apr 29, 2014 1:38 pm

Thanks a lot skwa :)

I already knew that ApproxCountDistinct is not a user defined function, but was surprised to see it in user_functions table.

also, Does the same bug apply for stored Procedure thing

Thanks
nnani........
Long way to go

You can check out my blogs at vertica-howto

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

Re: UDF created by user in user_functions

Post by id10t » Tue Apr 29, 2014 1:57 pm

Hi!

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

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: UDF created by user in user_functions

Post by nnani » Tue Apr 29, 2014 3:18 pm

Thanks skwa :)

The last part of your reply answered my doubt.

So there are three bugs

1. user_functions should have only user defined function, currently having all new function released with Vertica 7
2. procedure_type column should be function_type column description for this column in documents - The type of user defined function. For example, 'User Defined Function'.
3. user_function system table should not have stored procedures, currently showing EXT procedures also.

Thanks
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “Vertica User Defined Functions (UDFs)”