Re: Create custom UDF

2015-03-05 Thread Buntu Dev
Is there a pivot/transform function available? I need to pivot the rows to columns without the knowledge of the values. Source table: date | page | count 20150301 | p1 | 10 20150301 | p2 | 20 ... Result table that I would like without the knowledge of the distinct values for 'page'

Re: Create custom UDF

2015-03-05 Thread Buntu Dev
Thanks for the info! On Thu, Mar 5, 2015 at 12:17 PM, Alexander Pivovarov wrote: > Several useful common udf methods we added to GenericUDF recently > https://issues.apache.org/jira/browse/HIVE-9744 > > > you can look at the following UDFs as an example: > > https://github.com/apache/hive/blob/t

Re: Create custom UDF

2015-03-05 Thread Alexander Pivovarov
Several useful common udf methods we added to GenericUDF recently https://issues.apache.org/jira/browse/HIVE-9744 you can look at the following UDFs as an example: https://github.com/apache/hive/blob/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFLevenshtein.java https://githu

Re: Create custom UDF

2015-03-03 Thread Buntu Dev
Thanks Pradeep. On Tue, Mar 3, 2015 at 2:53 PM, Pradeep Gollakota wrote: > This is what I use: > > > org.apache.hive > hive-exec > 0.12.0 > provided > > > I don't believe anything else is needed. > > On Tue, Mar 3, 2015 at 2:43 PM, Buntu Dev wrote: > >> I couldn't find any off

Re: Create custom UDF

2015-03-03 Thread Pradeep Gollakota
This is what I use: org.apache.hive hive-exec 0.12.0 provided I don't believe anything else is needed. On Tue, Mar 3, 2015 at 2:43 PM, Buntu Dev wrote: > I couldn't find any official documentation on how to create a UDF and mvn > dependencies for building the project except f

Create custom UDF

2015-03-03 Thread Buntu Dev
I couldn't find any official documentation on how to create a UDF and mvn dependencies for building the project except for this page: https://cwiki.apache.org/confluence/display/Hive/HivePlugins Can anyone help me with whats needed to construct the pom? Thanks!