[jira] [Updated] (HUDI-3944) Supports CTAS compatibility with string, char, and varchar.

["YangXuan (Jira)" <ji...@apache.org>]

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

YangXuan updated HUDI-3944:
---------------------------
    Description: 
1、create a table containing fields of type char and type varchar use hive.

create table hivetb_char (id int, comb int, col0 char(5), col1 varchar(5)) row format delimited fields terminated by ',' stored as orc;

insert into hivetb_char select 1,100,'aaaaa','bbbbb';

2、run CTAS to create hudi table by sparksql

create table hudi_test_char using hudi options(primaryKey='id', preCombineField='comb') as select * from default.hivetb_char;

!https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/8/14/qwx352829/e4f814488cb145f0b8dcd9595b0d9e90/image.png!

> Supports CTAS compatibility with string, char, and varchar.
> -----------------------------------------------------------
>
>                 Key: HUDI-3944
>                 URL: https://issues.apache.org/jira/browse/HUDI-3944
>             Project: Apache Hudi
>          Issue Type: Improvement
>            Reporter: YangXuan
>            Priority: Major
>
> 1、create a table containing fields of type char and type varchar use hive.
> create table hivetb_char (id int, comb int, col0 char(5), col1 varchar(5)) row format delimited fields terminated by ',' stored as orc;
> insert into hivetb_char select 1,100,'aaaaa','bbbbb';
> 2、run CTAS to create hudi table by sparksql
> create table hudi_test_char using hudi options(primaryKey='id', preCombineField='comb') as select * from default.hivetb_char;
> !https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/8/14/qwx352829/e4f814488cb145f0b8dcd9595b0d9e90/image.png!



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