{ "table_id": 44762622, "partition_id": 44762621, "tablet_id": 44762624, "schema_hash": 280461879, "shard_id": 312, "creation_time": 1760075662, "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": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "external_userid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "type", "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": 4, "name": "gender", "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": "unionid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "position", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "corp_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "corp_full_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "del_flag", "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": 10, "name": "user_type", "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": "account_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": 12, "name": "account_name", "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": 13, "name": "userid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "add_way", "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": 15, "name": "add_time", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 16, "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": 17, "name": "update_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": 18, "name": "remark_mobiles", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 19, "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": 20, "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": 21, "is_in_memory": false, "delete_sign_idx": 19, "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": 44762621, "tablet_id": 44762624, "tablet_schema_hash": 280461879, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 4, "num_rows": 85, "total_disk_size": 15018, "data_disk_size": 15018, "index_disk_size": 1710, "empty": false, "creation_time": 1761743184, "tablet_uid": { "hi": 6290093608491254724, "lo": 4499969656839513519 }, "num_segments": 1, "rowset_id_v2": "0200000000ae273b89472365a4c7bdfc8fa28538ec4d9385", "newest_write_timestamp": 1761210635, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0000^", "max_key": "\u0002€\u0000\u0000½" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "external_userid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "type", "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": 4, "name": "gender", "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": "unionid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "position", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "corp_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "corp_full_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "del_flag", "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": 10, "name": "user_type", "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": "account_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": 12, "name": "account_name", "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": 13, "name": "userid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "add_way", "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": 15, "name": "add_time", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 16, "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": 17, "name": "update_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": 18, "name": "remark_mobiles", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 19, "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": 20, "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": 21, "is_in_memory": false, "delete_sign_idx": 19, "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": 44762621, "tablet_id": 44762624, "txn_id": 11089782, "tablet_schema_hash": 280461879, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 5, "end_version": 5, "num_rows": 85, "total_disk_size": 16143, "data_disk_size": 16143, "index_disk_size": 1710, "empty": false, "load_id": { "hi": 3193005659695696295, "lo": -7411096510840663406 }, "creation_time": 1762132656, "tablet_uid": { "hi": 6290093608491254724, "lo": 4499969656839513519 }, "num_segments": 1, "rowset_id_v2": "0200000000b3301f89472365a4c7bdfc8fa28538ec4d9385", "newest_write_timestamp": 1762132656, "segments_key_bounds": [ { "min_key": "\u0002€\u0000\u0000^", "max_key": "\u0002€\u0000\u0000½" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "INT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "external_userid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "type", "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": 4, "name": "gender", "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": "unionid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "position", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "corp_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "corp_full_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 102, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "del_flag", "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": 10, "name": "user_type", "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": "account_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": 12, "name": "account_name", "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": 13, "name": "userid", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "add_way", "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": 15, "name": "add_time", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 16, "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": 17, "name": "update_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": 18, "name": "remark_mobiles", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 502, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 19, "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": 20, "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": 21, "is_in_memory": false, "delete_sign_idx": 19, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 1, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": 20, "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": 6290093608491254724, "lo": 4499969656839513519 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 44762625, "delete_bitmap": { "rowset_ids": [ "0200000000ae273b89472365a4c7bdfc8fa28538ec4d9385" ], "segment_ids": [ 0 ], "versions": [ 5 ], "segment_delete_bitmaps": [ ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000T\u0000\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\u0000M\u0000N\u0000O\u0000P\u0000Q\u0000R\u0000S\u0000T\u0000" ] }, "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 }