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 13:55:04 GMT

    [ https://issues.apache.org/jira/browse/HIVE-11055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14635147#comment-14635147
] 

wangchangchun commented on HIVE-11055:
--------------------------------------

I found where the problem is.The code Exec.java have some problem.

  void initOptions() {
    Iterator<Map.Entry<String,String>> i = exec.conf.iterator();
    while (i.hasNext()) {
      Entry<String,String> item = (Entry<String,String>)i.next();
      String key = (String)item.getKey();
      String value = (String)item.getValue();
      if (key == null || value == null) {
        continue;
      }
      else if (key.compareToIgnoreCase(Conf.CONN_DEFAULT) == 0) {
        exec.conf.defaultConnection = value;
      }
      else if (key.startsWith("hplsql.conn.init.")) {
        //this should be key.substring(17)
        exec.conn.addConnectionInit(key.substring(16), value);        
      }
      else if (key.startsWith(Conf.CONN_CONVERT)) {
        //this should be key.substring(20)
        exec.conf.setConnectionConvert(key.substring(19), value);        
      }
      else if (key.startsWith("hplsql.conn.")) {
        //this should be key.substring(12)
        exec.conn.addConnection(key.substring(11), value);

      }
      else if (key.startsWith("hplsql.")) {
        exec.conf.setOption(key, value);
      }
    }    
  }

> 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