Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] a table specified with "appendonly=true, orientation=column" appears not as an ao table #368

Open
1 of 2 tasks
congxuebin opened this issue Jan 19, 2024 · 1 comment
Assignees
Labels
type: Bug Something isn't working

Comments

@congxuebin
Copy link
Collaborator

congxuebin commented Jan 19, 2024

Cloudberry Database version

Expected:

create table mpp17761.split_tab5( a int, b int, c char(5), d boolean default true) with (appendonly=true, orientation=column ) 
distributed randomly 
partition by list(b)
(
    partition a values (1,2,3,4) with (appendonly = true), 
    partition b values(5,6,7,8) with (appendonly = true),
    DEFAULT COLUMN ENCODING (compresstype=zlib,compresslevel=5)
);
CREATE TABLE

Actual behavior:

create table mpp17761.split_tab5( a int, b int, c char(5), d boolean default true) with (appendonly=true, orientation=column ) 
distributed randomly 
partition by list(b)
(
    partition a values (1,2,3,4) with (appendonly = true), 
    partition b values(5,6,7,8) with (appendonly = true),
    DEFAULT COLUMN ENCODING (compresstype=zlib,compresslevel=5)
);
);
psql:/code/cbdb_testrepo_src/mpp/gpdb/tests/storage/basic/partition/output/mpp17761.sql:196: ERROR:  ENCODING clause only supported with column oriented tables

What happened

As stated above,

What you think should happen instead

No response

How to reproduce

As stated above

Operating System

centos7

Anything else

No response

Are you willing to submit PR?

  • Yes, I am willing to submit a PR!

Code of Conduct

@congxuebin congxuebin added the type: Bug Something isn't working label Jan 19, 2024
@congxuebin congxuebin changed the title [Bug] table with appendonly=true, orientation=column, appears not as a AO table [Bug] table with appendonly=true, orientation=column, but appears not as a AO table Jan 19, 2024
@congxuebin congxuebin changed the title [Bug] table with appendonly=true, orientation=column, but appears not as a AO table [Bug] table with appendonly=true, orientation=column, but appears not as an AO table Jan 19, 2024
@congxuebin
Copy link
Collaborator Author

I tried on old version cbdb, it is not as AO table(I don't see Access method ao_column), which could be the problem?

gpadmin=# create table split_tab5( a int, b int, c char(5), d boolean default true) with (appendonly=true, orientation=column ) 
distributed randomly 
partition by list(b)
(
    partition a values (1,2,3,4) with (appendonly = true), 
    partition b values(5,6,7,8) with (appendonly = true),
    DEFAULT COLUMN ENCODING (compresstype=zlib,compresslevel=5)
);
CREATE TABLE
gpadmin=# \d+ split_tab5
                                    Partitioned table "public.split_tab5"
 Column |     Type     | Collation | Nullable | Default | Storage  | Compression | Stats target | Description 
--------+--------------+-----------+----------+---------+----------+-------------+--------------+-------------
 a      | integer      |           |          |         | plain    |             |              | 
 b      | integer      |           |          |         | plain    |             |              | 
 c      | character(5) |           |          |         | extended |             |              | 
 d      | boolean      |           |          | true    | plain    |             |              | 
Partition key: LIST (b)
Partitions: split_tab5_1_prt_a FOR VALUES IN (1, 2, 3, 4),
            split_tab5_1_prt_b FOR VALUES IN (5, 6, 7, 8)
Distributed randomly

@congxuebin congxuebin changed the title [Bug] table with appendonly=true, orientation=column, but appears not as an AO table [Bug] a table specified with "appendonly=true, orientation=column" appears not as an ao table Jan 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type: Bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants