starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

FILE EXTERNAL TABLE cannot convert the parquet BOOLEAN to INT

Open fenganli opened this issue 8 months ago • 0 comments

Please see the error msg below. Can we support the conversion? Note that BROKER LOAD can support this conversion, so I think it would be nice to make them consistent. java.sql.SQLException: (conn=104748) parquet column reader: not supported convert from parquet BOOLEANtoBIGINT.

Steps to reproduce the behavior (Required)

Just read a parquet boolean column from S3 as BIGINT using FILE EXTERNAL TABLE and you will encounter the above error message.

Expected behavior (Required)

Convert boolean to BIGINT similar to how BROKER LOAD does it.

Real behavior (Required)

Errors out.

StarRocks version (Required)

Any version has the problem now.

fenganli avatar Jun 27 '24 21:06 fenganli