[ https://issues.apache.org/jira/browse/HIVE-6687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laljo John Pullokkaran updated HIVE-6687: ----------------------------------------- Attachment: HIVE-6687.4.patch > JDBC ResultSet fails to get value by qualified projection name > -------------------------------------------------------------- > > Key: HIVE-6687 > URL: https://issues.apache.org/jira/browse/HIVE-6687 > Project: Hive > Issue Type: Bug > Components: HiveServer2 > Affects Versions: 0.12.0 > Reporter: Laljo John Pullokkaran > Assignee: Laljo John Pullokkaran > Labels: documentation > Fix For: 0.12.1 > > Attachments: HIVE-6687.4.patch > > > 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. > {code} > 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"); > {code} > res.getInt("r1.x"); would throw exception unknown column even though sql > specifies it. > Fix is to fix resultsetschema in semantic analyzer. -- This message was sent by Atlassian JIRA (v6.2#6252)