hive-issues mailing list archives

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


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(
	at org.apache.hive.hplsql.Conn.executeQuery(
	at org.apache.hive.hplsql.Exec.executeQuery(
	at org.apache.hive.hplsql.Exec.executeQuery(

  <description>The default connection profile</description>
  <description>HiveServer2 JDBC connection (embedded mode)</description>
     set hive.execution.engine=mr;
     use default;
  <description>Statements for execute after connection to the database</description>

> HPL/SQL - Implementing Procedural SQL in Hive (PL/HQL Contribution)
> -------------------------------------------------------------------
>                 Key: HIVE-11055
>                 URL:
>             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,
> There is PL/HQL tool ( 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

View raw message