phoenix 查看表主键和字段信息的命令

phoenix | 2019-09-13 10:02:39

1.phoenix查看表主键信息的命令

0: jdbc:phoenix:> !primarykeys SYSTEM.CATALOG

输出结果

+------------+--------------+-------------+----------------+----------+----------+--------------+------------+------------+--------------+----------+----------------+
| TABLE_CAT  | TABLE_SCHEM  | TABLE_NAME  |  COLUMN_NAME   | KEY_SEQ  | PK_NAME  | ASC_OR_DESC  | DATA_TYPE  | TYPE_NAME  | COLUMN_SIZE  | TYPE_ID  | VIEW_CONSTANT  |
+------------+--------------+-------------+----------------+----------+----------+--------------+------------+------------+--------------+----------+----------------+
|            | SYSTEM       | CATALOG     | COLUMN_FAMILY  | 5        | PK       | A            | 12         | VARCHAR    | null         | 12       |                |
|            | SYSTEM       | CATALOG     | COLUMN_NAME    | 4        | PK       | A            | 12         | VARCHAR    | null         | 12       |                |
|            | SYSTEM       | CATALOG     | TABLE_NAME     | 3        | PK       | A            | 12         | VARCHAR    | null         | 12       |                |
|            | SYSTEM       | CATALOG     | TABLE_SCHEM    | 2        | PK       | A            | 12         | VARCHAR    | null         | 12       |                |
|            | SYSTEM       | CATALOG     | TENANT_ID      | 1        | PK       | A            | 12         | VARCHAR    | null         | 12       |                |
+------------+--------------+-------------+----------------+----------+----------+--------------+------------+------------+--------------+----------+----------------+

2.phoenix查看表字段信息的命令

0: jdbc:phoenix:> !desc SYSTEM.CATALOG

输出结果

+------------+--------------+-------------+--------------------------------+------------+-------------------+--------------+----------------+-----------------+-----------------+-----------+----------+--------+
| TABLE_CAT  | TABLE_SCHEM  | TABLE_NAME  |          COLUMN_NAME           | DATA_TYPE  |     TYPE_NAME     | COLUMN_SIZE  | BUFFER_LENGTH  | DECIMAL_DIGITS  | NUM_PREC_RADIX  | NULLABLE  | REMARKS  | COLUMN |
+------------+--------------+-------------+--------------------------------+------------+-------------------+--------------+----------------+-----------------+-----------------+-----------+----------+--------+
|            | SYSTEM       | CATALOG     | TENANT_ID                      | 12         | VARCHAR           | null         | null           | null            | null            | 1         |          |        |
|            | SYSTEM       | CATALOG     | TABLE_SCHEM                    | 12         | VARCHAR           | null         | null           | null            | null            | 1         |          |        |
|            | SYSTEM       | CATALOG     | TABLE_NAME                     | 12         | VARCHAR           | null         | null           | null            | null            | 0         |          |        |
|            | SYSTEM       | CATALOG     | COLUMN_NAME                    | 12         | VARCHAR           | null         | null           | null            | null            | 1         |          |        |
|            | SYSTEM       | CATALOG     | COLUMN_FAMILY                  | 12         | VARCHAR           | null         | null           | null            | null            | 1         |          |        |
|            | SYSTEM       | CATALOG     | TABLE_SEQ_NUM                  | -5         | BIGINT            | null         | null           | null            | null            | 1         |          |        |

3.phoenix查看所有表信息

0: jdbc:phoenix:> !tables

输出结果

+------------+--------------+--------------------------------------------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+--------+
| TABLE_CAT  | TABLE_SCHEM  |                    TABLE_NAME                    |  TABLE_TYPE   | REMARKS  | TYPE_NAME  | SELF_REFERENCING_COL_NAME  | REF_GENERATION  | INDEX_STATE  | IMMUTABLE_ROWS  | SALT_B |
+------------+--------------+--------------------------------------------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+--------+
|            | SYSTEM       | CATALOG                                          | SYSTEM TABLE  |          |            |                            |                 |              | false           | null   |
|            | SYSTEM       | FUNCTION                                         | SYSTEM TABLE  |          |            |                            |                 |              | false           | null   |
|            | SYSTEM       | LOG                                              | SYSTEM TABLE  |          |            |                            |                 |              | true            | 32     |
|            | SYSTEM       | SEQUENCE                                         | SYSTEM TABLE  |          |            |                            |                 |              | false           | null   |
|            | SYSTEM       | STATS                                            | SYSTEM TABLE  |          |            |                            |                 |              | false           | null   |

登录后即可回复登录 | 注册

linux查看cpu信息个数核数 linux du命令查看文件目录大小 spark rdd转dataframe构造字段信息元数据 phoenix 查看表主键和字段信息的命令 jdbc连接phoenix hbase 异常the node /hbase is not in zookeeper phoenix表修改字段数据类型长度 phoenix如何查看表的主键信息 hdfs fsck命令操作查看block文件块信息 mysql 分析空间信息 php 图像生成和处理可交换图像信息 php php 选项/信息函数设置/获取断言的各种标志 php php 选项/信息函数强制收集所有现存的垃圾循环周期 php php 选项/信息函数返回所有编译并加载模块名的 array php php 选项/信息函数从命令行参数列表中获取选项 php gd 和图像处理函数设置标记以在保存 png 图像时保存完整的 alpha 通道信息（与单一透明色相反）php mysql 函数取得 mysql 主机信息 php php 选项/信息函数取得已加载的 php.ini 文件的路径 php snmp 函数查询关于网络实体的信息树 php memcache 获取服务器统计信息 Linux iftop 命令查看服务器网络带宽