{ "table_id": 1502304, "partition_id": 35748459, "tablet_id": 83408144, "schema_hash": 1394013520, "shard_id": 692, "creation_time": 1782380592, "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": "order_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": 22, "name": "annual_income", "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": 23, "name": "family_income", "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": 24, "name": "marriage_status", "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": 18, "name": "funder_pretrial_no", "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": 2, "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": 3, "name": "relation_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": 4, "name": "relation", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "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": 6, "name": "telephone", "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": 19, "name": "validate_code", "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": 20, "name": "validate_msg", "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": "card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "card_file", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 902, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "nation", "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": "nation_id", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "native_place", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "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": 12, "name": "born_date", "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": "address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "education", "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": "age", "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": 25, "name": "living_address", "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": 26, "name": "living_zone_id_path", "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": 27, "name": "living_zone_name_path", "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": 28, "name": "registered_address", "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": 29, "name": "registered_zone_id_path", "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": 30, "name": "registered_zone_name_path", "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": 31, "name": "id_visa_org", "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": 32, "name": "id_start_date", "type": "DATEV2", "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": 33, "name": "id_end_date", "type": "DATEV2", "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": 34, "name": "contributor_amount", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 35, "name": "contributor_ratio", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "contributor_date", "type": "DATEV2", "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": 16, "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": 17, "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": 37, "is_in_memory": false, "delete_sign_idx": 35, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 0, "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": 35748459, "tablet_id": 83408144, "tablet_schema_hash": 1394013520, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 19373, "num_rows": 134049, "total_disk_size": 13876789, "data_disk_size": 13876789, "index_disk_size": 1260581280182524, "empty": false, "creation_time": 1785237389, "tablet_uid": { "hi": -3798417420369366593, "lo": -4121215878025162054 }, "num_segments": 1, "rowset_id_v2": "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "newest_write_timestamp": 1785221756, "segments_key_bounds": [ { "min_key": "\u0002\u0000\u0000", "max_key": "\u0002\u0002!" } ], "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": "order_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": 22, "name": "annual_income", "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": 23, "name": "family_income", "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": 24, "name": "marriage_status", "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": 18, "name": "funder_pretrial_no", "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": 2, "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": 3, "name": "relation_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": 4, "name": "relation", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "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": 6, "name": "telephone", "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": 19, "name": "validate_code", "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": 20, "name": "validate_msg", "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": 7, "name": "card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "card_file", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1802, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "nation", "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": "nation_id", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "native_place", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "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": 12, "name": "born_date", "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": "address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "education", "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": "age", "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": 25, "name": "living_address", "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": 26, "name": "living_zone_id_path", "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": 27, "name": "living_zone_name_path", "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": 28, "name": "registered_address", "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": 29, "name": "registered_zone_id_path", "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": 30, "name": "registered_zone_name_path", "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": 31, "name": "id_visa_org", "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": 32, "name": "id_start_date", "type": "DATEV2", "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": 33, "name": "id_end_date", "type": "DATEV2", "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": 34, "name": "contributor_amount", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 35, "name": "contributor_ratio", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "contributor_date", "type": "DATEV2", "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": 16, "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": 17, "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": 37, "is_in_memory": false, "delete_sign_idx": 35, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 0, "compression_type": "LZ4F", "schema_version": 30, "disable_auto_compaction": false, "version_col_idx": 36, "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": 35748459, "tablet_id": 83408144, "tablet_schema_hash": 1394013520, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 19374, "end_version": 20194, "num_rows": 960, "total_disk_size": 226950, "data_disk_size": 226950, "index_disk_size": 7107, "empty": false, "creation_time": 1785891407, "tablet_uid": { "hi": -3798417420369366593, "lo": -4121215878025162054 }, "num_segments": 1, "rowset_id_v2": "02000000002116ef724476bac6948ab1d0f5d0f35eb377b4", "newest_write_timestamp": 1785891406, "segments_key_bounds": [ { "min_key": "\u0002\u0002F", "max_key": "\u0002\u0002" } ], "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": "order_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": 22, "name": "annual_income", "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": 23, "name": "family_income", "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": 24, "name": "marriage_status", "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": 18, "name": "funder_pretrial_no", "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": 2, "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": 3, "name": "relation_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": 4, "name": "relation", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "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": 6, "name": "telephone", "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": 19, "name": "validate_code", "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": 20, "name": "validate_msg", "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": 7, "name": "card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "card_file", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1802, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "nation", "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": "nation_id", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "native_place", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "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": 12, "name": "born_date", "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": "address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "education", "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": "age", "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": 25, "name": "living_address", "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": 26, "name": "living_zone_id_path", "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": 27, "name": "living_zone_name_path", "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": 28, "name": "registered_address", "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": 29, "name": "registered_zone_id_path", "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": 30, "name": "registered_zone_name_path", "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": 31, "name": "id_visa_org", "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": 32, "name": "id_start_date", "type": "DATEV2", "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": 33, "name": "id_end_date", "type": "DATEV2", "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": 34, "name": "contributor_amount", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 35, "name": "contributor_ratio", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "contributor_date", "type": "DATEV2", "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": 16, "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": 17, "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": 37, "is_in_memory": false, "delete_sign_idx": 35, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 0, "compression_type": "LZ4F", "schema_version": 30, "disable_auto_compaction": false, "version_col_idx": 36, "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": 35748459, "tablet_id": 83408144, "tablet_schema_hash": 1394013520, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 20195, "end_version": 20312, "num_rows": 138, "total_disk_size": 44792, "data_disk_size": 44792, "index_disk_size": 1260580177404485, "empty": false, "creation_time": 1785978029, "tablet_uid": { "hi": -3798417420369366593, "lo": -4121215878025162054 }, "num_segments": 1, "rowset_id_v2": "020000000024b125724476bac6948ab1d0f5d0f35eb377b4", "newest_write_timestamp": 1785978016, "segments_key_bounds": [ { "min_key": "\u0002\u0002", "max_key": "\u0002\u0002\\" } ], "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": "order_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": 22, "name": "annual_income", "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": 23, "name": "family_income", "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": 24, "name": "marriage_status", "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": 18, "name": "funder_pretrial_no", "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": 2, "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": 3, "name": "relation_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": 4, "name": "relation", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "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": 6, "name": "telephone", "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": 19, "name": "validate_code", "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": 20, "name": "validate_msg", "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": 7, "name": "card", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 34, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 21, "name": "card_file", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1802, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "nation", "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": "nation_id", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "native_place", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "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": 12, "name": "born_date", "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": "address", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 257, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "education", "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": "age", "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": 25, "name": "living_address", "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": 26, "name": "living_zone_id_path", "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": 27, "name": "living_zone_name_path", "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": 28, "name": "registered_address", "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": 29, "name": "registered_zone_id_path", "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": 30, "name": "registered_zone_name_path", "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": 31, "name": "id_visa_org", "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": 32, "name": "id_start_date", "type": "DATEV2", "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": 33, "name": "id_end_date", "type": "DATEV2", "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": 34, "name": "contributor_amount", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 35, "name": "contributor_ratio", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 36, "name": "contributor_date", "type": "DATEV2", "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": 16, "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": 17, "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": 37, "is_in_memory": false, "delete_sign_idx": 35, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 0, "compression_type": "LZ4F", "schema_version": 30, "disable_auto_compaction": false, "version_col_idx": 36, "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": -3798417420369366593, "lo": -4121215878025162054 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 83408145, "delete_bitmap": { "rowset_ids": [ "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "020000000006a358724476bac6948ab1d0f5d0f35eb377b4", "02000000002116ef724476bac6948ab1d0f5d0f35eb377b4", "02000000002116ef724476bac6948ab1d0f5d0f35eb377b4", "02000000002116ef724476bac6948ab1d0f5d0f35eb377b4" ], "segment_ids": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ], "versions": [ 19375, 19376, 19386, 19414, 19446, 19460, 19465, 19615, 19658, 19772, 20036, 20071, 20200, 20201, 20203 ], "segment_delete_bitmaps": [ ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000K\u000B", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000\u000B", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000\u000B", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000w\u000B", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000W\n", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000?\n", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000\u0006", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000-\n", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000L\u000B", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000\u0018\n", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000\n", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0002\u0000\u0000\u0000\u0010\u0000\u0000\u0000c\u0007", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000\u0003", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000\u0003", ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0010\u0000\u0000\u0000\u0003" ] }, "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 }