[ https://issues.apache.org/jira/browse/HIVE-17025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16432066#comment-16432066 ]
Hive QA commented on HIVE-17025: -------------------------------- | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || | {color:red}-1{color} | {color:red} patch {color} | {color:red} 0m 9s{color} | {color:red} /data/hiveptest/logs/PreCommit-HIVE-Build-10115/patches/PreCommit-HIVE-Build-10115.patch does not apply to master. Rebase required? Wrong Branch? See http://cwiki.apache.org/confluence/display/Hive/HowToContribute for help. {color} | \\ \\ || Subsystem || Report/Notes || | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-10115/yetus.txt | | Powered by | Apache Yetus http://yetus.apache.org | This message was automatically generated. > 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 > Assignee: Dmitry Tolpeko > Priority: Major > Fix For: 3.1.0 > > Attachments: HIVE-17025.1.patch > > > 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 (v7.6.3#76005)