starrocks
starrocks copied to clipboard
FILE EXTERNAL TABLE cannot convert the parquet BOOLEAN to INT
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
BOOLEANto
BIGINT.
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.