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

[ydb dwh] add useful attributes to coltable tabs #885

Closed
antonkovalenko opened this issue Jun 7, 2024 · 6 comments
Closed

[ydb dwh] add useful attributes to coltable tabs #885

antonkovalenko opened this issue Jun 7, 2024 · 6 comments
Assignees

Comments

@antonkovalenko
Copy link
Member

antonkovalenko commented Jun 7, 2024

  1. Don't display metrics that has not value, like these:
LastAccessTime . . . . . .  N/A
LastUpdateTime . . . . . . .N/A
  1. Rename Columntable to Column-oriented table like in docs

  2. At the top section AUTO_PARTITIONING_MIN_PARTITIONS_COUNT should be displayed as well, according to docs

  3. Partitioning section should be displayed just like it was written in sql query - PARTITION BY HASH(id)

Further improvements are to be discussed during a meeting in a couple of weeks

@SloNN
Copy link

SloNN commented Jul 11, 2024

I suggest that the following list should be displayed:

  1. Type - Column-based table
  2. Created
  3. Updated
  4. Row count
  5. Disk size

You can show below (or better to show somewhere separate):

  1. Partition count
  2. Type of partitioning (by size, by load etc)

I suggest not to show:

  1. Id
  2. Version

@antonkovalenko antonkovalenko changed the title [ydb dwh] add useful attributed to coltable tabs [ydb dwh] add useful attributes to coltable tabs Jul 15, 2024
@antonkovalenko
Copy link
Member Author

ydb-platform/ydb#6672 waiting for this one

@artemmufazalov
Copy link
Member

You can show below (or better to show somewhere separate):

  1. Type of partitioning (by size, by load etc)

@SloNN Where can I get info about column table partitioning? Currently, we have only ColumnTableDescription.Sharding.HashSharding, so we display Sharding: hash if it is present

@artemmufazalov
Copy link
Member

Regarding Min and Max number of partitions - we don't have these params for columns tables, do they exist somewhere?

@SloNN
Copy link

SloNN commented Jul 26, 2024

Where can I get info about column table partitioning? Currently, we have only ColumnTableDescription.Sharding.HashSharding, so we display Sharding: hash if it is present

We will resolve it here ydb-platform/ydb#6672

@SloNN
Copy link

SloNN commented Aug 9, 2024

This information will be provided in this issue ydb-platform/ydb#7620

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants