[HIVE-26041] Fix wrong type supplied for getLatestCommittedCompaction

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Assignee: Yu-Wen Lai
• Reporter: Yu-Wen Lai
• Created: 16/Mar/22 18:46
• Updated: 28/Mar/22 17:39
• Resolved: 28/Mar/22 17:39

Description

In HIVE-25753, we filter compactions by CC_ID, but I used string type as the parameter for the prepared statement. That cause a type error on some databases (at least failed on PostgreSQL).

To correctly handle the filter, we should use 

preparedStatement.setLong(...)

Issue Links

• is caused by: HIVE-25753 Improving performance of getLatestCommittedCompactionInfo
• links to: GitHub Pull Request #3113