@Query("match p=(a:`历史建筑`)-[:`位于`]->(b)\n" + "where b.level=\"区县\"\n" + "return distinct(b).name as name,count(a) as count") List<LsjzCount> staticByXzqh();
时间: 2024-03-27 18:42:01 浏览: 37
这段代码是一个使用Neo4j数据库进行查询的方法。它的功能是查询所有历史建筑所处的区县,并统计每个区县中历史建筑的数量。在查询过程中,首先通过节点a与节点b之间的“位于”关系将历史建筑与区县进行关联,然后通过where子句筛选出区县节点,并通过return子句返回区县名称和历史建筑数量。最后,将查询结果封装为一个LsjzCount对象列表并返回。
相关问题
Consider the following Neo4J Cypher CREATE command. CREATE (sue:Person {name:"Sue"}),(anna:Person {name:"Anna"}), (joe:Person {name:"Joe"}), (bob:Person {name:"Bob"}), (sue)-[:KNOWS]->(bob), (sue)-[:KNOWS]->(anna), (sue)-[:KNOWS]->(joe), (joe)-[:KNOWS]->(anna) a. Draw the property graph diagram that would result from executing the command. b. Write a Cypher query that reports the common friends of Anna and Joe. Report the query and the result of running it in the created database.
a. The property graph diagram resulting from executing the command is:
```
(sue)-[:KNOWS]->(bob)
(sue)-[:KNOWS]->(anna)
(sue)-[:KNOWS]->(joe)
(joe)-[:KNOWS]->(anna)
```
```
(sue) ---[:KNOWS]---> (bob)
|
|
[:KNOWS]|
|
V
(anna)
|
[:KNOWS]|
|
V
(joe)
```
b. The Cypher query that reports the common friends of Anna and Joe is:
```
MATCH (anna:Person)-[:KNOWS]->(friend:Person)<-[:KNOWS]-(joe:Person)
WHERE anna.name = 'Anna' AND joe.name = 'Joe'
RETURN friend.name
```
The result of running the query in the created database would be:
```
friend.name
-----------
Sue
```
SELECT count(*) FROM device_monitor_attr_his where deviceID=27143 AND monKey=107 AND createTime >= '2022-01-01 00:00:00' AND createTime <= '2022-01-02 00:00:00'用elasticesesarch怎么写?
在 Elasticsearch 中,可以使用以下语句来实现上述 SQL 查询:
```
POST /device_monitor_attr_his/_search
{
"query": {
"bool": {
"must": [
{"match": {"deviceID": "27143"}},
{"match": {"monKey": "107"}},
{"range": {"createTime": {"gte": "2022-01-01T00:00:00", "lte": "2022-01-02T00:00:00"}}}
]
}
}
}
```
其中,`device_monitor_attr_his` 是 Elasticsearch 索引名,`deviceID`、`monKey` 和 `createTime` 是索引中的字段名,`27143` 和 `107` 是对应的字段值,`2022-01-01T00:00:00` 和 `2022-01-02T00:00:00` 是时间范围。这个查询将返回匹配条件的文档总数。