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

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

     [ https://issues.apache.org/jira/browse/HIVE-27337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sai Hemanth Gantasala resolved HIVE-27337.
------------------------------------------
    Fix Version/s: 4.0.0-alpha-1
       Resolution: Fixed

> 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
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.0.0-alpha-1
>
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> 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)