大数据-UDF开发实例

    <dependencies> <!-- https://mvnrepository.com/artifact/org.apache.hive/hive-exec -->
        <dependency>
            <groupId>org.apache.hive</groupId>
            <artifactId>hive-exec</artifactId>
            <version>3.1.1</version>
        </dependency> <!-- https://mvnrepository.com/artifact/org.apache.hadoop/hadoop-common -->
        <dependency>
            <groupId>org.apache.hadoop</groupId>
            <artifactId>hadoop-common</artifactId>
            <version>3.1.1</version>
        </dependency>
    </dependencies>
    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.0</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
        </plugins>
    </build>

public class MyUDF extends UDF {
    public Text evaluate(final Text str) {
        String tmp_str = str.toString();
        if (str != null && !tmp_str.equals("")) {
            String str_ret = tmp_str.substring(0, 1).toUpperCase() + tmp_str.substring(1);
            return new Text(str_ret);
        }
        return new Text("");
    }
}

cd /export/servers/apache-hive-3.1.1-bin/lib 
mv original-day_05_hive_udf-1.0-SNAPSHOT.jar myudf.jar

add jar /export/servers/apache-hive-3.1.1-bin/lib/udf.jar;

create temporary function my_upper as 'cn.itcast.udf.ItcastUDF';

select my_upper('abc');