title: Debug information with UDF's in Hive
body: <p>I'm trying to get GeoIP working with hive. I found this: <a href="http://www.jointhegrid.com/hive-udf-geo-ip-jtg/index.jsp" rel="nofollow">http://www.jointhegrid.com/hive-udf-geo-ip-jtg/index.jsp</a>, which seems to be exactly what I want.</p>
  
  <p>I built the jars (I have no java experience, so I only hope I did this part right), added them to my query and get this:</p>
  
  <pre><code>hive&gt; ADD jar hive-udf-geo-ip-jtg.jar;
  Added hive-udf-geo-ip-jtg.jar to class path
  Added resource: hive-udf-geo-ip-jtg.jar
  hive&gt; ADD jar geo-ip-java.jar;
  Added geo-ip-java.jar to class path
  Added resource: geo-ip-java.jar
  hive&gt; ADD file GeoIPCity.dat;
  Added resource: GeoIPCity.dat
  hive&gt; create temporary function geoip as 'com.jointhegrid.hive.udf.GenericUDFGeoIP';
  FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask
  </code></pre>
  
  <p>Is there a way to find out what exactly is going wrong? <code>return code 1</code> doesn't tell me much... Is there a log file somewhere?</p>