[jira] [Updated] (HIVE-17025) HPL/SQL: hplsql.conn.convert.hiveconn seems to default to false, contrary to docs
[ https://issues.apache.org/jira/browse/HIVE-17025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated HIVE-17025: --- Fix Version/s: (was: 3.2.0) I cleared the fixVersion field since this ticket is not resolved. Please review this ticket and if the fix is already committed to a specific version please set the version accordingly and mark the ticket as RESOLVED. According to the JIRA guidelines (https://cwiki.apache.org/confluence/display/Hive/HowToContribute) the fixVersion should be set only when the issue is resolved/closed. > 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 > 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), > locVARCHAR2(13), > CONSTRAINT pk_dept PRIMARY KEY (deptno) > ); > With this config: > > > hplsql.conn.default > hiveconn > > > hplsql.conn.hiveconn > org.apache.hive.jdbc.HiveDriver;jdbc:hive2:// > > > 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: > > > hplsql.conn.default > hiveconn > > > hplsql.conn.hiveconn > org.apache.hive.jdbc.HiveDriver;jdbc:hive2:// > > > hplsql.conn.convert.hiveconn > true > > > the example works. > Version = 3.0.0-SNAPSHOT r71f52d8ad512904b3f2c4f04fe39a33f2834f1f2 -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Updated] (HIVE-17025) HPL/SQL: hplsql.conn.convert.hiveconn seems to default to false, contrary to docs
[ https://issues.apache.org/jira/browse/HIVE-17025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17025: --- Fix Version/s: (was: 3.1.0) 3.2.0 Deferring this to 3.2.0 since the branch for 3.1.0 has been cut off. > 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.2.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), > locVARCHAR2(13), > CONSTRAINT pk_dept PRIMARY KEY (deptno) > ); > With this config: > > > hplsql.conn.default > hiveconn > > > hplsql.conn.hiveconn > org.apache.hive.jdbc.HiveDriver;jdbc:hive2:// > > > 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: > > > hplsql.conn.default > hiveconn > > > hplsql.conn.hiveconn > org.apache.hive.jdbc.HiveDriver;jdbc:hive2:// > > > hplsql.conn.convert.hiveconn > true > > > the example works. > Version = 3.0.0-SNAPSHOT r71f52d8ad512904b3f2c4f04fe39a33f2834f1f2 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-17025) HPL/SQL: hplsql.conn.convert.hiveconn seems to default to false, contrary to docs
[ https://issues.apache.org/jira/browse/HIVE-17025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17025: --- Fix Version/s: (was: 3.0.0) 3.1.0 Deferring this to 3.1.0 since the branch for 3.0.0 has been cut off. Please update the JIRA if you would like to get your patch in 3.0.0. > 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), > locVARCHAR2(13), > CONSTRAINT pk_dept PRIMARY KEY (deptno) > ); > With this config: > > > hplsql.conn.default > hiveconn > > > hplsql.conn.hiveconn > org.apache.hive.jdbc.HiveDriver;jdbc:hive2:// > > > 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: > > > hplsql.conn.default > hiveconn > > > hplsql.conn.hiveconn > org.apache.hive.jdbc.HiveDriver;jdbc:hive2:// > > > hplsql.conn.convert.hiveconn > true > > > the example works. > Version = 3.0.0-SNAPSHOT r71f52d8ad512904b3f2c4f04fe39a33f2834f1f2 -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-17025) HPL/SQL: hplsql.conn.convert.hiveconn seems to default to false, contrary to docs
[ https://issues.apache.org/jira/browse/HIVE-17025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Tolpeko updated HIVE-17025: -- Fix Version/s: 3.0.0 Status: Patch Available (was: In Progress) > 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 > Fix For: 3.0.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), > locVARCHAR2(13), > CONSTRAINT pk_dept PRIMARY KEY (deptno) > ); > With this config: > > > hplsql.conn.default > hiveconn > > > hplsql.conn.hiveconn > org.apache.hive.jdbc.HiveDriver;jdbc:hive2:// > > > 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: > > > hplsql.conn.default > hiveconn > > > hplsql.conn.hiveconn > org.apache.hive.jdbc.HiveDriver;jdbc:hive2:// > > > hplsql.conn.convert.hiveconn > true > > > the example works. > Version = 3.0.0-SNAPSHOT r71f52d8ad512904b3f2c4f04fe39a33f2834f1f2 -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Updated] (HIVE-17025) HPL/SQL: hplsql.conn.convert.hiveconn seems to default to false, contrary to docs
[ https://issues.apache.org/jira/browse/HIVE-17025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dmitry Tolpeko updated HIVE-17025: -- Attachment: HIVE-17025.1.patch > 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 > 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), > locVARCHAR2(13), > CONSTRAINT pk_dept PRIMARY KEY (deptno) > ); > With this config: > > > hplsql.conn.default > hiveconn > > > hplsql.conn.hiveconn > org.apache.hive.jdbc.HiveDriver;jdbc:hive2:// > > > 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: > > > hplsql.conn.default > hiveconn > > > hplsql.conn.hiveconn > org.apache.hive.jdbc.HiveDriver;jdbc:hive2:// > > > hplsql.conn.convert.hiveconn > true > > > the example works. > Version = 3.0.0-SNAPSHOT r71f52d8ad512904b3f2c4f04fe39a33f2834f1f2 -- This message was sent by Atlassian JIRA (v6.4.14#64029)