[HIVE-27337] create and alter queries should trim empty spaces in the request objects.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0-alpha-2
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Assignee: Sai Hemanth Gantasala
• Reporter: Sai Hemanth Gantasala
• Created: 12/May/23 00:10
• Updated: 09/Jun/23 04:12
• Resolved: 09/Jun/23 04:11

Description

If starting/trailing empty strings are being provided in the query (within the quotes),
Create table request (event) is currently being inserted into the notification log table. This would be a problem for listeners subscribed to the HMS notification log. So it would be ideal to trim these whitespaces and then insert it into the notification log. 

Alter table query is throwing an error here. The ideal behavior should be to ignore the whitespaces and proceed with alter request.

Issue Links

• links to: GitHub Pull Request #4316