query clustering_information return: ERROR 1105 (HY000): Code: 1002, displayText = Unimplemented

[lddlww]

databend version

v0.9.16-nightly-3fcebe7(rust-1.68.0-nightly-2023-01-27T16:29:17.399818523Z)

reproduce

mysql> create table t1(id int, name varchar(10));
mysql> alter table t1 cluster by(id,name);
mysql> select * from clustering_information('default','t1');
ERROR 1105 (HY000): Code: 1002, displayText = Unimplemented.

[xudong963]

Please try the latest version. I tested in main branch, it's ok.

[lddlww]

thanks, above step work now
add new step

mysql> create table t1(id int, name varchar(10));
mysql> insert into t1 values(1,'1');
mysql> alter table t1 cluster by(id,name);
mysql> select * from clustering_information('default','t1');
ERROR 1105 (HY000): Code: 1002, displayText = Unimplemented.

[xudong963]

backtrace:

   0: std::backtrace_rs::backtrace::libunwind::trace
             at /rustc/b70baa4f922a1809d79caeaeb902800c3be283b9/library/std/src/../../backtrace/src/backtrace/libunwind.rs:93:5
   1: std::backtrace_rs::backtrace::trace_unsynchronized
             at /rustc/b70baa4f922a1809d79caeaeb902800c3be283b9/library/std/src/../../backtrace/src/backtrace/mod.rs:66:5
   2: std::backtrace::Backtrace::create
             at /rustc/b70baa4f922a1809d79caeaeb902800c3be283b9/library/std/src/backtrace.rs:332:13
   3: common_exception::exception_code::<impl common_exception::exception::ErrorCode>::Unimplemented
             at ./src/common/exception/src/exception_code.rs:38:71
   4: common_storages_fuse::table_functions::clustering_informations::clustering_information::ClusteringInformation::get_min_max_stats
             at ./src/query/storages/fuse/src/table_functions/clustering_informations/clustering_information.rs:156:24
   5: common_storages_fuse::table_functions::clustering_informations::clustering_information::ClusteringInformation::get_clustering_stats
             at ./src/query/storages/fuse/src/table_functions/clustering_informations/clustering_information.rs:181:30
   6: common_storages_fuse::table_functions::clustering_informations::clustering_information::ClusteringInformation::get_clustering_info::{{closure}}
             at ./src/query/storages/fuse/src/table_functions/clustering_informations/clustering_information.rs:104:24
   7: <common_storages_fuse::table_functions::clustering_informations::clustering_information_table::ClusteringInformationSource as common_pipeline_sources::processors::sources::async_source::AsyncSource>::generate::{{closure}}

Seems we don't support manually specifying the cluster key. cc @zhyass

[xudong963]

Btw, it's better to return specific error info instead Unimplemented

[Xuanwo]

Btw, it's better to return specific error info instead Unimplemented

Can you help create an issue for this?

[xudong963]

An existing issue: #9764