GBase 8a MPP基础 查询8a集群的系统变量值

Server：CentOS Linux release 7.3.1611 (Core) （3.10.0-514.el7.x86_64）
GBase8a MPP Cluster：9.5.2.39-redhat7.3-x86_64
GBaseDataStudio：9.5.1.0_build2_Windows_x86_64

查看包含 ‘char’ 的系统变量

show variables like '%char%';

Variable_name                                    |Value                                      |
-------------------------------------------------|-------------------------------------------|
_t_kafka_varchar_auto_truncate                   |0                                          |
character_set_client                             |utf8                                       |
character_set_connection                         |utf8                                       |
character_set_database                           |utf8                                       |
character_set_filesystem                         |binary                                     |
character_set_results                            |utf8                                       |
character_set_server                             |utf8                                       |
character_set_sort                               |binary                                     |
character_set_system                             |utf8mb4                                    |
character_sets_dir                               |/opt/gcluster/server/share/gbase/charsets/ |
gbase_loader_charset_convert                     |2                                          |
gbase_loader_check_charset                       |OFF                                        |
gcluster_kafka_consumer_output_charset_name      |                                           |
gcluster_kafka_consumer_special_use_charset_name |                                           |

select
	*
from
	information_schema.global_variables
where
	variable_name like '%char%';

VARIABLE_NAME                                    |VARIABLE_VALUE                             |SESSION_LEVEL |WRITEABLE |
-------------------------------------------------|-------------------------------------------|--------------|----------|
CHARACTER_SET_SERVER                             |utf8                                       |1             |1         |
CHARACTER_SETS_DIR                               |/opt/gcluster/server/share/gbase/charsets/ |0             |0         |
CHARACTER_SET_CONNECTION                         |utf8                                       |1             |1         |
GBASE_LOADER_CHARSET_CONVERT                     |2                                          |1             |1         |
CHARACTER_SET_RESULTS                            |utf8                                       |1             |1         |
CHARACTER_SET_CLIENT                             |utf8                                       |1             |1         |
CHARACTER_SET_SORT                               |binary                                     |1             |1         |
GCLUSTER_KAFKA_CONSUMER_OUTPUT_CHARSET_NAME      |                                           |1             |1         |
GCLUSTER_KAFKA_CONSUMER_SPECIAL_USE_CHARSET_NAME |                                           |1             |1         |
_T_KAFKA_VARCHAR_AUTO_TRUNCATE                   |0                                          |1             |1         |
GBASE_LOADER_CHECK_CHARSET                       |OFF                                        |1             |1         |
CHARACTER_SET_SYSTEM                             |utf8mb4                                    |0             |0         |
CHARACTER_SET_FILESYSTEM                         |binary                                     |1             |1         |
CHARACTER_SET_DATABASE                           |utf8                                       |1             |1         |

相关链接

• GBase培训中心
• 墨天轮社区

欢迎各位同学一起来交流学习心得！