Re: [Neo4j] Any reporting tool for Neo4J ??

2017-07-05 Thread 'Michael Hunger' via Neo4j
Hi Sean, thanks for asking. 1. true that, some of that can be handled by custom browser guides or stored queries: https://neo4j.com/developer/guide-create-neo4j-browser-guide/ 2. hmm good point, we should investigate that 3. there is actually a Tableau10 WDC connector for neo4j:

Re: [Neo4j] Neo4J Get Data From Multiple Node with Multiple Relationship

2017-04-27 Thread 'Michael Hunger' via Neo4j
Then check the relationship (type and direction) from n to pulse if it exists. Michael On Thu, Apr 27, 2017 at 8:08 AM, Alliance Ais wrote: > Thanks for given your valuable time. But We cannot fetch any pulse that > you mentioned as *p2* in cypher Query. We get

Re: [Neo4j] Return common result between 2 different queries

2017-07-28 Thread 'Michael Hunger' via Neo4j
It should be simple to do it within one query match (u:Port1) WITH u, size( (u)-->() ) as outDegree, size ( (u)<--() ) as inDegree WHERE inDegree = 0 // root nodes RETURN u ORDER BY outDegree DESC LIMIT 5 On Fri, Jul 28, 2017 at 8:34 AM, Krishna Mahi wrote: > I want to

Re: [Neo4j] Passing a list as a parameter of session.Run in C#

2017-08-08 Thread 'Michael Hunger' via Neo4j
You need to pass a dictionary with a key of "values" and your list as value. On Tue, Aug 8, 2017 at 9:12 AM, wrote: > Hi, > > I have a query running something like this: > > WITH $values as values > MATCH (n:Node) > WHERE node.value in values > > How can I pass

Re: [Neo4j] Re: Multiple Neo4j schemas/databases on same server?

2017-08-07 Thread 'Michael Hunger' via Neo4j
Hi Ganesh, you'd have to manage the config file to start several instances of Neo4j with different port and database settings. Please try the new neo4j-desktop for that: Neo4j Desktop A platform for easily managing Neo4j installations on your personal desktop or laptop. Neo4j Desktop 0.3.5

Re: [Neo4j] Not able to access nodes outside of FOREACH clause

2017-08-04 Thread 'Michael Hunger' via Neo4j
The easiest way would be a multi-pass where you do the filters on the fields to create the nodes with WHERE and then a last pass for the relationships. Based on your code you can also do a second MERGE in the 2nd FOREACH // create the Enrich Graph node if value is not NA FOREACH(ignoreMe IN

Re: [Neo4j] label implementation details

2017-08-04 Thread 'Michael Hunger' via Neo4j
You need to supply more details, i.e. the queries, query plans, query times, how many labels you have per node etc. Michael On Fri, Aug 4, 2017 at 7:02 AM, Sun Yuhan wrote: > I tested the query like (a:A) --> (b:B) in two graphs. The two graphs have > the same graph

Re: [Neo4j] Load data from s3

2017-07-27 Thread 'Michael Hunger' via Neo4j
https://github.com/jenshadlich/S3-URLStreamHandler/blob/master/README.md Von meinem iPhone gesendet > Am 26.07.2017 um 23:48 schrieb srinu gajjala : > > Hi, > > Is there a way we can load data from s3. I have seen few posts talking about > loading data from an URL

Re: [Neo4j] Load data from s3

2017-07-27 Thread 'Michael Hunger' via Neo4j
You can add this library to your neo4j instance to add s3 as a protocol Von meinem iPhone gesendet > Am 26.07.2017 um 23:48 schrieb srinu gajjala : > > Hi, > > Is there a way we can load data from s3. I have seen few posts talking about > loading data from an URL

[Neo4j] Re: Struggling.....

2017-08-06 Thread 'Michael Hunger' via Neo4j
Hi Roger, best to join the neo4j.com/slack neo4j-users slack or the google group. there are a lot of helpful people. For your questions: 1. you don't need the "root" nodes, the label itself takes the function of that 2. for continuous variables I wouldn't create "categorical" nodes, I would

Re: [Neo4j] Data is loss when i use the UNWIND

2017-08-22 Thread 'Michael Hunger' via Neo4j
Not really sure what you want to achieve. WITH problem, collect(problem) doesn't make sense, as you are aggregating on problem, so you have all 1 element collections. You don't need unwind for collections, just use size(measures) On Wed, Aug 16, 2017 at 11:55 AM,

Re: [Neo4j] Easiest way to load my data...

2017-08-22 Thread 'Michael Hunger' via Neo4j
Hi Ryan, did you see this https://neo4j.com/developer/guide-import-csv/ With plain cypher it's a bit tricky, as you can't have dynamic labels. LOAD CSV FROM "url/file" AS row WHERE row.SOURCE_TYPE='PERSON' and row.TARGET_TYPE='ORGANIZATION' MERGE (p:Person {name:row.SOURCE}) MERGE

Re: [Neo4j] Best tool to migrate data from Oracle to Neo4J

2017-08-23 Thread 'Michael Hunger' via Neo4j
Can you try the neo4j-etl-components tool: https://github.com/neo4j-contrib/neo4j-etl-components/releases/tag/1.1.0 There is a new release coming soon. On Wed, Aug 23, 2017 at 9:56 AM, jai parkash Yadav < jaiparkashya...@gmail.com> wrote: > Dear Experts, > > I am new to Neo4J. I want to migrate

