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
UDF created by user in user_functions
Moderator: NorbertKrupa
Re: UDF created by user in user_functions
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:30 pm, edited 1 time in total.
Re: UDF created by user in user_functions
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
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
Re: UDF created by user in user_functions
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:30 pm, edited 1 time in total.
Re: UDF created by user in user_functions
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
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