GBase8a mpp如何查看表的tableid_方式三
通过metadump查看:
元数据合并前版本查看方式metadump table.desc.A/B, 元数据合并后的版本查看方式metadumptable.info.A/B,其中的t_num就是tableid
元数据合并前版本:
[gbase@localhost t1.GED]$ metadump table.des.B
This tool is designed for use at GBase internally,and is unsupported externally.
GBase makes no claims and holds no liability regarding the external use of this tool.
This tool is copyrighted and his redistribution is restricted.
table.des.B
+----------------------+-----------------+
| storage_version | GEHV6 |
| encrypt | 0 |
| shrinked_rowid | 0 |
| no_attr | 1 |
| attr_nums[0] | 0 |
| no_attr_cnt | 1 |
| no_attr[0] | 1 |
| t_name | t1 |
| t_desc::false | |
| offset | 46 |
| length | 10 |
| block type | 1 |
| next | 0 |
| t_num | 2053 |
| limit_storage_size | 0 |
| storage_size | 0 |
| scn | 131083 |
| compress_flag_num | 4294967295 |
| compress_flag_str | 4294967295 |
| extend_size | 0 |
| autoextend_flag | 0 |
| tab_data_size | 0 |
| durability | 0 |
+----------------------+-----------------+
元数据合并后版本:
[gbase@node34 t1.GED]$ metadump table.info.B
This tool is designed for use at GBase internally,and is unsupported externally.
GBase makes no claims and holds no liability regarding the external use of this tool.
This tool is copyrighted and his redistribution is restricted.
table.info.B
----------------------------state------------------------
+-------------------------------------+-----------------+
| version | 8 |
| checksum | 3585941699 |
| table_last_operation | DDL |
| ctl_version | B |
| map_version | A |
| delete_version | B |
+-------------------------------------+-----------------+
----------------------------des--------------------------
+----------------------+-----------------+
| storage_version | GEHV8 |
| checksum | 2647270172 |
| t_num | 5 |
| tablespace_id | 0 |
| no_attr | 3 |
| no_attr_cnt | 3 |
| encrypt | 0 |
| compress_flag_num | 4294967295 |
| compress_flag_str | 4294967295 |
| limit_storage_size | 0 |
| autoextend_flag | 0 |
| extend_size | 0 |
| shrinked_rowid | 0 |
| tab_data_size | 0 |
| storage_size | 0 |
| scn | 9 |
+----------------------+-----------------+
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25044
- 42023-09-25浏览数:18519
- 52020-05-11浏览数:17526