{ "table_id": 27765962, "partition_id": 27765961, "tablet_id": 27765968, "schema_hash": 1210374941, "shard_id": 970, "creation_time": 1790675278, "cumulative_layer_point": -1, "tablet_state": "PB_RUNNING", "schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "batch_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 38, "index_length": 20, "visible": true }, { "unique_id": 1, "name": "game_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true }, { "unique_id": 2, "name": "participant_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 3, "name": "nickname", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true }, { "unique_id": 4, "name": "best_score", "type": "DOUBLE", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 5, "name": "best_score_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 6, "name": "last_played_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 7, "name": "has_completed", "type": "BOOLEAN", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 8, "name": "source_kind", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 9, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 10, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 11, "is_in_memory": false, "delete_sign_idx": 9, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 3, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1 }, "rs_metas": [ { "rowset_id": 0, "partition_id": 27765961, "tablet_id": 27765968, "tablet_schema_hash": 1210374941, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 1, "num_rows": 0, "total_disk_size": 0, "data_disk_size": 0, "index_disk_size": 0, "empty": true, "creation_time": 1790675278, "tablet_uid": { "hi": 1895273802431556561, "lo": 70614225842879164 }, "num_segments": 0, "rowset_id_v2": "020000000f32242d514f3c0a4431ef29fdb28aaedb5b78a6", "oldest_write_timestamp": 1790675278, "newest_write_timestamp": 1790675278, "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "batch_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 38, "index_length": 20, "visible": true }, { "unique_id": 1, "name": "game_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true }, { "unique_id": 2, "name": "participant_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 3, "name": "nickname", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true }, { "unique_id": 4, "name": "best_score", "type": "DOUBLE", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 5, "name": "best_score_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 6, "name": "last_played_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 7, "name": "has_completed", "type": "BOOLEAN", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 8, "name": "source_kind", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 9, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 10, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 11, "is_in_memory": false, "delete_sign_idx": 9, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 3, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1 }, "segments_overlap_pb": "NONOVERLAPPING" }, { "rowset_id": 0, "partition_id": 27765961, "tablet_id": 27765968, "tablet_schema_hash": 1210374941, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 2, "end_version": 120772, "num_rows": 46700, "total_disk_size": 2204268, "data_disk_size": 2204268, "index_disk_size": 465636, "empty": false, "creation_time": 1793280240, "tablet_uid": { "hi": 1895273802431556561, "lo": 70614225842879164 }, "num_segments": 1, "rowset_id_v2": "0200000000311daf6f4539094a92d3c48d0047dbc3129b89", "oldest_write_timestamp": 1790690406, "newest_write_timestamp": 1793280238, "segments_key_bounds": [ { "min_key": "\u000200071fe3-c9f3-430a-a5a0-66ef73d2ea88\u0002canal-escape-game\u00023334471", "max_key": "\u0002fffd80b0-575f-4527-9876-76126a94a67d\u0002where-is-it\u00023334471" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "batch_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 38, "index_length": 20, "visible": true }, { "unique_id": 1, "name": "game_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true }, { "unique_id": 2, "name": "participant_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 3, "name": "nickname", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true }, { "unique_id": 4, "name": "best_score", "type": "DOUBLE", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 5, "name": "best_score_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 6, "name": "last_played_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 7, "name": "has_completed", "type": "BOOLEAN", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 8, "name": "source_kind", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 9, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 10, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 11, "is_in_memory": false, "delete_sign_idx": 9, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 3, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1 }, "segments_overlap_pb": "NONOVERLAPPING" }, { "rowset_id": 0, "partition_id": 27765961, "tablet_id": 27765968, "tablet_schema_hash": 1210374941, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 120773, "end_version": 128368, "num_rows": 4220, "total_disk_size": 154510, "data_disk_size": 154510, "index_disk_size": 127099, "empty": false, "creation_time": 1793533439, "tablet_uid": { "hi": 1895273802431556561, "lo": 70614225842879164 }, "num_segments": 1, "rowset_id_v2": "02000000004793756f4539094a92d3c48d0047dbc3129b89", "oldest_write_timestamp": 1793280240, "newest_write_timestamp": 1793533438, "segments_key_bounds": [ { "min_key": "\u00020033c008-4718-4c3b-aab0-e6fd8659c7cc\u0002attention-game\u00023296009", "max_key": "\u0002ff96be11-73aa-46ee-a5e2-791d7af273a7\u0002where-is-it\u00023334471" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "batch_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 38, "index_length": 20, "visible": true }, { "unique_id": 1, "name": "game_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true }, { "unique_id": 2, "name": "participant_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 3, "name": "nickname", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true }, { "unique_id": 4, "name": "best_score", "type": "DOUBLE", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 5, "name": "best_score_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 6, "name": "last_played_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 7, "name": "has_completed", "type": "BOOLEAN", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 8, "name": "source_kind", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 9, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 10, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 11, "is_in_memory": false, "delete_sign_idx": 9, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 3, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1 }, "segments_overlap_pb": "NONOVERLAPPING" }, { "rowset_id": 0, "partition_id": 27765961, "tablet_id": 27765968, "tablet_schema_hash": 1210374941, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 128369, "end_version": 130585, "num_rows": 1230, "total_disk_size": 48596, "data_disk_size": 48596, "index_disk_size": 38468, "empty": false, "creation_time": 1793607241, "tablet_uid": { "hi": 1895273802431556561, "lo": 70614225842879164 }, "num_segments": 1, "rowset_id_v2": "02000000004d25936f4539094a92d3c48d0047dbc3129b89", "oldest_write_timestamp": 1793533439, "newest_write_timestamp": 1793607241, "segments_key_bounds": [ { "min_key": "\u0002015abce4-03a5-4706-9c03-092dc3043043\u0002attention-game\u00023296009", "max_key": "\u0002fcd3a79a-8015-4187-9427-9d0944b761ab\u0002where-is-it\u00023334471" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "batch_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 38, "index_length": 20, "visible": true }, { "unique_id": 1, "name": "game_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true }, { "unique_id": 2, "name": "participant_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 3, "name": "nickname", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true }, { "unique_id": 4, "name": "best_score", "type": "DOUBLE", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 5, "name": "best_score_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 6, "name": "last_played_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 7, "name": "has_completed", "type": "BOOLEAN", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 8, "name": "source_kind", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 9, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 10, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 11, "is_in_memory": false, "delete_sign_idx": 9, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 3, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1 }, "segments_overlap_pb": "NONOVERLAPPING" }, { "rowset_id": 0, "partition_id": 27765961, "tablet_id": 27765968, "tablet_schema_hash": 1210374941, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 130586, "end_version": 130625, "num_rows": 22, "total_disk_size": 4005, "data_disk_size": 4005, "index_disk_size": 1430, "empty": false, "creation_time": 1793608447, "tablet_uid": { "hi": 1895273802431556561, "lo": 70614225842879164 }, "num_segments": 1, "rowset_id_v2": "02000000004d50606f4539094a92d3c48d0047dbc3129b89", "oldest_write_timestamp": 1793607243, "newest_write_timestamp": 1793608444, "segments_key_bounds": [ { "min_key": "\u0002638df3c7-7f3a-471e-b4f2-b743cfaa2890\u0002attention-game\u00023296009", "max_key": "\u0002d976fec9-87c7-49e7-81cd-2fbf67af9c43\u0002sky-symbols-game\u00022871921" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "batch_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 38, "index_length": 20, "visible": true }, { "unique_id": 1, "name": "game_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true }, { "unique_id": 2, "name": "participant_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 3, "name": "nickname", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true }, { "unique_id": 4, "name": "best_score", "type": "DOUBLE", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 5, "name": "best_score_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 6, "name": "last_played_at", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 3, "length": 8, "index_length": 8, "visible": true }, { "unique_id": 7, "name": "has_completed", "type": "BOOLEAN", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 8, "name": "source_kind", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true }, { "unique_id": 9, "name": "__DORIS_DELETE_SIGN__", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true }, { "unique_id": 10, "name": "__DORIS_VERSION_COL__", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "default_value": "0", "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 11, "is_in_memory": false, "delete_sign_idx": 9, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 3, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1 }, "segments_overlap_pb": "NONOVERLAPPING" } ], "in_restore_mode": false, "tablet_uid": { "hi": 1895273802431556561, "lo": 70614225842879164 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 27765969, "storage_policy": "", "delete_bitmap": {}, "enable_unique_key_merge_on_write": true }