[jira] [Commented] (HIVE-21308) Negative forms of variables are not supported in HPL/SQL
[ https://issues.apache.org/jira/browse/HIVE-21308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16774961#comment-16774961 ] Baoning He commented on HIVE-21308: --- HI,[~daijy] could you please review ? Thank you! > Negative forms of variables are not supported in HPL/SQL > > > Key: HIVE-21308 > URL: https://issues.apache.org/jira/browse/HIVE-21308 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21308.1.patch > > > In the following HPL/SQL programs: > declare num = 1; print -num; > The expected result should be '-1',but it print '1' . -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21308) Negative forms of variables are not supported in HPL/SQL
[ https://issues.apache.org/jira/browse/HIVE-21308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21308: -- Attachment: HIVE-21308.1.patch Status: Patch Available (was: Open) > Negative forms of variables are not supported in HPL/SQL > > > Key: HIVE-21308 > URL: https://issues.apache.org/jira/browse/HIVE-21308 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21308.1.patch > > > In the following HPL/SQL programs: > declare num = 1; print -num; > The expected result should be '-1',but it print '1' . -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (HIVE-21308) Negative forms of variables are not supported in HPL/SQL
[ https://issues.apache.org/jira/browse/HIVE-21308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He reassigned HIVE-21308: - > Negative forms of variables are not supported in HPL/SQL > > > Key: HIVE-21308 > URL: https://issues.apache.org/jira/browse/HIVE-21308 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > > In the following HPL/SQL programs: > declare num = 1; print -num; > The expected result should be '-1',but it print '1' . -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21124) HPL/SQL does not support the CREATE TABLE LIKE statement
[ https://issues.apache.org/jira/browse/HIVE-21124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16743530#comment-16743530 ] Baoning He commented on HIVE-21124: --- HI,[~daijy] could you please review ? Thank you! > HPL/SQL does not support the CREATE TABLE LIKE statement > > > Key: HIVE-21124 > URL: https://issues.apache.org/jira/browse/HIVE-21124 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21124.1.patch > > > Hive supports the CREATE TABLE LIKE statement but HPL/SQL does not support. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21124) HPL/SQL does not support the CREATE TABLE LIKE statement
[ https://issues.apache.org/jira/browse/HIVE-21124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21124: -- Status: Patch Available (was: Open) > HPL/SQL does not support the CREATE TABLE LIKE statement > > > Key: HIVE-21124 > URL: https://issues.apache.org/jira/browse/HIVE-21124 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21124.1.patch > > > Hive supports the CREATE TABLE LIKE statement but HPL/SQL does not support. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21124) HPL/SQL does not support the CREATE TABLE LIKE statement
[ https://issues.apache.org/jira/browse/HIVE-21124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21124: -- Attachment: HIVE-21124.1.patch > HPL/SQL does not support the CREATE TABLE LIKE statement > > > Key: HIVE-21124 > URL: https://issues.apache.org/jira/browse/HIVE-21124 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21124.1.patch > > > Hive supports the CREATE TABLE LIKE statement but HPL/SQL does not support. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21124) HPL/SQL does not support the CREATE TABLE LIKE statement
[ https://issues.apache.org/jira/browse/HIVE-21124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21124: -- Environment: (was: Hive supports the CREATE TABLE LIKE statement but HPL/SQL does not support.) Description: Hive supports the CREATE TABLE LIKE statement but HPL/SQL does not support. > HPL/SQL does not support the CREATE TABLE LIKE statement > > > Key: HIVE-21124 > URL: https://issues.apache.org/jira/browse/HIVE-21124 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > > Hive supports the CREATE TABLE LIKE statement but HPL/SQL does not support. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (HIVE-21124) HPL/SQL does not support the CREATE TABLE LIKE statement
[ https://issues.apache.org/jira/browse/HIVE-21124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He reassigned HIVE-21124: - > HPL/SQL does not support the CREATE TABLE LIKE statement > > > Key: HIVE-21124 > URL: https://issues.apache.org/jira/browse/HIVE-21124 > Project: Hive > Issue Type: Bug > Components: hpl/sql > Environment: Hive supports the CREATE TABLE LIKE statement but > HPL/SQL does not support. >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21113) For HPL/SQL that contains boolean expression with NOT, incorrect SQL may be generated.
[ https://issues.apache.org/jira/browse/HIVE-21113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16739267#comment-16739267 ] Baoning He commented on HIVE-21113: --- [~daijy] Could you please review the patch? Thank you! > For HPL/SQL that contains boolean expression with NOT, incorrect SQL may be > generated. > --- > > Key: HIVE-21113 > URL: https://issues.apache.org/jira/browse/HIVE-21113 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21113.1.patch > > > In HPL/SQL, ' SELECT * FROM a WHERE NOT (1 = 2) ' will generate to incorrect > SQL ' SELECT * FROM a WHERE (1 = 2) ', the 'NOT' in boolean expression is > missing. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21113) For HPL/SQL that contains boolean expression with NOT, incorrect SQL may be generated.
[ https://issues.apache.org/jira/browse/HIVE-21113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21113: -- Attachment: HIVE-21113.1.patch Status: Patch Available (was: Open) > For HPL/SQL that contains boolean expression with NOT, incorrect SQL may be > generated. > --- > > Key: HIVE-21113 > URL: https://issues.apache.org/jira/browse/HIVE-21113 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21113.1.patch > > > In HPL/SQL, ' SELECT * FROM a WHERE NOT (1 = 2) ' will generate to incorrect > SQL ' SELECT * FROM a WHERE (1 = 2) ', the 'NOT' in boolean expression is > missing. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (HIVE-21113) For HPL/SQL that contains boolean expression with NOT, incorrect SQL may be generated.
[ https://issues.apache.org/jira/browse/HIVE-21113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He reassigned HIVE-21113: - > For HPL/SQL that contains boolean expression with NOT, incorrect SQL may be > generated. > --- > > Key: HIVE-21113 > URL: https://issues.apache.org/jira/browse/HIVE-21113 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > > In HPL/SQL, ' SELECT * FROM a WHERE NOT (1 = 2) ' will generate to incorrect > SQL ' SELECT * FROM a WHERE (1 = 2) ', the 'NOT' in boolean expression is > missing. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21082) In HPL/SQL, declare statement does not support variable of type character
[ https://issues.apache.org/jira/browse/HIVE-21082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16737879#comment-16737879 ] Baoning He commented on HIVE-21082: --- [~daijy] Thank you for reminding, I have attached a new patch with a test. > In HPL/SQL, declare statement does not support variable of type character > -- > > Key: HIVE-21082 > URL: https://issues.apache.org/jira/browse/HIVE-21082 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21082.1.patch > > > In the following HPL/SQL programs: > DECLARE a character(5); SET a = 'b'; > when the type of variable 'a' is CHARACTER, it cannot be assigned a value > successfully. The support for the character type should be added to DECLARE > statement. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21082) In HPL/SQL, declare statement does not support variable of type character
[ https://issues.apache.org/jira/browse/HIVE-21082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21082: -- Attachment: (was: HIVE-21082.patch) > In HPL/SQL, declare statement does not support variable of type character > -- > > Key: HIVE-21082 > URL: https://issues.apache.org/jira/browse/HIVE-21082 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > > In the following HPL/SQL programs: > DECLARE a character(5); SET a = 'b'; > when the type of variable 'a' is CHARACTER, it cannot be assigned a value > successfully. The support for the character type should be added to DECLARE > statement. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21082) In HPL/SQL, declare statement does not support variable of type character
[ https://issues.apache.org/jira/browse/HIVE-21082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21082: -- Attachment: HIVE-21082.1.patch Status: Patch Available (was: In Progress) > In HPL/SQL, declare statement does not support variable of type character > -- > > Key: HIVE-21082 > URL: https://issues.apache.org/jira/browse/HIVE-21082 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21082.1.patch > > > In the following HPL/SQL programs: > DECLARE a character(5); SET a = 'b'; > when the type of variable 'a' is CHARACTER, it cannot be assigned a value > successfully. The support for the character type should be added to DECLARE > statement. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21082) In HPL/SQL, declare statement does not support variable of type character
[ https://issues.apache.org/jira/browse/HIVE-21082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21082: -- Status: In Progress (was: Patch Available) > In HPL/SQL, declare statement does not support variable of type character > -- > > Key: HIVE-21082 > URL: https://issues.apache.org/jira/browse/HIVE-21082 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > > In the following HPL/SQL programs: > DECLARE a character(5); SET a = 'b'; > when the type of variable 'a' is CHARACTER, it cannot be assigned a value > successfully. The support for the character type should be added to DECLARE > statement. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21082) In HPL/SQL, declare statement does not support variable of type character
[ https://issues.apache.org/jira/browse/HIVE-21082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16736866#comment-16736866 ] Baoning He commented on HIVE-21082: --- HI,[~daijy] could you please review the patch? Thank you! > In HPL/SQL, declare statement does not support variable of type character > -- > > Key: HIVE-21082 > URL: https://issues.apache.org/jira/browse/HIVE-21082 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21082.patch > > > In the following HPL/SQL programs: > DECLARE a character(5); SET a = 'b'; > when the type of variable 'a' is CHARACTER, it cannot be assigned a value > successfully. The support for the character type should be added to DECLARE > statement. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Issue Comment Deleted] (HIVE-21082) In HPL/SQL, declare statement does not support variable of type character
[ https://issues.apache.org/jira/browse/HIVE-21082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21082: -- Comment: was deleted (was: [~ashutoshc] could you please review? Thank you!) > In HPL/SQL, declare statement does not support variable of type character > -- > > Key: HIVE-21082 > URL: https://issues.apache.org/jira/browse/HIVE-21082 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21082.patch > > > In the following HPL/SQL programs: > DECLARE a character(5); SET a = 'b'; > when the type of variable 'a' is CHARACTER, it cannot be assigned a value > successfully. The support for the character type should be added to DECLARE > statement. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-21082) In HPL/SQL, declare statement does not support variable of type character
[ https://issues.apache.org/jira/browse/HIVE-21082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16733803#comment-16733803 ] Baoning He commented on HIVE-21082: --- [~ashutoshc] could you please review? Thank you! > In HPL/SQL, declare statement does not support variable of type character > -- > > Key: HIVE-21082 > URL: https://issues.apache.org/jira/browse/HIVE-21082 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21082.patch > > > In the following HPL/SQL programs: > DECLARE a character(5); SET a = 'b'; > when the type of variable 'a' is CHARACTER, it cannot be assigned a value > successfully. The support for the character type should be added to DECLARE > statement. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21082) In HPL/SQL, declare statement does not support variable of type character
[ https://issues.apache.org/jira/browse/HIVE-21082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21082: -- Priority: Major (was: Minor) > In HPL/SQL, declare statement does not support variable of type character > -- > > Key: HIVE-21082 > URL: https://issues.apache.org/jira/browse/HIVE-21082 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Major > Attachments: HIVE-21082.patch > > > In the following HPL/SQL programs: > DECLARE a character(5); SET a = 'b'; > when the type of variable 'a' is CHARACTER, it cannot be assigned a value > successfully. The support for the character type should be added to DECLARE > statement. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-21082) In HPL/SQL, declare statement does not support variable of type character
[ https://issues.apache.org/jira/browse/HIVE-21082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He updated HIVE-21082: -- Attachment: HIVE-21082.patch Status: Patch Available (was: Open) > In HPL/SQL, declare statement does not support variable of type character > -- > > Key: HIVE-21082 > URL: https://issues.apache.org/jira/browse/HIVE-21082 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Minor > Attachments: HIVE-21082.patch > > > In the following HPL/SQL programs: > DECLARE a character(5); SET a = 'b'; > when the type of variable 'a' is CHARACTER, it cannot be assigned a value > successfully. The support for the character type should be added to DECLARE > statement. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Assigned] (HIVE-21082) In HPL/SQL, declare statement does not support variable of type character
[ https://issues.apache.org/jira/browse/HIVE-21082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Baoning He reassigned HIVE-21082: - > In HPL/SQL, declare statement does not support variable of type character > -- > > Key: HIVE-21082 > URL: https://issues.apache.org/jira/browse/HIVE-21082 > Project: Hive > Issue Type: Bug > Components: hpl/sql >Reporter: Baoning He >Assignee: Baoning He >Priority: Minor > > In the following HPL/SQL programs: > DECLARE a character(5); SET a = 'b'; > when the type of variable 'a' is CHARACTER, it cannot be assigned a value > successfully. The support for the character type should be added to DECLARE > statement. -- This message was sent by Atlassian JIRA (v7.6.3#76005)