Re: [Neo4j] Re: Cypher::List all property keys allowed?

2017-05-03 Thread 'Michael Hunger' via Neo4j
call db.propertyKeys(); On Sun, Apr 30, 2017 at 11:36 AM, David Osumi-Sutherland wrote: > This seems to work: > >MATCH (n) with keys(n) AS kl UNWIND kl as k RETURN DISTINCT k; > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j"

Re: [Neo4j] System architecture

2017-05-03 Thread 'Michael Hunger' via Neo4j
There is a chapter on this in the graph databases book. you can get it at graphdatabases.com for free. Also if you google for neo4j internals there are some presentations (and blog posts). All a bit older but most still partially valid. On Thu, Apr 27, 2017 at 4:30 PM,

Re: [Neo4j] Neo4j v 3.1.0 failing test case MatchLongPatternAcceptanceTest.scala

2017-05-03 Thread 'Michael Hunger' via Neo4j
Can you share more details about the issue / error? Best as github issue as this is related to building the project. On Fri, Apr 28, 2017 at 8:18 AM, Ketan Kunde wrote: > Hi , > > I am trying to debug cause of failure for the test > MatchLongPatternAcceptanceTest.scala

Re: [Neo4j] Please erase http://portal.graphgist.org/graph_gists/nuliga-tennis-in-neo4j

2017-05-03 Thread 'Michael Hunger' via Neo4j
But your graph gist doesn't look so bad? You should be able to update your own? Or just ping us and we can do it. Meanwhile I recommend to use the preview functionality (either preview inline or the preview link). Michael On Thu, Apr 20, 2017 at 9:54 PM, tjh wrote: > I

Re: [Neo4j] Using the Output as Input in two differents APOC procedures.

2017-05-03 Thread 'Michael Hunger' via Neo4j
What of the paths returned by shortest path do you want to send to dijkstra? You can just get * nodes(path) for all nodes * nodes(path)[0] for the first, and [-1] for the last etc. MATCH (startNode:Hosts {IP:"10.0.0.1"}), (endNode:Hosts {IP:"10.0.0.4"}) call

Re: [Neo4j] export and import database using community edition 3.1.3

2017-05-03 Thread 'Michael Hunger' via Neo4j
Can you tell us more about your database (size, number of nodes / rels per label, degree distribution etc). 2. means export.cypher how did you import it again (exactly) -> it's meant to be used with cypher-shell or neo4j-shell 3. apoc.export.cypher can do it in a recent build (not relesed yet)

Re: [Neo4j] best approach for loading referential data

2017-05-03 Thread 'Michael Hunger' via Neo4j
You can have all the referential data in the graph and query it quickly. e.g. MATCH (c:Country) RETURN c or MATCH (c:Country) RETURN {id:c.code, name:c.name} or MATCH (c:Country) RETURN c.code as id, c.name as name On Fri, Apr 21, 2017 at 9:14 AM, wrote: > Hi

Re: [Neo4j] How to expand all nodes in web browser

2017-05-03 Thread 'Michael Hunger' via Neo4j
A similar feature will be available soon. Stay tuned. Von meinem iPhone gesendet > Am 21.04.2017 um 06:12 schrieb Noah Silverman : > > Hello, > > When I execute a query in the web browser, it gives me a very nice graph of > the returned nodes. Looks great. > >

Re: [Neo4j] Could not use Neosemantics plugin

2017-05-03 Thread 'Michael Hunger' via Neo4j
Sounds like a version issue, pleaese check the apoc docs for the right version to deploy to 3.1.3 Same for neosemantics Michael On Tue, May 2, 2017 at 6:45 PM, Sayed Nafiz Haider wrote: > I am facing problem while deploying the neosemantics plugin in Windows 10. > > I

Re: [Neo4j] Cypher query does not return resultset

2017-05-03 Thread 'Michael Hunger' via Neo4j
Can you run it with PROFILE and share the result picture? Then you'll see where it stops finding data. On Fri, Apr 28, 2017 at 4:52 PM, Igor Azarny wrote: > Hi All > > I've to migrate solution from neo4j 2nd version to 3rd. The query below > works ok in 2nd version, but does

Re: [Neo4j] Get number of hit pages in java api

2017-05-03 Thread 'Michael Hunger' via Neo4j
Why? Probably with low level monitoring SPIs, you gonna have to dive into the kernel internals for that. Perhaps a good way to start is to look how cypher's profiler / query listing does it in 3.2 Michael On Wed, May 3, 2017 at 8:34 PM, Sun Yuhan wrote: > I am using neo4j

Re: [Neo4j] Questions about import data neo4j

2017-05-03 Thread 'Michael Hunger' via Neo4j
1. there is a chapter in the free graphdatabases book on that 2. not efficiently as very fast disk-io is important 3. see above, we've done work to support block devices like IBMs CAPI Flash in Neo4j though What's your use-case / reason for these questions? Michael On Thu, Apr 27, 2017 at 4:42

Re: [Neo4j] Where is JmxUtils ?

