Three methods to add jar files for udafs udtf and other functions in Hive

After the jar file of the hive udf udaf udtf function is developed, you must put the jar file into the hive environment. You can add the following three methods:

1. Use the add jar path/test. jar; Method to add

The disadvantage of this method is that it must be added again every time Hive is started, and exiting hive will become invalid.

2. Add by setting the hive profile hive-site.xml

Add configuration in the configuration file

<Property>
<Name> hive. aux. jars. path </name>
<Value> file: // jarpath/all_new1.jar, file: // jarpath/all_new2.jar </value>
</Property>

Save it.

This method is much more convenient than the first method. You do not need to add the Hive execution command every time, but the configuration is slightly more complicated.

3. Create the folder auxlib in $ {HIVE_HOME and put the custom jar file into the folder.

I personally recommend this method, which is convenient and quick.