Since Hive0.13.0 started, the method of creating temporary functions for UDFs using the HiveServer2 JDBC approach is:
ADD JAR ${hiveudfjarpath}
Create temporary function MD5 as ' com.hugedata.hive.udf.codec.UDFMd5 ';
Switch
Create temporary function MD5 as ' com.hugedata.hive.udf.codec.UDFMd5 ' USING JAR ${hiveudfjarpath};
The evil of this modification, let me busy for a long day.
Exception stack trace information:
Exception in thread ' main ' java.sql.SQLException:Error while processing statement:null
At Org.apache.hive.jdbc.Utils.verifySuccess (utils.java:120)
At Org.apache.hive.jdbc.Utils.verifySuccessWithInfo (utils.java:108)
At Org.apache.hive.jdbc.HiveStatement.execute (hivestatement.java:233)
The HiveServer2 JDBC method creates a UDF modification (the Add jar is best not to be used), otherwise it causes a java.sql.SQLException:Error while processing statement:null