EXPORT SCHEMA¶
EXPORT SCHEMA命令返回当前服务组中所有 Schema 的资源对象以及定义资源对象的语句。
EXPORT SCHEMA <schema_reference>命令返回特定 Schema 的资源对象以及定义资源对象的语句。
下表展示了上述命令返回的信息：
| 列 | 描述 |
|---|---|
entity |
构成 Schema 的资源对象，可以是图、图类型或索引。 |
statement |
定义资源对象的语句。 |
前提条件¶
若要执行EXPORT SCHEMA命令，您必须是拥有角色ADMIN的用户。
语法¶
- export_schemas_command
- export_schema_command
export_schemas_command ::=
'EXPORT' 'SCHEMA'
export_schema_command ::=
'EXPORT' 'SCHEMA' schema_reference
参数¶
schema_reference¶
所引用的 Schema 路径。此处即待导出 Schema 的路径。
路径区分大小写，必须与现有的 Schema 路径匹配。绝对路径或相对路径均可在命令中使用。
示例¶
导出所有 SCHEMA¶
EXPORT SCHEMA
返回：
+-----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| entity | statement |
+-----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GraphType | CREATE GRAPH TYPE IF NOT EXISTS `movie_type` AS {\n NODE TYPE `Actor` (LABEL `Person`{`id` INT64 NOT NULL, `name` STRING DEFAULT NULL, `birthDate` DATE DEFAULT NULL, PRIMARY KEY (`id`)}),\n NODE TYPE `Director` (LABEL `Person`{`id` INT64 NOT NULL, `name` STRING DEFAULT NULL, `birthDate` DATE DEFAULT NULL, PRIMARY KEY (`id`)}),\n NODE TYPE `User` (LABEL `Person`{`id` INT64 NOT NULL, PRIMARY KEY (`id`)}),\n NODE TYPE `Movie` (LABEL `Movie`{`id` INT64 NOT NULL, `name` STRING DEFAULT NULL, PRIMARY KEY (`id`)}),\n NODE TYPE `Genre` (LABEL `Genre`{`id` INT64 NOT NULL, `name` STRING DEFAULT NULL, PRIMARY KEY (`id`)}),\n EDGE TYPE `Act` (`Actor`)-[LABEL `Act`{}]->(`Movie`),\n EDGE TYPE `Direct` (`Director`)-[LABEL `Direct`{}]->(`Movie`),\n EDGE TYPE `Watch` (`User`)-[LABEL `Watch`{`rate` FLOAT DEFAULT NULL}]->(`Movie`),\n EDGE TYPE `WithGenre` (`Movie`)-[LABEL `WithGenre`{}]->(`Genre`)\n} |
| Graph | CREATE GRAPH IF NOT EXISTS `movie` TYPED `movie_type` |
| NodeIndex | CREATE INDEX IF NOT EXISTS `idx_actor_age` FOR `movie` ON NODE `Actor`(birthDate) |
| GraphType | CREATE GRAPH TYPE IF NOT EXISTS `export_type` AS {\n NODE TYPE `player` (LABEL `player`{`id` INT64 NOT NULL, `age` INT64 DEFAULT NULL, `v1` VECTOR<3, FLOAT> DEFAULT NULL, PRIMARY KEY (`id`)}),\n EDGE TYPE `follow` (`player`)-[LABEL `follow`{`s1` STRING DEFAULT NULL, `v2` VECTOR<3, FLOAT> DEFAULT NULL}]->(`player`)\n} |
| Graph | CREATE GRAPH IF NOT EXISTS `export_test` TYPED `export_type` |
| NodeIndex | CREATE INDEX IF NOT EXISTS `i_player_age` FOR `export_test` ON NODE `player`(age) |
| EdgeIndex | CREATE INDEX IF NOT EXISTS `i_follow_s1` ON EDGE `follow`(s1) FOR `export_test` |
| NodeVectorIndex | CREATE VECTOR INDEX IF NOT EXISTS `i_ann_player_v1` FOR `export_test` ON NODE `player`::v1 OPTIONS {dim: 3, type: IVF, metric: L2} |
| EdgeVectorIndex | CREATE VECTOR INDEX IF NOT EXISTS `i_ann_follow_v2` FOR `export_test` ON EDGE `follow`::v2 OPTIONS {dim: 3, type: IVF, metric: L2} |
+-----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
导出特定 SCHEMA¶
EXPORT SCHEMA /default_schema
返回：
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| entity | statement |
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GraphType | CREATE GRAPH TYPE IF NOT EXISTS `movie_type` AS {\n NODE TYPE `Actor` (LABEL `Person`{`id` INT64 NOT NULL, `name` STRING DEFAULT NULL, `birthDate` DATE DEFAULT NULL, PRIMARY KEY (`id`)}),\n NODE TYPE `Director` (LABEL `Person`{`id` INT64 NOT NULL, `name` STRING DEFAULT NULL, `birthDate` DATE DEFAULT NULL, PRIMARY KEY (`id`)}),\n NODE TYPE `User` (LABEL `Person`{`id` INT64 NOT NULL, PRIMARY KEY (`id`)}),\n NODE TYPE `Movie` (LABEL `Movie`{`id` INT64 NOT NULL, `name` STRING DEFAULT NULL, PRIMARY KEY (`id`)}),\n NODE TYPE `Genre` (LABEL `Genre`{`id` INT64 NOT NULL, `name` STRING DEFAULT NULL, PRIMARY KEY (`id`)}),\n EDGE TYPE `Act` (`Actor`)-[LABEL `Act`{}]->(`Movie`),\n EDGE TYPE `Direct` (`Director`)-[LABEL `Direct`{}]->(`Movie`),\n EDGE TYPE `Watch` (`User`)-[LABEL `Watch`{`rate` FLOAT DEFAULT NULL}]->(`Movie`),\n EDGE TYPE `WithGenre` (`Movie`)-[LABEL `WithGenre`{}]->(`Genre`)\n} |
| Graph | CREATE GRAPH IF NOT EXISTS `movie` TYPED `movie_type` |
| NodeIndex | CREATE INDEX IF NOT EXISTS `idx_actor_age` FOR `movie` ON NODE `Actor`(birthDate) |
+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+