[
https://issues.apache.org/jira/browse/HIVE-26507?focusedWorklogId=808397&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-808397
]
ASF GitHub Bot logged work on HIVE-26507:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 13/Sep/22 18:07
Start Date: 13/Sep/22 18:07
Worklog Time Spent: 10m
Work Description: nrg4878 merged PR #3593:
URL: https://github.com/apache/hive/pull/3593
Issue Time Tracking
-------------------
Worklog Id: (was: 808397)
Time Spent: 1h 10m (was: 1h)
> Do not allow hive to iceberg migration if source table contains CHAR or
> VARCHAR columns
> ---------------------------------------------------------------------------------------
>
> Key: HIVE-26507
> URL: https://issues.apache.org/jira/browse/HIVE-26507
> Project: Hive
> Issue Type: Bug
> Reporter: Rajesh Balamohan
> Assignee: László Pintér
> Priority: Major
> Labels: iceberg, pull-request-available
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> "alter table" statements can be used for generating iceberg metadata
> information (i.e for converting external tables -> iceberg tables).
> As part of this process, it also converts certain datatypes to iceberg
> compatible types (e.g char -> string). "iceberg.mr.schema.auto.conversion"
> enables this conversion.
> This could cause certain issues at runtime. Here is an example
> {noformat}
> Before conversion:
> ==================
> -- external table
> select count(*) from customer_demographics where cd_gender = 'F' and
> cd_marital_status = 'U' and cd_education_status = '2 yr Degree';
> 27440
> after conversion:
> =================
> -- iceberg table
> select count(*) from customer_demographics where cd_gender = 'F' and
> cd_marital_status = 'U' and cd_education_status = '2 yr Degree';
> 0
> select count(*) from customer_demographics where cd_gender = 'F' and
> cd_marital_status = 'U' and trim(cd_education_status) = '2 yr Degree';
> 27440
> {noformat}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
