hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "wangchangchun (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11055) HPL/SQL - Implementing Procedural SQL in Hive (PL/HQL Contribution)
Date Tue, 21 Jul 2015 12:07:04 GMT

    [ 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)

Mime
View raw message