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

["Sai Hemanth Gantasala (Jira)" <ji...@apache.org>]

Sai Hemanth Gantasala created HIVE-27337:
--------------------------------------------

             Summary: create and alter queries should trim empty spaces in the request objects.
                 Key: HIVE-27337
                 URL: https://issues.apache.org/jira/browse/HIVE-27337
             Project: Hive
          Issue Type: Bug
          Components: Standalone Metastore
    Affects Versions: 4.0.0-alpha-2
            Reporter: Sai Hemanth Gantasala
            Assignee: Sai Hemanth Gantasala


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|https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/HiveAlterHandler.java#L174]. The ideal behavior should be to ignore the whitespaces and proceed with alter request.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)