{ "table_id": 65006978, "partition_id": 69396997, "tablet_id": 69397013, "schema_hash": 24451824, "shard_id": 170, "creation_time": 1774505240, "cumulative_layer_point": -1, "tablet_state": "PB_RUNNING", "schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "BIGINT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "product_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "unit", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "value", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "param_code", "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": "source_type", "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": 8, "name": "clean_task_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "etl_batch_no", "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": 10, "name": "is_deleted", "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": 11, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "update_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "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": 14, "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": 15, "is_in_memory": false, "delete_sign_idx": 13, "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": 69396997, "tablet_id": 69397013, "txn_id": 16372284, "tablet_schema_hash": 24451824, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 67050, "end_version": 67050, "num_rows": 44, "total_disk_size": 8351, "data_disk_size": 8351, "index_disk_size": 1365, "empty": false, "load_id": { "hi": 1317772930147755580, "lo": 552632796199527318 }, "creation_time": 1778013324, "tablet_uid": { "hi": 6864009960539617564, "lo": -4789850467424342349 }, "num_segments": 1, "rowset_id_v2": "0200000000d7b95a3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1778013324, "segments_key_bounds": [ { "min_key": "\u0002„NOð;\u0003`\n", "max_key": "\u0002„NOð[ƒ`0" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "BIGINT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "product_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "unit", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "value", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "param_code", "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": 7, "name": "source_type", "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": 8, "name": "clean_task_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "etl_batch_no", "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": 10, "name": "is_deleted", "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": 11, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "update_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "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": 14, "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": 15, "is_in_memory": false, "delete_sign_idx": 13, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 1, "compression_type": "LZ4F", "schema_version": 4, "disable_auto_compaction": false, "version_col_idx": 14, "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": 69396997, "tablet_id": 69397013, "tablet_schema_hash": 24451824, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 67049, "num_rows": 3727438, "total_disk_size": 84522288, "data_disk_size": 84522288, "index_disk_size": 4886264052299292, "empty": false, "creation_time": 1778103804, "tablet_uid": { "hi": 6864009960539617564, "lo": -4789850467424342349 }, "num_segments": 1, "rowset_id_v2": "0200000000d9efff3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1778013323, "segments_key_bounds": [ { "min_key": "\u0002„\u001A\u0019Snƒ`\u000E", "max_key": "\u0002„NOá·ƒ`\u0007" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "id", "type": "BIGINT", "is_key": true, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "province_name", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 66, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "product_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 3, "name": "item", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "unit", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "value", "type": "VARCHAR", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 1002, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "param_code", "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": 7, "name": "source_type", "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": 8, "name": "clean_task_id", "type": "BIGINT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "etl_batch_no", "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": 10, "name": "is_deleted", "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": 11, "name": "create_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 12, "name": "update_time", "type": "DATETIMEV2", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 18, "frac": 0, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "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": 14, "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": 15, "is_in_memory": false, "delete_sign_idx": 13, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 1, "compression_type": "LZ4F", "schema_version": 4, "disable_auto_compaction": false, "version_col_idx": 14, "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": 6864009960539617564, "lo": -4789850467424342349 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 69397015, "delete_bitmap": {}, "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 }