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

[YSQL] Partition schema is not defined for table "sys.catalog" in YugaByte #5832

Open
nocaway opened this issue Sep 26, 2020 · 1 comment
Open
Assignees
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue

Comments

@nocaway
Copy link
Contributor

nocaway commented Sep 26, 2020

Jira Link: DB-4848
Each table in YSQL is stored in YugaByte under a specific partition schema, either HASH or RANGE.
However, the table "sys.catalog" definition does not specify the partition schema.
Other YSQL system tables also have the same issue.

Here is its full definition in Protobuf format.

name: "sys.catalog"
version: 0
schema {
  columns {
    id: 10
    name: "entry_type"
    type {
      main: INT8
    }
    is_key: true
    is_nullable: false
    is_static: false
    is_counter: false
    sorting_type: 1
    order: 0
  }
  columns {
    id: 11
    name: "entry_id"
    type {
      main: BINARY
    }
    is_key: true
    is_nullable: false
    is_static: false
    is_counter: false
    sorting_type: 1
    order: 0
  }
  columns {
    id: 12
    name: "metadata"
    type {
      main: BINARY
    }
    is_key: false
    is_nullable: false
    is_static: false
    is_counter: false
    sorting_type: 0
    order: 0
  }
  table_properties {
    contain_counters: false
    is_transactional: false
    consistency_level: STRONG
    use_mangled_column_name: false
    is_ysql_catalog_table: false
    is_backfilling: false
  }
  colocated_table_id {
  }
}
state: RUNNING
table_type: YQL_TABLE_TYPE
namespace_id: "00000000000000000000000000000002"
@nocaway nocaway added the kind/bug This issue is a bug label Sep 26, 2020
@nocaway nocaway self-assigned this Sep 26, 2020
@nocaway
Copy link
Contributor Author

nocaway commented Sep 26, 2020

Since "sys.catalog" has TWO ASC columns and occupies one tablet, its schema can be defined as COLOCATED and RANGE-PARTITIONING

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue
Projects
Status: No status
Development

No branches or pull requests

4 participants