[HIVE-28214] HPLSQL not using the hive variables passed through beeline using --hivevar option

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.1.0, 4.0.1
• Component/s: hpl/sql
• Labels: hive-4.0.1-merged hive-4.0.1-must pull-request-available
• Assignee: Dayakar M
• Reporter: Dayakar M
• Created: 24/Apr/24 17:01
• Updated: 24/Sep/24 02:15
• Resolved: 02/May/24 07:09

Description

HPLSQL not using the hive variables passed through beeline using --hivevar option.

Steps to reproduce:

beeline -u 'jdbc:hive2://localhost:10000/default;user=hive;password=hive;mode=hplsql' --hivevar hivedb=sys --hivevar hivetbl=tbls

0: jdbc:hive2://localhost> DECLARE hivedb_tbl string;
 . . . . . . . . . . . . . . . . . . . . . . .> SELECT hivedb || '.' || hivetbl into hivedb_tbl;
 . . . . . . . . . . . . . . . . . . . . . . .> PRINT hivedb_tbl;
 . . . . . . . . . . . . . . . . . . . . . . .> /
INFO  : Compiling command(queryId=hive_20240424145826_617acb79-0b27-46eb-aa05-1332703c94fb): SELECT CONCAT(hivedb, '.', hivetbl) 
ERROR : FAILED: SemanticException [Error 10004]: Line 1:14 Invalid table alias or column reference 'hivedb': (possible column names are: ) 
org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:14 Invalid table alias or column reference 'hivedb': (possible column names are: )
 
INFO  : Completed compiling command(queryId=hive_20240424145826_617acb79-0b27-46eb-aa05-1332703c94fb); Time taken: 3.976 seconds 
ERROR : Unhandled exception in HPL/SQL 
No rows affected (4.901 seconds)
0: jdbc:hive2://localhost>

Issue Links

• links to: GitHub Pull Request #5229