Inceptor \u7684\u5143\u6570\u636e\u5e93\u7ba1\u7406<\/a> \u7684 5.x \u4ee5\u4e0a\u7248\u672c\u767b\u5f55Metastore \u7ae0\u8282\u3002<\/h5>\n\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n
$ kubectl get pods |grep txsql\ntxsql-server-txsql1-3619959039-lcp6s 1\/1 Running 4 64d\ntxsql-server-txsql1-3619959039-mdqqs 1\/1 Running 1 53d\ntxsql-server-txsql1-3619959039-sb8zj 1\/1 Running 1 16d\n$ kubectl exec -ti txsql-server-txsql1-3619959039-lcp6s -- \/usr\/bin\/txsql\/tools\/txsql.sh localshell\nWarning: Using a password on the command line interface can be insecure.\nWelcome to the MySQL monitor. Commands end with ; or \\g.\nYour MySQL connection id is 584270\nServer version: 5.6.31-77.0-log Source distribution\n\nCopyright (c) 2009-2016 Percona LLC and\/or its affiliates\nCopyright (c) 2000, 2016, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql> show databases;\n+----------------------------+\n| Database |\n+----------------------------+\n| information_schema ||\n| metastore_inceptor1 |\n| metastore_slipstream1 |\n| mysql |\n| performance_schema |\n| test |\n| tmp_txsql_function_test |\n+----------------------------+\n7 rows in set (0.00 sec)\n\nmysql><\/code><\/pre>\n\u4fee\u6539 metastore_inceptor \u7684 TABLE_PARAMS \u7684\u5b57\u6bb5\u957f\u5ea6<\/h5>\n
\u8be5\u8868\u7684 PARAM_VALUE \u5b57\u6bb5\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u4e3a varchar(4000)\uff0ctdt \u81ea\u52a8\u7ec4\u88c5\u7684 sql \u5e94\u8be5\u662f\u5728\u8fd9\u4e2a\u8303\u56f4\u5185\u7684\uff0c\u6240\u4ee5\u5982\u679c\u5b57\u6bb5\u8fc7\u591a\u65f6\uff0c\u53ef\u4ee5\u8003\u8651\u5c06\u8be5\u5b57\u6bb5\u957f\u5ea6\u6539\u5927\u4e00\u4e9b\uff0c\u6bd4\u5982 varchar(10000)\uff1b
\n\u4fee\u6539 sql \u8bed\u53e5\u4e3a \uff1a<\/p>\n
alter table metastore_inceptor1.TABLE_PARAMS modify column PARAM_VALUE varchar(10000);<\/code><\/pre>\n\u6ce8\u610f\uff1a<\/strong><\/p>\n\u4fee\u6539TABLE_PARAMS<\/code>\u8868PARAM_VALUE\u5b57\u6bb5\u7684\u957f\u5ea6\u65f6\uff0c\u82e5\u4e0d\u6307\u5b9a\u5b57\u6bb5\u7f16\u7801\uff0c\u5219\u8be5\u5b57\u6bb5\u7f16\u7801\u7531utf-8<\/code>\u53d8\u4e3alatin1_bin<\/code> <\/p>\n\u89e3\u51b3\u65b9\u6848\uff1a
\n\u6b63\u786e\u7684\u53d8\u66f4\u8bed\u53e5\u4e3a\uff1aALTER TABLE metastore_inceptor1.TABLE_PARAMS modify column PARAM_VALUE varchar(10002) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL;<\/code> <\/p>\n\u95ee\u9898\u5f71\u54cd\uff1a\u5df2\u4ea7\u751f\u7684\u5f71\u54cd\u65e0\u6cd5\u81ea\u52a8\u6062\u590d\uff0c\u53ea\u80fd\u9010\u8868\u4fee\u6539\u6ce8\u91ca\u3002<\/strong>
\n<\/font><\/p>\n\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n
mysql> describe metastore_inceptor1.TABLE_PARAMS;\n+-------------+----------------+------+-----+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+-------------+----------------+------+-----+---------+-------+\n| TBL_ID | bigint(20) | NO | PRI | NULL | |\n| PARAM_KEY | varchar(256) | NO | PRI | NULL | |\n| PARAM_VALUE | varchar(4000) | YES | | NULL | |\n+-------------+----------------+------+-----+---------+-------+\n3 rows in set (0.00 sec)\n\nmysql> use metastore_inceptor1;\nDatabase changed\nmysql> alter table TABLE_PARAMS modify column PARAM_VALUE varchar(10000); \nQuery OK, 539 rows affected (0.20 sec)\nRecords: 539 Duplicates: 0 Warnings: 0\n\nmysql> describe metastore_inceptor1.TABLE_PARAMS;\n+-------------+----------------+------+-----+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+-------------+----------------+------+-----+---------+-------+\n| TBL_ID | bigint(20) | NO | PRI | NULL | |\n| PARAM_KEY | varchar(256) | NO | PRI | NULL | |\n| PARAM_VALUE | varchar(10000) | YES | | NULL | |\n+-------------+----------------+------+-----+---------+-------+\n3 rows in set (0.00 sec)\n\nmysql> <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u6982\u8981\u63cf\u8ff0 inceptor \u7684\u8868\u5c5e\u6027\u662f\u4ee5\u952e\u503c\u5bf9\u7684\u5f62\u5f0f\u8bb0\u5f55\u5728 txsql \u4e2d\uff0cTDT \u4e2d\u95f4\u5e93\u8868\u4e2d\u4f1a\u6709 mapre ..<\/p>\n
<\/div>\n
Read more<\/a><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1536","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"_links":{"self":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/1536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1536"}],"version-history":[{"count":3,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/1536\/revisions"}],"predecessor-version":[{"id":8861,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/1536\/revisions\/8861"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}