2017-05-12 Thread 'Michael Hunger' via Neo4j
JmxUtils is still contained in : package org.neo4j.jmx public class JmxUtils { private static final MBeanServer mbeanServer = ManagementFactory.getPlatformMBeanServer(); public JmxUtils() { } public static ObjectName getObjectName(GraphDatabaseService db, String name) {

Re: [Neo4j] Neo4j 3.2 fatal bug ?

2017-05-12 Thread 'Michael Hunger' via Neo4j
I have to release a new APOC version over the weekend. Michael > Am 12.05.2017 um 19:21 schrieb unrealadmin23 via Neo4j > : > > Ha - Thanks Michael - that appears to do the trick. > Perhaps the error can be displayed in a less aggressive manner ! > > On another note,

Re: [Neo4j] What is "java.lang.NoSuchMethodError: org.neo4j.kernel.impl.util.ArrayMap.(BZZ)V" when I call newEmbeddedDatabase ?

2017-05-15 Thread 'Michael Hunger' via Neo4j
Best use a build too like maven / gradle and add org.neo4j:neo4j:3.2.0 as a dependency. It will pull all required dependencies for you. > Am 14.05.2017 um 22:23 schrieb Bill Nicholson > : > > This is what I have: > > > > On Sunday, May 14, 2017 at 3:49:23

[Neo4j] Live Streaming GraphConnect Keynote tomorrow !

2017-05-10 Thread 'Michael Hunger' via Neo4j
Hello Everyone, If you cannot make it to London for GraphConnect tomorrow, we have a special treat for you. We will be live streaming Emils Keynote around the world for you to watch in time or later on the day: Join our Online Meetup Group and be there with us for all the new announcements:

Re: [Neo4j] Neo4j 3.2 fatal bug ?

2017-05-12 Thread 'Michael Hunger' via Neo4j
Thanks for raising it, it's a fallback issue. But probably not that critical as you can prefix your query with CYPHER 2.3 start ... (or configure the cypher version in neo4j.conf) and start has been deprecated for a long while. Cheers, Michael > Am 12.05.2017 um 16:10 schrieb unrealadmin23

Re: [Neo4j] Regarding ACID/Transactional

2017-05-15 Thread 'Michael Hunger' via Neo4j
Neo4j is transactional, i.e. changes are isolated by an in-memory overlay per transaction (thread). Only at commit the change becomes visible to other threads (isolation-level read-committed). The same is guaranteed for a cluster, which also adds causal consistency for read-your-own-writes using

Re: [Neo4j] How to programmatically change the default password for a database that was just created.

2017-05-16 Thread 'Michael Hunger' via Neo4j
The embedded database doesn't have auth. For the server you can use `bin/neo4j-admin --set-initial-password "password"` Michael On Tue, May 16, 2017 at 4:27 AM, Bill Nicholson < delmerwilliamnichol...@gmail.com> wrote: > I programmatically created a Neo4j DB now I need to change the default PW

Re: [Neo4j] Auth Problem when connecting to Neo4j Server (Ubuntu)

2017-06-20 Thread 'Michael Hunger' via Neo4j
You can remove data/dbms/auth and try neo4j-admin again And then provide -u neo4j:password to curl for auth Von meinem iPhone gesendet > Am 21.06.2017 um 00:02 schrieb apprentice...@gmail.com: > > I'm trying to setup neo4j on ubuntu virtual server but having issues > connecting. > > curl -H

Re: [Neo4j] Auth Problem when connecting to Neo4j Server (Ubuntu)

2017-06-21 Thread 'Michael Hunger' via Neo4j
On Wed, Jun 21, 2017 at 10:18 AM, wrote: > http://localhost:7474/ this endpoint is unauthenticated: http://localhost:7474/ use to test: http://localhost:7474/db/data/ use /db/data/transaction not sure how the old endpoint works with regard to auth -- You received

Re: [Neo4j] Doubts in Graph representation

2017-06-21 Thread 'Michael Hunger' via Neo4j
We are using a means to draw arcs when there are overlapping edges. You can find the source in github.com/neo4j/neo4j-browser On Wed, Jun 21, 2017 at 8:15 AM, Vignesh Mano wrote: > I heard Neo4j is having client side framework too to represent the graph. > My doubt is

Re: [Neo4j] Run multiple neo4j db's in same machine on different ports

2017-06-21 Thread 'Michael Hunger' via Neo4j
you have to adapt both http port as well as bolt port (optionally https) in neo4j.conf for 3.x for 2.x it's neo4j.properties On Wed, Jun 14, 2017 at 10:05 AM, Sreejith C wrote: > How to run multiple neo4j in same machine on different ports ? > > I tried editing

Re: [Neo4j] Run multiple neo4j db's in same machine on different ports

2017-06-21 Thread 'Michael Hunger' via Neo4j
But please upgrade On Wed, Jun 21, 2017 at 12:14 PM, Michael Hunger < michael.hun...@neotechnology.com> wrote: > you have to adapt both http port as well as bolt port (optionally https) > in neo4j.conf > for 3.x > > for 2.x it's neo4j.properties > > > On Wed, Jun 14, 2017 at 10:05 AM, Sreejith C

Re: [Neo4j] The quickest way to ingest cypher (write operations)

2017-05-24 Thread 'Michael Hunger' via Neo4j
Use parameters and batching where possible. Also :begin ... :commit around larger blocks (eg 10k ops) where possible http://jexp.de/blog/2017/03/5-tips-tricks-for-fast-batched-updates-of-graph-structures-with-neo4j-and-cypher/ Von meinem iPhone gesendet > Am 24.05.2017 um 13:54 schrieb

Re: [Neo4j] Re: The quickest way to ingest cypher (write operations)

2017-05-27 Thread 'Michael Hunger' via Neo4j
Oh sorry didn't notice that. I suggest to use MERGE instead of create unique as it takes degrees of nodes into consideration at runtime. (create unique is deprecated too). So it would always check from the side with the fewer relationships. Michael > Am 27.05.2017 um 21:12 schrieb

Re: [Neo4j] How to disable auto increment Identifier (id) of the neo4j?

2017-05-28 Thread 'Michael Hunger' via Neo4j
Just set them as regular attribute, like "id" or "_id", you should also create a constraint on that label + id. e.g. create constraint on (p:Person) assert p.id is unique; The internal Neo4j id's are not meant for that purpose. > Am 17.05.2017 um 14:47 schrieb Andre Soares

Re: [Neo4j] How to find 'pattern' using Neo4j?

2017-05-28 Thread 'Michael Hunger' via Neo4j
For frequent patterns you could do something like this: MATCH (a)-[r]->(b) RETURN labels(a),type(r), labels(b), count(*) ORDER BY count(*) desc limit 10; But it's not very efficient as it is a full database scan What is your use-case ? What do you mean by "abnormal" patterns. Do you have any

Re: [Neo4j] query performance in shell vs browser

2017-05-28 Thread 'Michael Hunger' via Neo4j
see my other answer. (disable the auto-complete) Also you don't need the WITH in your query. How long does it take if you just return the tabular data, i.e. > match (a:Contig {id:"isotig1010.5"}) return a.id, properties(a); Can you also share the query plan? Michael > Am 23.05.2017 um 00:19

Re: [Neo4j] how to get faster visualization of a local db

2017-05-28 Thread 'Michael Hunger' via Neo4j
Which version are you using and which dataset and which query? You can disable the "auto-complete" feature in the sidebar settings in 3.2 (or auto-complete switch below the viz in 3.1) which pulls additional relationships between returned nodes. Michael > Am 22.05.2017 um 23:38 schrieb Isaac

Re: [Neo4j] Connection setting

2017-05-28 Thread 'Michael Hunger' via Neo4j
Not really you can limit the amount of threads in the server process. What's your use-case? Michael > Am 24.05.2017 um 09:19 schrieb ong jiancai : > > Is there a way to limit the amt of concurrent users for neo4j? > > -- > You received this message because you are

Re: [Neo4j] Not able to connect to the Neo4j 3.2.0 hosted on ubuntu server

2017-05-28 Thread 'Michael Hunger' via Neo4j
The 3.2.0 browser needs the bolt connection to talk to the server. It doesn't use an http connector anymore. If you need http stay at 3.1.x or use an 3.1.x browser-jar in your 3.2.0 installation. Michael > Am 18.05.2017 um 16:18 schrieb Deepak Nair : > > Hi, > > I

Re: [Neo4j] Re: neo4j browser display nodes as images

2017-05-28 Thread 'Michael Hunger' via Neo4j
s / icons and none derived from properties > unfortunately. > > Michael > > On Wed, Dec 28, 2016 at 11:34 AM, Koen Kleingeld <kdwykl...@gmail.com> wrote: > switched on .. so how do i link images to labels types .. where to store > images / icons .. is this already for 3.1 or for a

Re: [Neo4j] Re: The quickest way to ingest cypher (write operations)

2017-05-27 Thread 'Michael Hunger' via Neo4j
I presume you have a constraint on :Entity(name) Merge does match-or-create So it tries to find first and otherwise create Von meinem iPhone gesendet > Am 26.05.2017 um 12:16 schrieb unrealadmin23 via Neo4j > : > > John, Michael, > > Thank you for your suggestions.

Re: [Neo4j] Host my locally developped 'embedded' neo4j application.

2017-05-30 Thread 'Michael Hunger' via Neo4j
You can move the performance critical parts of the app into a server extension or procedure, which both access the embedded APIs. > Am 26.02.2017 um 23:52 schrieb Emmanuel Guedia : > > Hi everyone, is there a cloud platform supporting neo4j embedded? The ones I > have

Re: [Neo4j] Production application

2017-05-30 Thread 'Michael Hunger' via Neo4j
Also there has been a rich stream of interviews / podcasts, customers and case studies, if you're interested in these: neo4j.com/customers (customers, case-studies) https://www.youtube.com/playlist?list=PL9Hl4pk2FsvUOhz3gy68HvayMbaUZsH9T

Re: [Neo4j] How to validate an update cypher query against a schema?

2017-05-30 Thread 'Michael Hunger' via Neo4j
In general Neo4j is a schema free database so it's strength is in many other areas. Best would be to use a query generator/DSL that adhere's to the schema. You can look into the work on ontologies by my colleague Jesus:

Re: [Neo4j] Wrapper for neo4j to injest the son data in python

2017-06-01 Thread 'Michael Hunger' via Neo4j
What have you tried so far? Have a look here: https://neo4j.com/developer/guide-import-csv/ https://github.com/community-graph/twitter-import/blob/master/twitter-import.py > Am 31.05.2017 um 09:06 schrieb Ralph : > > Can anyone guide me how to create a python wrapper

Re: [Neo4j] Java OGM: session.load() returns a null object for existing ID

2017-06-01 Thread 'Michael Hunger' via Neo4j
Can you reproduce the issue using the template here: https://github.com/neo4j-examples/neo4j-sdn-ogm-issue-report-template > Am 01.06.2017 um 12:13 schrieb Joachim Nielandt : > > Hello all, > > I have a weird problem, where it's not clear to me where I should be

Re: [Neo4j] Import a website / online book into Neo4J

2017-05-04 Thread 'Michael Hunger' via Neo4j
Not sure if you've seen the NLP talks / blog posts around Neo4j, those import structure into the graph by linking words to sentences then you could paragraphs, chapters, parts and books on top of these. http://www.lyonwj.com/2015/06/16/nlp-with-neo4j/

Re: [Neo4j] Re: Neo4j display options (Nodes moving and lagging)

2017-05-07 Thread 'Michael Hunger' via Neo4j
Unfortunately it's not a RTFM issue (yet). But I could recommend that you could quickly grab an existing visualizaiton library like viz.js (see here): https://github.com/johnymontana/neovis.js And implement a quick visualizer that keeps not positions. You can just store the nodes by id to

Re: [Neo4j] Neo4j display options (Nodes moving and lagging)

2017-05-07 Thread 'Michael Hunger' via Neo4j
Hey Jeff, what is your main use-case? There are several approaches that settle the physics faster, but usually several thousand nodes on the display don't make so much sense? We're working on improving the UX for such cases but that also includes other means like level-of-detail, clustering

[Neo4j] Re: Quick question on Cypher

2017-05-05 Thread 'Michael Hunger' via Neo4j
a list of lists MATCH (p)-->(c) WITH p, collect(c) as children RETURN collect([p, children]) or a list of maps MATCH (p)-->(c) WITH p, collect(c) as children RETURN collect({parent:p, children:children}) or with pattern comprehensions MATCH (p) RETURN collect( [ (p)-->(c) | {parent:p,

[Neo4j] Re: Posibillity of uploading

2017-05-05 Thread 'Michael Hunger' via Neo4j
You can use a Platform like Heroku, AWS or GCE for that. You can run your Neo4j database on the same machine or use a cloud provider. Just configure your Neo4j database URL accordingly in your Flask app. There are some examples for that in:

Re: [Neo4j] Neo4j Conf Properties All Commented Out

2017-05-05 Thread 'Michael Hunger' via Neo4j
Because most of those settings are the defaults, or *recommendations/hints* if you want to change the defaults. Can you provide the 3 configs + all log files. > Am 05.05.2017 um 17:54 schrieb Dale Chang : > > As the title says, I was wondering why almost, if not, all

Re: [Neo4j] org.neo4j.kernel.DeadlockDetectedException: Unable to acquire exclusive lock

2017-05-05 Thread 'Michael Hunger' via Neo4j
Please provide all detail you have, esp. what kind of operation you run concurrently. > Am 05.05.2017 um 16:17 schrieb cong : > > Hi all, > I was in trouble when I was using the neo4j 2.3.3. How can I solve this > problem? Thanks for your kindly help. > >

Re: [Neo4j] Re: Get all nodes and endges between them

2017-05-04 Thread 'Michael Hunger' via Neo4j
MATCH (a:A {a:"a"}) WITH collect(a) as nodes MATCH (b:B {b:"b"}) WITH collect(b) + nodes as nodes MATCH (c:C {c:"c"}) WITH collect(c) + nodes as nodes UNWIND nodes as n MATCH (n)-[rel:X|Y|Z]->(m) WHERE n IN nodes RETURN n, rel, m On Thu, May 4, 2017 at 7:33 PM, Kamal Murthy

Re: [Neo4j] Storing data in Neo4j through Windows Hyper-V Manager & Bolt Protocol

2017-05-03 Thread 'Michael Hunger' via Neo4j
Where is nifi running? Does it use ssl ? So it's not the windows firewall and such? If you access browser from linux can you check in the browser settings that it uses bolt? Or perhaps use cypher-shell (apt-get install cypher-shell) to access neo4j from linux to windows? Btw if you get this up

Re: [Neo4j] Storing data in Neo4j through Windows Hyper-V Manager & Bolt Protocol

2017-05-03 Thread 'Michael Hunger' via Neo4j
cypher-shell is part of the neo4j download so you can just use that too, and run ./bin/cypher-shell I might not be a good help for windows firewall issues :( On Wed, May 3, 2017 at 11:53 PM, Dale Chang wrote: > browser -- You received this message because you are

Re: [Neo4j] 4000 lines of WARN [o.n.k.i.c.MonitorGc] GC Monitor: Application threads blocked for 279ms in one day

2017-09-17 Thread 'Michael Hunger' via Neo4j
In general, I would avoid running 2 databases on the same server, as both use also a considerable amount of off-heap memory. *What is your use-case / types of queries?* Not sure what version you're running as there is no 4.0.3 of Neo4j. What is your configuration of Neo4j (heap / page-cache) ?

Re: [Neo4j] Re: Match against multiple nodes

2017-09-17 Thread 'Michael Hunger' via Neo4j
Dave, do you think you could set up e.g. a graphgist with some sample data and the different queries you've tried? That would make it much easier to help and try out alternative queries Micahel On Sun, Sep 17, 2017 at 12:39 AM, Dave Clissold wrote: > Ok have found

Re: [Neo4j] is there an API in py2neo to get random node var

2017-09-17 Thread 'Michael Hunger' via Neo4j
I think those are just python object identifiers. you should be able to iterate over the records and access them from there. Michael On Wed, Sep 6, 2017 at 6:00 AM, Yanchun Ni wrote: > graph.data("MATCH(n) return n") > > output: > {u'n': (ccf5bfa:Person

Re: [Neo4j] How to mirror local database to remote server (hraphenedb) for backup purposes ?

2017-09-17 Thread 'Michael Hunger' via Neo4j
A diff via bolt would be a good idea. I currently don't know of such a tool. You could install APOC and use any of the apoc.export.cypher functions to export yoru db. Michael On Wed, Sep 6, 2017 at 10:11 AM, Dmitry Ponyatov wrote: > The problem is target side hosted on

Re: [Neo4j] how to use ActiveRecord with Neo4j . i am using ActiveRecord with neoid and neography gem .but i am facing an issue with create a record with getting No such ServerPlugin: "GremlinPlugin",

2017-09-17 Thread 'Michael Hunger' via Neo4j
Best ask in the gitter channel of neo4jrb.io Michael On Fri, Aug 4, 2017 at 4:09 PM, Nuttu Hariprasad wrote: > > > > hariprasad@Hari:~/Neo4J_Apps/sixth$ rake neo4j:start > Starting Neo4j... > WARNING: Max 1024 open files allowed, minimum of 40 000 recommended. See >

Re: [Neo4j] Printing date/time

2017-09-09 Thread 'Michael Hunger' via Neo4j
uot; > > RETURN apoc.date.format(timestamp(),'s','mm/dd/'); > "10/26/49657" > > Thanks > > > >> On Thu, Sep 7, 2017 at 5:50 PM, 'Michael Hunger' via Neo4j >> <neo4j@googlegroups.com> wrote: >> The last one is correct but witho

Re: [Neo4j] Printing date/time

2017-09-07 Thread 'Michael Hunger' via Neo4j
The last one is correct but without the [] Von meinem iPhone gesendet > Am 07.09.2017 um 23:43 schrieb Sean R : > > Thank you. > > Somehow my format is not changing. Am I missing anything ? > > 1. RETURN apoc.date.format(timestamp(),'mm//dd') > > ans: "2017-09-07

Re: [Neo4j] Neo4j 4.0.3 timeout with 4,000 transaction size sometimes

2017-09-12 Thread 'Michael Hunger' via Neo4j
Can you try to run the same workload with a different driver? e.g. Javascript or Java ? It seems that the client aborts the connection. Michael On Thu, Sep 7, 2017 at 4:52 AM, Ray Chengr wrote: > Three findings: > 1) Tried to use bolt instead of http. The same error still

Re: [Neo4j] Re: Match against multiple nodes

2017-09-30 Thread 'Michael Hunger' via Neo4j
On Mon, Sep 18, 2017 at 4:41 PM, Dave Clissold wrote: > Hi Michael > > I have submitted a gist for approval, interestingly whilst writing it I > found a better solution to the problem I was facing, would be great to get > your thoughts on it and if there might be a

Re: [Neo4j] Share some part of db between neo4j instances

2017-10-01 Thread 'Michael Hunger' via Neo4j
You can export them to cypher files or to any other format that is easy to diff, like sorted CSV JSON/XML are harder to diff / merge. Michael On Sun, Oct 1, 2017 at 5:41 AM, Dmitry Ponyatov wrote: > I have feew projects using neo4j. Every project uses its own neo4j >

Re: [Neo4j] tree structure, millions of nodes

2017-10-01 Thread 'Michael Hunger' via Neo4j
Yes definitely, I recently generated a tree of 10bn nodes/relationships for a prospect and then we ran deep aggregation queries in a few ms to seconds. The basic query is: MATCH path = (start:File {id: $startId })<-[:PARENT*20]-(child) RETURN nodes(path) Data import is also straightforward if

Re: [Neo4j] High memory consumption

2017-10-01 Thread 'Michael Hunger' via Neo4j
How / where do you call this? Why do you want to create an RDF model in Neo4j in the first place? *I can already tell you that's not a good idea.* *Do you have constraints for Entity(uri) and :Predicate(uri)? * The problem is the two Entity nodes, they will trigger an Eager operation in Cypher

Re: [Neo4j] Neo4J community edition DB size limit?

2017-10-01 Thread 'Michael Hunger' via Neo4j
Also for a educational purposes / students there are free enterprise licenses available if you're interested. Michael On Mon, Oct 2, 2017 at 1:34 AM, Michael Hunger wrote: > 2^35 Nodes and Relationships each > 2^36 Property-Records > > What is your use-case and scale

Re: [Neo4j] Neo4J community edition DB size limit?

2017-10-01 Thread 'Michael Hunger' via Neo4j
2^35 Nodes and Relationships each 2^36 Property-Records What is your use-case and scale ? Michael On Fri, Sep 29, 2017 at 11:22 PM, wrote: > Hi, > > > The Neo4J site states that the community version of Neo4J has a limit in > the graph size, but does not state the limit of

Re: [Neo4j] Inference engine (or Prolog/Datalog on top of neo4j)

2017-10-01 Thread 'Michael Hunger' via Neo4j
There is semspect from derivo as inference engine running on top of Neo4j https://www.linkedin.com/pulse/uncovering-hidden-springernatures-scigraph-thorsten-liebig/ Some work within neosemantics might support what you need. I think you need to detail

Re: [Neo4j] Allowing end users to make change to constraints?

2017-10-01 Thread 'Michael Hunger' via Neo4j
Depends on how you trust your power users, if you don't have constraints and still want to enforce them you'd need to have an admin create them. If you want people to query on these fields (only) then without indexes at least it won't be that fast for global queries. How about a mix, the power

Re: [Neo4j] Netty error

2017-10-02 Thread 'Michael Hunger' via Neo4j
It seems you're running into the open file descriptor limit, which defaults to 1024 on Linux. We recommend it to be at least 4. You can change it when you start your docker container, see here: https://neo4j.com/docs/operations-manual/current/installation/docker/#_file_descriptor_limit Can

Re: [Neo4j] tree structure, millions of nodes

2017-10-03 Thread 'Michael Hunger' via Neo4j
For 100m you can also use neo4j import which should import that volume in a few minutes Von meinem iPhone gesendet > Am 03.10.2017 um 15:49 schrieb Sarah C : > > Thank you very much Michael, I've done what you suggest and it looks great > but so far only

Re: [Neo4j] Re: Import delta

2017-08-22 Thread 'Michael Hunger' via Neo4j
This statement is idempotent, but also updates properties on nodes / rels HTH Michael LOAD CSV FROM "url" as row // get-or-create-node MERGE (n1:Node1 {row.id1}) // update prop SET n1.prop1 = row.prop1 // get-or-create-node MERGE (n2:Node2 {row.id2}) // update prop SET n2.prop2 = row.prop2 //

Re: [Neo4j] Does Neo4j 3.2.3 Community edition allow storage reuse?

2017-08-25 Thread 'Michael Hunger' via Neo4j
It's currently an enterprise only feature. B/c it's mostly useful for production deployments. Most Neo4j users have the qualitfication of using Neo4j Enterprise for free, so please check if that applies to you. Download the trial and talk to your representative. Cheers, Michael On Sat, Aug 26,

Re: [Neo4j] Merge multiple nodes into single node with relations

2017-08-28 Thread 'Michael Hunger' via Neo4j
elationships in & out.Sorry to bother but i am not > able to figure this out. > > On Aug 24, 2017 1:24 PM, "'Michael Hunger' via Neo4j" < > neo4j@googlegroups.com> wrote: > > That will happen automatically. > > On Thu, Aug 24, 2017 at 6:08 AM, Pawan Wagh <p

Re: [Neo4j] Merge multiple nodes into single node with relations

2017-08-23 Thread 'Michael Hunger' via Neo4j
You can use the apoc procedures with apoc.refactor.mergeNode([nodes]) https://neo4j-contrib.github.io/neo4j-apoc-procedures/#_graph_refactoring_2 Michael On Wed, Aug 23, 2017 at 4:22 PM, Pawan Wagh wrote: > Hii, > My current project runs on neo4j and mongodb as

Re: [Neo4j] What is "java.lang.NoSuchMethodError: org.neo4j.kernel.impl.util.ArrayMap.(BZZ)V" when I call newEmbeddedDatabase ?

2017-08-23 Thread 'Michael Hunger' via Neo4j
Can you share "mvn dependency:tree" to see where you have a version conflict? On Wed, Aug 23, 2017 at 2:13 PM, T L Andrews wrote: > Hi - I am having a very similar problem, for which StackOverflow has no > answer, after upgrading from version 2.2.10 in my project. > >

Re: [Neo4j] What is "java.lang.NoSuchMethodError: org.neo4j.kernel.impl.util.ArrayMap.(BZZ)V" when I call newEmbeddedDatabase ?

2017-08-24 Thread 'Michael Hunger' via Neo4j
use is slightly older. > > On Thu, Aug 24, 2017 at 1:44 AM 'Michael Hunger' via Neo4j < > neo4j@googlegroups.com> wrote: > >> Can you share "mvn dependency:tree" >> to see where you have a version conflict? >> >> On Wed, Aug 23, 2017 at 2:13 PM, T L An

Re: [Neo4j] Merge multiple nodes into single node with relations

2017-08-24 Thread 'Michael Hunger' via Neo4j
That will happen automatically. On Thu, Aug 24, 2017 at 6:08 AM, Pawan Wagh wrote: > > Thanks for your suggestion. But what about redirecting all relationships > of two nodes into that one node. > > > On Thursday, August 24, 2017 at 5:39:29 AM UTC+5:30, Michael Hunger wrote:

Re: [Neo4j] How to mirror local database to remote server (hraphenedb) for backup purposes ?

2017-09-02 Thread 'Michael Hunger' via Neo4j
In general, Neo4j Enterprise has a backup tool that backs up to fully operable graph database directories. You could shutdown, zip it up and upload it. Or just set up a Neo4j cluster that uses the remote servers as replicas. If you want to have continuous updates, then that would be more

Re: [Neo4j] Re: Model Driven Programming, Transformational programming and Software analysis in neo4j with graph rewrite

2017-09-02 Thread 'Michael Hunger' via Neo4j
Thanks a lot Dmitry, I will have a look. In general you could work around it by elevanting such expressions to a Node. Alternatively you can store some of the information on the relationship as just scalar properties. There has been some work in this area by Raoul Urma in his thesis, there are

Re: [Neo4j] Re: Looking for wisdom (rule of thumb) for labels/indexes versus relationships...

2017-10-09 Thread 'Michael Hunger' via Neo4j
You can also sub-structure the relationships from the subnet to represent the levels in the ip address. Otherwise it might also be possible to just store the IP as a numeric value array and use a filter on top of that array for the subnets (or a second property for the subnet). Michael On Thu,

Re: [Neo4j] How to start read code with understanding architecture ?

2017-10-19 Thread 'Michael Hunger' via Neo4j
Tom the Graph Databases Book which you can get for free on graphdatabases.com has a longer chapter on that topic. Otherwise the source is not too hard to understand if you spend some hours. For cypher there was a good article here: https://neo4j.com/blog/introducing-new-cypher-query-optimizer/

Re: [Neo4j] How to create a local DB ?

2017-10-19 Thread 'Michael Hunger' via Neo4j
I think you found a very old example. Use Neo4j Desktop 0.5.0 instead from this page: https://neo4j.com/download/other-releases/ It's easiest to use LOAD CSV to load data from a CSV file. Put them in the *import directory* of your database. LOAD CSV WITH HEADERS FROM "file://people.csv" AS row

Re: [Neo4j] How to set a statement Label info in Cypher?

2017-10-19 Thread 'Michael Hunger' via Neo4j
You cannot parameterize labels, rel-types and property-keys right now. You'll have to use string substitution, make sure to surround it with `%s` backticks and sanitize your input. Michael On Thu, Oct 19, 2017 at 8:55 AM, Stephen wrote: > According to Neo4j

Re: [Neo4j] How to set a statement Label info in Cypher?

2017-10-19 Thread 'Michael Hunger' via Neo4j
Oh and also you got it wrong, name is not a label but a property. session.run( "CREATE (:Person {name:$name})", parameters( "name", name ) ); On Thu, Oct 19, 2017 at 10:10 PM, Michael Hunger wrote: > You cannot parameterize labels, rel-types and property-keys right

Re: [Neo4j] What will the technical/performance implications be of having multiple neo4j instances in a startup scenario?

2017-10-19 Thread 'Michael Hunger' via Neo4j
As this is tiny, I think each istance is good enough if you give it 500MB to 1G memory each and 500M disk. The different graphs should be best isolated then, I think the docker image would be the easiest way to achieve that. Michael On Thu, Oct 5, 2017 at 11:13 PM, bryan rasmussen

Re: [Neo4j] Favorite queries are not filtered according to the current database

2017-10-19 Thread 'Michael Hunger' via Neo4j
It is stored in browser storage based on URL (host:port) There is currently no distiction by database. On Sun, Oct 8, 2017 at 10:46 AM, talsj39 wrote: > !When I open any of my databases I still can see queries which are related > to another database, I would like to view only

Re: [Neo4j] neo4j desktop

2017-11-28 Thread 'Michael Hunger' via Neo4j
On Tue, Nov 28, 2017 at 4:31 PM, koen wrote: > Hi all, i just started using neo4j desktop (previously i downloaded / used > the .zip file distributions) and this looks like a very handy frontend for > the neo4j database!!. I noticed a few things > > 1) it looks like i

Re: [Neo4j] If one MATCH is empty the entire query returns empty

2017-11-28 Thread 'Michael Hunger' via Neo4j
MATCH (p:Person) WHERE p.name =~ '(?i).test.*' WITH COLLECT(DISTINCT {name: p.name}) as persons OPTIONAL MATCH (pla:Place) WHERE pla.name =~ '(?i).*test.*' RETURN persons, [x IN COLLECT(DISTINCT pla) | {name: x.name}] as places On Tue, Nov 28, 2017 at 11:56 AM, wrote: > OK

Re: [Neo4j] Importing Paradise Papers relationships CSV file

2017-11-24 Thread 'Michael Hunger' via Neo4j
What is your error message? On Fri, Nov 24, 2017 at 10:02 AM, greg bahde wrote: > Hello, > Thanks for the scripts. I guess I have to change the sed command too, > since it doesn't work. > What did you change? I can't seem to make it work > > regards > > > Le jeudi 23

Re: [Neo4j] Best practise for huge data import in neo4j

2017-11-22 Thread 'Michael Hunger' via Neo4j
How much memory does your sever have? It should probably have 64G min, 16G for heap and 45G for page-cache. How big is your database on disk (especially neostore.*.db) What kind of disk do you have (you need a SSD). Use Neo4j 3.3.0 Enterprise You need also indexes/constraints for your nodes to

<    1   2   3   4   5   6   7   >