Re: Insert into vs Insert overwrite

Hi Kasun, INSERT OVERWRITE will overwrite any existing data in the table or partition and INSERT INTO will append to the table or partition keeping the existing data. Please have a look into the below link for the same. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageM

Re: Custom MR scripts using java in Hive

Hi Manish, Thanks for your help.I did the same using UDF.Now trying with Transform,Map and Reduce clauses.so is it mean by using java we have to goahead through UDF and for other languages using MapReduce Scripts i.e., the Transform,Map and Reduce clauses. Please correct me if am wrong. Thanks

Re: UDAF:FAILED: Execution Error

add you jar to hive: > > hive> add jar Maclass.jar > > ** ** > > **· **you create then an UDF like: > > hive> create temporary function mafonction as > 'com.example.hive.udf.monjar'; > > ** ** > > **· **and then use mafonction in hive query

UDAF:FAILED: Execution Error

Hi Experts, I have written an UDAF function and followed the below steps. Step 1: Export jar file Step 2: hive>ADD JAR /userdata/tamil/SumOfColumnTest/AvgOfColumn.jar; (also tried with hive --auxpath /userdata/tamil/SumOfColumnTest/AvgOfColumn.jar; export HADOOP_CLASSPATH=

Re: Java methods from within a Hive query

gt; Regards > > Bertrand > > > On Tue, Sep 4, 2012 at 4:38 PM, Tamil A <4tamil...@gmail.com> wrote: > >> Hi Experts, >> I am familiar with calling out to python from hive.Now looking for Java >> methods from within a Hive query.Is UDF the only option to a