{ "table_id": 11794206, "partition_id": 11794205, "tablet_id": 11794208, "schema_hash": 106803762, "shard_id": 850, "creation_time": 1734679195, "cumulative_layer_point": -1, "tablet_state": "PB_RUNNING", "schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "user_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "telephone", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "available", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "dept_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "duty", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "duty_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "superior_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "superior", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "level_id", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "level_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "wework_userid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "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, "result_is_nullable": false }, { "unique_id": 15, "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, "result_is_nullable": false } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 16, "is_in_memory": false, "delete_sign_idx": 14, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 1, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1, "store_row_column": false, "enable_single_replica_compaction": false, "skip_write_index_on_load": false, "inverted_index_storage_format": "V1" }, "rs_metas": [ { "rowset_id": 0, "partition_id": 11794205, "tablet_id": 11794208, "tablet_schema_hash": 106803762, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 229, "num_rows": 356, "total_disk_size": 23533, "data_disk_size": 23533, "index_disk_size": 1903, "empty": false, "creation_time": 1750748122, "tablet_uid": { "hi": -5890304368529980152, "lo": -5520654920142751815 }, "num_segments": 1, "rowset_id_v2": "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494", "newest_write_timestamp": 1750744879, "segments_key_bounds": [ { "min_key": "\u0002\u0000\u0000\u0001", "max_key": "\u0002\u0000\u0001t" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "user_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "telephone", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "available", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "dept_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "duty", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "duty_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "superior_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "superior", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "level_id", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "level_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "wework_userid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "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, "result_is_nullable": false }, { "unique_id": 15, "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, "result_is_nullable": false } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 16, "is_in_memory": false, "delete_sign_idx": 14, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 1, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": -1, "store_row_column": false, "enable_single_replica_compaction": false, "skip_write_index_on_load": false, "inverted_index_storage_format": "V1" }, "segments_overlap_pb": "NONOVERLAPPING" }, { "rowset_id": 0, "partition_id": 11794205, "tablet_id": 11794208, "tablet_schema_hash": 106803762, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 230, "end_version": 266, "num_rows": 266, "total_disk_size": 20009, "data_disk_size": 20009, "index_disk_size": 1788, "empty": false, "creation_time": 1751447250, "tablet_uid": { "hi": -5890304368529980152, "lo": -5520654920142751815 }, "num_segments": 1, "rowset_id_v2": "020000000051c3010d4b56a6a62184a4bba84e77d0cd6494", "newest_write_timestamp": 1751447212, "segments_key_bounds": [ { "min_key": "\u0002\u0000\u0000\u0001", "max_key": "\u0002\u0000\u0001p" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "user_no", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "telephone", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 62, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "available", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "dept_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "duty", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "duty_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "superior_id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "superior", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 52, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "level_id", "type": "TINYINT", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1, "index_length": 1, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "level_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "wework_userid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 152, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "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, "result_is_nullable": false }, { "unique_id": 15, "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, "result_is_nullable": false } ], "num_short_key_columns": 1, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 16, "is_in_memory": false, "delete_sign_idx": 14, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 1, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": 15, "store_row_column": false, "enable_single_replica_compaction": false, "skip_write_index_on_load": false, "inverted_index_storage_format": "V1" }, "segments_overlap_pb": "NONOVERLAPPING" } ], "in_restore_mode": false, "tablet_uid": { "hi": -5890304368529980152, "lo": -5520654920142751815 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 11794209, "delete_bitmap": { "rowset_ids": [ "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494", "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494", "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494", "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494", "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494", "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494", "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494", "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494", "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494", "0200000000457e3e0d4b56a6a62184a4bba84e77d0cd6494" ], "segment_ids": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ], "versions": [ 230, 231, 232, 236, 237, 238, 240, 242, 247, 260 ], "segment_delete_bitmaps": [ ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000U\u0001", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000\u001C\u0001", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000#\u0001", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000]\u0001", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000X\u0001", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000Z\u0001", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000^\u0001", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000\u0011\u0001", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0001\u0010\u0000\u0000\u0000\u0000\u0000\u0001\u0000\u0002\u0000\u0003\u0000\u0004\u0000\u0005\u0000\u0006\u0000\u0007\u0000\b\u0000\t\u0000\n\u0000\u000B\u0000\f\u0000\r\u0000\u000E\u0000\u000F\u0000\u0010\u0000\u0011\u0000\u0012\u0000\u0013\u0000\u0014\u0000\u0015\u0000\u0016\u0000\u0017\u0000\u0018\u0000\u0019\u0000\u001A\u0000\u001B\u0000\u001C\u0000\u001D\u0000\u001E\u0000\u001F\u0000 \u0000!\u0000\"\u0000#\u0000$\u0000%\u0000&\u0000'\u0000(\u0000)\u0000*\u0000+\u0000,\u0000-\u0000.\u0000/\u00000\u00001\u00002\u00003\u00004\u00005\u00006\u00007\u00008\u00009\u0000:\u0000;\u0000<\u0000=\u0000>\u0000?\u0000@\u0000A\u0000B\u0000C\u0000D\u0000E\u0000F\u0000G\u0000H\u0000I\u0000J\u0000K\u0000L\u0000N\u0000O\u0000P\u0000Q\u0000R\u0000S\u0000T\u0000U\u0000V\u0000W\u0000X\u0000Y\u0000Z\u0000[\u0000\\\u0000]\u0000^\u0000_\u0000`\u0000a\u0000b\u0000c\u0000d\u0000e\u0000f\u0000g\u0000h\u0000i\u0000j\u0000k\u0000l\u0000m\u0000n\u0000o\u0000p\u0000q\u0000r\u0000s\u0000t\u0000u\u0000v\u0000w\u0000x\u0000y\u0000z\u0000{\u0000|\u0000}\u0000~\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u000E\u0001\u0012\u0001\u0014\u0001\u0015\u0001\u0016\u0001\u0017\u0001\u0018\u0001\u0019\u0001\u001A\u0001\u001D\u0001\u001E\u0001\u001F\u0001 \u0001!\u0001\"\u0001$\u0001%\u0001&\u0001'\u0001(\u0001)\u0001*\u0001+\u0001,\u0001-\u0001.\u0001/\u00010\u00011\u00012\u00013\u00014\u00015\u00016\u00017\u00018\u00019\u0001:\u0001;\u0001<\u0001=\u0001>\u0001?\u0001@\u0001A\u0001B\u0001C\u0001D\u0001E\u0001F\u0001G\u0001H\u0001I\u0001J\u0001K\u0001L\u0001M\u0001N\u0001O\u0001P\u0001Q\u0001R\u0001S\u0001T\u0001V\u0001W\u0001Y\u0001[\u0001\\\u0001", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000_\u0001" ] }, "enable_unique_key_merge_on_write": true, "binlog_config": { "enable": false, "ttl_seconds": 86400, "max_bytes": 9223372036854775807, "max_history_nums": 9223372036854775807 }, "compaction_policy": "size_based", "time_series_compaction_goal_size_mbytes": 1024, "time_series_compaction_file_count_threshold": 2000, "time_series_compaction_time_threshold_seconds": 3600, "time_series_compaction_empty_rowsets_threshold": 5, "time_series_compaction_level_threshold": 1 }