SELECT START_KEY, TIDB_DECODE_KEY(START_KEY),t.PARTITION_ID FROM information_schema.tikv_region_status t WHERE table_name=‘XXX’
and t.DB_NAME=‘XXXX’
and t.IS_INDEX=0
and t.IS_PARTITION=1
你可以用这个语句看看分区表和普通表的key构成
SELECT START_KEY, TIDB_DECODE_KEY(START_KEY),t.PARTITION_ID FROM information_schema.tikv_region_status t WHERE table_name=‘XXX’
and t.DB_NAME=‘XXXX’
and t.IS_INDEX=0
and t.IS_PARTITION=1
你可以用这个语句看看分区表和普通表的key构成