[jira] [Created] (HIVE-17025) HPL/SQL: hplsql.conn.convert.hiveconn seems to default to false, contrary to docs

[Carter Shanklin (JIRA)]

Carter Shanklin created HIVE-17025:
--------------------------------------

             Summary: HPL/SQL: hplsql.conn.convert.hiveconn seems to default to 
false, contrary to docs
                 Key: HIVE-17025
                 URL: https://issues.apache.org/jira/browse/HIVE-17025
             Project: Hive
          Issue Type: Bug
          Components: hpl/sql
            Reporter: Carter Shanklin


This bug is part of a series of issues and surprising behavior I encountered 
writing a reporting script that would aggregate values and give rows different 
classifications based on an the aggregate. Addressing some or all of these 
issues would make HPL/SQL more accessible to newcomers.

Example from the docs is as follows:
CREATE TABLE dept (
  deptno NUMBER(2,0),
  dname  NUMBER(14),
  loc    VARCHAR2(13),
  CONSTRAINT pk_dept PRIMARY KEY (deptno)
);

With this config:
<configuration>
  <property>
    <name>hplsql.conn.default</name>
    <value>hiveconn</value>
  </property>

  <property>
    <name>hplsql.conn.hiveconn</name>
    <value>org.apache.hive.jdbc.HiveDriver;jdbc:hive2://</value>
  </property>
</configuration>

I get this error:
Caused by: java.lang.RuntimeException: 
org.apache.hadoop.hive.ql.parse.ParseException:line 2:9 cannot recognize input 
near 'NUMBER' '(' '2' in column type
With this config:
<configuration>
  <property>
    <name>hplsql.conn.default</name>
    <value>hiveconn</value>
  </property>

  <property>
    <name>hplsql.conn.hiveconn</name>
    <value>org.apache.hive.jdbc.HiveDriver;jdbc:hive2://</value>
  </property>

  <property>
    <name>hplsql.conn.convert.hiveconn</name>
    <value>true</value>
  </property>
</configuration>

the example works.

Version = 3.0.0-SNAPSHOT r71f52d8ad512904b3f2c4f04fe39a33f2834f1f2



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)