show create table  DEV_TMP.RTE_TEMP_2 \G
*************************** 1. row ***************************
       Table: rte_temp_2
Create Table: CREATE TABLE `rte_temp_2` (
  `OC_CARR` char(2) DEFAULT NULL,
  `OC_FLT_NBR` char(4) DEFAULT NULL,
  `RTE_CHG_IND` char(4) DEFAULT NULL,
  `RTE_IND_NEW` int(11) DEFAULT NULL,
  `LEG_SEQ` int(11) DEFAULT NULL,
  `DPT_AIRPT` char(3) DEFAULT NULL,
  `ARRV_AIRPT` char(3) DEFAULT NULL,
  `RECORD_SEQ_1` int(11) DEFAULT NULL,
  `V` varchar(200) DEFAULT NULL,
  KEY `index_name` (`OC_CARR`, `OC_FLT_NBR`, `RTE_IND_NEW`, `LEG_SEQ`) BLOCK_SIZE 16384 LOCAL
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
 partition by key(oc_carr,oc_flt_nbr)
(partition p0,
partition p1,
partition p2,
partition p3,
partition p4,
partition p5,
partition p6,
partition p7,
partition p8,
partition p9,
partition p10,
partition p11,
partition p12,
partition p13,
partition p14,
partition p15,
partition p16,
partition p17,
partition p18,
partition p19,
partition p20,
partition p21,
partition p22,
partition p23,
partition p24,
partition p25,
partition p26,
partition p27,
partition p28,
partition p29,
partition p30,
partition p31,
partition p32,
partition p33,
partition p34,
partition p35,
partition p36,
partition p37,
partition p38,
partition p39,
partition p40,
partition p41,
partition p42,
partition p43,
partition p44,
partition p45,
partition p46,
partition p47,
partition p48,
partition p49,
partition p50,
partition p51,
partition p52,
partition p53,
partition p54,
partition p55,
partition p56,
partition p57,
partition p58,
partition p59,
partition p60,
partition p61,
partition p62,
partition p63,
partition p64,
partition p65,
partition p66,
partition p67,
partition p68,
partition p69,
partition p70,
partition p71,
partition p72,
partition p73,
partition p74,
partition p75,
partition p76,
partition p77,
partition p78,
partition p79,
partition p80,
partition p81,
partition p82,
partition p83,
partition p84,
partition p85,
partition p86,
partition p87,
partition p88,
partition p89,
partition p90,
partition p91,
partition p92,
partition p93,
partition p94,
partition p95,
partition p96,
partition p97,
partition p98,
partition p99,
partition p100,
partition p101,
partition p102,
partition p103,
partition p104,
partition p105,
partition p106,
partition p107,
partition p108,
partition p109,
partition p110,
partition p111,
partition p112,
partition p113,
partition p114,
partition p115,
partition p116,
partition p117,
partition p118,
partition p119,
partition p120,
partition p121,
partition p122,
partition p123,
partition p124,
partition p125,
partition p126,
partition p127,
partition p128,
partition p129,
partition p130,
partition p131,
partition p132,
partition p133,
partition p134,
partition p135,
partition p136,
partition p137,
partition p138,
partition p139,
partition p140,
partition p141,
partition p142,
partition p143,
partition p144,
partition p145,
partition p146,
partition p147,
partition p148,
partition p149,
partition p150,
partition p151,
partition p152,
partition p153,
partition p154,
partition p155,
partition p156,
partition p157,
partition p158,
partition p159,
partition p160,
partition p161,
partition p162,
partition p163,
partition p164,
partition p165,
partition p166,
partition p167,
partition p168,
partition p169,
partition p170,
partition p171,
partition p172,
partition p173,
partition p174,
partition p175,
partition p176,
partition p177,
partition p178,
partition p179,
partition p180,
partition p181,
partition p182,
partition p183,
partition p184,
partition p185,
partition p186,
partition p187,
partition p188,
partition p189,
partition p190,
partition p191,
partition p192,
partition p193,
partition p194,
partition p195,
partition p196,
partition p197,
partition p198,
partition p199,
partition p200,
partition p201,
partition p202,
partition p203,
partition p204,
partition p205,
partition p206,
partition p207,
partition p208,
partition p209,
partition p210,
partition p211,
partition p212,
partition p213,
partition p214,
partition p215,
partition p216,
partition p217,
partition p218,
partition p219,
partition p220,
partition p221,
partition p222,
partition p223,
partition p224,
partition p225,
partition p226,
partition p227,
partition p228,
partition p229,
partition p230,
partition p231,
partition p232,
partition p233,
partition p234,
partition p235,
partition p236,
partition p237,
partition p238,
partition p239,
partition p240,
partition p241,
partition p242,
partition p243,
partition p244,
partition p245,
partition p246,
partition p247,
partition p248,
partition p249,
partition p250,
partition p251,
partition p252,
partition p253,
partition p254,
partition p255,
partition p256,
partition p257,
partition p258,
partition p259,
partition p260,
partition p261,
partition p262,
partition p263,
partition p264,
partition p265,
partition p266,
partition p267,
partition p268,
partition p269,
partition p270,
partition p271,
partition p272,
partition p273,
partition p274,
partition p275,
partition p276,
partition p277,
partition p278,
partition p279,
partition p280,
partition p281,
partition p282,
partition p283,
partition p284,
partition p285,
partition p286,
partition p287,
partition p288,
partition p289,
partition p290,
partition p291,
partition p292,
partition p293,
partition p294,
partition p295,
partition p296,
partition p297,
partition p298,
partition p299,
partition p300,
partition p301,
partition p302,
partition p303,
partition p304,
partition p305,
partition p306,
partition p307,
partition p308,
partition p309,
partition p310,
partition p311,
partition p312,
partition p313,
partition p314,
partition p315,
partition p316,
partition p317,
partition p318,
partition p319,
partition p320,
partition p321,
partition p322,
partition p323,
partition p324,
partition p325,
partition p326,
partition p327,
partition p328,
partition p329,
partition p330,
partition p331,
partition p332,
partition p333,
partition p334,
partition p335,
partition p336,
partition p337,
partition p338,
partition p339,
partition p340,
partition p341,
partition p342,
partition p343,
partition p344,
partition p345,
partition p346,
partition p347,
partition p348,
partition p349,
partition p350,
partition p351,
partition p352,
partition p353,
partition p354,
partition p355,
partition p356,
partition p357,
partition p358,
partition p359,
partition p360,
partition p361,
partition p362,
partition p363,
partition p364,
partition p365,
partition p366,
partition p367,
partition p368,
partition p369,
partition p370,
partition p371,
partition p372,
partition p373,
partition p374,
partition p375,
partition p376,
partition p377,
partition p378,
partition p379,
partition p380,
partition p381,
partition p382,
partition p383,
partition p384,
partition p385,
partition p386,
partition p387,
partition p388,
partition p389,
partition p390,
partition p391,
partition p392,
partition p393,
partition p394,
partition p395,
partition p396,
partition p397,
partition p398,
partition p399,
partition p400,
partition p401,
partition p402,
partition p403,
partition p404,
partition p405,
partition p406,
partition p407,
partition p408,
partition p409,
partition p410,
partition p411,
partition p412,
partition p413,
partition p414,
partition p415,
partition p416,
partition p417,
partition p418,
partition p419,
partition p420,
partition p421,
partition p422,
partition p423,
partition p424,
partition p425,
partition p426,
partition p427,
partition p428,
partition p429,
partition p430,
partition p431,
partition p432,
partition p433,
partition p434,
partition p435,
partition p436,
partition p437,
partition p438,
partition p439,
partition p440,
partition p441,
partition p442,
partition p443,
partition p444,
partition p445,
partition p446,
partition p447,
partition p448,
partition p449,
partition p450,
partition p451,
partition p452,
partition p453,
partition p454,
partition p455,
partition p456,
partition p457,
partition p458,
partition p459,
partition p460,
partition p461,
partition p462,
partition p463,
partition p464,
partition p465,
partition p466,
partition p467,
partition p468,
partition p469,
partition p470,
partition p471,
partition p472,
partition p473,
partition p474,
partition p475,
partition p476,
partition p477,
partition p478,
partition p479)
1 row in set (0.06 sec)


+------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+-----------+---------------+---------+------------+
| Table      | Non_unique | Key_name   | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment   | Index_comment | Visible | Expression |
+------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+-----------+---------------+---------+------------+
| rte_temp_2 |          1 | index_name |            1 | OC_CARR     | A         |        NULL | NULL     | NULL   | YES  | BTREE      | available |               | YES     | NULL       |
| rte_temp_2 |          1 | index_name |            2 | OC_FLT_NBR  | A         |        NULL | NULL     | NULL   | YES  | BTREE      | available |               | YES     | NULL       |
| rte_temp_2 |          1 | index_name |            3 | RTE_IND_NEW | A         |        NULL | NULL     | NULL   | YES  | BTREE      | available |               | YES     | NULL       |
| rte_temp_2 |          1 | index_name |            4 | LEG_SEQ     | A         |        NULL | NULL     | NULL   | YES  | BTREE      | available |               | YES     | NULL       |
+------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+-----------+---------------+---------+------------+