🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 27 (from laksa093)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa027.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html\')), getAhrefsUnparsedNoserviceFromURL(\'https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html","crawl_time":1774911667,"first_indexed_time":1460737448,"http_code":200,"src_unparsed":"com,javacodegeeks!www,\/2014\/10\/neo4j-collecting-multiple-values.html s443","src_root_hash":"14334457447596406227","history_drop_reason":null,"meta_title":"Neo4j: COLLECTing multiple values","meta_descriptions":["One of my favourite functions in Neo4j’s cypher query language is COLLECT which allows us to group items into an array for later consumption. However,"],"attrs_boilerpipe_text":"One of my favourite functions in Neo4j’s cypher query language is COLLECT which allows us to group items into an array for later consumption.\nHowever, I’ve noticed that people sometimes have trouble working out how to collect multiple items with COLLECT and struggle to find a way to do so.\nConsider the following data set:\ncreate (p:Person {name: \"Mark\"})\ncreate (e1:Event {name: \"Event1\", timestamp: 1234})\ncreate (e2:Event {name: \"Event2\", timestamp: 4567})\n \ncreate (p)-[:EVENT]->(e1)\ncreate (p)-[:EVENT]->(e2)\nIf we wanted to return each person along with a collection of the event names they’d participated in we could write the following:\n$ MATCH (p:Person)-[:EVENT]->(e)\n> RETURN p, COLLECT(e.name);\n+--------------------------------------------+\n| p                    | COLLECT(e.name)     |\n+--------------------------------------------+\n| Node[0]{name:\"Mark\"} | [\"Event1\",\"Event2\"] |\n+--------------------------------------------+\n1 row\nThat works nicely, but what about if we want to collect the event name and the timestamp but don’t want to return the entire event node?\nAn approach I’ve seen a few people try during workshops is the following:\nMATCH (p:Person)-[:EVENT]->(e)\nRETURN p, COLLECT(e.name, e.timestamp)\nUnfortunately this doesn’t compile:\nSyntaxException: Too many parameters for function 'collect' (line 2, column 11)\n\"RETURN p, COLLECT(e.name, e.timestamp)\"\n           ^\nAs the error message suggests, the COLLECT function only takes one argument so we need to find another way to solve our problem.\nOne way is to put the two values into a literal array which will result in an array of arrays as our return result:\n$ MATCH (p:Person)-[:EVENT]->(e)\n> RETURN p, COLLECT([e.name, e.timestamp]);\n+----------------------------------------------------------+\n| p                    | COLLECT([e.name, e.timestamp])    |\n+----------------------------------------------------------+\n| Node[0]{name:\"Mark\"} | [[\"Event1\",1234],[\"Event2\",4567]] |\n+----------------------------------------------------------+\n1 row\nThe annoying thing about this approach is that as you add more items you’ll forget in which position you’ve put each bit of data so I think a preferable approach is to collect a map of items instead:\n$ MATCH (p:Person)-[:EVENT]->(e)\n> RETURN p, COLLECT({eventName: e.name, eventTimestamp: e.timestamp});\n+--------------------------------------------------------------------------------------------------------------------------+\n| p                    | COLLECT({eventName: e.name, eventTimestamp: e.timestamp})                                         |\n+--------------------------------------------------------------------------------------------------------------------------+\n| Node[0]{name:\"Mark\"} | [{eventName -> \"Event1\", eventTimestamp -> 1234},{eventName -> \"Event2\", eventTimestamp -> 4567}] |\n+--------------------------------------------------------------------------------------------------------------------------+\n1 row\nDuring the\nClojure Neo4j Hackathon\nthat we ran earlier this week this proved to be a particularly pleasing approach as we could easily destructure the collection of maps in our Clojure code.","attrs_markdown":"- [Knowledge Base](https:\/\/www.javacodegeeks.com\/)\n  - [Tutorials](https:\/\/www.javacodegeeks.com\/tutorials)\n    - [Java Tutorial](https:\/\/www.javacodegeeks.com\/java-tutorial)\n      - [Core Java Tutorials](https:\/\/www.javacodegeeks.com\/core-java-tutorials)\n        - [Java 8 Tutorials](https:\/\/www.javacodegeeks.com\/java-8-tutorials)\n        - [Java 9 Tutorials](https:\/\/www.javacodegeeks.com\/java-9-tutorials)\n        - [Java Concurrency Tutorials](https:\/\/www.javacodegeeks.com\/java-concurrency-tutorials)\n        - [Java NIO Tutorials](https:\/\/www.javacodegeeks.com\/java-nio-tutorials)\n        - [Java Logging Tutorials](https:\/\/www.javacodegeeks.com\/java-logging-tutorials)\n        - [Design Patterns Tutorials](https:\/\/www.javacodegeeks.com\/design-patterns-java-tutorials)\n        - [Exception Handling Tutorials](https:\/\/www.javacodegeeks.com\/java-exception-handling-tutorials)\n        - [JUnit Tutorials](https:\/\/www.javacodegeeks.com\/junit-tutorials)\n        - [XPath Tutorials](https:\/\/www.javacodegeeks.com\/xpath-tutorials)\n        - [Mockito Tutorials](https:\/\/www.javacodegeeks.com\/mockito-tutorials)\n      - [Enterprise Java Tutorials](https:\/\/www.javacodegeeks.com\/enterprise-java-tutorials)\n        - [Java Spring Tutorial](https:\/\/www.javacodegeeks.com\/java-spring-tutorial)\n          - [Spring Boot Tutorials](https:\/\/www.javacodegeeks.com\/spring-boot-tutorials)\n          - [Spring Data Tutorials](https:\/\/www.javacodegeeks.com\/spring-data-tutorials)\n          - [Spring Batch Tutorials](https:\/\/www.javacodegeeks.com\/spring-batch-tutorials)\n          - [Spring Integration Tutorials](https:\/\/www.javacodegeeks.com\/spring-integration-tutorials)\n          - [Spring MVC Tutorials](https:\/\/www.javacodegeeks.com\/spring-mvc-tutorials)\n          - [Spring Security Tutorials](https:\/\/www.javacodegeeks.com\/spring-security-tutorials)\n        - [JDBC Tutorials](https:\/\/www.javacodegeeks.com\/jdbc-tutorials)\n        - [Hibernate Tutorials](https:\/\/www.javacodegeeks.com\/hibernate-tutorials)\n        - [Selenium Tutorials](https:\/\/www.javacodegeeks.com\/selenium-tutorials)\n        - [Java Servlet Tutorials](https:\/\/www.javacodegeeks.com\/java-servlet-tutorials)\n        - [JPA Tutorials](https:\/\/www.javacodegeeks.com\/jpa-tutorials)\n        - [JSF Tutorials](https:\/\/www.javacodegeeks.com\/jsf-tutorials)\n        - [JSP Tutorials](https:\/\/www.javacodegeeks.com\/jsp-tutorials)\n        - [JAX-RS Tutorials](https:\/\/www.javacodegeeks.com\/jax-rs-tutorials)\n        - [JAX-WS Tutorials](https:\/\/www.javacodegeeks.com\/jax-ws-tutorials)\n          - [JAXB Tutorials](https:\/\/www.javacodegeeks.com\/jaxb-tutorials)\n        - [JMS Tutorials](https:\/\/www.javacodegeeks.com\/jms-tutorials)\n        - [EJB Tutorials](https:\/\/www.javacodegeeks.com\/ejb-tutorials)\n        - [ElasticSearch Tutorials](https:\/\/www.javacodegeeks.com\/elasticsearch-tutorials)\n        - [JBoss Drools Tutorials](https:\/\/www.javacodegeeks.com\/jboss-drools-tutorials)\n        - [JMeter Tutorials](https:\/\/www.javacodegeeks.com\/jmeter-tutorials)\n        - [Apache Camel Tutorials](https:\/\/www.javacodegeeks.com\/apache-camel-tutorials)\n        - [Apache Hadoop Tutorials](https:\/\/www.javacodegeeks.com\/apache-hadoop-tutorials)\n        - [Java SLF4J Tutorials](https:\/\/www.javacodegeeks.com\/java-slf4j-tutorials)\n        - [CDI Tutorials](https:\/\/www.javacodegeeks.com\/cdi-tutorials)\n        - [Quartz Tutorials](https:\/\/www.javacodegeeks.com\/quartz-tutorials)\n      - [Desktop Java Tutorials](https:\/\/www.javacodegeeks.com\/desktop-java-tutorials)\n        - [AWT Tutorials](https:\/\/www.javacodegeeks.com\/awt-tutorials)\n        - [Java Swing Tutorials](https:\/\/www.javacodegeeks.com\/java-swing-tutorials)\n        - [JavaFX Tutorials](https:\/\/www.javacodegeeks.com\/javafx-tutorials)\n        - [Xuggler Tutorials](https:\/\/www.javacodegeeks.com\/xuggler-tutorials)\n        - [Eclipse IDE Tutorials](https:\/\/www.javacodegeeks.com\/eclipse-ide-tutorials)\n        - [IntelliJ IDEA Tutorials](https:\/\/www.javacodegeeks.com\/intellij-idea-tutorials)\n        - [Netbeans IDE Tutorials](https:\/\/www.javacodegeeks.com\/netbeans-ide-tutorials)\n    - [Android Tutorials](https:\/\/www.javacodegeeks.com\/android-tutorials)\n    - [Scala Tutorials](https:\/\/www.javacodegeeks.com\/scala-tutorials)\n      - [Play Framework Tutorials](https:\/\/www.javacodegeeks.com\/play-framework-tutorials)\n    - [DevOps Tutorials](https:\/\/www.javacodegeeks.com\/devops-tutorials)\n      - [Docker Tutorials](https:\/\/www.javacodegeeks.com\/docker-tutorials)\n    - [NoSQL Tutorials](https:\/\/www.javacodegeeks.com\/nosql-tutorials)\n      - [MongoDB Tutorials](https:\/\/www.javacodegeeks.com\/mongodb-tutorials)\n    - [Groovy Tutorials](https:\/\/www.javacodegeeks.com\/groovy-tutorials)\n    - [Git Tutorials](https:\/\/www.javacodegeeks.com\/git-tutorials)\n  - [Examples](https:\/\/examples.javacodegeeks.com\/)\n  - [Courses](https:\/\/courses.javacodegeeks.com\/)\n  - [Minibooks](https:\/\/www.javacodegeeks.com\/minibook)\n- [Resources](https:\/\/www.javacodegeeks.com\/resources)\n  - [Java](https:\/\/www.javacodegeeks.com\/best-java-programming-resources)\n  - [Software](https:\/\/www.javacodegeeks.com\/resources\/software)\n  - [Our Courses](https:\/\/www.javacodegeeks.com\/courses)\n  - [Our Projects](https:\/\/www.javacodegeeks.com\/resources\/our-projects)\n- [About](https:\/\/www.javacodegeeks.com\/about)\n  - [About JCGs](https:\/\/www.javacodegeeks.com\/about\/about-jcgs)\n  - [Advertising](https:\/\/www.javacodegeeks.com\/about\/advertising)\n  - [Terms of Use](https:\/\/www.javacodegeeks.com\/about\/terms-of-use)\n  - [Privacy Policy](https:\/\/www.javacodegeeks.com\/about\/privacy-policy)\n  - [Join Us](https:\/\/www.javacodegeeks.com\/join-us)\n    - [JCG](https:\/\/www.javacodegeeks.com\/join-us\/jcg)\n    - [W4G](https:\/\/www.javacodegeeks.com\/join-us\/w4g)\n      - [Submission Guidelines](https:\/\/www.javacodegeeks.com\/join-us\/w4g\/submission-guidelines)\n      - [Terms & Conditions](https:\/\/www.javacodegeeks.com\/join-us\/w4g\/terms-conditions)\n- [Deals](https:\/\/deals.javacodegeeks.com\/)\n\n- [RSS](https:\/\/feeds.feedburner.com\/JavaCodeGeeks)\n- [Facebook](https:\/\/www.facebook.com\/javacodegeeks)\n- [X](https:\/\/twitter.com\/javacodegeeks)\n- [LinkedIn](https:\/\/www.linkedin.com\/groups\/3810709\/)\n- [YouTube](https:\/\/www.youtube.com\/channel\/UCxoUc7Rar2q90Gu0nT2ffuQ)\n- [GitHub](https:\/\/github.com\/javacodegeeks\/)\n\n- [Menu](https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html)\n\n[![Java Code Geeks](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/JavaCodeGeeks-logo.png)](https:\/\/www.javacodegeeks.com\/ \"Java Code Geeks\")\n\n- [Search for](https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html)\n\n- [Android](https:\/\/www.javacodegeeks.com\/category\/android)\n  - [Android Core](https:\/\/www.javacodegeeks.com\/category\/android\/android-core)\n  - [Android Games](https:\/\/www.javacodegeeks.com\/category\/android\/android-games)\n- [Java](https:\/\/www.javacodegeeks.com\/category\/java)\n  - [Core Java](https:\/\/www.javacodegeeks.com\/category\/java\/core-java)\n  - [Desktop Java](https:\/\/www.javacodegeeks.com\/category\/java\/desktop-java)\n  - [Enterprise Java](https:\/\/www.javacodegeeks.com\/category\/java\/enterprise-java)\n- [JVM Languages](https:\/\/www.javacodegeeks.com\/category\/jvm-languages)\n  - [Ceylon](https:\/\/www.javacodegeeks.com\/category\/jvm-languages\/ceylon)\n  - [Clojure](https:\/\/www.javacodegeeks.com\/category\/jvm-languages\/clojure)\n  - [Groovy](https:\/\/www.javacodegeeks.com\/category\/jvm-languages\/groovy)\n  - [JRuby](https:\/\/www.javacodegeeks.com\/category\/jvm-languages\/jruby)\n  - [Kotlin](https:\/\/www.javacodegeeks.com\/category\/jvm-languages\/kotlin)\n  - [Scala](https:\/\/www.javacodegeeks.com\/category\/jvm-languages\/scala)\n- [Soft Dev](https:\/\/www.javacodegeeks.com\/category\/software-development)\n- [Web Development](https:\/\/www.javacodegeeks.com\/category\/web-development)\n  - [Python](https:\/\/www.javacodegeeks.com\/category\/web-development\/python)\n  - [JavaScript](https:\/\/www.javacodegeeks.com\/category\/web-development\/javascript)\n    - [React.js](https:\/\/www.javacodegeeks.com\/category\/web-development\/javascript\/react-js)\n    - [Node.js](https:\/\/www.javacodegeeks.com\/category\/web-development\/javascript\/node-js)\n    - [Angular](https:\/\/www.javacodegeeks.com\/category\/web-development\/javascript\/angular)\n    - [jQuery](https:\/\/www.javacodegeeks.com\/category\/web-development\/javascript\/jquery)\n    - [Vue.js](https:\/\/www.javacodegeeks.com\/category\/web-development\/javascript\/vue-js)\n  - [TypeScript](https:\/\/www.javacodegeeks.com\/category\/web-development\/typescript)\n  - [PHP](https:\/\/www.javacodegeeks.com\/category\/web-development\/php)\n- [Agile](https:\/\/www.javacodegeeks.com\/category\/agile)\n- [Career](https:\/\/www.javacodegeeks.com\/category\/career)\n- [Comms](https:\/\/www.javacodegeeks.com\/category\/communications)\n- [DevOps](https:\/\/www.javacodegeeks.com\/category\/devops)\n- [Blockchain](https:\/\/www.javacodegeeks.com\/category\/blockchain)\n  - [Cardano](https:\/\/www.javacodegeeks.com\/category\/blockchain\/cardano)\n- [Meta JCG](https:\/\/www.javacodegeeks.com\/category\/meta-jcg)\n  - [Best Of The Week](https:\/\/www.javacodegeeks.com\/category\/meta-jcg\/best-of-the-week)\n  - [Misc](https:\/\/www.javacodegeeks.com\/category\/misc)\n\n[Home](https:\/\/www.javacodegeeks.com\/)*»*[Java](https:\/\/www.javacodegeeks.com\/category\/java)*»*[Enterprise Java](https:\/\/www.javacodegeeks.com\/category\/java\/enterprise-java)*»*Neo4j: COLLECTing multiple values\n\n[Enterprise Java](https:\/\/www.javacodegeeks.com\/category\/java\/enterprise-java)\n\n# Neo4j: COLLECTing multiple values\n[![Photo of Mark Needham](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNDAiIGhlaWdodD0iMTQwIiB2aWV3Qm94PSIwIDAgMTQwIDE0MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![Photo of Mark Needham](https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=140&d=mm&r=g)](https:\/\/www.javacodegeeks.com\/author\/Mark-Needham)\n\n[Mark Needham](https:\/\/www.javacodegeeks.com\/author\/Mark-Needham \"Mark Needham\")\n\nOctober 1st, 2014Last Updated: September 30th, 2014\n\n0 223  2 minutes read\n\nOne of my favourite functions in Neo4j’s cypher query language is COLLECT which allows us to group items into an array for later consumption.\n\nHowever, I’ve noticed that people sometimes have trouble working out how to collect multiple items with COLLECT and struggle to find a way to do so.\n\nConsider the following data set:\n```\ncreate (p:Person {name: \"Mark\"})\ncreate (e1:Event {name: \"Event1\", timestamp: 1234})\ncreate (e2:Event {name: \"Event2\", timestamp: 4567})\n \ncreate (p)-[:EVENT]->(e1)\ncreate (p)-[:EVENT]->(e2)\n```\nIf we wanted to return each person along with a collection of the event names they’d participated in we could write the following:\n```\n$ MATCH (p:Person)-[:EVENT]->(e)\n> RETURN p, COLLECT(e.name);\n+--------------------------------------------+\n| p                    | COLLECT(e.name)     |\n+--------------------------------------------+\n| Node[0]{name:\"Mark\"} | [\"Event1\",\"Event2\"] |\n+--------------------------------------------+\n1 row\n```\nThat works nicely, but what about if we want to collect the event name and the timestamp but don’t want to return the entire event node?\n\nAn approach I’ve seen a few people try during workshops is the following:\n```\nMATCH (p:Person)-[:EVENT]->(e)\nRETURN p, COLLECT(e.name, e.timestamp)\n```\nUnfortunately this doesn’t compile:\n```\nSyntaxException: Too many parameters for function 'collect' (line 2, column 11)\n\"RETURN p, COLLECT(e.name, e.timestamp)\"\n           ^\n```\nAs the error message suggests, the COLLECT function only takes one argument so we need to find another way to solve our problem.\n\nOne way is to put the two values into a literal array which will result in an array of arrays as our return result:\n```\n$ MATCH (p:Person)-[:EVENT]->(e)\n> RETURN p, COLLECT([e.name, e.timestamp]);\n+----------------------------------------------------------+\n| p                    | COLLECT([e.name, e.timestamp])    |\n+----------------------------------------------------------+\n| Node[0]{name:\"Mark\"} | [[\"Event1\",1234],[\"Event2\",4567]] |\n+----------------------------------------------------------+\n1 row\n```\nThe annoying thing about this approach is that as you add more items you’ll forget in which position you’ve put each bit of data so I think a preferable approach is to collect a map of items instead:\n```\n$ MATCH (p:Person)-[:EVENT]->(e)\n> RETURN p, COLLECT({eventName: e.name, eventTimestamp: e.timestamp});\n+--------------------------------------------------------------------------------------------------------------------------+\n| p                    | COLLECT({eventName: e.name, eventTimestamp: e.timestamp})                                         |\n+--------------------------------------------------------------------------------------------------------------------------+\n| Node[0]{name:\"Mark\"} | [{eventName -> \"Event1\", eventTimestamp -> 1234},{eventName -> \"Event2\", eventTimestamp -> 4567}] |\n+--------------------------------------------------------------------------------------------------------------------------+\n1 row\n```\nDuring the [Clojure Neo4j Hackathon](http:\/\/www.meetup.com\/graphdb-london\/events\/194308602\/) that we ran earlier this week this proved to be a particularly pleasing approach as we could easily destructure the collection of maps in our Clojure code.\n\n|   |   |\n|---|---|\n| Reference: | [Neo4j: COLLECTing multiple values](http:\/\/www.markhneedham.com\/blog\/2014\/09\/26\/neo4j-collecting-multiple-values-too-many-parameters-for-function-collect\/) from our [JCG partner](https:\/\/www.javacodegeeks.com\/jcg\/) Mark Needham at the [Mark Needham Blog](http:\/\/www.markhneedham.com\/blog\/) blog. |\n\nDo you want to know how to develop your skillset to become a Java Rockstar?\n\nSubscribe to our newsletter to start Rocking right now\\!\n\nTo get you started we give you our best selling eBooks for FREE\\!\n\n1\\. JPA Mini Book\n\n2\\. JVM Troubleshooting Guide\n\n3\\. JUnit Tutorial for Unit Testing\n\n4\\. Java Annotations Tutorial\n\n5\\. Java Interview Questions\n\n6\\. Spring Interview Questions\n\n7\\. Android UI Design\n\nand many more ....\n\nI agree to the [Terms](https:\/\/www.javacodegeeks.com\/about\/terms-of-use)  and [Privacy Policy](https:\/\/www.javacodegeeks.com\/about\/privacy-policy)\n\n[Sign up](https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html)\n\n![](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIzMjAiIGhlaWdodD0iMzYzIiB2aWV3Qm94PSIwIDAgMzIwIDM2MyI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)\n\n![](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2015\/01\/books_promo.png)\n\n#### Thank you\\!\nWe will contact you soon.\n\nTags\n\n[Neo4j](https:\/\/www.javacodegeeks.com\/tag\/neo4j)\n\n[![Photo of Mark Needham](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNDAiIGhlaWdodD0iMTQwIiB2aWV3Qm94PSIwIDAgMTQwIDE0MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![Photo of Mark Needham](https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=140&d=mm&r=g)](https:\/\/www.javacodegeeks.com\/author\/Mark-Needham)\n\n[Mark Needham](https:\/\/www.javacodegeeks.com\/author\/Mark-Needham \"Mark Needham\")\n\nOctober 1st, 2014Last Updated: September 30th, 2014\n\n0 223  2 minutes read\n\n[![Photo of Mark Needham](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxODAiIGhlaWdodD0iMTgwIiB2aWV3Qm94PSIwIDAgMTgwIDE4MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![Photo of Mark Needham](https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=180&d=mm&r=g)](https:\/\/www.javacodegeeks.com\/author\/Mark-Needham)\n\n### [Mark Needham](https:\/\/www.javacodegeeks.com\/author\/Mark-Needham)\n- [Website](http:\/\/www.markhneedham.com\/blog\/)\n\n### Related Articles\n[![java-interview-questions-answers](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![java-interview-questions-answers](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/enterprise-java-logo.jpg)](https:\/\/www.javacodegeeks.com\/2012\/09\/simple-rest-client-in-java.html)\n\n### [Simple REST client in Java](https:\/\/www.javacodegeeks.com\/2012\/09\/simple-rest-client-in-java.html)\nSeptember 11th, 2012\n\n[![spring-interview-questions-answers](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![spring-interview-questions-answers](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/spring-logo.jpg)](https:\/\/www.javacodegeeks.com\/2019\/05\/error-creating-bean-datasource-datasourceautoconfiguration.html)\n\n### [Spring Boot Error – Error creating a bean with name ‘dataSource’ defined in class path resource DataSourceAutoConfiguration](https:\/\/www.javacodegeeks.com\/2019\/05\/error-creating-bean-datasource-datasourceautoconfiguration.html)\nMay 1st, 2019\n\n[![](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/slf4j-logo.jpg)](https:\/\/www.javacodegeeks.com\/2018\/02\/fix-exception-thread-main-java-lang-noclassdeffounderror-org-slf4j-loggerfactory-java.html)\n\n### [How to fix Exception in thread “main” java.lang.NoClassDefFoundError: org\/slf4j\/LoggerFactory in Java](https:\/\/www.javacodegeeks.com\/2018\/02\/fix-exception-thread-main-java-lang-noclassdeffounderror-org-slf4j-loggerfactory-java.html)\nFebruary 22nd, 2018\n\n[![](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/mockito-logo.jpg)](https:\/\/www.javacodegeeks.com\/2020\/07\/mockito-cannot-instantiate-injectmocks-field-the-type-is-an-interface.html)\n\n### [Mockito: Cannot instantiate @InjectMocks field: the type is an interface](https:\/\/www.javacodegeeks.com\/2020\/07\/mockito-cannot-instantiate-injectmocks-field-the-type-is-an-interface.html)\nJuly 7th, 2020\n\n[![spring-interview-questions-answers](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![spring-interview-questions-answers](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/spring-logo.jpg)](https:\/\/www.javacodegeeks.com\/2020\/04\/spring-boot-remove-embedded-tomcat-server-enable-jetty-server.html)\n\n### [Spring Boot Remove Embedded Tomcat Server, Enable Jetty Server](https:\/\/www.javacodegeeks.com\/2020\/04\/spring-boot-remove-embedded-tomcat-server-enable-jetty-server.html)\nApril 28th, 2020\n\n[![spring-interview-questions-answers](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![spring-interview-questions-answers](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/spring-logo.jpg)](https:\/\/www.javacodegeeks.com\/spring-interview-questions-and-answers.html)\n\n### [100 Java Spring Interview Questions & Answers – The ULTIMATE List (PDF Download)](https:\/\/www.javacodegeeks.com\/spring-interview-questions-and-answers.html)\nMay 2nd, 2014\n\n[![spring-interview-questions-answers](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![spring-interview-questions-answers](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/spring-logo.jpg)](https:\/\/www.javacodegeeks.com\/2018\/02\/securitycontext-securitycontextholder-spring-security.html)\n\n### [What is SecurityContext and SecurityContextHolder in Spring Security?](https:\/\/www.javacodegeeks.com\/2018\/02\/securitycontext-securitycontextholder-spring-security.html)\nFebruary 21st, 2018\n\n[![java-interview-questions-answers](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![java-interview-questions-answers](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/enterprise-java-logo.jpg)](https:\/\/www.javacodegeeks.com\/2020\/05\/how-to-install-apache-web-server-on-ec2-instance-using-user-data-script.html)\n\n### [How to install Apache Web Server on EC2 Instance using User data script](https:\/\/www.javacodegeeks.com\/2020\/05\/how-to-install-apache-web-server-on-ec2-instance-using-user-data-script.html)\nMay 7th, 2020\n\nSubscribe\n\nThis site uses Akismet to reduce spam. [Learn how your comment data is processed.](https:\/\/akismet.com\/privacy\/)\n\n0 Comments\n\nOldest\n\nNewest Most Voted\n\nInline Feedbacks\n\nView all comments\n\nJoin Us\n\n![Join Us](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2013\/04\/w4g-badge-150x150.png)\n\nWith\n\n1,240,600\n\nmonthly unique visitors and over\n\n500\n\nauthors we are placed among the top Java related sites around. Constantly being on the lookout for partners; we encourage you to join us. So If you have a blog with unique and interesting content then you should check out our **[JCG](https:\/\/www.javacodegeeks.com\/join-us\/jcg)** partners program. You can also be a **[guest writer](https:\/\/www.javacodegeeks.com\/join-us\/w4g)** for Java Code Geeks and hone your writing skills\\!\n\nNewsletter\n\n![](data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIzMzUiIGhlaWdodD0iMzEwIiB2aWV3Qm94PSIwIDAgMzM1IDMxMCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)\n\n![](https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2018\/01\/newsletter-bg.jpg)\n\nInsiders are already enjoying weekly updates and complimentary whitepapers\\!\n\nJoin them now to gain exclusive access to the latest news in the Java world, as well as insights about Android, JVM languages, cloud computing, Web development, DevOps, big data, Web3, blockchain programming and other related technologies.\n\nEmail address:\n\nI agree to the [Terms](https:\/\/www.systemcodegeeks.com\/about\/terms-of-use\/)  and [Privacy Policy](https:\/\/www.javacodegeeks.com\/about\/privacy-policy\/)\n\n[Sign up](https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html)\n\n#### Thank you\\!\nWe will contact you soon.\n\nKnowledge Base\n\n- [Courses](https:\/\/courses.javacodegeeks.com\/)\n- [Examples](https:\/\/examples.javacodegeeks.com\/)\n- [Minibooks](https:\/\/www.javacodegeeks.com\/minibook)\n- [Resources](https:\/\/www.javacodegeeks.com\/resources)\n- [Tutorials](https:\/\/www.javacodegeeks.com\/tutorials)\n\nThe Code Geeks Network\n\n- [.NET Code Geeks](https:\/\/www.dotnetcodegeeks.com\/)\n- [Java Code Geeks](https:\/\/www.javacodegeeks.com\/)\n- [System Code Geeks](https:\/\/www.systemcodegeeks.com\/)\n- [Web Code Geeks](https:\/\/www.webcodegeeks.com\/)\n\nHall Of Fame\n\n- [“Android Full Application Tutorial” series](https:\/\/www.javacodegeeks.com\/2010\/10\/android-full-application-tutorial.html)\n- [11 Online Learning websites that you should check out](https:\/\/www.javacodegeeks.com\/2013\/01\/15-online-learning-websites-that-you-should-check-out.html)\n- [Advantages and Disadvantages of Cloud Computing – Cloud computing pros and cons](https:\/\/www.javacodegeeks.com\/2013\/04\/advantages-and-disadvantages-of-cloud-computing-cloud-computing-pros-and-cons.html)\n- [Android Google Maps Tutorial](https:\/\/www.javacodegeeks.com\/2011\/02\/android-google-maps-tutorial.html)\n- [Android JSON Parsing with Gson Tutorial](https:\/\/www.javacodegeeks.com\/2011\/01\/android-json-parsing-gson-tutorial.html)\n- [Android Location Based Services Application – GPS location](https:\/\/www.javacodegeeks.com\/2010\/09\/android-location-based-services.html)\n- [Android Quick Preferences Tutorial](https:\/\/www.javacodegeeks.com\/2011\/01\/android-quick-preferences-tutorial.html)\n- [Difference between Comparator and Comparable in Java](https:\/\/www.javacodegeeks.com\/2013\/03\/difference-between-comparator-and-comparable-in-java.html)\n- [GWT 2 Spring 3 JPA 2 Hibernate 3.5 Tutorial](https:\/\/www.javacodegeeks.com\/2010\/05\/gwt-2-spring-3-jpa-2-hibernate-35-2.html)\n- [Java Best Practices – Vector vs ArrayList vs HashSet](https:\/\/www.javacodegeeks.com\/2010\/08\/java-best-practices-vector-arraylist.html)\n\nAbout Java Code Geeks\n\nJCGs (Java Code Geeks) is an independent online community focused on creating the ultimate Java to Java developers resource center; targeted at the technical architect, technical team lead (senior developer), project manager and junior developers alike. JCGs serve the Java, SOA, Agile and Telecom communities with daily news written by domain experts, articles, tutorials, reviews, announcements, code snippets and open source projects.\n\nDisclaimer\n\nAll trademarks and registered trademarks appearing on Java Code Geeks are the property of their respective owners. Java is a trademark or registered trademark of Oracle Corporation in the United States and other countries. Examples Java Code Geeks is not connected to Oracle Corporation and is not sponsored by Oracle Corporation.\n\nJava Code Geeks and all content copyright © 2010-2026, [Exelixis Media P.C.](https:\/\/www.exelixismedia.com\/) \\| [Terms of Use](https:\/\/www.javacodegeeks.com\/about\/terms-of-use) \\| [Privacy Policy](https:\/\/www.javacodegeeks.com\/about\/privacy-policy) \\| [Contact](mailto:support@javacodegeeks.com)\n\n\\| Do not share my Personal Information\n\n\\| [Cookie Settings]()\n\n- [RSS](https:\/\/feeds.feedburner.com\/JavaCodeGeeks)\n- [Facebook](https:\/\/www.facebook.com\/javacodegeeks)\n- [X](https:\/\/twitter.com\/javacodegeeks)\n- [LinkedIn](https:\/\/www.linkedin.com\/groups\/3810709\/)\n- [YouTube](https:\/\/www.youtube.com\/channel\/UCxoUc7Rar2q90Gu0nT2ffuQ)\n- [GitHub](https:\/\/github.com\/javacodegeeks\/)\n\n[Facebook](https:\/\/www.facebook.com\/sharer.php?u=https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html \"Facebook\")   [X](https:\/\/x.com\/intent\/post?text=Neo4j%3A%20COLLECTing%20multiple%20values&url=https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html \"X\")   [WhatsApp](https:\/\/api.whatsapp.com\/send?text=Neo4j%3A%20COLLECTing%20multiple%20values%20https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html \"WhatsApp\")   [Telegram](https:\/\/telegram.me\/share\/url?url=https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html&text=Neo4j%3A%20COLLECTing%20multiple%20values \"Telegram\")\n\n[Back to top button](https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html#go-to-tie-body)\n\n[Close](https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html)\n\n- [RSS](https:\/\/feeds.feedburner.com\/JavaCodeGeeks)\n- [Facebook](https:\/\/www.facebook.com\/javacodegeeks)\n- [X](https:\/\/twitter.com\/javacodegeeks)\n- [LinkedIn](https:\/\/www.linkedin.com\/groups\/3810709\/)\n- [YouTube](https:\/\/www.youtube.com\/channel\/UCxoUc7Rar2q90Gu0nT2ffuQ)\n- [GitHub](https:\/\/github.com\/javacodegeeks\/)\n\n[Close](https:\/\/www.javacodegeeks.com\/2014\/10\/neo4j-collecting-multiple-values.html)\n\nwpDiscuz\n\nInsert","attrs_readable_markdown":"One of my favourite functions in Neo4j’s cypher query language is COLLECT which allows us to group items into an array for later consumption.\n\nHowever, I’ve noticed that people sometimes have trouble working out how to collect multiple items with COLLECT and struggle to find a way to do so.\n\nConsider the following data set:\n```\ncreate (p:Person {name: \"Mark\"})\ncreate (e1:Event {name: \"Event1\", timestamp: 1234})\ncreate (e2:Event {name: \"Event2\", timestamp: 4567})\n \ncreate (p)-[:EVENT]->(e1)\ncreate (p)-[:EVENT]->(e2)\n```\nIf we wanted to return each person along with a collection of the event names they’d participated in we could write the following:\n```\n$ MATCH (p:Person)-[:EVENT]->(e)\n> RETURN p, COLLECT(e.name);\n+--------------------------------------------+\n| p                    | COLLECT(e.name)     |\n+--------------------------------------------+\n| Node[0]{name:\"Mark\"} | [\"Event1\",\"Event2\"] |\n+--------------------------------------------+\n1 row\n```\nThat works nicely, but what about if we want to collect the event name and the timestamp but don’t want to return the entire event node?\n\nAn approach I’ve seen a few people try during workshops is the following:\n```\nMATCH (p:Person)-[:EVENT]->(e)\nRETURN p, COLLECT(e.name, e.timestamp)\n```\nUnfortunately this doesn’t compile:\n```\nSyntaxException: Too many parameters for function 'collect' (line 2, column 11)\n\"RETURN p, COLLECT(e.name, e.timestamp)\"\n           ^\n```\nAs the error message suggests, the COLLECT function only takes one argument so we need to find another way to solve our problem.\n\nOne way is to put the two values into a literal array which will result in an array of arrays as our return result:\n```\n$ MATCH (p:Person)-[:EVENT]->(e)\n> RETURN p, COLLECT([e.name, e.timestamp]);\n+----------------------------------------------------------+\n| p                    | COLLECT([e.name, e.timestamp])    |\n+----------------------------------------------------------+\n| Node[0]{name:\"Mark\"} | [[\"Event1\",1234],[\"Event2\",4567]] |\n+----------------------------------------------------------+\n1 row\n```\nThe annoying thing about this approach is that as you add more items you’ll forget in which position you’ve put each bit of data so I think a preferable approach is to collect a map of items instead:\n```\n$ MATCH (p:Person)-[:EVENT]->(e)\n> RETURN p, COLLECT({eventName: e.name, eventTimestamp: e.timestamp});\n+--------------------------------------------------------------------------------------------------------------------------+\n| p                    | COLLECT({eventName: e.name, eventTimestamp: e.timestamp})                                         |\n+--------------------------------------------------------------------------------------------------------------------------+\n| Node[0]{name:\"Mark\"} | [{eventName -> \"Event1\", eventTimestamp -> 1234},{eventName -> \"Event2\", eventTimestamp -> 4567}] |\n+--------------------------------------------------------------------------------------------------------------------------+\n1 row\n```\nDuring the [Clojure Neo4j Hackathon](http:\/\/www.meetup.com\/graphdb-london\/events\/194308602\/) that we ran earlier this week this proved to be a particularly pleasing approach as we could easily destructure the collection of maps in our Clojure code.\n\n[![Photo of Mark Needham](https:\/\/secure.gravatar.com\/avatar\/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=180&d=mm&r=g)](https:\/\/www.javacodegeeks.com\/author\/Mark-Needham)","meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

