GBase 8a MPP 常用信息查看命令

select version();

/*查看集群版本*/

select vc();

/*查看当前所在vc*/

select database();

/*查看当前所在数据库*/

select user();

/*查看当前所登用户*/

select dbName,tbName,isReplicate,hash_column from gbase.table_distribution where dbname='dbname' and tbname like 'tbname';

/*查看表类型以及hash分布键*/

select * from information_schema.tables where TABLE_SCHEMA ='test';

/*查看当前集群中test数据库中所有表信息*/

select * from information_schema.tables where TABLE_TYPE like 'VIEW';

/*查看当前集群中所有的视图信息*/

select TB_NAME,IP,ELAPSED_TIME,AVG_SPEED,PROGRESS,SKIPPED_RECORDS from information_schema.load_status order by tb_name;

/*查看加载进度*/

select table_schema,table_name,table_data_size,table_storage_size from information_schema.cluster_tables where table_schema='test' and table_name='test';

/*查看表大小*/

select column_name,table_name,column_type from information_schema.columns;

/*查看列属性*/

select dbName,tbName,isReplicate,hash_column from gbase.table_distribution where dbName = 'usr_sod' and hash_column is null;

/*查看某表的hash分布键*/