[
https://issues.apache.org/jira/browse/HIVE-11055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14635014#comment-14635014
]
wangchangchun commented on HIVE-11055:
--------------------------------------
I put an hplsql-site.xml in conf dir. The content is from HIVE-11254.4.patch
./hplsql -e "select * from hive_tables";
Unhandled exception in PL/HQL
java.lang.Exception: Unknown connection profile: hiveconn
at org.apache.hive.hplsql.Conn.getConnection(Conn.java:127)
at org.apache.hive.hplsql.Conn.executeQuery(Conn.java:55)
at org.apache.hive.hplsql.Exec.executeQuery(Exec.java:412)
at org.apache.hive.hplsql.Exec.executeQuery(Exec.java:421)
at org.apache.hive.hplsql.Select.select(Select.java:73)
```
<configuration>
<property>
<name>hplsql.conn.default</name>
<value>hiveconn</value>
<description>The default connection profile</description>
</property>
<property>
<name>hiveconn</name>
<value>org.apache.hive.jdbc.HiveDriver;jdbc:hive2://</value>
<description>HiveServer2 JDBC connection (embedded mode)</description>
</property>
<property>
<name>hplsql.conn.init.hiveconn</name>
<value>
set mapred.job.queue.name=default;
set hive.execution.engine=mr;
use default;
</value>
<description>Statements for execute after connection to the
database</description>
</property>
```
> HPL/SQL - Implementing Procedural SQL in Hive (PL/HQL Contribution)
> -------------------------------------------------------------------
>
> Key: HIVE-11055
> URL: https://issues.apache.org/jira/browse/HIVE-11055
> Project: Hive
> Issue Type: Improvement
> Reporter: Dmitry Tolpeko
> Assignee: Dmitry Tolpeko
> Fix For: 2.0.0
>
> Attachments: HIVE-11055.1.patch, HIVE-11055.2.patch,
> HIVE-11055.3.patch, HIVE-11055.4.patch, hplsql-site.xml
>
>
> There is PL/HQL tool (www.plhql.org) that implements procedural SQL for Hive
> (actually any SQL-on-Hadoop implementation and any JDBC source).
> Alan Gates offered to contribute it to Hive under HPL/SQL name
> (org.apache.hive.hplsql package). This JIRA is to create a patch to
> contribute the PL/HQL code.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
