{ "table_id": 7939123, "partition_id": 7939347, "tablet_id": 7939348, "schema_hash": 2047311125, "shard_id": 335, "creation_time": 1729827623, "cumulative_layer_point": -1, "tablet_state": "PB_RUNNING", "schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "goal_date", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "business_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "zone_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": 3, "name": "goal_type", "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": 4, "name": "id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "business_type", "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": "business_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 12, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "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": 8, "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": 9, "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": 10, "is_in_memory": false, "delete_sign_idx": 8, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "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": 7939347, "tablet_id": 7939348, "tablet_schema_hash": 2047311125, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 0, "end_version": 1, "num_rows": 0, "total_disk_size": 0, "data_disk_size": 0, "index_disk_size": 0, "empty": true, "creation_time": 1729827623, "tablet_uid": { "hi": 7226756504605734062, "lo": -4641766442727882335 }, "num_segments": 0, "rowset_id_v2": "020000000031536f5448a97d7196ae0164825bca959a4598", "newest_write_timestamp": 1729827623, "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "goal_date", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "business_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "zone_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": 3, "name": "goal_type", "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": 4, "name": "id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "business_type", "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": "business_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 12, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "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": 8, "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": 9, "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": 10, "is_in_memory": false, "delete_sign_idx": 8, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "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": "OVERLAP_UNKNOWN" }, { "rowset_id": 0, "partition_id": 7939347, "tablet_id": 7939348, "txn_id": 2436568, "tablet_schema_hash": 2047311125, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 2, "end_version": 2, "num_rows": 26433, "total_disk_size": 174546, "data_disk_size": 174546, "index_disk_size": 71059, "empty": false, "load_id": { "hi": -2862066266043207508, "lo": -3234186439500689221 }, "creation_time": 1729827643, "tablet_uid": { "hi": 7226756504605734062, "lo": -4641766442727882335 }, "num_segments": 1, "rowset_id_v2": "02000000003153855448a97d7196ae0164825bca959a4598", "newest_write_timestamp": 1729827643, "segments_key_bounds": [ { "min_key": "\u000220230201000000\u00025\u0002\u0000\u0000\u0002\u0002\u0000\u0000\u0001", "max_key": "\u000220241001000000\u0002cpic\u0002\u0000\b\u0002\u0000\u0000\u0001" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "goal_date", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "business_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "zone_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": 3, "name": "goal_type", "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": 4, "name": "id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "business_type", "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": "business_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 12, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "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": 8, "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": 9, "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": 10, "is_in_memory": false, "delete_sign_idx": 8, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": 9, "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": 7939347, "tablet_id": 7939348, "tablet_schema_hash": 2047311125, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 3, "end_version": 76, "num_rows": 4100, "total_disk_size": 36094, "data_disk_size": 36094, "index_disk_size": 419980963780965, "empty": false, "creation_time": 1732903286, "tablet_uid": { "hi": 7226756504605734062, "lo": -4641766442727882335 }, "num_segments": 1, "rowset_id_v2": "020000000039d3555448a97d7196ae0164825bca959a4598", "newest_write_timestamp": 1732903207, "segments_key_bounds": [ { "min_key": "\u000220240901000000\u00025\u0002\u0000\u0000\u0002\u0002\u0000\u0000\u0001", "max_key": "\u000220241101000000\u0002cpic\u0002\u0000\u000F\u0002\u0000\u0000\u0001" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "goal_date", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 22, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 1, "name": "business_id", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 13, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "zone_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": 3, "name": "goal_type", "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": 4, "name": "id", "type": "INT", "is_key": false, "aggregation": "NONE", "is_nullable": false, "precision": 0, "frac": 0, "length": 4, "index_length": 4, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "business_type", "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": "business_money", "type": "DECIMAL64", "is_key": false, "aggregation": "NONE", "is_nullable": true, "precision": 12, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "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": 8, "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": 9, "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": 10, "is_in_memory": false, "delete_sign_idx": 8, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 4, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": 9, "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": 7226756504605734062, "lo": -4641766442727882335 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 7939349, "delete_bitmap": { "rowset_ids": [ "02000000003153855448a97d7196ae0164825bca959a4598" ], "segment_ids": [ 0 ], "versions": [ 12 ], "segment_delete_bitmaps": [ ":0\u0000\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0003\u0010\u0000\u0000\u0000cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc\u0000d\u0001d\u0002d\u0003d\u0004d\u0005d\u0006d\u0007d\bd\td\nd\u000Bd\fd\rd\u000Ed\u000Fd\u0010d\u0011d\u0012d\u0013d\u0014d\u0015d\u0016d\u0017d\u0018d\u0019d\u001Ad\u001Bd\u001Cd\u001Dd\u001Ed\u001Fd d!d\"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;dd?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\\d]d^d_d`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|d}d~dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd\u0000e\u0001e\u0002e\u0003e\u0004e\u0005e\u0006e\u0007e\be\te\ne\u000Be\fe\re\u000Ee\u000Fe\u0010e\u0011e\u0012e\u0013e\u0014e\u0015e\u0016e\u0017e\u0018e\u0019e\u001Ae\u001Be\u001Ce\u001De\u001Ee\u001Fe e!e\"e#e$e%e&e'e(e)e*e+e,e-e.e/e0e1e2e3e4e5e6e7e8e9e:e;ee?e@eAeBeCeDeEeFeGeHeIeJeKeLeMeNeOePeQeReSeTeUeVeWeXeYeZe[e\\e]e^e_e`eaebecedeeefegeheiejekelemeneoepeqereseteuevewexeyeze{e|e}e~eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee\u0000f\u0001f\u0002f\u0003f\u0004f\u0005f\u0006f\u0007f\bf\tf\nf\u000Bf\ff\rf\u000Ef\u000Ff\u0010f\u0011f\u0012f\u0013f\u0014f\u0015f\u0016f\u0017f\u0018f\u0019f\u001Af\u001Bf\u001Cf\u001Df\u001Ef\u001Ff f!f\"f#f$f%f&f'f(f)f*f+f,f-f.f/f0f1f2f3f4f5f6f7f8f9f:f;ff?f@fAfBfCfDfEfFfGfHfIfJfKfLfMfNfOfPfQfRfSfTfUfVfWfXfYfZf[f\\f]f^f_f`fafbfcfdfefffgfhfifjfkflfmfnfofpfqfrfsftfufvfwfxfyfzf{f|f}f~ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff\u0000g\u0001g\u0002g\u0003g\u0004g\u0005g\u0006g\u0007g\bg\tg\ng\u000Bg\fg\rg\u000Eg\u000Fg\u0010g\u0011g\u0012g\u0013g\u0014g\u0015g\u0016g\u0017g\u0018g\u0019g\u001Ag\u001Bg\u001Cg\u001Dg\u001Eg\u001Fg g!g\"g#g$g%g&g'g(g)g*g+g,g-g.g/g0g1g2g3g4g5g6g7g8g9g:g;gg?g@g" ] }, "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 }