12 days ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	0.4 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html
Last Crawled	2026-03-30 23:01:07 (12 days ago)
First Indexed	2016-04-15 16:24:08 (9 years ago)
HTTP Status Code	200
Meta Title	Neo4j: COLLECTing multiple values
Meta Description	One of my favourite functions in Neo4j’s cypher query language is COLLECT which allows us to group items into an array for later consumption. However,
Meta Canonical	null
Boilerpipe Text	One of my favourite functions in Neo4j’s cypher query language is COLLECT which allows us to group items into an array for later consumption. However, I’ve noticed that people sometimes have trouble working out how to collect multiple items with COLLECT and struggle to find a way to do so. Consider the following data set: create (p:Person {name: "Mark"}) create (e1:Event {name: "Event1", timestamp: 1234}) create (e2:Event {name: "Event2", timestamp: 4567}) create (p)-[:EVENT]->(e1) create (p)-[:EVENT]->(e2) If we wanted to return each person along with a collection of the event names they’d participated in we could write the following: $ MATCH (p:Person)-[:EVENT]->(e) > RETURN p, COLLECT(e.name); +--------------------------------------------+ \| p \| COLLECT(e.name) \| +--------------------------------------------+ \| Node[0]{name:"Mark"} \| ["Event1","Event2"] \| +--------------------------------------------+ 1 row That works nicely, but what about if we want to collect the event name and the timestamp but don’t want to return the entire event node? An approach I’ve seen a few people try during workshops is the following: MATCH (p:Person)-[:EVENT]->(e) RETURN p, COLLECT(e.name, e.timestamp) Unfortunately this doesn’t compile: SyntaxException: Too many parameters for function 'collect' (line 2, column 11) "RETURN p, COLLECT(e.name, e.timestamp)" ^ As the error message suggests, the COLLECT function only takes one argument so we need to find another way to solve our problem. One way is to put the two values into a literal array which will result in an array of arrays as our return result: $ MATCH (p:Person)-[:EVENT]->(e) > RETURN p, COLLECT([e.name, e.timestamp]); +----------------------------------------------------------+ \| p \| COLLECT([e.name, e.timestamp]) \| +----------------------------------------------------------+ \| Node[0]{name:"Mark"} \| [["Event1",1234],["Event2",4567]] \| +----------------------------------------------------------+ 1 row The annoying thing about this approach is that as you add more items you’ll forget in which position you’ve put each bit of data so I think a preferable approach is to collect a map of items instead: $ MATCH (p:Person)-[:EVENT]->(e) > RETURN p, COLLECT({eventName: e.name, eventTimestamp: e.timestamp}); +--------------------------------------------------------------------------------------------------------------------------+ \| p \| COLLECT({eventName: e.name, eventTimestamp: e.timestamp}) \| +--------------------------------------------------------------------------------------------------------------------------+ \| Node[0]{name:"Mark"} \| [{eventName -> "Event1", eventTimestamp -> 1234},{eventName -> "Event2", eventTimestamp -> 4567}] \| +--------------------------------------------------------------------------------------------------------------------------+ 1 row During the Clojure Neo4j Hackathon that we ran earlier this week this proved to be a particularly pleasing approach as we could easily destructure the collection of maps in our Clojure code.
Markdown	- [Knowledge Base](https://www.javacodegeeks.com/) - [Tutorials](https://www.javacodegeeks.com/tutorials) - [Java Tutorial](https://www.javacodegeeks.com/java-tutorial) - [Core Java Tutorials](https://www.javacodegeeks.com/core-java-tutorials) - [Java 8 Tutorials](https://www.javacodegeeks.com/java-8-tutorials) - [Java 9 Tutorials](https://www.javacodegeeks.com/java-9-tutorials) - [Java Concurrency Tutorials](https://www.javacodegeeks.com/java-concurrency-tutorials) - [Java NIO Tutorials](https://www.javacodegeeks.com/java-nio-tutorials) - [Java Logging Tutorials](https://www.javacodegeeks.com/java-logging-tutorials) - [Design Patterns Tutorials](https://www.javacodegeeks.com/design-patterns-java-tutorials) - [Exception Handling Tutorials](https://www.javacodegeeks.com/java-exception-handling-tutorials) - [JUnit Tutorials](https://www.javacodegeeks.com/junit-tutorials) - [XPath Tutorials](https://www.javacodegeeks.com/xpath-tutorials) - [Mockito Tutorials](https://www.javacodegeeks.com/mockito-tutorials) - [Enterprise Java Tutorials](https://www.javacodegeeks.com/enterprise-java-tutorials) - [Java Spring Tutorial](https://www.javacodegeeks.com/java-spring-tutorial) - [Spring Boot Tutorials](https://www.javacodegeeks.com/spring-boot-tutorials) - [Spring Data Tutorials](https://www.javacodegeeks.com/spring-data-tutorials) - [Spring Batch Tutorials](https://www.javacodegeeks.com/spring-batch-tutorials) - [Spring Integration Tutorials](https://www.javacodegeeks.com/spring-integration-tutorials) - [Spring MVC Tutorials](https://www.javacodegeeks.com/spring-mvc-tutorials) - [Spring Security Tutorials](https://www.javacodegeeks.com/spring-security-tutorials) - [JDBC Tutorials](https://www.javacodegeeks.com/jdbc-tutorials) - [Hibernate Tutorials](https://www.javacodegeeks.com/hibernate-tutorials) - [Selenium Tutorials](https://www.javacodegeeks.com/selenium-tutorials) - [Java Servlet Tutorials](https://www.javacodegeeks.com/java-servlet-tutorials) - [JPA Tutorials](https://www.javacodegeeks.com/jpa-tutorials) - [JSF Tutorials](https://www.javacodegeeks.com/jsf-tutorials) - [JSP Tutorials](https://www.javacodegeeks.com/jsp-tutorials) - [JAX-RS Tutorials](https://www.javacodegeeks.com/jax-rs-tutorials) - [JAX-WS Tutorials](https://www.javacodegeeks.com/jax-ws-tutorials) - [JAXB Tutorials](https://www.javacodegeeks.com/jaxb-tutorials) - [JMS Tutorials](https://www.javacodegeeks.com/jms-tutorials) - [EJB Tutorials](https://www.javacodegeeks.com/ejb-tutorials) - [ElasticSearch Tutorials](https://www.javacodegeeks.com/elasticsearch-tutorials) - [JBoss Drools Tutorials](https://www.javacodegeeks.com/jboss-drools-tutorials) - [JMeter Tutorials](https://www.javacodegeeks.com/jmeter-tutorials) - [Apache Camel Tutorials](https://www.javacodegeeks.com/apache-camel-tutorials) - [Apache Hadoop Tutorials](https://www.javacodegeeks.com/apache-hadoop-tutorials) - [Java SLF4J Tutorials](https://www.javacodegeeks.com/java-slf4j-tutorials) - [CDI Tutorials](https://www.javacodegeeks.com/cdi-tutorials) - [Quartz Tutorials](https://www.javacodegeeks.com/quartz-tutorials) - [Desktop Java Tutorials](https://www.javacodegeeks.com/desktop-java-tutorials) - [AWT Tutorials](https://www.javacodegeeks.com/awt-tutorials) - [Java Swing Tutorials](https://www.javacodegeeks.com/java-swing-tutorials) - [JavaFX Tutorials](https://www.javacodegeeks.com/javafx-tutorials) - [Xuggler Tutorials](https://www.javacodegeeks.com/xuggler-tutorials) - [Eclipse IDE Tutorials](https://www.javacodegeeks.com/eclipse-ide-tutorials) - [IntelliJ IDEA Tutorials](https://www.javacodegeeks.com/intellij-idea-tutorials) - [Netbeans IDE Tutorials](https://www.javacodegeeks.com/netbeans-ide-tutorials) - [Android Tutorials](https://www.javacodegeeks.com/android-tutorials) - [Scala Tutorials](https://www.javacodegeeks.com/scala-tutorials) - [Play Framework Tutorials](https://www.javacodegeeks.com/play-framework-tutorials) - [DevOps Tutorials](https://www.javacodegeeks.com/devops-tutorials) - [Docker Tutorials](https://www.javacodegeeks.com/docker-tutorials) - [NoSQL Tutorials](https://www.javacodegeeks.com/nosql-tutorials) - [MongoDB Tutorials](https://www.javacodegeeks.com/mongodb-tutorials) - [Groovy Tutorials](https://www.javacodegeeks.com/groovy-tutorials) - [Git Tutorials](https://www.javacodegeeks.com/git-tutorials) - [Examples](https://examples.javacodegeeks.com/) - [Courses](https://courses.javacodegeeks.com/) - [Minibooks](https://www.javacodegeeks.com/minibook) - [Resources](https://www.javacodegeeks.com/resources) - [Java](https://www.javacodegeeks.com/best-java-programming-resources) - [Software](https://www.javacodegeeks.com/resources/software) - [Our Courses](https://www.javacodegeeks.com/courses) - [Our Projects](https://www.javacodegeeks.com/resources/our-projects) - [About](https://www.javacodegeeks.com/about) - [About JCGs](https://www.javacodegeeks.com/about/about-jcgs) - [Advertising](https://www.javacodegeeks.com/about/advertising) - [Terms of Use](https://www.javacodegeeks.com/about/terms-of-use) - [Privacy Policy](https://www.javacodegeeks.com/about/privacy-policy) - [Join Us](https://www.javacodegeeks.com/join-us) - [JCG](https://www.javacodegeeks.com/join-us/jcg) - [W4G](https://www.javacodegeeks.com/join-us/w4g) - [Submission Guidelines](https://www.javacodegeeks.com/join-us/w4g/submission-guidelines) - [Terms & Conditions](https://www.javacodegeeks.com/join-us/w4g/terms-conditions) - [Deals](https://deals.javacodegeeks.com/) - [RSS](https://feeds.feedburner.com/JavaCodeGeeks) - [Facebook](https://www.facebook.com/javacodegeeks) - [X](https://twitter.com/javacodegeeks) - [LinkedIn](https://www.linkedin.com/groups/3810709/) - [YouTube](https://www.youtube.com/channel/UCxoUc7Rar2q90Gu0nT2ffuQ) - [GitHub](https://github.com/javacodegeeks/) - [Menu](https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html) [![Java Code Geeks](https://www.javacodegeeks.com/wp-content/uploads/2012/12/JavaCodeGeeks-logo.png)](https://www.javacodegeeks.com/ "Java Code Geeks") - [Search for](https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html) - [Android](https://www.javacodegeeks.com/category/android) - [Android Core](https://www.javacodegeeks.com/category/android/android-core) - [Android Games](https://www.javacodegeeks.com/category/android/android-games) - [Java](https://www.javacodegeeks.com/category/java) - [Core Java](https://www.javacodegeeks.com/category/java/core-java) - [Desktop Java](https://www.javacodegeeks.com/category/java/desktop-java) - [Enterprise Java](https://www.javacodegeeks.com/category/java/enterprise-java) - [JVM Languages](https://www.javacodegeeks.com/category/jvm-languages) - [Ceylon](https://www.javacodegeeks.com/category/jvm-languages/ceylon) - [Clojure](https://www.javacodegeeks.com/category/jvm-languages/clojure) - [Groovy](https://www.javacodegeeks.com/category/jvm-languages/groovy) - [JRuby](https://www.javacodegeeks.com/category/jvm-languages/jruby) - [Kotlin](https://www.javacodegeeks.com/category/jvm-languages/kotlin) - [Scala](https://www.javacodegeeks.com/category/jvm-languages/scala) - [Soft Dev](https://www.javacodegeeks.com/category/software-development) - [Web Development](https://www.javacodegeeks.com/category/web-development) - [Python](https://www.javacodegeeks.com/category/web-development/python) - [JavaScript](https://www.javacodegeeks.com/category/web-development/javascript) - [React.js](https://www.javacodegeeks.com/category/web-development/javascript/react-js) - [Node.js](https://www.javacodegeeks.com/category/web-development/javascript/node-js) - [Angular](https://www.javacodegeeks.com/category/web-development/javascript/angular) - [jQuery](https://www.javacodegeeks.com/category/web-development/javascript/jquery) - [Vue.js](https://www.javacodegeeks.com/category/web-development/javascript/vue-js) - [TypeScript](https://www.javacodegeeks.com/category/web-development/typescript) - [PHP](https://www.javacodegeeks.com/category/web-development/php) - [Agile](https://www.javacodegeeks.com/category/agile) - [Career](https://www.javacodegeeks.com/category/career) - [Comms](https://www.javacodegeeks.com/category/communications) - [DevOps](https://www.javacodegeeks.com/category/devops) - [Blockchain](https://www.javacodegeeks.com/category/blockchain) - [Cardano](https://www.javacodegeeks.com/category/blockchain/cardano) - [Meta JCG](https://www.javacodegeeks.com/category/meta-jcg) - [Best Of The Week](https://www.javacodegeeks.com/category/meta-jcg/best-of-the-week) - [Misc](https://www.javacodegeeks.com/category/misc) [Home](https://www.javacodegeeks.com/)»[Java](https://www.javacodegeeks.com/category/java)»[Enterprise Java](https://www.javacodegeeks.com/category/java/enterprise-java)»Neo4j: COLLECTing multiple values [Enterprise Java](https://www.javacodegeeks.com/category/java/enterprise-java) # Neo4j: COLLECTing multiple values [![Photo of Mark Needham](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNDAiIGhlaWdodD0iMTQwIiB2aWV3Qm94PSIwIDAgMTQwIDE0MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![Photo of Mark Needham](https://secure.gravatar.com/avatar/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=140&d=mm&r=g)](https://www.javacodegeeks.com/author/Mark-Needham) [Mark Needham](https://www.javacodegeeks.com/author/Mark-Needham "Mark Needham") October 1st, 2014Last Updated: September 30th, 2014 0 223 2 minutes read One of my favourite functions in Neo4j’s cypher query language is COLLECT which allows us to group items into an array for later consumption. However, I’ve noticed that people sometimes have trouble working out how to collect multiple items with COLLECT and struggle to find a way to do so. Consider the following data set: ``` create (p:Person {name: "Mark"}) create (e1:Event {name: "Event1", timestamp: 1234}) create (e2:Event {name: "Event2", timestamp: 4567}) create (p)-[:EVENT]->(e1) create (p)-[:EVENT]->(e2) ``` If we wanted to return each person along with a collection of the event names they’d participated in we could write the following: ``` $ MATCH (p:Person)-[:EVENT]->(e) > RETURN p, COLLECT(e.name); +--------------------------------------------+ \| p \| COLLECT(e.name) \| +--------------------------------------------+ \| Node[0]{name:"Mark"} \| ["Event1","Event2"] \| +--------------------------------------------+ 1 row ``` That works nicely, but what about if we want to collect the event name and the timestamp but don’t want to return the entire event node? An approach I’ve seen a few people try during workshops is the following: ``` MATCH (p:Person)-[:EVENT]->(e) RETURN p, COLLECT(e.name, e.timestamp) ``` Unfortunately this doesn’t compile: ``` SyntaxException: Too many parameters for function 'collect' (line 2, column 11) "RETURN p, COLLECT(e.name, e.timestamp)" ^ ``` As the error message suggests, the COLLECT function only takes one argument so we need to find another way to solve our problem. One way is to put the two values into a literal array which will result in an array of arrays as our return result: ``` $ MATCH (p:Person)-[:EVENT]->(e) > RETURN p, COLLECT([e.name, e.timestamp]); +----------------------------------------------------------+ \| p \| COLLECT([e.name, e.timestamp]) \| +----------------------------------------------------------+ \| Node[0]{name:"Mark"} \| [["Event1",1234],["Event2",4567]] \| +----------------------------------------------------------+ 1 row ``` The annoying thing about this approach is that as you add more items you’ll forget in which position you’ve put each bit of data so I think a preferable approach is to collect a map of items instead: ``` $ MATCH (p:Person)-[:EVENT]->(e) > RETURN p, COLLECT({eventName: e.name, eventTimestamp: e.timestamp}); +--------------------------------------------------------------------------------------------------------------------------+ \| p \| COLLECT({eventName: e.name, eventTimestamp: e.timestamp}) \| +--------------------------------------------------------------------------------------------------------------------------+ \| Node[0]{name:"Mark"} \| [{eventName -> "Event1", eventTimestamp -> 1234},{eventName -> "Event2", eventTimestamp -> 4567}] \| +--------------------------------------------------------------------------------------------------------------------------+ 1 row ``` During the [Clojure Neo4j Hackathon](http://www.meetup.com/graphdb-london/events/194308602/) that we ran earlier this week this proved to be a particularly pleasing approach as we could easily destructure the collection of maps in our Clojure code. \| \| \| \|---\|---\| \| Reference: \| [Neo4j: COLLECTing multiple values](http://www.markhneedham.com/blog/2014/09/26/neo4j-collecting-multiple-values-too-many-parameters-for-function-collect/) from our [JCG partner](https://www.javacodegeeks.com/jcg/) Mark Needham at the [Mark Needham Blog](http://www.markhneedham.com/blog/) blog. \| Do you want to know how to develop your skillset to become a Java Rockstar? Subscribe to our newsletter to start Rocking right now\! To get you started we give you our best selling eBooks for FREE\! 1\. JPA Mini Book 2\. JVM Troubleshooting Guide 3\. JUnit Tutorial for Unit Testing 4\. Java Annotations Tutorial 5\. Java Interview Questions 6\. Spring Interview Questions 7\. Android UI Design and many more .... I agree to the [Terms](https://www.javacodegeeks.com/about/terms-of-use) and [Privacy Policy](https://www.javacodegeeks.com/about/privacy-policy) [Sign up](https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html) ![](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIzMjAiIGhlaWdodD0iMzYzIiB2aWV3Qm94PSIwIDAgMzIwIDM2MyI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=) ![](https://www.javacodegeeks.com/wp-content/uploads/2015/01/books_promo.png) #### Thank you\! We will contact you soon. Tags [Neo4j](https://www.javacodegeeks.com/tag/neo4j) [![Photo of Mark Needham](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNDAiIGhlaWdodD0iMTQwIiB2aWV3Qm94PSIwIDAgMTQwIDE0MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![Photo of Mark Needham](https://secure.gravatar.com/avatar/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=140&d=mm&r=g)](https://www.javacodegeeks.com/author/Mark-Needham) [Mark Needham](https://www.javacodegeeks.com/author/Mark-Needham "Mark Needham") October 1st, 2014Last Updated: September 30th, 2014 0 223 2 minutes read [![Photo of Mark Needham](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxODAiIGhlaWdodD0iMTgwIiB2aWV3Qm94PSIwIDAgMTgwIDE4MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![Photo of Mark Needham](https://secure.gravatar.com/avatar/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=180&d=mm&r=g)](https://www.javacodegeeks.com/author/Mark-Needham) ### [Mark Needham](https://www.javacodegeeks.com/author/Mark-Needham) - [Website](http://www.markhneedham.com/blog/) ### Related Articles [![java-interview-questions-answers](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![java-interview-questions-answers](https://www.javacodegeeks.com/wp-content/uploads/2012/10/enterprise-java-logo.jpg)](https://www.javacodegeeks.com/2012/09/simple-rest-client-in-java.html) ### [Simple REST client in Java](https://www.javacodegeeks.com/2012/09/simple-rest-client-in-java.html) September 11th, 2012 [![spring-interview-questions-answers](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![spring-interview-questions-answers](https://www.javacodegeeks.com/wp-content/uploads/2012/10/spring-logo.jpg)](https://www.javacodegeeks.com/2019/05/error-creating-bean-datasource-datasourceautoconfiguration.html) ### [Spring Boot Error – Error creating a bean with name ‘dataSource’ defined in class path resource DataSourceAutoConfiguration](https://www.javacodegeeks.com/2019/05/error-creating-bean-datasource-datasourceautoconfiguration.html) May 1st, 2019 [![](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![](https://www.javacodegeeks.com/wp-content/uploads/2012/10/slf4j-logo.jpg)](https://www.javacodegeeks.com/2018/02/fix-exception-thread-main-java-lang-noclassdeffounderror-org-slf4j-loggerfactory-java.html) ### [How to fix Exception in thread “main” java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory in Java](https://www.javacodegeeks.com/2018/02/fix-exception-thread-main-java-lang-noclassdeffounderror-org-slf4j-loggerfactory-java.html) February 22nd, 2018 [![](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![](https://www.javacodegeeks.com/wp-content/uploads/2012/10/mockito-logo.jpg)](https://www.javacodegeeks.com/2020/07/mockito-cannot-instantiate-injectmocks-field-the-type-is-an-interface.html) ### [Mockito: Cannot instantiate @InjectMocks field: the type is an interface](https://www.javacodegeeks.com/2020/07/mockito-cannot-instantiate-injectmocks-field-the-type-is-an-interface.html) July 7th, 2020 [![spring-interview-questions-answers](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![spring-interview-questions-answers](https://www.javacodegeeks.com/wp-content/uploads/2012/10/spring-logo.jpg)](https://www.javacodegeeks.com/2020/04/spring-boot-remove-embedded-tomcat-server-enable-jetty-server.html) ### [Spring Boot Remove Embedded Tomcat Server, Enable Jetty Server](https://www.javacodegeeks.com/2020/04/spring-boot-remove-embedded-tomcat-server-enable-jetty-server.html) April 28th, 2020 [![spring-interview-questions-answers](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![spring-interview-questions-answers](https://www.javacodegeeks.com/wp-content/uploads/2012/10/spring-logo.jpg)](https://www.javacodegeeks.com/spring-interview-questions-and-answers.html) ### [100 Java Spring Interview Questions & Answers – The ULTIMATE List (PDF Download)](https://www.javacodegeeks.com/spring-interview-questions-and-answers.html) May 2nd, 2014 [![spring-interview-questions-answers](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![spring-interview-questions-answers](https://www.javacodegeeks.com/wp-content/uploads/2012/10/spring-logo.jpg)](https://www.javacodegeeks.com/2018/02/securitycontext-securitycontextholder-spring-security.html) ### [What is SecurityContext and SecurityContextHolder in Spring Security?](https://www.javacodegeeks.com/2018/02/securitycontext-securitycontextholder-spring-security.html) February 21st, 2018 [![java-interview-questions-answers](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxNTAiIGhlaWdodD0iMTUwIiB2aWV3Qm94PSIwIDAgMTUwIDE1MCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=)![java-interview-questions-answers](https://www.javacodegeeks.com/wp-content/uploads/2012/10/enterprise-java-logo.jpg)](https://www.javacodegeeks.com/2020/05/how-to-install-apache-web-server-on-ec2-instance-using-user-data-script.html) ### [How to install Apache Web Server on EC2 Instance using User data script](https://www.javacodegeeks.com/2020/05/how-to-install-apache-web-server-on-ec2-instance-using-user-data-script.html) May 7th, 2020 Subscribe This site uses Akismet to reduce spam. [Learn how your comment data is processed.](https://akismet.com/privacy/) 0 Comments Oldest Newest Most Voted Inline Feedbacks View all comments Join Us ![Join Us](https://www.javacodegeeks.com/wp-content/uploads/2013/04/w4g-badge-150x150.png) With 1,240,600 monthly unique visitors and over 500 authors we are placed among the top Java related sites around. Constantly being on the lookout for partners; we encourage you to join us. So If you have a blog with unique and interesting content then you should check out our [JCG](https://www.javacodegeeks.com/join-us/jcg) partners program. You can also be a [guest writer](https://www.javacodegeeks.com/join-us/w4g) for Java Code Geeks and hone your writing skills\! Newsletter ![](data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIzMzUiIGhlaWdodD0iMzEwIiB2aWV3Qm94PSIwIDAgMzM1IDMxMCI+PHJlY3Qgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgZmlsbD0idHJhbnNwYXJlbnQiLz48L3N2Zz4=) ![](https://www.javacodegeeks.com/wp-content/uploads/2018/01/newsletter-bg.jpg) Insiders are already enjoying weekly updates and complimentary whitepapers\! Join them now to gain exclusive access to the latest news in the Java world, as well as insights about Android, JVM languages, cloud computing, Web development, DevOps, big data, Web3, blockchain programming and other related technologies. Email address: I agree to the [Terms](https://www.systemcodegeeks.com/about/terms-of-use/) and [Privacy Policy](https://www.javacodegeeks.com/about/privacy-policy/) [Sign up](https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html) #### Thank you\! We will contact you soon. Knowledge Base - [Courses](https://courses.javacodegeeks.com/) - [Examples](https://examples.javacodegeeks.com/) - [Minibooks](https://www.javacodegeeks.com/minibook) - [Resources](https://www.javacodegeeks.com/resources) - [Tutorials](https://www.javacodegeeks.com/tutorials) The Code Geeks Network - [.NET Code Geeks](https://www.dotnetcodegeeks.com/) - [Java Code Geeks](https://www.javacodegeeks.com/) - [System Code Geeks](https://www.systemcodegeeks.com/) - [Web Code Geeks](https://www.webcodegeeks.com/) Hall Of Fame - [“Android Full Application Tutorial” series](https://www.javacodegeeks.com/2010/10/android-full-application-tutorial.html) - [11 Online Learning websites that you should check out](https://www.javacodegeeks.com/2013/01/15-online-learning-websites-that-you-should-check-out.html) - [Advantages and Disadvantages of Cloud Computing – Cloud computing pros and cons](https://www.javacodegeeks.com/2013/04/advantages-and-disadvantages-of-cloud-computing-cloud-computing-pros-and-cons.html) - [Android Google Maps Tutorial](https://www.javacodegeeks.com/2011/02/android-google-maps-tutorial.html) - [Android JSON Parsing with Gson Tutorial](https://www.javacodegeeks.com/2011/01/android-json-parsing-gson-tutorial.html) - [Android Location Based Services Application – GPS location](https://www.javacodegeeks.com/2010/09/android-location-based-services.html) - [Android Quick Preferences Tutorial](https://www.javacodegeeks.com/2011/01/android-quick-preferences-tutorial.html) - [Difference between Comparator and Comparable in Java](https://www.javacodegeeks.com/2013/03/difference-between-comparator-and-comparable-in-java.html) - [GWT 2 Spring 3 JPA 2 Hibernate 3.5 Tutorial](https://www.javacodegeeks.com/2010/05/gwt-2-spring-3-jpa-2-hibernate-35-2.html) - [Java Best Practices – Vector vs ArrayList vs HashSet](https://www.javacodegeeks.com/2010/08/java-best-practices-vector-arraylist.html) About Java Code Geeks JCGs (Java Code Geeks) is an independent online community focused on creating the ultimate Java to Java developers resource center; targeted at the technical architect, technical team lead (senior developer), project manager and junior developers alike. JCGs serve the Java, SOA, Agile and Telecom communities with daily news written by domain experts, articles, tutorials, reviews, announcements, code snippets and open source projects. Disclaimer All trademarks and registered trademarks appearing on Java Code Geeks are the property of their respective owners. Java is a trademark or registered trademark of Oracle Corporation in the United States and other countries. Examples Java Code Geeks is not connected to Oracle Corporation and is not sponsored by Oracle Corporation. Java Code Geeks and all content copyright © 2010-2026, [Exelixis Media P.C.](https://www.exelixismedia.com/) \\| [Terms of Use](https://www.javacodegeeks.com/about/terms-of-use) \\| [Privacy Policy](https://www.javacodegeeks.com/about/privacy-policy) \\| [Contact](mailto:support@javacodegeeks.com) \\| Do not share my Personal Information \\| [Cookie Settings]() - [RSS](https://feeds.feedburner.com/JavaCodeGeeks) - [Facebook](https://www.facebook.com/javacodegeeks) - [X](https://twitter.com/javacodegeeks) - [LinkedIn](https://www.linkedin.com/groups/3810709/) - [YouTube](https://www.youtube.com/channel/UCxoUc7Rar2q90Gu0nT2ffuQ) - [GitHub](https://github.com/javacodegeeks/) [Facebook](https://www.facebook.com/sharer.php?u=https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html "Facebook") [X](https://x.com/intent/post?text=Neo4j%3A%20COLLECTing%20multiple%20values&url=https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html "X") [WhatsApp](https://api.whatsapp.com/send?text=Neo4j%3A%20COLLECTing%20multiple%20values%20https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html "WhatsApp") [Telegram](https://telegram.me/share/url?url=https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html&text=Neo4j%3A%20COLLECTing%20multiple%20values "Telegram") [Back to top button](https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html#go-to-tie-body) [Close](https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html) - [RSS](https://feeds.feedburner.com/JavaCodeGeeks) - [Facebook](https://www.facebook.com/javacodegeeks) - [X](https://twitter.com/javacodegeeks) - [LinkedIn](https://www.linkedin.com/groups/3810709/) - [YouTube](https://www.youtube.com/channel/UCxoUc7Rar2q90Gu0nT2ffuQ) - [GitHub](https://github.com/javacodegeeks/) [Close](https://www.javacodegeeks.com/2014/10/neo4j-collecting-multiple-values.html) wpDiscuz Insert
Readable Markdown	One of my favourite functions in Neo4j’s cypher query language is COLLECT which allows us to group items into an array for later consumption. However, I’ve noticed that people sometimes have trouble working out how to collect multiple items with COLLECT and struggle to find a way to do so. Consider the following data set: ``` create (p:Person {name: "Mark"}) create (e1:Event {name: "Event1", timestamp: 1234}) create (e2:Event {name: "Event2", timestamp: 4567}) create (p)-[:EVENT]->(e1) create (p)-[:EVENT]->(e2) ``` If we wanted to return each person along with a collection of the event names they’d participated in we could write the following: ``` $ MATCH (p:Person)-[:EVENT]->(e) > RETURN p, COLLECT(e.name); +--------------------------------------------+ \| p \| COLLECT(e.name) \| +--------------------------------------------+ \| Node[0]{name:"Mark"} \| ["Event1","Event2"] \| +--------------------------------------------+ 1 row ``` That works nicely, but what about if we want to collect the event name and the timestamp but don’t want to return the entire event node? An approach I’ve seen a few people try during workshops is the following: ``` MATCH (p:Person)-[:EVENT]->(e) RETURN p, COLLECT(e.name, e.timestamp) ``` Unfortunately this doesn’t compile: ``` SyntaxException: Too many parameters for function 'collect' (line 2, column 11) "RETURN p, COLLECT(e.name, e.timestamp)" ^ ``` As the error message suggests, the COLLECT function only takes one argument so we need to find another way to solve our problem. One way is to put the two values into a literal array which will result in an array of arrays as our return result: ``` $ MATCH (p:Person)-[:EVENT]->(e) > RETURN p, COLLECT([e.name, e.timestamp]); +----------------------------------------------------------+ \| p \| COLLECT([e.name, e.timestamp]) \| +----------------------------------------------------------+ \| Node[0]{name:"Mark"} \| [["Event1",1234],["Event2",4567]] \| +----------------------------------------------------------+ 1 row ``` The annoying thing about this approach is that as you add more items you’ll forget in which position you’ve put each bit of data so I think a preferable approach is to collect a map of items instead: ``` $ MATCH (p:Person)-[:EVENT]->(e) > RETURN p, COLLECT({eventName: e.name, eventTimestamp: e.timestamp}); +--------------------------------------------------------------------------------------------------------------------------+ \| p \| COLLECT({eventName: e.name, eventTimestamp: e.timestamp}) \| +--------------------------------------------------------------------------------------------------------------------------+ \| Node[0]{name:"Mark"} \| [{eventName -> "Event1", eventTimestamp -> 1234},{eventName -> "Event2", eventTimestamp -> 4567}] \| +--------------------------------------------------------------------------------------------------------------------------+ 1 row ``` During the [Clojure Neo4j Hackathon](http://www.meetup.com/graphdb-london/events/194308602/) that we ran earlier this week this proved to be a particularly pleasing approach as we could easily destructure the collection of maps in our Clojure code. [![Photo of Mark Needham](https://secure.gravatar.com/avatar/5489baed26ce2d932bf951ecfb47afe80bec45d3648c23521d87c83b8f1c3ea9?s=180&d=mm&r=g)](https://www.javacodegeeks.com/author/Mark-Needham)
Shard	27 (laksa)
Root Hash	14334457447596406227
Unparsed URL	com,javacodegeeks!www,/2014/10/neo4j-collecting-multiple-values.html s443