user-defined-functions
COLLECT_SET() in Hive, keep duplicates?
Is there a way to keep the duplicates in a collected set in Hive, or simulate the sort of aggregate collection that Hive provides using some other method? I want to aggregate all of the items in开发者[详细]
2023-03-14 22:41 分类:问答Remove AddIn path from UDF in Excel formula
My addin was xla, now I use excelDNA, so it becomes xll, When I open spreadsheet built in previous version of My addin,[详细]
2023-03-14 08:43 分类:问答How to generate unique numbers inside a UDF (SQL Server)
Is there a way to generate unique numbers (int for instance) inside a开发者_如何学运维 user defined function?[详细]
2023-03-13 14:34 分类:问答Execute Stored Procedure from a Function
I know this has been asked to death, and I know why SQL Server doesn\'t let you do it. But is there any workaround for this, other than using Extended Stored Procedures?[详细]
2023-03-13 08:44 分类:问答How to call the Stored Procedure in the Table Valued Function in SQL Server 2005?
I want to call the Stored Procedure which returns a table in the Table Valued Function. How to create the Table Valued Function?[详细]
2023-03-13 06:45 分类:问答Managing Defaults in Stored Procedures' Parameters
I am working in a DB which has about 10 DEFAULT constraints scattered by two or three different tables, and I need to write a stored procedure which receives as parameters values for all these attribu[详细]
2023-03-12 17:43 分类:问答vba sumifs getting confused about dates, wrong result in april
I´m following this other Stack Overflow question, and was very enlightened, but when I made a sanity check of the results I get this particular odd behavior in April, any rev_date of april yields a r[详细]
2023-03-12 15:23 分类:问答How to name arguments to a UDF?
i\'m calling a user-defined function (UDF). i want to be able to name the parameters (like you can with stored procedures) for ease of re开发者_开发百科adability (and to reduce errors), e.g.:[详细]
2023-03-12 09:30 分类:问答Are there any useful tutorials on Pig UDFs other than the apache.org tutorial?
I\'ve spent a few hours getting acclimated, but I w开发者_C百科ant to find some other ways to practice.The book Programming Pig is available online, and has a great chapter on writing UDFs:[详细]
2023-03-10 22:17 分类:问答Cannot use a MySQL UDF function
I have loaded an UDF function into MySQL (without having selected any particular DB). It used to work well during my session but now I get the error \"ERROR 1305 (42000): FUNCTION currentdatabase.myfu[详细]
2023-03-09 23:37 分类:问答