Skip to content

paimonHDFS did not work when paimon table is not PARTITIONED #89690

@ALFIE2017

Description

@ALFIE2017

Company or project name

No response

Describe the unexpected behaviour

SQL 错误 [1002]: ClickHouse exception, code: 1002, host: 192.168.180.203, port: 18123; Code: 660. DB::Exception: /bucket-0/data-00bd0bec-06a6-41d5-820d-2f8e29746239-0.parquet does not exist. Error: FileNotFoundException: Path /bucket-0/data-00bd0bec-06a6-41d5-820d-2f8e29746239-0.parquet does not exist: While executing ReadFromObjectStorage. (HDFS_ERROR) (version 25.10.1.3832 (official build))

Which ClickHouse versions are affected?

version 25.10.1.3832

How to reproduce

paimon ddl :
tableEnv.executeSql("CREATE TABLE if not exists my_table_np (\n" +
" user_id BIGINT,\n" +
" item_id BIGINT,\n" +
" behavior STRING,\n" +
" dt STRING,\n" +
" hh STRING,\n" +
" PRIMARY KEY (dt, hh, user_id) NOT ENFORCED);");
clickhouse-sql:
create named collection paimon_conf on cluster cluster_3s_2r as url = 'hdfs://nameservice1/dev/paimon/test.db';
SELECT * FROM paimonHDFS(paimon_conf, filename = 'my_table_np' ) settings hdfs_ignore_file_doesnt_exist = 1;

Expected behavior

No response

Error message and/or stacktrace

No response

Additional context

No response

Metadata

Metadata

Assignees

Labels

unexpected behaviourResult is unexpected, but not entirely wrong at the same time.

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions