[HIVE-6687] JDBC ResultSet fails to get value by qualified projection name

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.12.0
• Fix Version/s: 0.13.0
• Component/s: HiveServer2
• Labels: documentation
• Assignee: Laljo John Pullokkaran
• Reporter: Laljo John Pullokkaran
• Created: 17/Mar/14 21:26
• Updated: 10/Aug/16 06:25
• Resolved: 24/Mar/14 05:28

Description

Getting value from result set using fully qualified name would throw exception. Only solution today is to use position of the column as opposed to column label.

String sql = "select r1.x, r2.x from r1 join r2 on r1.y=r2.y";
ResultSet res = stmt.executeQuery(sql);
res.getInt("r1.x");

res.getInt("r1.x"); would throw exception unknown column even though sql specifies it.

Fix is to fix resultsetschema in semantic analyzer.

Issue Links

• is duplicated by: HIVE-14387 Add an option to skip the table names for the column headers
• relates to: HIVE-11614 CBO: Calcite Operator To Hive Operator (Calcite Return Path): ctas after order by has problem