matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.77k stars 274 forks source link

[Bug]: load parquet file reported load STRING to DOUBLE is not yet implemented #15626

Open heni02 opened 5 months ago

heni02 commented 5 months ago

Is there an existing issue for the same bug?

Branch Name

main

Commit ID

43ed769a01e02a59f4f7b1b48face8a0d6699e2a

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

mysql> load data infile {'filepath'='/Users/heni/test_data/parquet_data/Iris.parquet','format'='parquet'} into table parquet_04; ERROR 20102 (HY000): load STRING to DOUBLE is not yet implemented

ddl: create table parquet_04(sepal.length double,sepal.width double, petal.length double,petal.width double,variety double);

Iris.parquet schema: sepal.length: double sepal.width: double petal.length: double petal.width: double variety: string

Iris.parquet: iris.tar.gz

Expected Behavior

No response

Steps to Reproduce

create table parquet_04(`sepal.length` double,`sepal.width` double, `petal.length` double,`petal.width` double,`variety` double);
load data infile {'filepath'='/Users/heni/test_data/parquet_data/Iris.parquet','format'='parquet'} into table parquet_04;

Additional information

No response

heni02 commented 5 months ago

和楠哥沟通,1.2无法完成,先挪到1.3-backlog

YANGGMM commented 5 months ago

backlog

forsaken628 commented 4 months ago

ddl not match

variety double variety: string