You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Wechar (Jira)" <ji...@apache.org> on 2022/06/25 16:01:00 UTC

[jira] [Assigned] (HIVE-26355) Column compare should be case insensitive

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

Wechar reassigned HIVE-26355:
-----------------------------


> Column compare should be case insensitive
> -----------------------------------------
>
>                 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
>
>
> 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)