cloudberry icon indicating copy to clipboard operation
cloudberry copied to clipboard

[Bug] Pax create table with minmax_columns

Open yjhjstz opened this issue 7 months ago • 0 comments

Apache Cloudberry version

main

What happened

SET default_table_access_method = pax;
create table partition_cow(c1 int, c2 bigint, c3 varchar, c4 text, c5 date, c6 float4, c7 float8, c8 numeric, c9 interval) partition by range(c1) (start(1) end(15000) every(5000)) with (minmax_columns='c1,c2,c3,c4,c5,c6,c7,c8,c9');
NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c1' as the Apache Cloudberry data distribution key for this table.
HINT:  The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
ERROR:  unrecognized parameter "minmax_columns"

What you think should happen instead

No response

How to reproduce

SET default_table_access_method = pax;
create table partition_cow(c1 int, c2 bigint, c3 varchar, c4 text, c5 date, c6 float4, c7 float8, c8 numeric, c9 interval) partition by range(c1) (start(1) end(15000) every(5000)) with (minmax_columns='c1,c2,c3,c4,c5,c6,c7,c8,c9');
NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c1' as the Apache Cloudberry data distribution key for this table.
HINT:  The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
ERROR:  unrecognized parameter "minmax_columns"

Operating System

centos 7, 8

Anything else

No response

Are you willing to submit PR?

  • [ ] Yes, I am willing to submit a PR!

Code of Conduct

yjhjstz avatar May 06 '25 17:05 yjhjstz