apache / apache/cloudberry

[Bug] Pax create table with minmax_columns

Open
#1,089 0 comments 0 reactions 1 assignee Claimed by @gfphoenix78 View on GitHub
type: Bug
Dominant language
C
Stars
1.4k
Forks
247
Avg merge
4d 3h
Merged PRs (30d)
39

Description

### Apache Cloudberry version

main

### What happened

```sql
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

```sql
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

- [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/cloudberry/blob/main/CODE_OF_CONDUCT.md).

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.