Question

I m 试图让GeoIP进行冲动。我发现:,这似乎正是我所希望的。

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:

hive> 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> ADD jar geo-ip-java.jar;
Added geo-ip-java.jar to class path
Added resource: geo-ip-java.jar
hive> ADD file GeoIPCity.dat;
Added resource: GeoIPCity.dat
hive> create temporary function geoip as  com.jointhegrid.hive.udf.GenericUDFGeoIP ;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask

是否有办法查明究竟什么是错的? 页: 1 是否有记录?

Answer 1

if you want to see the log of hive, you can use $HIVE_HOME/bin/hive -hiveconf hive.root.logger=INFO,console. You can also change levels (DEBUG, INFO, WARN, ERROR or FATAL) to see if you can get enough information.

Answer 2

Try executing hive UDF with below command

hive --hiveconf hive.root.logger=DRFA --hiveconf hive.log.dir=./logs --hiveconf hive.log.level=DEBUG -e "query"

or

hive --hiveconf hive.root.logger=DRFA --hiveconf hive.log.dir=./logs --hiveconf hive.log.level=DEBUG -f queryscript.hql

记录将记录在记录夹(现有目录)的档案中。请确保标识的夹。

调整记录,以获得正确细节。

友情链接