ClickHouse / ClickHouse

ClickHouse® is a real-time analytics DBMS
https://clickhouse.com
Apache License 2.0
37.54k stars 6.9k forks source link

Error occurred while reading data from an Iceberg table on S3. #68436

Open nanchun opened 2 months ago

nanchun commented 2 months ago

Company or project name

No response

Question

SELECT * FROM iceberg('http://******/lake/data/base_da/de_test', 'root', '1234qwer');

org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [36] [07000]: Code: 36. DB::Exception: Bad metadata file name: v00001-34e20dae-5c6f-4d3e-abb6-4710cb2c43de.metadata.json. Expected vN.metadata.json where N is a number. (BAD_ARGUMENTS) (version 24.9.1.386 (official build)) , server ClickHouseNode [uri=http://192.168.1.110:28123/default, options={use_server_time_zone=false,use_time_zone=false}]@1171156552

at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)
nanchun commented 2 months ago

If the issue has been resolved, please provide the version number where the fix was applied.

kssenii commented 2 months ago

How did you create your iceberg table? I do not see in spec metadata file with format v<V>-<uuid>.metadata.json (as in your exception), there is only either <V>-<uuid>.metadata.json or v<V>.metadata.json in https://iceberg.apache.org/spec/