[HIVE-27489] HPL/SQL does not support table aliases on column names in loops

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0
• Component/s: hpl/sql
• Labels: pull-request-available
• Assignee: Dayakar M
• Reporter: Dayakar M
• Created: 10/Jul/23 05:54
• Updated: 29/Mar/24 17:49
• Resolved: 22/Jan/24 05:11

Description

HPL/SQL does not support table aliases on column names in cursor loops where as the same works in Oracle's PL/SQL.

 

This works in Oracle:

 

CREATE OR replace PROCEDURE test2
AS
BEGIN
FOR rec IN (select tab.a from test tab) LOOP
dbms_output.put_line(rec.a);
END LOOP;
END;
SQL> call test2();
one
two

 

This does not work in Hive -
ERROR : Unhandled exception in HPL/SQL
No other errors are shown

Without alias, it works in Hive:

BEGIN
FOR rec IN (select a from test tab) LOOP
dbms_output.put_line(rec.a);
END LOOP;
END;

Issue Links

• is related to: HIVE-26818 Beeline module misses transitive dependencies due to shading
• links to: GitHub Pull Request #5005