load hive data into openmldb error: requirement failed: schema mismatch

[chen131311]

Bug Description openMLDB:0.9.2 load hive data into openmldb error: requirement failed: schema mismatch

Expected Behavior

Relation Case

Steps to Reproduce

1. hive table : CREATE EXTERNAL TABLE tmp.ods_admin_da( id bigint, biz_key string ', biz_domain string , biz_type string , locked string , url string , method string , created_at string, updated_at string, biz_tag string, status string)
2. openMLDB table: desc test4;

   ---

   Field Type Null Default

   ---

   1 id BigInt YES 2 biz_key Varchar YES 3 biz_domain Varchar YES 4 biz_type Varchar YES 5 locked Varchar YES 6 url Varchar YES 7 method Varchar YES 8 created_at Varchar YES 9 updated_at Varchar YES 10 biz_tag Varchar YES 11 status Varchar YES

3. LOAD DATA INFILE 'hive://tmp.ods_admin_da' INTO TABLE demo_db.test4 OPTIONS(deep_copy=true,mode='append');
4. Get exception: requirement failed: schema mismatch, loaded StructType(StructField(id,LongType,true),StructField(biz_key,StringType,true),StructField(biz_domain,StringType,true),StructField(biz_type,StringType,true),StructField(locked,StringType,true),StructField(url,StringType,true),StructField(method,StringType,true),StructField(created_at,StringType,true),StructField(updated_at,StringType,true),StructField(biz_tag,StringType,true),StructField(status,StringType,true)) != table StructType(StructField(id,LongType,true),StructField(biz_key,StringType,true),StructField(biz_domain,StringType,true),StructField(biz_type,StringType,true),StructField(locked,StringType,true),StructField(url,StringType,true),StructField(method,StringType,true),StructField(created_at,StringType,true),StructField(updated_at,StringType,true),StructField(biz_tag,StringType,true),StructField(status,StringType,true)), check hive://kc_tmp.ods_admin_admin_biz_config_da

[Shouren]

@chen131311 I am trying to reproduce this bug and i want to know how is the table test4 created? Please provide the DDL of this table