Dennis created HIVE-21120:
-----------------------------
Summary: Bug while executing control structure with subquery
Key: HIVE-21120
URL: https://issues.apache.org/jira/browse/HIVE-21120
Project: Hive
Issue Type: Bug
Reporter: Dennis
I found a bug in HPL/SQL 0.3.31 integrated in Hive Service.
When I execute following Stored Procedure, the Print inside the IF Statement is
not reached:
CREATE PROCEDURE EVALUATION
BEGIN
DECLARE Result DOUBLE;
SELECT Result = MAX(LISTPRICE) FROM PRODUCT_ORC;
PRINT Result;
IF CAST(Result AS DOUBLE) > 500.00 THEN
PRINT 'IF wird aufgerufen';
END IF;
END
You can reproduce the bug, when you run following SQL Statements in hive,
before you start the HPL/SQL stored procedure
CREATE TABLE adventureworks.PRODUCT_ORC
(
productid int,
listprice double
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS ORC
TBLPROPERTIES("transactional"="true");
INSERT INTO PRODUCT_ORC VALUES (1, 250.358);
INSERT INTO PRODUCT_ORC VALUES (2, 358.485);
INSERT INTO PRODUCT_ORC VALUES (3, 501.525);
!https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif!
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)