[jira] [Work logged] (HIVE-26355) Column compare should be case insensitive for name

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-26355?focusedWorklogId=784810&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-784810 ]

ASF GitHub Bot logged work on HIVE-26355:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 25/Jun/22 16:14
            Start Date: 25/Jun/22 16:14
    Worklog Time Spent: 10m 
      Work Description: wecharyu opened a new pull request, #3406:
URL: https://github.com/apache/hive/pull/3406

   
   ### What changes were proposed in this pull request?
   Fix a bug in comparing column fields between old table and new table.
   
   
   ### Why are the changes needed?
   Hive is case-insensitive in field name, but some engines are case-sensitive, so when calling `alter_table` the existing column name may not be equal because of the case.
   
   ### Does this PR introduce _any_ user-facing change?
   No
   
   ### How was this patch tested?
   We add two unit tests, can be run with command:
   ```bash
   $ mvn test -Dtest=org.apache.hadoop.hive.metastore.utils.TestMetaStoreServerUtils -pl :hive-standalone-metastore-server
   ```
   




Issue Time Tracking
-------------------

            Worklog Id:     (was: 784810)
    Remaining Estimate: 0h
            Time Spent: 10m

> Column compare should be case insensitive for name
> --------------------------------------------------
>
>                 Key: HIVE-26355
>                 URL: https://issues.apache.org/jira/browse/HIVE-26355
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 4.0.0-alpha-1
>            Reporter: Wechar
>            Assignee: Wechar
>            Priority: Major
>             Fix For: 4.0.0-alpha-2
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Hive stores all name related value as lower case, such as db_name, tbl_name, col_name etc. But the compare of {{FieldSchema}} does not ignore the case of name, which may cause incorrect result of compare.
> *Bug Description:*
> Some computing engines are case sensitive for column name. For example, Spark will add a table property to save the column fields when creating a table, and will replace column fields with this property when fetching table fields.
> When calling {{*ALTER TABLE ... ADD COLUMNS*}}, the compare of fields between old table and new table will be not expected, and the ADD COLUMNS operation will be cascaded to PARTITIONS, which is unnecessary and time consuming if the table has many partitions.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)