用户在执行Match语句之前需要通过Use Graph语句指定当前查询的图。
USE GRAPH Identifier
-- Set current using graph. USE GRAPH modern; INSERT INTO tbl_result SELECT a.id, b.id, c.id, c.kind, d.id, d.type FROM ( MATCH (a) -> (b) where b.id > 0 and a.lang is null MATCH (a) <- (c) where label(c) = 'person' Let c.kind = 'k' || cast(c.age / 10 as varchar) MATCH (c) -> (d) where d != b Let d.type = if (label(d) = 'person', 1, 0) RETURN a, b, c, d ) ;
Instance类似于Hive/Mysql中的Database的概念。我们可以通过Use Instance命令指定当前语句的实例。
USE INSTANCE Identifier
Use instance geaflow; USE GRAPH modern; INSERT INTO tbl_result SELECT a.id, b.id, c.id, c.kind, d.id, d.type FROM ( MATCH (a) -> (b) where b.id > 0 and a.lang is null MATCH (a) <- (c) where label(c) = 'person' Let c.kind = 'k' || cast(c.age / 10 as varchar) MATCH (c) -> (d) where d != b Let d.type = if (label(d) = 'person', 1, 0) RETURN a, b, c, d );