[ARROW-13306] [Java][JDBC] use ResultSetMetaData.getColumnLabel instead of ResultSetMetaData.getColumnName

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 5.0.0
• Component/s: Java
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/28982
• Assignee: Jiangtao Peng
• Reporter: Jiangtao Peng
• Created: 12/Jul/21 09:08
• Updated: 11/Jan/23 08:32
• Resolved: 19/Jul/21 09:43

Description

when using JDBC to Arrow utils, sometimes, column alias can not be displayed in final arrow results. 

For example, here is a result set from query 

SELECT col AS a FROM table

postgres can works properly, arrow result schema contains "a", but mysql arrow result schema contains "col".

This is because postgres use field label as column name and column label (postgres jdbc), but mysql use column name as label, original column name as name (mysql jdbc).

Maybe "getColumnLabel" is more fittable for arrow results, instead of "getColumnName".

Issue Links

• links to: GitHub Pull Request #10700