[HIVE-15096] hplsql registerUDF conflicts with pom.xml

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0, 2.0.1, 2.1.0
• Fix Version/s: 2.3.0
• Component/s: hpl/sql
• Target Version/s: 2.2.0
• Assignee: Hui Fei
• Reporter: Hui Fei
• Created: 29/Oct/16 03:00
• Updated: 21/Jul/17 18:26
• Resolved: 13/Nov/16 03:17

Description

in hplsql code, registerUDF code is

sql.add("ADD JAR " + dir + "hplsql.jar");
sql.add("ADD JAR " + dir + "antlr-runtime-4.5.jar");
sql.add("ADD FILE " + dir + Conf.SITE_XML);

but pom configufation is

<parent>
<groupId>org.apache.hive</groupId>
<artifactId>hive</artifactId>
<version>2.2.0-SNAPSHOT</version>
<relativePath>../pom.xml</relativePath>
</parent>

<artifactId>hive-hplsql</artifactId>
<packaging>jar</packaging>
<name>Hive HPL/SQL</name>

<dependency>
<groupId>org.antlr</groupId>
<artifactId>antlr4-runtime</artifactId>
<version>4.5</version>
</dependency>

when run hplsql , errors occur as below

Error while processing statement: /opt/apps/apache-hive-2.0.0-bin/lib/hplsql.jar does not exist