{ "table_id": 30924582, "partition_id": 82706962, "tablet_id": 82706963, "schema_hash": 1916205221, "shard_id": 373, "creation_time": 1781991438, "cumulative_layer_point": -1, "tablet_state": "PB_RUNNING", "schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "out_date", "type": "DATEV2", "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": "loan_repayment_model", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "loan_installment_number", "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": "service_user_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "channel_user_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "funder_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "funder_rate", "type": "DECIMAL64", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "dealer_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "dealer_zone_province", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "dealer_zone_city", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "dealer_zone_region", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "machine_factory_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": 12, "name": "machine_factory_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "machine_device_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "order_count", "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": "device_count", "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": 16, "name": "loan_money", "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": 17, "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": 18, "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": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 19, "is_in_memory": false, "delete_sign_idx": 17, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 14, "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": 82706962, "tablet_id": 82706963, "tablet_schema_hash": 1916205221, "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": 1781991438, "tablet_uid": { "hi": 1604971955061186893, "lo": -7610920205601572944 }, "num_segments": 0, "rowset_id_v2": "02000000015adbb23e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1781991438, "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "out_date", "type": "DATEV2", "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": "loan_repayment_model", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "loan_installment_number", "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": "service_user_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "channel_user_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "funder_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "funder_rate", "type": "DECIMAL64", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "dealer_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "dealer_zone_province", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "dealer_zone_city", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "dealer_zone_region", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "machine_factory_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": 12, "name": "machine_factory_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "machine_device_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "order_count", "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": "device_count", "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": 16, "name": "loan_money", "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": 17, "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": 18, "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": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 19, "is_in_memory": false, "delete_sign_idx": 17, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 14, "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": 82706962, "tablet_id": 82706963, "tablet_schema_hash": 1916205221, "rowset_type": "BETA_ROWSET", "rowset_state": "VISIBLE", "start_version": 2, "end_version": 82, "num_rows": 31458, "total_disk_size": 1312130, "data_disk_size": 1312130, "index_disk_size": 279623910810566, "empty": false, "creation_time": 1782063026, "tablet_uid": { "hi": 1604971955061186893, "lo": -7610920205601572944 }, "num_segments": 1, "rowset_id_v2": "02000000015bd95e3e4f039611b6885945b9c09748d2b3ba", "newest_write_timestamp": 1782063015, "segments_key_bounds": [ { "min_key": "\u0002\u0000\u000F\u000F\u00023+3\u0002\u0000\u0000\u0006\u0002杨怡\u0002刘佳玲\u0002小雨点\u0002\u0000\u0000\u0000\u0000\u0000\u0005x\u0002常德市金诺农机销售有限公司\u0002湖南省\u0002常德市\u0002南方大区\u0002\u0000\u0000|\u0002江苏沃得\u0002水稻收", "max_key": "\u0002\u0000\u000F\u00026+6+6+6\u0002\u0000\u0000\u0018\u0002马冬\u0001\u0002兴邦金租\u0002\u0000\u0000\u0000\u0000\u0000\u0003\u0002礼县应学农机经销有限责任公司\u0002甘肃省\u0002陇南市\u0002中部大区\u0002\u0000\u0000\u0002丰收芬美得\u0002拖拉机" } ], "tablet_schema": { "keys_type": "UNIQUE_KEYS", "column": [ { "unique_id": 0, "name": "out_date", "type": "DATEV2", "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": "loan_repayment_model", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 2, "name": "loan_installment_number", "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": "service_user_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 4, "name": "channel_user_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 5, "name": "funder_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 6, "name": "funder_rate", "type": "DECIMAL64", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 10, "frac": 2, "length": 8, "index_length": 8, "visible": true, "result_is_nullable": false }, { "unique_id": 7, "name": "dealer_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 8, "name": "dealer_zone_province", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 9, "name": "dealer_zone_city", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 10, "name": "dealer_zone_region", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 11, "name": "machine_factory_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": 12, "name": "machine_factory_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 13, "name": "machine_device_name", "type": "VARCHAR", "is_key": true, "aggregation": "NONE", "is_nullable": true, "precision": 0, "frac": 0, "length": 202, "index_length": 20, "visible": true, "result_is_nullable": false }, { "unique_id": 14, "name": "order_count", "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": "device_count", "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": 16, "name": "loan_money", "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": 17, "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": 18, "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": 2, "num_rows_per_row_block": 1024, "compress_kind": "COMPRESS_LZ4", "next_column_unique_id": 19, "is_in_memory": false, "delete_sign_idx": 17, "sequence_col_idx": -1, "sort_type": "LEXICAL", "sort_col_num": 14, "compression_type": "LZ4F", "schema_version": 0, "disable_auto_compaction": false, "version_col_idx": 18, "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": 1604971955061186893, "lo": -7610920205601572944 }, "preferred_rowset_type": "BETA_ROWSET", "tablet_type": "TABLET_TYPE_DISK", "replica_id": 82706964, "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 }