Re: [Neo4j] can u help me genrate cypher query ?

2023-05-09 Thread 'Michael Hunger' via Neo4j
Hi Shreyans,

would you mind sending it as a post to https://community.neo4j.com

Thank you,

Cheers, Michael

Twitter  | LinkedIn
 | GitHub  |
Blog  | Mastodon

Neo4j Germany GmbH; Viktualienmarkt 8, 80331 München, DE; AG M HRB 252331;
GF Mike Asher, Emil Eifrém


On Tue, May 9, 2023 at 1:32 PM Shreyansh shah 
wrote:

> Hello Team, I am facing a bit of a work problem,
>
> So i am using metaphors in the problem.
>
> I have imported two ontology using neosemantics in neo4j from RDf/TTL file
>
> Ontology 1. Actor
> Ontology 2. Movie
>
> Now import is completed.
>
> Now i have a csv file where both ontology are mapped using "URI" present
> in SKOS properties.
> Column A is having uri's from movie and column 2 is having uri's from
> actor.
>
> How can i load this csv file to generate relationships b/w already
> imported ontology.
>
> Basically question is how can map ontologies based on uri matching via CSV
> ?
>
> If any one please help me .
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/5e0cbac1-9480-4bb8-a164-eaab1811ae04n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWmTC4vn19myPFj_Hf2o%3D0KWHOpVBJhe2UE3vO3Pgp%2BHfQ%40mail.gmail.com.


Re: [Neo4j] Basic Neomodel db.cypher_query(...) that used to work, does no longer

2023-05-09 Thread 'Michael Hunger' via Neo4j
Hi Luna,

would you mind either opening this as an issue on the neomodel repository.
Or sending it as a post to https://community.neo4j.com

Thank you,

Cheers, Michael

Twitter  | LinkedIn
 | GitHub  |
Blog  | Mastodon

Neo4j Germany GmbH; Viktualienmarkt 8, 80331 München, DE; AG M HRB 252331;
GF Mike Asher, Emil Eifrém


On Tue, May 9, 2023 at 1:32 PM Luna Tuna  wrote:

> So here's a screenshot showing that it should work as in Neo4j browser:
>
> (See Untitled.png)
>
> The actual text of the query is:
>
>
> *MATCH (D:Diagram)-[:CONTAINS]->(X:Object), p=(X)-[:MAPS_TO*]->(:Object) 
> WHERE D.uid = 'abaaa79c616e40f9a07ae3b1acbac871' RETURN p ORDER BY length(p) 
> DESC*
>
> *Thank you!*
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/aa0a0f5d-d00f-4736-95f4-c078210b411fn%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWm1FhqPpmyWxRTEs3mEeue%2BbzA7o%3DCHEoSgCVyi9Qj%2B1A%40mail.gmail.com.


Re: [Neo4j] Can't able to import the CSV file to neo4j database

2022-08-19 Thread 'Michael Hunger' via Neo4j
Best checkout the new data importer tool

https://data-importer.neo4j.io
there is also a graphacademy course
https://graphacademy.neo4j.com/courses/importing-data/

you have to open the terminal and then there is a bin directory where
cypher-shell resides
if you're on windows it might be .\bin\cypher-shell




Join our new Community Site & Forum 

Neo4j Germany GmbH; Viktualienmarkt 8, 80331 München, DE; AG M HRB 252331;
GF Mike Asher, Emil Eifrém


On Fri, Aug 19, 2022 at 12:18 PM Ravi Leeladhar 
wrote:

> Hi All,
>
> I am following this article to import the csv file
> https://neo4j.com/developer/desktop-csv-import/
> as per the instruction Enter bin/cypher-shell i am getting below error
> 'bin' is not recognized as an internal or external command,
> operable program or batch file.
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/0d53e919-47a2-4bbd-aeaf-da90240875d4n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWnMTzDsUGYGb6ek740QpkgwLi8Dh-AQbA0EhHcqktFgJw%40mail.gmail.com.


Re: [Neo4j] Repository not found for neo4j-mobile-android

2021-01-30 Thread 'Michael Hunger' via Neo4j
Sorry, this effort was discontinued.

Join our new Community Site & Forum 


On Sat, Jan 30, 2021 at 9:03 PM 马欣宇  wrote:

> I want to use neo4j-mobile-android ( here is the github [
> https://github.com/neo4j-contrib/neo4j-mobile-android.git]
> ), but when using "git clone https://github.com/UrsBoehm/Neo4A.git
> ", there is an error [fatal: repository '
> https://github.com/UrsBoehm/Neo4A.git/' not found].
>
>
> Is this the repository failure? And how do I get Neo4A or use neo4j for 
> android?
>
>
> I would appreciate it if you could provide me with some useful information. 
> Thank you very much!
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/4378205c-727e-47d0-b31e-3db15be442f9n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWkG9F9Hz5Pxkd5tHouJ%3D3O47eUiE2T%2BCzY--euAV4N5EQ%40mail.gmail.com.


Re: [Neo4j] Unmanaged Extension

2021-01-22 Thread 'Michael Hunger' via Neo4j
The main focus for extensions these days are user defined procedures and
functions.
https://neo4j.com/developer/cypher/procedures-functions/
https://neo4j.com/docs/java-reference/current/extending-neo4j/procedures-and-functions/introduction/

Unmanaged extensions, i.e. having the database serve REST endpoints becomes
less common and moves into middleware.
So it's unlikely there will be more docs.

You will be able to find a number of examples and GH repositories on Max de
Marzi's blog:
https://maxdemarzi.com/

Join our new Community Site & Forum 


On Fri, Jan 22, 2021 at 1:14 PM Julien Piltant 
wrote:

>
> Hello guys,
>
> I'm trying to write an unmanaged extension. I find it very difficult to
> get some extensive documentation about neo4j apart from this :
> https://neo4j.com/docs/java-reference/4.2/extending-neo4j/http-server-extensions/
>
> Moreover javadoc.io does not provide documentation for versions above 3.9.
> I think I kinda crawled the entire internet about the subject...
>
> Can you help me with some good doc?
>
> Thank you guys.
> Have a good day
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/99a7a6ce-c38a-4200-bd98-13d5c7095310n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuW%3DGCTgnuu635xaCJ48UNrjcNmHMtm3wQqYEd4N8GSMSoQ%40mail.gmail.com.


Re: [Neo4j] Neo4j ETL takes time to migrate from RDBMS to Graph

2021-01-12 Thread 'Michael Hunger' via Neo4j
Postgres has a bug that makes this slow for remote databases. 

But that’s only for pulling the metadata. 

After that it should be fine

Von meinem iPhone gesendet

> Am 12.01.2021 um 22:07 schrieb Samir Kurry :
> 
> 
> Trying the option of going with ETL as in Production we would like to use 
> this option but once I start connecting my RDBMS to Graph as mentioned in the 
> link https://neo4j.com/labs/etl-tool, it is taking a lot of time and hovering 
> over a disabled START MAPPING button. as the attached link: Logs-ETL
> 
> Firstly the goal is to create a POC for ProductSales correlation, the current 
> dataset I am having has 175000 rows(can reduce the size) from two tables. 
> Once we know that it works then we look more into this. What would you all 
> recommend to get the graph for this?
> 
> Please let me know if any more information is needed.
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/neo4j/12420c0f-bbdc-4fe0-b56c-efbd25bd1dfdn%40googlegroups.com.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/477AC113-EC98-4337-8412-87DBDFF640D0%40neotechnology.com.


Re: [Neo4j] Neo4j Beginner

2021-01-05 Thread 'Michael Hunger' via Neo4j
yes, the neo4j.com/developer site is good. I suggest the training classes
in neo4j.com/graphacademy

And you can go to community.neo4j.com to ask questions, also to explain
what kind of project you're working on.

Join our new Community Site & Forum 


On Tue, Jan 5, 2021 at 10:51 PM Samir Kurry  wrote:

> I'm a beginner in Neo4j and am looking forward to learn it asap . After
> some research found that the developer section in Neo4j site is a better
> way to learn and also its YouTube channel. My goal is to make a proof of
> concept so that we can start implementing it Neo4j in our project. Can
> someone suggest/help if I can refer anything else which will quickly set me
> up?
> Thanks in advance, Samir Kurry
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/4bcee079-e31a-45b0-8718-02af7e724688n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuW%3Did0n2eszevi7Uoa7Cr8APS0bFEPvUzrmdy4rDBoeUDg%40mail.gmail.com.


Re: [Neo4j] Design Patterns

2020-12-07 Thread 'Michael Hunger' via Neo4j
There is a public graph modeling training that you can take and a follow up
(implementing graph models)

https://neo4j.com/graphacademy/training-gdm-40/enrollment/

Join our new Community Site & Forum 


On Mon, Dec 7, 2020 at 12:55 PM mr. Doctor  wrote:

> I'm starting to work with the neo4j and I need info about Design Patterns
> for this database. I would be glad to have any information on the topic.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/98a6b661-cc8a-464a-ac45-e11570317e04n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWnkdQX3f39dWOtcejnvFRCE9C1CEi7qM_EQxw0Xgr3Sgg%40mail.gmail.com.


Re: [Neo4j] PropertyRecord claims to have more property blocks than can fit in a record

2020-12-07 Thread 'Michael Hunger' via Neo4j
Just create a copy.

Join our new Community Site & Forum <https://community.neo4j.com>


On Mon, Dec 7, 2020 at 12:56 PM Filippo Grazioli 
wrote:

> Hello Michael,  thanks for your reply.
>
> Version is 4.1.1.
>
> Could you please clarify how neo4j-admin copy creates a fixed version?
>
> Is there some specific flag I should use to fix it, or simply create a
> copy?
>
> Thanks,
> Filippo
>
> Il giorno mercoledì 25 novembre 2020 alle 12:13:12 UTC+1 Michael Hunger ha
> scritto:
>
>> Hi,
>>
>> seems to be a issue with your store.
>> What is your database version?
>> Perhaps neo4j-admin copy would help for creating a fixed version of the
>> store.
>>
>> Michael
>>
>> Join our new Community Site & Forum <https://community.neo4j.com>
>>
>>
>> On Wed, Nov 25, 2020 at 12:10 PM Filippo Grazioli 
>> wrote:
>>
>>>
>>> Hello,
>>>
>>> I have a graph with 300k nodes and 4M relationships.
>>>
>>> I'd like to query all triples:
>>> MATCH p=()-[]->() RETURN p
>>>
>>> I get the following error:
>>> Neo.DatabaseError.Statement.ExecutionFailed org.neo4j.io.pagecache
>>> .CursorException: PropertyRecord claims to have more property blocks
>>> than can fit in a record
>>>
>>> Do you know what goes wrong? Thanks.
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to neo4j+un...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/neo4j/c180b9f7-ada9-4453-b9e9-1875bc2aac28n%40googlegroups.com
>>> <https://groups.google.com/d/msgid/neo4j/c180b9f7-ada9-4453-b9e9-1875bc2aac28n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/582f76c6-3a9e-4c0e-84a4-1fc665a06040n%40googlegroups.com
> <https://groups.google.com/d/msgid/neo4j/582f76c6-3a9e-4c0e-84a4-1fc665a06040n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWm1s6QT0Qp8Msigx-8aHrXJdZofDgG-b9OGGhfSOxxQ6g%40mail.gmail.com.


Re: [Neo4j] neo4j 4.1.3 -> Where condition with count not working as expected

2020-12-07 Thread &#x27;Michael Hunger' via Neo4j
Best to send questions like this to community.neo4j.com

In general if you aggregate, you must not add the thing you want to count /
aggregate on as an aggregation key, you can use collect on those.

MATCH (echk:REC {id: 'abcdef'})
OPTIONAL MATCH (p:Person) WHERE p.name CONTAINS 'Shirley'
WITH collect(p) as people, echk, count(p) as personcnt where personcnt=1
UNWIND people as p
MERGE (p)-[:TEST]->(echk)

You don't need apoc.merge.relationship for your case you can just use
cypher.



Join our new Community Site & Forum 


On Mon, Dec 7, 2020 at 12:55 PM 'Shanthi Viswanathan' via Neo4j <
neo4j@googlegroups.com> wrote:

> I am using neo4j 4.1.3. I have 2 labels : Person and Rec. I need to create
> a relationship between these 2 only when there exists exactly one person
> with that last name. When I run the below, relationships are created for
> all persons with that last name. My code is below:
>
> MATCH (echk:REC {id: 'abcdef'}) OPTIONAL MATCH (p:Person) WHERE p.name
> CONTAINS 'Shirley' WITH p, echk, count(p) as personcnt where personcnt=1
> CALL apoc.merge.relationship(p, 'Test', {}, {}, echk, {}) YIELD rel RETURN
> p, echk, rel
>
> I have 33 people with "Shirley' and 33 relationships are getting created
> with that REC. However, there should be no relationship because personcnt
> <> 1. When I just write
> OPTIONAL MATCH (p:Person) WHERE p.name CONTAINS 'Shirley'  return
> count(p) -> I get 33 as the value. I am not sure why my where condition is
> not kicking in.
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/9f5043ee-fec0-4f0b-94e4-85d9b6ee8a45n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWkzsZDo0pXf1FFyshohXFqOd2%2BAjDimCfGyU0v8q7QjFQ%40mail.gmail.com.


Re: [Neo4j] PropertyRecord claims to have more property blocks than can fit in a record

2020-11-25 Thread &#x27;Michael Hunger' via Neo4j
Hi,

seems to be a issue with your store.
What is your database version?
Perhaps neo4j-admin copy would help for creating a fixed version of the
store.

Michael

Join our new Community Site & Forum 


On Wed, Nov 25, 2020 at 12:10 PM Filippo Grazioli 
wrote:

>
> Hello,
>
> I have a graph with 300k nodes and 4M relationships.
>
> I'd like to query all triples:
> MATCH p=()-[]->() RETURN p
>
> I get the following error:
> Neo.DatabaseError.Statement.ExecutionFailed org.neo4j.io.pagecache
> .CursorException: PropertyRecord claims to have more property blocks than
> can fit in a record
>
> Do you know what goes wrong? Thanks.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/c180b9f7-ada9-4453-b9e9-1875bc2aac28n%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWmFo9X3WQgD5Jbim8dAj%3DL23RSW6LGTajETLx5eD8cR7g%40mail.gmail.com.


Re: [Neo4j] Neomodel for neo4j 4.x

2020-08-19 Thread &#x27;Michael Hunger' via Neo4j
We’re looking into it from a community perspective. 

Von meinem iPhone gesendet

> Am 19.08.2020 um 18:21 schrieb 'Nigel Small' via Neo4j 
> :
> 
> 
> Hi Monica
> 
> Unfortunately, we don't support or maintain neomodel in-house. I'm not sure 
> it even has a current maintainer right now, either, but you're probably best 
> off asking on the project's GitHub issues list. If you're after a general 
> purpose OGM for Python, though, I do offer this in py2neo as well.
> 
> Nigel
> 
>> On Sat, 15 Aug 2020 at 01:03, Monica Gatti  wrote:
>> Hi guys,
>> is supposed that a new version of neomodel can support neo4j 4.x?
>> At now, neomodel supports only neo4j 3.0, 3.1, 3.2, 3.3 
>> Any news?
>> Thanks in advance
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to neo4j+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/neo4j/b464604b-bb03-4245-b02a-8e7da2b13eb4o%40googlegroups.com.
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/neo4j/CACYW5h7ANUta8_kyrzFv8z2LhWsa%2B%2BddyudODA1Q%3DTcajVh%3DJA%40mail.gmail.com.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/A85C016A-360D-4907-9BFE-D9B89F71B780%40neotechnology.com.


Re: [Neo4j] :style in 4.1

2020-07-08 Thread &#x27;Michael Hunger' via Neo4j
Hi Roger,

this looks like a bug, would you mind raising it as a GitHub issue at
https://github.com/neo4j/neo4j-browser/issues?

Thanks so much,

Michael

Join our new Community Site & Forum 


On Wed, Jul 8, 2020 at 10:00 PM Roger Stone  wrote:

> I have edited the .grass sheet in the past with no problems - but 4.1
> seems to have me beaten
>
> I used to edit it (and I seem to remember I could give it any name I liked
> so long as it was saved as a .grass file) drop it in the favourites ares
> and... job done. Not Any More - or so it seems.
>
> If I do this now I am offered two option - save to favourites or put
> straight into the editor. So, if I put it into the editor and set it going
> - it chunters for a bit, seems ok and - has no effect on the style whether
> I call it style.grass or anything else.grass. Stopping and restarting the
> db has no effect.
>
> If I by pass the drag and drom and simply paste the new file into the
> browser - prefixed by :style as a command then I get:
>
> Neo.ClientError.Statement.SyntaxError: Invalid input 'l': expected 'n/N' 
> (line 1, column 3 (offset: 2))
> "color: #A5ABB6"
>^
> Which is calling an error in a line I have not touched! If I try using :style 
> and entering only the style statement that I want to change then I get an 
> error message as follow - essentially exactly the same:
>
> :style node.ConRod { defaultCaption: ""
>
>-
>
> caption: "{desc}"
>
>-
>
> ERROR
>
> Neo.ClientError.Statement.SyntaxError: Invalid input 'p': expected 't/T' or 
> 'l/L' (line 1, column 3 (offset: 2))
> "caption: "{desc}""
>^
>
> }
>
>-
>
> What and I doing wrong?
>
> Many thanks
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/e8325d75-2f60-44f1-8c5f-bccde0b9ce9co%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWnV9ZAQmNAekzyyG5-yEhV5H%2Bp3666hY1p7Wbf_Krpevw%40mail.gmail.com.


Re: [Neo4j] relationship property injestion in nodeEntity

2020-06-09 Thread &#x27;Michael Hunger' via Neo4j
Either add the property to your domain model or use DynamicProperties. 


Von meinem iPhone gesendet

> Am 09.06.2020 um 23:37 schrieb KASUBA BADRI VISHAL 
> :
> 
> 
> Hii Folks,
> 
> I am having a doubt regarding how to inject a property into an existing 
> relationship not by cypher query but through crud repository or annotations
> 
> Thank you
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/neo4j/be6c488d-fb29-4887-ab30-1f1f2b4ecd25o%40googlegroups.com.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/E255588C-12C0-418C-8791-B4E2F5FCB9E8%40neotechnology.com.


Re: [Neo4j] https://m2.neo4j.org seems to be down

2020-05-25 Thread &#x27;Michael Hunger' via Neo4j
Hi,

another option would be to build it locally and add it to your local maven
repo to be used in the build.
Do you use Cypher DSL in the project or is it just a dependency?

Otherwise if you want to resurrect your project I recommend moving to
SDN-RX going forward.

We plan to archive cypher-dsl in favor of the internally maintained one
that's used by SDN-RX:
https://github.com/neo4j/sdn-rx/tree/master/neo4j-opencypher-dsl
Which will be going to maven central as its own module from the next
release on.

Cheers, Michael

Join our new Community Site & Forum 


On Mon, May 25, 2020 at 11:15 AM Lasse Westh-Nielsen 
wrote:

> Hey Paulo,
>
> It was me who shut m2.neo4j.org down recently. We were no longer using it
> ourselves and thought it was safe to shut down, because we thought it was
> just a mirror for Maven Central. It _used to_ host snapshot artifacts for
> us, but we no longer produce those.
>
> Anyway to solve the problem: I don't suppose you are able to downgrade to
> 1.7? Because that one I can find on Maven Central:
> https://search.maven.org/artifact/org.neo4j/neo4j-cypher-dsl/1.7/jar
>
> A better solution of course would be to find that 2.0.1 artifact and
> publish it to Maven Central. I have CC'ed my colleague Michael who might
> know something - Michael? I also wonder if alternatives exist, again
> Michael will know.
>
> Lastly, we would be able to start the thing up again for some time, but we
> really want to retire m2.neo4j.org for good.
>
> Hope that helps!
>
> Regards,
>
> Lasse
>
>
> On Mon, 25 May 2020 at 11:00, Paulo Sérgio Medeiros 
> wrote:
>
>> I have an old project which uses spring data and neo4j. I'm trying to
>> build it, but maven is not able to find the neo4j-cypher-dsl dependency.
>>
>> This is the error that I'm getting from maven:
>>
>> [ERROR] Failed to execute goal on project evidencefactory: Could not
>> resolve dependencies for project
>> com.evidencefactory:evidencefactory:war:0.9-SNAPSHOT: Failed to collect
>> dependencies at
>> org.springframework.data:spring-data-neo4j-rest:jar:3.1.0.RELEASE ->
>> org.springframework.data:spring-data-neo4j:jar:3.1.0.RELEASE ->
>> org.neo4j:neo4j-cypher-dsl:jar:2.0.1: Failed to read artifact descriptor
>> for org.neo4j:neo4j-cypher-dsl:jar:2.0.1: Could not transfer artifact
>> org.neo4j:neo4j-cypher-dsl:pom:2.0.1 from/to neo4j (http://m2.neo4j.org/
>> ): *Failed to transfer
>> file 
>> http://m2.neo4j.org/org/neo4j/neo4j-cypher-dsl/2.0.1/neo4j-cypher-dsl-2.0.1.pom
>> 
>>  with
>> status code 502 -> [Help 1]*
>>
>>
>>
>> Is there a Neo4j maven repository for old dependencies?
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to neo4j+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/neo4j/626e18d2-3012-4deb-b931-ec99b2429e0c%40googlegroups.com
>> 
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWnFBjWKJsJOJJu8nQDz3ytJKFUVUUGaPuawtfvhLhQpNA%40mail.gmail.com.


Re: [Neo4j] Re: Is Neo4j Apache License compatible?

2020-02-01 Thread &#x27;Michael Hunger' via Neo4j
As Benoit said,

*there is no issue connecting an MIT app via the Apache Drivers to the GPL
server. So you can continue to use that forever. And all this discussion is
moot.*

if you exceed the startup program (i.e 3M revenue, 50 employees) then a
cloud service like Aura should be quite affordable (which starts right now
at $60 a month, there will be cheaper tiers later) for your needs.

For the other databases you still have to pay for hosting (your cloud
provider, or their cloud offering) and operations (one of your employees).

After all the engineers and other folks working on Neo4j also want to feed
and house their families, same as you.

Michael


Join our new Community Site & Forum 


On Thu, Jan 30, 2020 at 12:29 PM Benoît Simard  wrote:

> Hi,
>
> All the neo4j official drivers are under the Apache 2.0 license, so they
> can be used with an MIT project, there is no problem on that.
>
> About the database itself, there are two editions  :
> * Community under the GPLv3
> * Enterprise under a commercial license
>
> And you can use Neo4j in two modes :
> * As a server
> * Or embedded in your code (for java application)
>
> The GPL license is viral when you are using the embedded mode of Neo4j,
> because your code needs to be compliant with the GPL.
> But it's not the case when you are using the server mode.
> For a remote use with Apache v2 driver, there is really no problem (in
> fact that's why the drivers are using the apache license).
>
> There is a separation between the license of your application code (+ the
> drivers), and the license of the remote database server.
>
> So you can use Neo4j (community or enterprise) in server mode for your MIT
> project without any risk (for example, mysql community is also under a GPL
> license).
> But if you modify neo4j's code in the community edition, you have to put
> the code in GPL.
>
> The only point you need to be focus on, is the *distribution* of your
> application.
>
> And I have a last point to do about open-source, the GPL license is made
> by the Free Software Fundation, so GPL is free software. It respects the
> freedom to use, copy, study, modify the code (with a redistribution of the
> modifications) .
>
> Hope it helps.
>
> Cheers
>
> Le dimanche 15 janvier 2012 10:22:10 UTC+1, Harald Wellmann a écrit :
>>
>> True or false: copyleft is contagious, so if library A uses library B
>> which is GPLed, and if library A is distributed, then library A must
>> also be licensed under GPL.
>>
>> If this is true, then how can Spring Data Neo4j be published under an
>> Apache License, whereas Neo4j is published under GPL?
>>
>> If this is false, does that mean I can write a software component using
>> Neo4j and publish it under an Apache License?
>>
>> Best regards,
>> Harald
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/e6f23a10-7476-4e06-92d4-57dcf2ae6701%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuW%3DAue1PEirPo4RW9Q2%2Bu8RNWfP82bS1122LOKe_6g-Mhw%40mail.gmail.com.


Re: [Neo4j] What is the best practice to archive the Node Entity

2020-01-30 Thread &#x27;Michael Hunger' via Neo4j
You could for instance relabel them, i.e. add an `:Old` label or even
replace the label with `:OldTrip` so they are still around but will not be
picked up anymore by your queries.

Btw. we moved away from google groups so please -> Join our new Community
Site & Forum 


On Wed, Jan 29, 2020 at 8:24 PM Rajesh Waran 
wrote:

> Hi All,
>
> Good day and compliments for the new year.
>
> I have just started with Neo4j Graph implementation for a project. I have
> use case where I cannot keep the same Node Entity on a daily basis for
> example
>
> I have Travel as main node and Trip as child node.
>
> Every Travel Node is created with List of Trip, and this activity happens
> on daily basis.
>
> Before end of each day the Trip needs to removed and archived and next day
> new set of trips are created.
>
> I want to keep the Old trips for analytics and cannot delete them.
>
> What is the best practices to achieve this ?
>
> Should I have another store where I should move the historical trips or is
> there something that I can manage in Neo4J.
>
> Any guidance on this regard would be of great help.
>
>
> Regards
> Rajesh
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/0bbc69af-7d32-4c0e-9fb6-a59e8a7e2ab1%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuW%3Ds49Xg1q%2B9eEuBzdA95_KCJJH%3DhbAW6LyRSPZ%2Bud_nBQ%40mail.gmail.com.


Re: [Neo4j] Complex schema constraints and constraint discovery - anyone tried it?

2019-10-21 Thread &#x27;Michael Hunger' via Neo4j
Did you see the ontology checking article on
https://jbarrasa.com/2016/04/06/building-a-semantic-graph-in-neo4j/
There is also imho a constraints extension from GraphAware for that.

I think you should also be able to use apoc triggers to veto transactions
that violate your constraints.

Join our new Community Site & Forum 


On Mon, Oct 21, 2019 at 8:38 PM Mark Novak  wrote:

> I have a requirement of placing a set of constraints on nodes,
> relationships and properties, and making these discoverable.
>
> For instance, a constraint might be that a relationship X may exist
> between nodes with labels A and B, , D and B, or B and C, but not between A
> and C or A and D.
> Or, a constraint may be that a property P set on a node with label A might
> only have a number of valid values: P1 or P2. An attempt to create a node
> with label A and a property P set to anything other than P1 and P2 would be
> invalid.
>
> Further, I'd like to be able to query these constrains to offer only legal
> choices when new nodes and relationships are created.
>
> Has anyone had a similar problem? How have you solved it?
>
> I am thinking of modeling these constraints as a graph in their own right,
> but maybe there is an existing solution or idea I should look at?
>
> Thanks!
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/0d6a5341-a686-4dde-9f9c-736ce8fcf3e6%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWkzDUKdiewJhscf6iHpg9hjivaie6PtghU_TWorZy819Q%40mail.gmail.com.


Re: [Neo4j] Neo4j: The client has provided incorrect authentication details too many times in a row.

2019-10-21 Thread &#x27;Michael Hunger' via Neo4j
I think you have to restore the auth folder to the same content as
the other cluster members


On Mon, Oct 21, 2019 at 8:38 PM Srihari Prabhakar 
wrote:

> Hi folks,
>
> I am getting the below error when logging in to one of the server in
> causal cluster.
>
> [root@neo-vm1~]# cypher-shell -uneo4j -p## -a'##'
> The client has provided incorrect authentication details too many times in
> a row.
>
> It is a 3 node cluster, connection to other 2 nodes is fine.
>
> I have tried restarting the server, then I removed auth files in folder
> "DATADIR/dbms", still facing the same issue. How do I fix this?
>
> Thanks in advance..
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/a32c16ec-20ba-4676-a3c8-00646091d085%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuW%3Dd1%3DsDo4xMBXD10ZNXpfVyji%3Dji3b9EOjgjMJuFf7wcg%40mail.gmail.com.


Re: [Neo4j] Free AWS EC2 with neo4j

2019-10-13 Thread &#x27;Michael Hunger' via Neo4j
To start learning you can just use Neo4j Sandbox https://neo4j.com/sandbox

The medium instance is for running real applications, you can definitely
scale that down. I don't remember what the micro size was, but if you have
512m for Neo4j that should do.

Join our new Community Site & Forum 


On Sun, Oct 13, 2019 at 5:38 PM Kevin Burton 
wrote:

> I went to the AWS Marketplace and noticed that images with Neo4j installed
> start with a t2.medium image. To start learning Neo4j I am not able to
> afford this. I see that AWS free tier is at t2.micro. Are the resource
> requirements of Neo4j that would make the image not an option?Are their
> free or very cheap ways to load my own data on?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/neo4j/e5788345-df7a-406e-8735-16f0b9c113ed%40googlegroups.com
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/neo4j/CAKZwuWkxjLjKDdGzxVTQw7uqF_g3HHHSmKZ%2BmiS6wyfZ6M%2B_Pg%40mail.gmail.com.


Re: [Neo4j] Re: Neo4J Connectivity Issue

2019-09-04 Thread &#x27;Michael Hunger' via Neo4j
Best join our new Community Site & Forum  for
questions.
The mailing list is not really active anymore.

I think you'll need to install a certificate for your server, see here:
https://medium.com/neo4j/getting-certificates-for-neo4j-with-letsencrypt-a8d05c415bbd


On Wed, Sep 4, 2019 at 4:10 PM ARUMUGAM PILLAI 
wrote:

> Team  - ANybody can help on this?
>
> On Monday, August 26, 2019 at 7:15:56 PM UTC-4, ARUMUGAM PILLAI wrote:
>>
>> Team,
>> Recently i have tried to configure the neo4j Graph DB on the AWS
>> EC2 instance and accessing using the UI.  But when we connecting am getting
>> the below error.
>>
>> *Hostname* : ne04j.dev.eis.nylcloud.com
>> *ELB *:
>> http://internal-neo4j-dev-i-elb-650335371.us-east-1.elb.amazonaws.com/browser/
>>
>> *Images *- Attached
>>
>> *Error*:  ServiceUnavailable: WebSocket connection failure. Due to
>> security constraints in your web browser, the reason for the failure is not
>> available to this Neo4j Driver. Please use your browsers development
>> console to determine the root cause of the failure. Common reasons include
>> the database being unavailable, using the wrong connection URL or temporary
>> network problems. If you have enabled encryption, ensure your browser is
>> configured to trust the certificate Neo4j is configured to use. WebSocket
>> `readyState` is: 3
>>
>> *Configuration Details :*
>>
>>
>> #*
>> # Neo4j configuration
>> #
>> # For more details and a complete list of settings, please see
>> #
>> https://neo4j.com/docs/operations-manual/current/reference/configuration-settings/
>> #*
>>
>> # The name of the database to mount
>> #dbms.active_database=graph.db
>>
>> # Paths of directories in the installation.
>> dbms.directories.data=/var/lib/neo4j/data
>> dbms.directories.plugins=/var/lib/neo4j/plugins
>> dbms.directories.certificates=/var/lib/neo4j/certificates
>> dbms.directories.logs=/var/log/neo4j
>> dbms.directories.lib=/usr/share/neo4j/lib
>> dbms.directories.run=/var/run/neo4j
>>
>> # This setting constrains all `LOAD CSV` import files to be under the
>> `import` directory. Remove or comment it out to
>> # allow files to be loaded from anywhere in the filesystem; this
>> introduces possible security problems. See the
>> # `LOAD CSV` section of the manual for details.
>> dbms.directories.import=/var/lib/neo4j/import
>>
>> # Whether requests to Neo4j are authenticated.
>> # To disable authentication, uncomment this line
>> #dbms.security.auth_enabled=false
>>
>> # Enable this to be able to upgrade a store from an older version.
>> #dbms.allow_upgrade=true
>>
>> # Java Heap Size: by default the Java heap size is dynamically
>> # calculated based on available system resources.
>> # Uncomment these lines to set specific initial and maximum
>> # heap size.
>> #dbms.memory.heap.initial_size=512m
>> #dbms.memory.heap.max_size=512m
>>
>> # The amount of memory to use for mapping the store files, in bytes (or
>> # kilobytes with the 'k' suffix, megabytes with 'm' and gigabytes with
>> 'g').
>> # If Neo4j is running on a dedicated server, then it is generally
>> recommended
>> # to leave about 2-4 gigabytes for the operating system, give the JVM
>> enough
>> # heap to hold all your transaction state and query context, and then
>> leave the
>> # rest for the page cache.
>> # The default page cache memory assumes the machine is dedicated to
>> running
>> # Neo4j, and is heuristically set to 50% of RAM minus the max Java heap
>> size.
>> #dbms.memory.pagecache.size=10g
>>
>> #*
>>
>> # Network connector configuration
>> #*
>>
>> # With default configuration Neo4j only accepts local connections.
>> # To accept non-local connections, uncomment this line:
>> dbms.connectors.default_listen_address=ne04j.dev.eis.nylcloud.com
>>
>> # You can also choose a specific network interface, and configure a
>> non-default
>> # port for each connector, by setting their individual listen_address.
>>
>> # The address at which this server can be reached by its clients. This
>> may be the server's IP address or DNS name, or
>> # it may be the address of a reverse proxy which sits in front of the
>> server. This setting may be overridden for
>> # individual connectors below.
>> dbms.connectors.default_advertised_address=ne04j.dev.eis.nylcloud.com
>>
>> # You can also choose a specific advertised hostname or IP address, and
>> # configure an advertised port for each connector, by setting their
>> # individual advertised_address.
>>
>> # Bolt connector
>> dbms.connector.bolt.enabled=true
>> #dbms.connector.bolt.tls_level=OPTIONAL
>> dbms.connector.bolt.listen_address=0.0.0.0:7687
>>
>> # HTTP Connector. There can be zero or one HTTP connectors.
>> dbms.connector.http.enabled=true
>> dbms.co

Re: [Neo4j] js driver is hanging

2019-02-12 Thread &#x27;Michael Hunger' via Neo4j
You need to use callbacks/promises and only close session  when you're dong
processing and driver when your app is shutting down.

see
https://www.adamcowley.co.uk/javascript/using-the-neo4j-driver-with-nodejs/

On Tue, Feb 12, 2019 at 11:46 AM 'Marc Donovan' via Neo4j <
neo4j@googlegroups.com> wrote:

> const neo4j = require('neo4j-driver').v1;
> const driver = neo4j.driver('bolt://localhost:7687',
> neo4j.auth.basic('neo4j', 'neo4j'));
> const session = driver.session();
> session.run('create (test:Airport)');
> session.close
> driver.close
>
> It hangs at session.run. Anyone know what I am doing wrong?
>
> If I run it in the browser it runs in 1 ms and displays the next prompt.
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] check if a word in a list - case insenstive

2019-02-12 Thread &#x27;Michael Hunger' via Neo4j
it's expensive and you need to do

WHERE toLower(e1.word) IN [w in e2.WordsList | toLower(w)]

or

WHERE ANY(w IN e2.WordsList WHERE toLower(e1.word) toLower(w))


you can also store lower case words in your properties, or add a 2nd
property to check for that.


I am having issues caused by case sensitive matches ,
can someone please help ?

here is my query:


> MATCH (e1:Entity), (e2:Entity) WHERE e1.Word in e2.WordsList and e1.Word
> ={name}
>

Word is a string
WordsList is List

how can I ignore the case when checking if a word is inside a list ?


Join our new Community Site & Forum 


On Tue, Feb 12, 2019 at 11:46 AM  wrote:

>
> Hi,
>
> I am having issues caused by case sensitive matches ,
> can someone please help ?
>
> here is my query:
>
>
>> MATCH (e1:Entity), (e2:Entity) WHERE e1.Word in e2.WordsList and e1.Word
>> ={name}
>>
>
> Word is a string
> WordsList is List
>
> how can I ignore the case when checking if a word is inside a list ?
>
>
> Thanks
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Launching neo4j from application on a different machine (no localhost)

2019-02-12 Thread &#x27;Michael Hunger' via Neo4j
Did you configure your Neo4j server to listen on the external interface?

It's explained in the docs here:
https://neo4j.com/docs/operations-manual/current/configuration/connectors/

On Tue, Feb 12, 2019 at 8:58 AM  wrote:

> Hi everyone, i'm fairly new to neo4j and i've been experimenting a bit
> using Neo4j Java Driver to populate a neo4j database on a standalone
> server. It's been working fine as long as the application and the server
> were running on the same machine (i was using bolt://localhost:port as
> uri), but now that i moved the server on a different machine it's giving me
> a "ServiceUnavailableException: Failed to establish connection with the
> server"
>
> driver = GraphDatabase.driver("bolt://" + neo4jSettings.NEO4J_HOSTNAME +
> ":" + neo4jSettings.NEO4J_PORT, AuthTokens.basic(neo4jSettings.
> NEO4J_USERNAME, neo4jSettings.NEO4J_PASSWORD))
>
> I'm not sure what is going wrong, but i can reach the machine just fine so
> the problem has to be somewhere else and my best guess is that i have to
> change something inside the .conf file, can anyone point me in the right
> direction please? Thanks in advance
>
> Andrea
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j Default Movie Database

2019-01-17 Thread &#x27;Michael Hunger' via Neo4j
You've probably seen the documentation:
https://neo4j.com/docs/graph-algorithms/current/algorithms/centrality/

the code is here:
https://github.com/neo4j-contrib/neo4j-graph-algorithms/tree/3.4/algo/src/main/java/org/neo4j/graphalgo

Michael

Join our new Community Site & Forum <https://community.neo4j.com>


On Thu, Jan 17, 2019 at 2:43 PM Andrea Balzoni 
wrote:

> Thanks again for precious help! Ultimately, could you please point me
> towards some material or code examples (virtual or not) that would allow me
> to obtain a better grasp of neo4j's centrality algorithms and, in
> particular, projections?
>
> Thanks again
>
> Andrea
>
> Il giorno gio 17 gen 2019 alle ore 13:52 'Michael Hunger' via Neo4j <
> neo4j@googlegroups.com> ha scritto:
>
>> Cool that it worked for you.
>>
>> For more iterative approaches it could work just to run it multiple times
>> and add e.g. `(m.pageRank + n.pageRank)/2` to the weight.
>>
>> Otherwise one would have to provide an option for "dynamic" weight
>> computation in the library.
>>
>> We plan to make the library more extensible and dynamic in 2019 probably
>> not in the very near future though as we work on some other topics.
>>
>> Join our new Community Site & Forum <https://community.neo4j.com>
>>
>>
>> On Thu, Jan 17, 2019 at 1:24 PM Andrea Balzoni <
>> andrea.balz...@keypartner.it> wrote:
>>
>>> Hi, thanks for your answer. I tried running your code this :
>>>
>>> call algo.pageRank.stream(
>>> 'MATCH (m:Movie) RETURN id(m) as id',
>>> 'MATCH (m:Movie)<-[:ACTED_IN]-(p:Person)-[:ACTED_IN]->(n:Movie)
>>> RETURN id(m) as source, id(n) as target, size( (p)-[:ACTED_IN]->() ) as
>>> weight',
>>> {graph:'cypher',weightProperty: 'weight'})
>>> YIELD node, score WITH node, score
>>> ORDER BY score DESC LIMIT 200
>>> RETURN node.title as movie, score
>>>
>>> with a small correction where i replaced "m" with "n" in "id(n) as
>>> target" and it worked just fine. The follow-up question would be: is there
>>> a way to make this more "iterative"? Instead of using the actors' degree,
>>> is there a way to make it "more iterative" and, instead of giving to every
>>> movie the same importance towards the actors' degree, take into account the
>>> movies' importance aswell and make them weight more or less according to
>>> that? Thanks again!
>>>
>>> Andrea
>>>
>>> Il giorno gio 17 gen 2019 alle ore 12:25 'Michael Hunger' via Neo4j <
>>> neo4j@googlegroups.com> ha scritto:
>>>
>>>> I guess based on your description, the a projection like this would
>>>> make most sense. Using the actor's degree as weight for page-rank
>>>>
>>>> call algo.pageRank.stream('
>>>> MATCH (m:Movie) RETURN id(m) as id
>>>> ','
>>>> MATCH (m:Movie)<-[:ACTED_IN]-(p:Person)-[:ACTED_IN]->(n:Movie)
>>>> RETURN id(m) as source, id(m) as target, size( (p)-[:ACTED_IN]->() ) as
>>>> weight
>>>> ', {graph:'cypher',weightProperty: 'weight'})
>>>>
>>>> Cheers, Michael
>>>>
>>>> Join our new Community Site & Forum <https://community.neo4j.com>
>>>>
>>>>
>>>> On Thu, Jan 17, 2019 at 11:55 AM  wrote:
>>>>
>>>>> Hi, i'm failry new to neo4j and i was playing around with the movie
>>>>> database that comes by default when installing neo4j. I would like to
>>>>> calculate the importance of each movie based on the actors that acted in
>>>>> them considering each actor more or less important according to the number
>>>>> of movies they acted in. I was thinking about some kind of iterative
>>>>> algorithm and since the eigenvector centrality is missing from neo4j i was
>>>>> looking at pageRank.
>>>>>
>>>>> What would be the best approach in this scenario to use pageRank
>>>>> correctly? I'm a bit lost and googling around didn't help much as what i'm
>>>>> looking for seems more specific than the average info you can find online.
>>>>> Thanks for reading and sorry for my bad english.
>>>>>
>>>>> --
>>>>> You received this message because you are subscribed to the Googl

Re: [Neo4j] Neo4j Default Movie Database

2019-01-17 Thread &#x27;Michael Hunger' via Neo4j
Cool that it worked for you.

For more iterative approaches it could work just to run it multiple times
and add e.g. `(m.pageRank + n.pageRank)/2` to the weight.

Otherwise one would have to provide an option for "dynamic" weight
computation in the library.

We plan to make the library more extensible and dynamic in 2019 probably
not in the very near future though as we work on some other topics.

Join our new Community Site & Forum <https://community.neo4j.com>


On Thu, Jan 17, 2019 at 1:24 PM Andrea Balzoni 
wrote:

> Hi, thanks for your answer. I tried running your code this :
>
> call algo.pageRank.stream(
> 'MATCH (m:Movie) RETURN id(m) as id',
> 'MATCH (m:Movie)<-[:ACTED_IN]-(p:Person)-[:ACTED_IN]->(n:Movie)
> RETURN id(m) as source, id(n) as target, size( (p)-[:ACTED_IN]->() ) as
> weight',
> {graph:'cypher',weightProperty: 'weight'})
> YIELD node, score WITH node, score
> ORDER BY score DESC LIMIT 200
> RETURN node.title as movie, score
>
> with a small correction where i replaced "m" with "n" in "id(n) as target"
> and it worked just fine. The follow-up question would be: is there a way to
> make this more "iterative"? Instead of using the actors' degree, is there a
> way to make it "more iterative" and, instead of giving to every movie the
> same importance towards the actors' degree, take into account the movies'
> importance aswell and make them weight more or less according to that?
> Thanks again!
>
> Andrea
>
> Il giorno gio 17 gen 2019 alle ore 12:25 'Michael Hunger' via Neo4j <
> neo4j@googlegroups.com> ha scritto:
>
>> I guess based on your description, the a projection like this would make
>> most sense. Using the actor's degree as weight for page-rank
>>
>> call algo.pageRank.stream('
>> MATCH (m:Movie) RETURN id(m) as id
>> ','
>> MATCH (m:Movie)<-[:ACTED_IN]-(p:Person)-[:ACTED_IN]->(n:Movie)
>> RETURN id(m) as source, id(m) as target, size( (p)-[:ACTED_IN]->() ) as
>> weight
>> ', {graph:'cypher',weightProperty: 'weight'})
>>
>> Cheers, Michael
>>
>> Join our new Community Site & Forum <https://community.neo4j.com>
>>
>>
>> On Thu, Jan 17, 2019 at 11:55 AM  wrote:
>>
>>> Hi, i'm failry new to neo4j and i was playing around with the movie
>>> database that comes by default when installing neo4j. I would like to
>>> calculate the importance of each movie based on the actors that acted in
>>> them considering each actor more or less important according to the number
>>> of movies they acted in. I was thinking about some kind of iterative
>>> algorithm and since the eigenvector centrality is missing from neo4j i was
>>> looking at pageRank.
>>>
>>> What would be the best approach in this scenario to use pageRank
>>> correctly? I'm a bit lost and googling around didn't help much as what i'm
>>> looking for seems more specific than the average info you can find online.
>>> Thanks for reading and sorry for my bad english.
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to neo4j+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to neo4j+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
> --
> *Andrea Balzoni  |  **Consultant*
>
> *Roma*,
> <https://maps.google.com/?q=Roma+,+%C2%A0+Via+F.+Cangiullo,+24&entry=gmail&source=g>
>
> <https://maps.google.com/?q=Roma+,+%C2%A0+Via+F.+Cangiullo,+24&entry=gmail&source=g>Via
> F. Cangiullo, 24 - *Milano*, Via Aosta, 4
> Office: +39 06.5922216 | Mobile: +39 333741162X
> Mail: andrea.balz...@keypartner.it 
>
>
> Visit our new website www.KeyPartner.com <http://www.keypartner.com/>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j Default Movie Database

2019-01-17 Thread &#x27;Michael Hunger' via Neo4j
I guess based on your description, the a projection like this would make
most sense. Using the actor's degree as weight for page-rank

call algo.pageRank.stream('
MATCH (m:Movie) RETURN id(m) as id
','
MATCH (m:Movie)<-[:ACTED_IN]-(p:Person)-[:ACTED_IN]->(n:Movie)
RETURN id(m) as source, id(m) as target, size( (p)-[:ACTED_IN]->() ) as
weight
', {graph:'cypher',weightProperty: 'weight'})

Cheers, Michael

Join our new Community Site & Forum 


On Thu, Jan 17, 2019 at 11:55 AM  wrote:

> Hi, i'm failry new to neo4j and i was playing around with the movie
> database that comes by default when installing neo4j. I would like to
> calculate the importance of each movie based on the actors that acted in
> them considering each actor more or less important according to the number
> of movies they acted in. I was thinking about some kind of iterative
> algorithm and since the eigenvector centrality is missing from neo4j i was
> looking at pageRank.
>
> What would be the best approach in this scenario to use pageRank
> correctly? I'm a bit lost and googling around didn't help much as what i'm
> looking for seems more specific than the average info you can find online.
> Thanks for reading and sorry for my bad english.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Problem configuring Neo4j on Centos remote machine

2019-01-17 Thread &#x27;Michael Hunger' via Neo4j
I would advice not to change the script in bin.

Can you access the port from your home computer at all? e.g. with `curl
http://host:7474`

Are you sure your remote firewall is open on all of those ports?

Join our new Community Site & Forum 


On Thu, Jan 17, 2019 at 11:55 AM Kwami Sossoe 
wrote:

> Hello all,
>
> Sorry to disturb. I have problem about configuring Neo4j server for remote
> machine.
> I well use it in my local machine. Now I putting neo4j in an remote centos
> machine.
> I changed in the file neo4j.conf the local address localhost to be the ip
> adress of my remote machine
> When I launch the neo4j server with the command ./neo4j console
> I get this output (but when I go to the browser using
> remote_ip_adress:7474, I get nothing or time out)
>
> #
> ./bin/neo4j console
> Active database: graph.db
> Directories in use:
>   home: /opt/cellule/apps/neo4j-community-3.5.1
>   config:   /opt/cellule/apps/neo4j-community-3.5.1/conf
>   logs: /opt/cellule/apps/neo4j-community-3.5.1/logs
>   plugins:  /opt/cellule/apps/neo4j-community-3.5.1/plugins
>   import:   /opt/cellule/apps/neo4j-community-3.5.1/import
>   data: /opt/cellule/apps/neo4j-community-3.5.1/data
>   certificates: /opt/cellule/apps/neo4j-community-3.5.1/certificates
>   run:  /opt/cellule/apps/neo4j-community-3.5.1/run
> Starting Neo4j.
> WARNING: Max 1024 open files allowed, minimum of 4 recommended. See
> the Neo4j manual.
> 2019-01-08 14:06:51.400+ WARN  dbms.connector.bolt.address is
> deprecated. Replaced by dbms.connector.bolt.listen_address
> 2019-01-08 14:06:51.415+ INFO   Neo4j 3.5.1 
> 2019-01-08 14:06:51.422+ INFO  Starting...
> 2019-01-08 14:06:53.593+ INFO  Bolt enabled on 172.17.135.46:7687.
> 2019-01-08 14:06:55.144+ INFO  Started.
> 2019-01-08 14:06:56.104+ INFO  Remote interface available at
> http://172.17.135.46:7474/
>
>
> I have try other thing. I find that in the file /bin/neo4j the variables
> are literally name differently than in /conf/neo4j.conf
> So I try to uniformise them.
> For example in /conf/neo4j.conf there
> is dbms.connectors.default_advertised_address, but in /bin/neo4j there
> is dbms_connectors_default_listen_address.
> I try to write same name in both files.
> Then when I run the command ./bin/neo4j console
> I got the error below
>
> ./neo4j: line 240: export: `-r': not a valid identifier
> ./neo4j: line 240: PROGRAM: readonly variable
>
> This is the line 240 :export ${key}="${value}"
>
> Thanks by advance,
>
> Kwami.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j Property Store

2019-01-08 Thread &#x27;Michael Hunger' via Neo4j
Is it the actual store that's keeping the space or tx logs?

neo4j marks records as unused to reuse them but doesn't currently free
space on disk.

with my store-utils you can compact it but that's an offline tool.

Join our new Community Site & Forum <https://community.neo4j.com>


On Mon, Jan 7, 2019 at 3:05 PM Vaibhav Aiyar  wrote:

> Hi,
>
> Is there anyway to compact the store without having to shutdown NEO4J. Or
> is there a way to configure NEO4J to actually free up space after a given
> time period
>
> On Thursday, May 14, 2015 at 5:05:00 AM UTC-5, Michael Hunger wrote:
>>
>> You can run a consistency check on your graph:
>>
>>
>> http://www.markhneedham.com/blog/2014/01/22/neo4j-backup-store-copy-and-consistency-check/
>>
>> You can use my StoryCopy tool to migrate/compact your store:
>>
>> https://github.com/jexp/store-utils
>>
>> HTH
>>
>> Michael
>>
>> Am 14.05.2015 um 08:42 schrieb Vaibhav Aiyar :
>>
>> Would that not be a waste of space? Why would it need 19G if all it needs
>> is to mark the blocks unused if there is no data?
>> We are concerned that the size may have increased due to some corruption
>> in the files.
>> We wanted to load the entire graph into memory to improve performance and
>> 19G is too large.
>>
>> On Wednesday, May 13, 2015 at 6:36:32 PM UTC-5, Michael Hunger wrote:
>>>
>>> I don't think disk space is freed, just the blocks marked as unused.
>>>
>>> And the restart will start using those blocks (for nodes and rels)
>>> For properties etc. the blocks will be reused directly.
>>>
>>> M
>>>
>>> Am 13.05.2015 um 16:28 schrieb Vaibhav Aiyar :
>>>
>>> Hi,
>>>
>>> When does NEO4j cleanup neostore.propertystore.db.strings store file.
>>>
>>> We see huge variations in the size of the files in our three
>>> environments even though the node count and the data is similar.
>>> Below are the sizes of this files in our three environments along with
>>> node counts
>>>
>>> DEV: 19GB - 55699 nodes
>>> TEST: 7.4GB - 184023 nodes
>>> PROD: 700 MB - 258845 nodes
>>>
>>> I deleted around 3000 Nodes is DEV which have the most number of
>>> properties and restarted NEO4j.
>>> I saw a reduction in the storage space for
>>> neostore.propertystore.db.strings.id but no change in
>>> neostore.propertystore.db.strings.
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to neo4j+un...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>>
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to neo4j+un...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] How detect errors in query?

2018-12-17 Thread &#x27;Michael Hunger' via Neo4j
It's a warning from the cypher engine.

You can run your query with EXPLAIN prefixed to see it.
If its particular to the driver please raise a GH issue at the repo.

Join our new Community Site & Forum 


On Mon, Dec 17, 2018 at 6:28 PM Andy  wrote:

> I an using https://github.com/cleishm/libneo4j-client.
> I check errors:
>   neo4j_value_t params = neo4j_null;
>   neo4j_result_stream_t *results = neo4j_run(connection, query.c_str(),
> params);
>   if (!results) ->error
> But sometimes when I have bad query, in browse
> http://127.0.0.1:7474/browser/
> i get detailed error but results!=null
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j connection timeout between servers

2018-11-28 Thread &#x27;Michael Hunger' via Neo4j
Could you please create this issue in spring data neo4j jira? Thx

Von meinem iPhone gesendet

> Am 28.11.2018 um 08:33 schrieb Siva Punnaivanam :
> 
> Hi Team, 
> 
> We have installed neo4j (neo4j-community-3.4.7-unix.tar) on a Server 1 and 
> our spring boot application deployed on server 2 is using that neo4j database.
> We often getting connection timeout issue in our application and immediately 
> on next try it is working fine. 
> Connection time out is not bcoz of long inactive time. 
> Though we are using application regressively, we are getting connection 
> timeout suddenly in between and on immediate next try it is working fine.
> 
> This is the neo4j property details given in our spring boot application 
> running on server 2. 
> 
> spring.data.neo4j.uri=bolt://X.X.X.X:17687
> spring.data.neo4j.username=neo4j
> spring.data.neo4j.password=xx
> 
> And below is the configuration file we used in our applicaiton to create the 
> connection.
> 
> @EnableNeo4jRepositories(basePackages = "com.metadata.dao", sessionFactoryRef 
> = "userSessionFactory", transactionManagerRef = "userTransactionManager")
> @Configuration
> @EnableTransactionManagement
> public class Neo4jConfiguration {
> 
>   @Value("${spring.data.neo4j.uri}")
>   private String url;
> 
>   @Value("${spring.data.neo4j.username}")
>   private String userName;
> 
>   @Value("${spring.data.neo4j.password}")
>   private String password;
> 
>   @Bean(name = "userSessionFactory")
>   @Primary
>   public SessionFactory bUserSessionFactory() {
>   return new SessionFactory(bUserconfiguration(), 
> "com.metadata.dao.entity");
>   }
> 
>   @Bean
>   public org.neo4j.ogm.config.Configuration bUserconfiguration() {
>   org.neo4j.ogm.config.Configuration configuration = new 
> org.neo4j.ogm.config.Configuration.Builder().uri(url)// "bolt://localhost"
>   .credentials(userName, password)// "user", 
> "secret")
>   .build();
>   return configuration;
>   }
> 
>   @Bean
>   public Neo4jTransactionManager bUserTransactionManager() {
>   return new Neo4jTransactionManager(bUserSessionFactory());
>   }
> 
> }
> 
> And attached is the neo4j connection time out logs we got in our application 
> logs. 
> 
> Please help me to resolve the issue. Kindly let me know if you need any 
> additional information.
> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
> 

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Re: Unable to run a query

2018-11-15 Thread &#x27;Michael Hunger' via Neo4j
Can you please move your questions to community.neo4j.com easier to answer
there.
Thank you

Bootstrap and ruby should still work.
Otherwise, check out React with Material UI and grandstack.io

Michael
Join our new Community Site & Forum <https://community.neo4j.com>


On Fri, Nov 16, 2018 at 1:16 AM Paolo Di Pietro 
wrote:

> Michael,
>
> Can you please try to rewrite for me the query using all the up to date
> tricks and syntax?
>
> Every nMe was different, because in the older versions qit returned a
> ‘variable already used ‘ error!
>
> I have thousands of excel tables to load, and the direct CSV import
> doesn’t provide me with a good system to control all the data , put them in
> relation, and create new node types and new relationships.
>
> Any suggestion is welcome, as always!!!
>
> Ciao
>
> Paolo
>
> Inviato da iPad
>
> Il giorno 15 nov 2018, alle ore 13:42, 'Michael Hunger' via Neo4j <
> neo4j@googlegroups.com> ha scritto:
>
> Why are you running such an old version?
> Just upgrade to the most recent one.
>
> Your query is broken in many places.
>
> I think it's best if you take the cypher online training again to
> familiarize yourself with the syntax or look at the cypher refcard:
> https://neo4j.com/docs/cypher-refcard/current
> Also it seems your generating queries with variable names changing all
> the time. That's not recommended, b/c then the cypher compiler cache cannot
> work.
>
> Parameter handling and query execution is separate in Neo4j browser.
> You have to set parameters first.
> And only after just run the query.
>
> :help params
>
> :help cypher
>
> Join our new Community Site & Forum <https://community.neo4j.com>
>
>
> On Thu, Nov 15, 2018 at 3:51 AM Paolo Di Pietro 
> wrote:
>
>>
>>
>> On Tuesday, November 13, 2018 at 9:03:26 AM UTC+1, Paolo Di Pietro wrote:
>>>
>>> Hi all,
>>>
>>> I'm running the Neo4j Community 3.0.12 on docker.
>>>
>>> First of all: there still is the old panel using to running queries
>>> instead of using the browser (speaking around v2.2)
>>>
>>> Second: I have some troubles running the following query:
>>>
>>>
>>> :param nome: "Di Pietro Chiara"   /* as suggested by Michael
>>> Hunger in an answer on a post
>>>
>>> merge (_cal_445:`calendario` { :`X-VR-CALNAME` = '$nome'
>>> })-[:`appartiene a`]->(_per_445:`persona`)
>>> WHERE $nome = concat(_per_445.cognome," ",_per_445.nome)
>>> OR $nome = concat(_per_445.nome," ",_per_445.cognome)
>>> return _cal_445, _per_445
>>>
>>> well, I made some changes and some attempts to run the query, with no
>>> result.
>>>
>>> {
>>>"nome" : 'Di Pietro Chiara'
>>> }
>>>
>>> Merge (_cal_445:`calendario` { :`X-VR-CALNAME` = '$nome'
>>> })-[:`appartiene a`]->(_per_445:`persona`)
>>> WHERE $nome = concat(_per_445.cognome," ",_per_445.nome)
>>> OR $nome = concat(_per_445.nome," ",_per_445.cognome)
>>> return _cal_445, _per_445
>>>
>>> and in this case the error is as follow:
>>>
>>> Invalid input '{': expected  (line 1, column 1 (offset: 0))
>>> "{ "nome" : 'Di Pietro Chiara' }"
>>>  ^
>>>
>>> Has someone an idea?
>>>
>>> BTW, the :help param|params returns an error
>>>
>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to neo4j+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Neo4j" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/neo4j/ThAWsemffB4/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Re: Unable to run a query

2018-11-15 Thread &#x27;Michael Hunger' via Neo4j
Why are you running such an old version?
Just upgrade to the most recent one.

Your query is broken in many places.

I think it's best if you take the cypher online training again to
familiarize yourself with the syntax or look at the cypher refcard:
https://neo4j.com/docs/cypher-refcard/current
Also it seems your generating queries with variable names changing all the
time. That's not recommended, b/c then the cypher compiler cache cannot
work.

Parameter handling and query execution is separate in Neo4j browser.
You have to set parameters first.
And only after just run the query.

:help params

:help cypher

Join our new Community Site & Forum <https://community.neo4j.com>


On Thu, Nov 15, 2018 at 3:51 AM Paolo Di Pietro 
wrote:

>
>
> On Tuesday, November 13, 2018 at 9:03:26 AM UTC+1, Paolo Di Pietro wrote:
>>
>> Hi all,
>>
>> I'm running the Neo4j Community 3.0.12 on docker.
>>
>> First of all: there still is the old panel using to running queries
>> instead of using the browser (speaking around v2.2)
>>
>> Second: I have some troubles running the following query:
>>
>>
>> :param nome: "Di Pietro Chiara"   /* as suggested by Michael
>> Hunger in an answer on a post
>>
>> merge (_cal_445:`calendario` { :`X-VR-CALNAME` = '$nome'
>> })-[:`appartiene a`]->(_per_445:`persona`)
>> WHERE $nome = concat(_per_445.cognome," ",_per_445.nome)
>> OR $nome = concat(_per_445.nome," ",_per_445.cognome)
>> return _cal_445, _per_445
>>
>> well, I made some changes and some attempts to run the query, with no
>> result.
>>
>> {
>>"nome" : 'Di Pietro Chiara'
>> }
>>
>> Merge (_cal_445:`calendario` { :`X-VR-CALNAME` = '$nome'
>> })-[:`appartiene a`]->(_per_445:`persona`)
>> WHERE $nome = concat(_per_445.cognome," ",_per_445.nome)
>> OR $nome = concat(_per_445.nome," ",_per_445.cognome)
>> return _cal_445, _per_445
>>
>> and in this case the error is as follow:
>>
>> Invalid input '{': expected  (line 1, column 1 (offset: 0))
>> "{ "nome" : 'Di Pietro Chiara' }"
>>  ^
>>
>> Has someone an idea?
>>
>> BTW, the :help param|params returns an error
>>
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j ETL problem to integrate with Azure SQL DB

2018-11-05 Thread &#x27;Michael Hunger' via Neo4j
Do you have foreign key constraints in your schema? Those are used to
derive the JOIN tables and relationships.

If you do have those, please create an issue at the
github.com/neo4j-contrib/neo4j-etl repository.

Join our new Community Site & Forum 


On Tue, Nov 6, 2018 at 8:01 AM  wrote:

> I don´t know why but the Neo4j ETL doesn't make the relationship between
> the nodes, and I declared all the keys, and I tried to add a schema. But is
> not working the relationship between the nodes.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j London Meetup

2018-11-01 Thread &#x27;Michael Hunger' via Neo4j
Thanks Dan, much appreciated

Join our new Community Site & Forum 


On Fri, Nov 2, 2018 at 1:44 AM Dan Keeley  wrote:

> Hi,
>
> Attended the Neo4j meetup in London last night, and wrote up my thoughts
> here:
>
> https://dankeeley.wordpress.com/2018/10/25/neo4j-london-meetup/
>
> Always good to know what others thought, and what particular things other
> people find interesting. Any other attendees here?
>
> Dan
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] bigint for neo4j

2018-11-01 Thread &#x27;Michael Hunger' via Neo4j
The APOC library adds support for these operations and storage as well.
See: https://neo4j-contrib.github.io/neo4j-apoc-procedures/#_exact

Join our new Community Site & Forum 


On Fri, Nov 2, 2018 at 1:44 AM Duc Trinh  wrote:

> Hello,
> I want to ask if there is way for me to handle very big number (20-digit
> numbers,...) in Neo4J. I can store it as string but in that case Im not
> able to make calculation on them like add/sub/mul/div
>
> Thank you in advance
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] use apoc.export.csv to append for existing file

2018-10-20 Thread &#x27;Michael Hunger' via Neo4j
That's currently not possible, but you can
Create a GH issue at the APOC repository to make it a config option like
`{append:true}`

Join our new Community Site & Forum 


On Sun, Oct 21, 2018 at 4:40 AM pradeep ponduri 
wrote:

> apoc.export.csv.query is overwriting the existing file. how can I make the
> query  append to the existing file ?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] How to export neo4j results to aurora database?

2018-10-16 Thread &#x27;Michael Hunger' via Neo4j
Either do it in client code. 
Or you might be able to use apoc.load.jdbcUpdate

Von meinem iPhone gesendet

> Am 15.10.2018 um 19:50 schrieb pradeep ponduri :
> 
> I need to run a cypher query and save the results of the query in Aurora 
> database?
> What is the best practice to do so?
> thanks
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] best practices for storing 40 millions of nodes

2018-10-10 Thread &#x27;Michael Hunger' via Neo4j
John, can you post here Community Site & Forum <https://community.neo4j.com>
Easier for me to answer there.


On Wed, Oct 10, 2018 at 3:41 PM John Carlo  wrote:

> Hello Michael,
>
> thank your for your reply.
>
> I've re-implemented the db structure using unique words/nodes, now the
> number of nodes dropped from 47.108.544 to 1.934.049
>
> I still have a huge number of relationships, 45.442.034 that now point to
> the unique nodes, and the query are slow.
>
> My end goal is to find specific patterns in sentence structures, like the
> following example
>
> (John)-[ACTION ]->(eat)-[SUBJECT]->(apple)
>
> Any suggestion will be appreciated
>
> thank you very much
>
>
>
> Il giorno mercoledì 10 ottobre 2018 00:50:22 UTC+2, Michael Hunger ha
> scritto:
>>
>> Yes, I would only create every word node once. And then link the sentence
>> structures.
>> In general, just finding all the word nodes is probably not your end-goal
>> or?
>>
>> Best ask here Community Site & Forum <https://community.neo4j.com> in
>> the Modeling and Cypher categories.
>>
>>
>> On Tue, Oct 9, 2018 at 11:00 PM John Carlo  wrote:
>>
>>> Hello all,
>>>
>>> I've been using Neo4j for some weeks and I think it's awesome.
>>>
>>> I'm building an NLP application, and basically, I'm using Neo4j for
>>> storing the dependency graph generated by a semantic parser, something like
>>> this:
>>>
>>> https://explosion.ai/demos/displacy?text=Hi%20dear%2C%20what%20is%20your%20name%3F&model=en_core_web_sm&cpu=1&cph=0
>>>
>>> In the nodes, I store the single words contained in the sentences, and I
>>> connect them through relations with a number of different types.
>>>
>>> For my application, I have the requirement to find all the nodes that
>>> contain a given word, so basically I have to search through all the nodes,
>>> finding those that contain the input word.  Of course, I've already created
>>> an index on the word text field.
>>>
>>> I'm working on a very big dataset (by the way, the CSV importer is a
>>> great thing).
>>>
>>> On my laptop, the following query takes about 20 ms
>>> *MATCH (t:token) WHERE t.text="avoid" RETURN t.text*
>>>
>>> Here are the details of the graph.db:
>>> 47.108.544 nodes
>>>
>>> *45.442.034 relationships*
>>>
>>> *13.39 GiB db size*
>>> *Index created on token.text field*
>>>
>>> PROFILE MATCH (t:token) WHERE t.text="switch" RETURN t.text
>>> 
>>> NodeIndexSeek
>>> 251,679 db hits
>>> ---
>>> Projection
>>> 251,678 db hits
>>> --
>>> ProduceResults
>>> 251,678 db hits
>>>
>>> I wonder if I'm doing something wrong in indexing such amount of nodes.
>>> At the moment, I create a new node for each word I encounter in the text,
>>> even if the text is the same of other nodes.
>>>
>>> Should I create a new node only when a new word is encountered, managing
>>> the sentence structures through relationships?
>>>
>>> Could you please help me with a suggestion or best practice to adopt for
>>> this specific case? I think that Neo4j is a great piece of software and I'd
>>> like to make the most out of it :-)
>>>
>>> Thank you very much
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to neo4j+un...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Does migrating data from oracle to neo4j with apoc jdbc is slower than load csv ?

2018-10-09 Thread &#x27;Michael Hunger' via Neo4j
Can you share more detail?

Ask in the import-export category in our new Community Site & Forum



On Tue, Oct 9, 2018 at 11:00 PM pradeep ponduri 
wrote:

> Am working on a use case where I need to migrate huge data from oracle to
> neo4j.
> What is the best way to do? Am using python as scripting.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j community edition dB with java API

2018-10-09 Thread &#x27;Michael Hunger' via Neo4j
You can use a backend java server that connects via the neo4j-java-driver
to the database.
You can also use backend frameworks like spark-java, micronaut or spring
(with spring-data-neo4j).

see some examples in github.com/neo4j-examples

Join our new Community Site & Forum 


On Tue, Oct 9, 2018 at 11:00 PM krits3112  wrote:

> Hi all,
>
> I have been exploring neo4j for white a sometime now, I have created some
> nodes and some relationships on a very large dataset of employees and their
> skillset.
> I can also see the results when I execute cypher queries on my neo4j
> community edition interface.
> Though now I am trying to integrate my already created dB with a java API
> so that I can built a selection process to select the filters based on
> scroll downs and options and not queries, the UI on which I need to publish
> the result is on javascript, I have gone through certain tutorials on
> tutorials point but could not achieve the desired results.
> Can anyone help me in guiding the way.
>
> Best,
> Kirtya
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] best practices for storing 40 millions of nodes

2018-10-09 Thread &#x27;Michael Hunger' via Neo4j
Yes, I would only create every word node once. And then link the sentence
structures.
In general, just finding all the word nodes is probably not your end-goal
or?

Best ask here Community Site & Forum  in the
Modeling and Cypher categories.


On Tue, Oct 9, 2018 at 11:00 PM John Carlo  wrote:

> Hello all,
>
> I've been using Neo4j for some weeks and I think it's awesome.
>
> I'm building an NLP application, and basically, I'm using Neo4j for
> storing the dependency graph generated by a semantic parser, something like
> this:
>
> https://explosion.ai/demos/displacy?text=Hi%20dear%2C%20what%20is%20your%20name%3F&model=en_core_web_sm&cpu=1&cph=0
>
> In the nodes, I store the single words contained in the sentences, and I
> connect them through relations with a number of different types.
>
> For my application, I have the requirement to find all the nodes that
> contain a given word, so basically I have to search through all the nodes,
> finding those that contain the input word.  Of course, I've already created
> an index on the word text field.
>
> I'm working on a very big dataset (by the way, the CSV importer is a great
> thing).
>
> On my laptop, the following query takes about 20 ms
> *MATCH (t:token) WHERE t.text="avoid" RETURN t.text*
>
> Here are the details of the graph.db:
> 47.108.544 nodes
>
> *45.442.034 relationships*
>
> *13.39 GiB db size*
> *Index created on token.text field*
>
> PROFILE MATCH (t:token) WHERE t.text="switch" RETURN t.text
> 
> NodeIndexSeek
> 251,679 db hits
> ---
> Projection
> 251,678 db hits
> --
> ProduceResults
> 251,678 db hits
>
> I wonder if I'm doing something wrong in indexing such amount of nodes. At
> the moment, I create a new node for each word I encounter in the text, even
> if the text is the same of other nodes.
>
> Should I create a new node only when a new word is encountered, managing
> the sentence structures through relationships?
>
> Could you please help me with a suggestion or best practice to adopt for
> this specific case? I think that Neo4j is a great piece of software and I'd
> like to make the most out of it :-)
>
> Thank you very much
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Creating constraints and indexes on data which is uploaded using Import tool

2018-10-09 Thread &#x27;Michael Hunger' via Neo4j
Can you share more detail? E.g. output of your import run and which
indexes/constraints you try to create.

Best ask here Community Site & Forum 


On Tue, Oct 9, 2018 at 11:00 PM pradeep ponduri 
wrote:

> I have used Import tool to make nodes and relationships for huge set of
> data.
> Problem I have is creating indexes and constraints. It is taking much
> longer time that expected.
> Is there any other way of doing this?
> Using import tool i guess we can only create indexes and constriants only
> after creating nodes.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Where to draw the line between Neo4j and an RDBMS?

2018-09-01 Thread &#x27;Michael Hunger' via Neo4j
I think from what you describe, you don't need a RDBMS.

That is usually only needed in

1. existing systems that are already built on an RDBMS that are used from
multiple applications and reporting systems
2. huge amounts of read-only properties, including BLOB/CLOB
3. loads of reporting queries that only run aggregations of the data

Michael


On Tue, Aug 28, 2018 at 12:15 AM, Kim Prince  wrote:

> I am planning to build an application which relies heavily on a directed
> graph (similar to a social graph).
>
> There is no doubt that Neo4j will be required, but I'm having trouble
> deciding if I will also require an RDBMS.  Is there an easy way for me to
> get a feel for this, other than just building the thing with Neo4j, and
> introducing the RDBMS if/when I reach a choke point?
>
> Some details of the planned application are as follows:
>
>- Designed for 10's of thousands of users, if not 100's of thousands
>- Business logic implemented using MVC (Laravel)
>- Some mobile traffic, some desktop, access via an API
>- Most DB activity will be reading from the graph
>- Not a lot of reporting required
>
> There will be around 8 types of entities that I will definitely implement
> as node types.  The primary focus of the application is the relationships
> between these nodes.  If I incorporate an RDBMS, it will require around 30
> tables for the remaining entities and their relationships.
>
> Any advice?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Join our new Community Site & Forum 

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Re: Cannot merge node using null property value error when I load a csv file

2018-09-01 Thread &#x27;Michael Hunger' via Neo4j
Only use the ID and filter out the null names or ids

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file:///C:/Users/user/
Documents/NEWDATANEO4J/myfile.csv" AS line
WITH line where not line.ID_Actor is null
MERGE (a:Actor{id:line.ID_Actor})
ON CREATE SET a.name=line.NAME_ACTOR

Please join community.neo4j.com and ask there in the cypher category.

On Mon, Aug 20, 2018 at 3:34 PM, Rhianna Tomlinson  wrote:

> Have you tried removing the blank lines in your CSV?
>
>
> On Sunday, 5 August 2018 16:35:53 UTC+1, Youssef Mourchid wrote:
>>
>> Hi,
>>
>> when I was working in the previous version of neo4j (my actual version is
>> 3.2.5) everything was ok, when I want to load my csv file I use this
>> command:
>>
>> USING PERIODIC COMMIT
>> LOAD CSV WITH HEADERS FROM 
>> "file:///C:/Users/user/Documents/NEWDATANEO4J/myfile.csv"
>> AS line
>> MERGE (a:Actor{id_actor:line.ID_Actor,name_actor:toString(line.
>> NAME_ACTOR)})
>>
>> but now after upgrading my neo4j version, it shows me the error "
>> Neo.ClientError.Statement.SemanticError: Cannot merge node using null
>> property value for id_actor"
>>
>> my csv file is like that:
>>
>>
>> 
>>
>>
>>
>>
>>
>>
>> if anyone can help me with that, I would be very thankful.
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Allowing Access to Neo4J server from web server

2018-09-01 Thread &#x27;Michael Hunger' via Neo4j
Did you configure the neo4j server to listen at the public IP? in
neo4j.conf uncomment the line with listen_address=0.0.0.0

Please join community.neo4j.com there is
https://community.neo4j.com/c/neo4j-graph-platform/operations for such
topics.

On Thu, Aug 23, 2018 at 4:15 PM, Mike Lawford  wrote:

> Hi All.
>
> I have installed Neo4J Enterprise and configured this on our test server
> (where web server and neo4j server exist on the same server) successfully.
>
> I then moved to our production environment where the web server and Neo4j
> servers are separated.  Our web server doesn't have access to write to the
> neo4J server via local IP though.  I guess I need to add something to the
> neo4j.conf file to allow this server access, but where and in what format?
>
> Thanks,
> Mike
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] query responding blank data.

2018-09-01 Thread &#x27;Michael Hunger' via Neo4j
If the data is already in the db then it will do nothing.

Please note that create unique is deprecated and should be replaced by
MERGE too.

There are some more issues, you should actually split it into multiple
statements.

Please post this in
https://community.neo4j.com/c/neo4j-graph-platform/import-export

On Tue, Aug 21, 2018 at 11:31 AM,  wrote:

> Hi,
>
> In my local am trying to excute below cypher queries to load data from
> azure and merger/create queries. It executed first time successfully then I
> deleted and re ran, but now queries are running successfully but doing
> nothing. Responding back *(no changes, no records).*
>
> LOAD CSV WITH HEADERS FROM "azure url of csv file" AS line
> MERGE(tsnvlocation:GeographyCity{Name:line.GeographyCity})
> MERGE(tsnvcontact:TSnVContact{Name:line.TSnVContact})
> MERGE(Need:Editedneed{Need:line.Editedneed,Priority:line.
> Priority,TimeFrame:line.TimeFrame})
> MERGE(LeadCompany:LeadCompany{LeadCompany:line.LeadCompany})
> MERGE(Companycontact:LeadCompanyContact{LeadContact:line.
> LeadCompanyContact})
> MERGE(CompanyTechnology:LeadcompanyTechnology{TechnologyName:line.
> LeadcompanyTechnology})
> CREATE UNIQUE (tsnvlocation)<-[:Location]-(tsnvcontact)
> CREATE UNIQUE (tsnvcontact)-[:Need]->(Need)
> CREATE UNIQUE (Need)-[:Lead_Company]->(LeadCompany)
> CREATE UNIQUE (LeadCompany)-[:Lead_Contact]->(Companycontact)
> CREATE UNIQUE (LeadCompany)-[:Lead_Technology]->(CompanyTechnology)
>
> Is there any kind of session which needs to be closed after first run.
> please help me on this.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Py2Neo - AttributeError: 'Graph' object has no attribute 'find_one'

2018-09-01 Thread &#x27;Michael Hunger' via Neo4j
If you haven't would you mind asking in
https://community.neo4j.com/c/drivers-stacks/python ?

Thank you :)



On Tue, Aug 28, 2018 at 12:22 PM, Lukas Ott  wrote:

> I tried to rebuild https://nicolewhite.github.io/neo4j-flask/pages/
> register-a-user.html in Python 3 and Py2Neo V4 (current one).
>
> Flask is running and Neo4J is running on Ubuntu 18.04.
>
>
> When I want to register a new User I'll get " AttributeError: 'Graph'
> object has no attribute 'find_one' "
>
> In the documentation by Nicole White:
>  -> The User.find() method uses py2neo’s Graph.find_one()
>  method to
> find a node in the database with label :User and the given username,
> returning a py2neo.Node 
> object.
>
> So my question is with what function the find_one() method has been
> replaced in the current Py2Neo V4 Version?
>
> In the docuementation https://py2neo.org/v4/database.html I found: 
>
> match_one(*nodes=None*, *r_type=None*)[source]
> 
> 
>
> Match and return one relationship with specific criteria.
>
>
> Anyone has an idea on how to update?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[Neo4j] (Goodbye Google Groups)-[:WELCOME]->(Neo4j Community Site & Forum)

2018-09-01 Thread &#x27;Michael Hunger' via Neo4j
Hello everyone,

We are very excited to announce our brand-new Neo4j Community Site and
Forum at community.neo4j.com based on Discourse. It's a place to ask
questions and to help others, but also to share things you've worked on and
to collaborate locally.

Thank you!

We want to thank you all for contributing to the growth, friendliness and
helpfulness of our Neo4j Community. Especially to everyone who patiently
answered questions.

Why are we moving?

As our user Slack grew to 8,750 members, it became more and more difficult
to answer questions properly, and many discussions descended into private
messages. :( Also, the 10,000 message limit made it impossible to find out
if a question was already answered, and required the helpful folks to
repeat themselves time and again. Others that encountered the same issues
, came to the
same conclusion

and moved to a dedicated forum, several of those also to Discourse as we
are doing.


The *Google Group* was also reduced to a trickle of messages over the last
years, only about 1-2 per day, so it is not worth keeping yet another
channel you need to watch.


*What will happen with the Google Group?*

We will stop using the Google Group, not sure if we'll close it down. At
least there will be no active monitoring or answering of questions anymore.


Please create an account with your social logins and introduce yourself.



To learn more you can watch the video .




If you ask questions please post in the correct category, but also search
first to see if your question has already been answered. It is also helpful
if you add additional tags. Please make sure to share all the details you
have for others to understand and reproduce your issue. Each category also
an introductory message, with a number of helpful links.

Join us and Win! 5x5x50

For the first 5 weeks we will be selecting 5 random users that have signed
up and introduced themselves to win a $50 USD coupon for the Neo4j Graph
Gear Store .

Looking forward to see you at GraphConnect NYC Sept 20-22
!

Or at least at the new Community Site :)

If you have any questions about the new site, please *reply* or ask in
the Feedback
category .

Cheers, Michael

for the Neo4j Developer Relations Team

* *

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] How to increase the thickness of relationship line in Neo4j

2018-08-29 Thread &#x27;Michael Hunger' via Neo4j
can you please re-post your question in
https://community.neo4j.com/c/neo4j-graph-platform/visualization

Thanks a lot.

Michael

On Wed, Aug 29, 2018 at 4:10 PM, Ganesh Babu 
wrote:

> Hi All,
>
> I am looking for help to customize the relationship line between the
> nodes. I have two nodes and each nodes I have given common label "Username"
> and it has a properties one node is having Sender & other node is having
> Receiver. In my data set, there are multiple records with same
> Sender-Receiver combination. Currently when i generate the graph, there are
> multiple lines traversing from sender to receiver. Now my requirement is to
> have a one single line between sender and receiver, but the thickness of
> the line has to vary depending
> on the number of sender-receiver combination available in the data set.
>
> To make it clear, assume sender x...@gmail.com receiver a...@gmail.com and
> there are 50 records in the data set, with the same combination.
> In the graph, relationship line between sender and receiver has to
> thicker, when compared to another set of sender & receiver combination
> which has only 5 records in the data set.
>
> Can we able to achieve this kind of relationship line in Neo4j?
>
> Please let me know your thoughts and share any documentation.
>
> Below is the Query I tried to build the relationship with the subject
> property,
>
> LOAD CSV WITH HEADERS FROM "file:///result.csv" AS csvLine
> MERGE (p1:Username {Property: csvLine.Receiver})
> MERGE (p2:Username {Property: csvLine.Sender})
> MERGE (p3)-[:SENT_TO {subject: csvLine.Subject} ]-(p1)
>
> Attached the sample graph for reference,
>
> [image: Neo4j_Transport_Log.PNG]
>
> In the above graph the sender *Vishal *is sent data to *Suraj *thrice
> with different subjects and I want to increase the thickness of the
> relationship line between the Vishal & Suraj.
>
>
> Thanks,
> Ganeshbabu R
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Real Time Graph Databases

2018-08-18 Thread &#x27;Michael Hunger' via Neo4j
Not sure what you mean in rdbms

An object graph mapper?

There are several. You can find them easily 

Von meinem iPhone gesendet

> Am 07.08.2018 um 18:46 schrieb Micheal Nayebare :
> 
> Is there a way to build graph databases that are dynamic. I would like to go 
> beyond writing cypher for creating nodes and relations to having that done 
> for me like in relational databases?
> As a database developer, i only develop the schema once and keeps pouring in. 
> I would like to do the same for graph databases.
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] is it possible to merge on field value and null property condition?

2018-08-18 Thread &#x27;Michael Hunger' via Neo4j
Only merge on keys not additional properties 
You could use an extra label for :Deleted 

Von meinem iPhone gesendet

> Am 09.08.2018 um 17:23 schrieb M :
> 
> Hello,
> I'm working with a data model where entities have a set of common properties:
> 
> name
> created
> deleted
> 
> Deleted property is null until entity is soft-deleted, then null is set to 
> time stamp value.
> I'm using merge to avoid creating new entity if an existing one has the same 
> name:
> 
> merge (x:Thing{name: $name}) on create set created=timestamp()
> 
> This works fine until entity is deleted:
> 
> match (x:Thing{name: "someName"}) set x.deleted=timestamp();
> 
> I would like to add deleted property to merge criteria but I'm not sure how 
> to do that.
> Something like this (not a valid query):
> 
> merge (x:Thing{name EQUALS $name AND deleted IS NULL}) on create set 
> created=timestamp()
> 
> That way I could create new entity only if name does not exist or it exists 
> but entity has been deleted.
> I would appreciate any help in this matter.
> Thanks,
> 
> M
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] help with Neo4j

2018-08-18 Thread &#x27;Michael Hunger' via Neo4j
With any driver see neo4j.com/developer/language-guides

Or cypher-shell

Von meinem iPhone gesendet

> Am 16.08.2018 um 21:04 schrieb cjajr...@gmail.com:
> 
> 1.   How can I connect to a Neo4j db w/out using Neo4j
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] https://m2.neo4j.org seems to be down

2018-08-18 Thread &#x27;Michael Hunger' via Neo4j
Should work again 

Von meinem iPhone gesendet

> Am 13.08.2018 um 12:58 schrieb Goutam Chowdhury :
> 
> Hi All,
> 
> Not able to download dependencies from m2.neo4j.org
> 
> Maven Error:
> 
> https://m2.neo4j.org/content/repositories/releases/org/mortbay/jetty/jetty/6.1.26.hwx/jetty-6.1.26.hwx.pom.
>  Return code is: 502 , ReasonPhrase:Bad Gateway.
> 
> Tried Accesing from browser:
> https://m2.neo4j.org/ 
> 
> Rsponse : 502 Bad Gateway
> 
> 
> 
> Thanks,
> Goutam
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] parallel processing with apoc.periodic.iterate

2018-08-08 Thread &#x27;Michael Hunger' via Neo4j
periodic.iterate is for updates.

Please share more details on your query / data-model and PROFILE output.

Did you create teh necessary indexes etc?


On Mon, Jul 30, 2018 at 10:08 PM, Pradeep Ponduri <
prad...@appsconsultants.com> wrote:

> Hi,
>
> For one of the usecase am working on, it takes me 3 min to do some
> operations  and get result for one month.
> Can I use apoc.periodic.iterate so that for any number of months the
> operations are performed in 3min on parallel threads?
> If so what is the process for doing it and are there any config settings I
> should make ?
>
>
> Thanks
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] how to match nodes based on datetime field without using WHERE clause

2018-08-08 Thread &#x27;Michael Hunger' via Neo4j
Which version are you at?

Are you sure this works? b/c you compare twice s.createdAT >= while you
probably want to do a between?



On Thu, Aug 2, 2018 at 4:06 PM, Imran Rajjad  wrote:

> Hello,
>
> I have some tweets indexed in Neo4j for testing puproses.
>
> Below is a query that finds top hashtags from certain country
>
> match (c:country{countryCode:"US"})-[*0..4]->(s:status)-[*0..1]->(
> h:hashtag)
> where (s.createdAt >= datetime('2017-06-01T00:00:00') AND s.createdAt >=
> datetime('2017-06-01T23:59:59'))
> return h.name,count(h.name) as hCount
> order by hCount desc
> limit 100
>
> is it possible to move the datetime expression from WHERE into the MATCH
> clause because it seems all the nodes are reached first and then filtered
> through where clause. The "createdAt" field is a datetime field and has
> been indexed
>
> thanks
> Imran
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Slow responses from neo4j

2018-08-08 Thread &#x27;Michael Hunger' via Neo4j
Did you by chance not recreate the indexes you had in the previous version?

Michael

On Thu, Jul 26, 2018 at 5:44 AM, iam Carrot  wrote:

> Hi,
> I recently upgraded to version 3.4.1 on a Windows 10 machine (i7, 16GB
> RAM, 500GB SSD) the problem I am facing is that the time it took before the
> upgrade and after the upgrade is very high.
> Earlier I was able to fire up 45-50 queries in about 50-100ms with warmed
> caches but now, it seems to be 700ms or so. I tried to switch to a Linux
> environment as well, that took more than 2.5 seconds to execute the
> queries.
>
> I have a simple query MATCH (v: child)-[:related_to]->(v1)-[:related_to]->(g:
> grandPa) WHERE v.name IN ['mark', 'rob'] AND g.name IN ['bob', 'zunic']
> RETURN v, v1, g
>
> Can someone share more insights on it?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] How to reuse a subgraph

2018-08-08 Thread &#x27;Michael Hunger' via Neo4j
You could also use a post-filter, i.e. check the resulting nodes together
against your user.

But in general yes you'd have to use something like this.
Alternatively you could also set a "owner" property on all data and only
have the user see their data.

On Thu, Jul 26, 2018 at 5:47 PM, Juha Mäkeläinen 
wrote:

> Hello! We are wondering how to implement user views in our system. Each
> our users have their own set of genealogical data. The users mostly access
> only their own working data (which may be later merged to common data after
> approval). Their data nodes are identified by linking them to the "User"
> node.
>
> Is the only way to write User match in my Cypher clauses? Could I somehow
> define a pre-filtered active subgraph, where cypher clauses are applied
> (reminding sql view, which is'nt available in Neo4j, see
> https://groups.google.com/d/msg/neo4j/kFa8_ZJYzEM/0KuulGphrTYJ)?
>
> Example: In a query `match (p:Person) --> (e:Event) <-- (n:Place)` each
> p, e, n are owned by current user. My solution is quite cumbersome:
>
> match (u:User {name:"John"})
> with u
> match (u) --> (p:Person), (u) --> (e:Event), (u) --> (x:Place)
> with p, e, x
> match (p) --> (e) --> (x)
> return p.id, e.id, x.id
>
> The same User match (the first 4 lines) must ne written in all my Cypher
> clauses.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] neo4j - One of the node hangs at times

2018-08-08 Thread &#x27;Michael Hunger' via Neo4j
Please create a GitHub issue. You might also want to migrate to a more
recent version like 3.4.5 and possibly move away from HA to a causal
cluster.

On Fri, Aug 3, 2018 at 7:55 PM,  wrote:

> One or other of our node in HA architecture  get hung most of the times
> Our neo4j version is 3.2.9 .
>
> $ neo4j status
> Neo4j is not running
> $neo4j start
> ...
> Starting Neo4j.
> Started neo4j (pid 15565). It is available at http://127.0.0.1:7474/
> There may be a short delay until the server is ready.
> See /neo4j/lensdblog/neo4j.log for current status.
> $tail -20 neo4j.log
> at org.neo4j.kernel.lifecycle.LifeSupport$LifecycleInstance.
> start(LifeSupport.java:434)
> ... 5 more
> Caused by: org.neo4j.kernel.lifecycle.LifecycleException: Component
> 'org.neo4j.causalclustering.core.state.CoreLife@f719071' was successfully
> initialized, but failed to start. Please see the attached cause exception
> "Unable to find transaction 1 in any of my logical logs: Couldn't find any
> log containing 1".
> at org.neo4j.kernel.lifecycle.LifeSupport$LifecycleInstance.
> start(LifeSupport.java:444)
> at org.neo4j.kernel.lifecycle.LifeSupport.start(LifeSupport.
> java:107)
> at org.neo4j.kernel.impl.factory.GraphDatabaseFacadeFactory.
> initFacade(GraphDatabaseFacadeFactory.java:205)
> ... 10 more
> Caused by: java.lang.RuntimeException: org.neo4j.kernel.impl.
> transaction.log.NoSuchTransactionException: Unable to find transaction 1
> in any of my logical logs: Couldn't find any log containing 1
> at org.neo4j.causalclustering.core.state.machines.tx.
> LastCommittedIndexFinder.getLastCommittedIndex(
> LastCommittedIndexFinder.java:67)
> at org.neo4j.causalclustering.core.state.machines.tx.
> RecoverConsensusLogIndex.findLastAppliedIndex(
> RecoverConsensusLogIndex.java:48)
> at org.neo4j.causalclustering.core.state.machines.
> CoreStateMachines.installCommitProcess(CoreStateMachines.java:138)
> at org.neo4j.causalclustering.core.state.CoreLife.start(
> CoreLife.java:83)
> at org.neo4j.kernel.lifecycle.LifeSupport$LifecycleInstance.
> start(LifeSupport.java:434)
> ... 12 more
> Caused by: org.neo4j.kernel.impl.transaction.log.NoSuchTransactionException:
> Unable to find transaction 1 in any of my logical logs: Couldn't find any
> log containing 1
> at org.neo4j.kernel.impl.transaction.log.
> PhysicalLogicalTransactionStore$LogVersionLocator.getLogPosition(
> PhysicalLogicalTransactionStore.java:223)
> at org.neo4j.kernel.impl.transaction.log.
> PhysicalLogicalTransactionStore.getTransactions(
> PhysicalLogicalTransactionStore.java:83)
> at org.neo4j.causalclustering.core.state.machines.tx.
> LastCommittedIndexFinder.getLastCommittedIndex(
> LastCommittedIndexFinder.java:57)
> ... 16 more
> 2018-08-03 17:50:29.302+ INFO  Neo4j Server shutdown initiated by
> request
> $cat debug.log
> 2018-08-03 17:50:26.154+ INFO [o.n.k.i.a.i.IndexingService]
> IndexingService.init: indexes not specifically mentioned above are null
> 2018-08-03 17:50:26.206+ INFO [o.n.k.NeoStoreDataSource] No commits
> found after last check point (which is at LogPosition{logVersion=0,
> byteOffset=16})
> 2018-08-03 17:50:26.212+ INFO [o.n.k.i.a.i.IndexingService]
> IndexingService.start: indexes not specifically mentioned above are null
> 2018-08-03 17:50:26.216+ INFO [o.n.k.i.DatabaseHealth] Database health
> set to OK
> 2018-08-03 17:50:26.900+ INFO [o.n.c.c.c.RaftServer] RaftServer
> stopping and unbinding from 0.0.0.0:7000
> 2018-08-03 17:50:29.106+ WARN [o.n.c.c.c.RaftServer] Worker group not
> shutdown within 10 seconds.
> 2018-08-03 17:50:29.106+ INFO [o.n.c.c.c.l.p.PruningScheduler]
> PruningScheduler stopping
> 2018-08-03 17:50:29.107+ INFO [o.n.c.c.CatchUpClient] CatchUpClient
> stopping
> 2018-08-03 17:50:29.121+ INFO [o.n.c.d.HazelcastCoreTopologyService]
> HazelcastCoreTopologyService stopping and unbinding from 0.0.0.0:5000
> 2018-08-03 17:50:29.140+ INFO [o.n.k.i.DiagnosticsManager] ---
> STOPPING diagnostics START ---
> 2018-08-03 17:50:29.141+ INFO [o.n.k.i.DiagnosticsManager] ---
> STOPPING diagnostics END ---
> 2018-08-03 17:50:29.141+ INFO [o.n.k.i.f.GraphDatabaseFacadeFactory]
> Shutdown started
> 2018-08-03 17:50:29.150+ INFO [o.n.k.i.t.l.c.CheckPointerImpl] Check
> Pointing triggered by database shutdown [1]:  Starting check pointing...
> 2018-08-03 17:50:29.150+ INFO [o.n.k.i.t.l.c.CheckPointerImpl] Check
> Pointing triggered by database shutdown [1]:  Starting store flush...
> 2018-08-03 17:50:29.155+ INFO [o.n.k.i.t.l.c.CheckPointerImpl] Check
> Pointing triggered by database shutdown [1]:  Store flush completed
> 2018-08-03 17:50:29.155+ INFO [o.n.k.i.t.l.c.CheckPointerImpl] Check
> Pointing triggered by database shutdown [1]:  Starting appending check
> point entry into the tx log...
> 2018-08-03 17:50:29.169+ INFO

Re: [Neo4j] Installation Issue Neo4j 3.4.5

2018-08-08 Thread &#x27;Michael Hunger' via Neo4j
Could you please create a GH issue for this? Thank you

On Mon, Jul 30, 2018 at 7:36 AM, Bhavin Shah  wrote:

> Getting Following error at the time of installing neo4j
>
> C:\Program Files\neo4j-community-3.4.5>bin\neo4j install-service
> You must provide a value expression on the right-hand side of the '-'
> operator.
> At C:\Program Files\neo4j-community-3.4.5\bin\Neo4j-Management\Get-
> Neo4jPrunsrv
> .ps1:107 char:12
>
>-
>
>  {$_ -  in @("ServerInstallInvoke", "ServerUpdateInvoke")} {
>
>- CategoryInfo : ParserError: (:) [], ParseException
>   - FullyQualifiedErrorId : ExpectedValueExpression
>
> Invoke-Neo4j : The term 'Get-Neo4jPrunsrv' is not recognized as the name
> of a c
> mdlet, function, script file, or operable program. Check the spelling of
> the na
> me, or if a path was included, verify that the path is correct and try
> again.
> At line:1 char:235
>
>- try { Unblock-File -Path 'C:\Program Files\neo4j-community-3.4.5\
>bin\Neo4j-Ma
>nagement*.*' -ErrorAction 'SilentlyContinue' } catch {};Import-Module
>'C:\Prog
>ram Files\neo4j-community-3.4.5\bin\Neo4j-Management.psd1'; Exit
>(Invoke-Neo4j
> install-service)
>   - CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorExcep
>   tion
>   - FullyQualifiedErrorId : Microsoft.PowerShell.Commands.
>   WriteErrorExceptio
>   n,Invoke-Neo4j
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j in server

2018-08-08 Thread &#x27;Michael Hunger' via Neo4j
Bloom currently only works via desktop there are plans for later to enable
bloom against an specific Neo4j Server.

On Tue, Jul 31, 2018 at 5:56 AM, Arnab  wrote:

> Hi
> I hv neo4j server running for our application. I want to use neo4j bloom
> and users dont want to download neo4j desktop for that. How can i connect
> to bloom using an url.?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Data Insertion Takes Long time

2018-08-06 Thread &#x27;Michael Hunger' via Neo4j
I think it is just either issue of memory allocation for transactional data
creation or it could be related to parsing the huge JSON.

Can you try to run the apoc.load.json and just return count(*) without
creating data to see how long that takes?

And then you can combine apoc.periodic.iterate with apoc.load.json to batch
your data creation

call apoc.periodic.iterate("
CALL apoc.load.json('file:///root/output/1532360242087/devices1.json')
YIELD value AS row UNWIND row.devices as val RETURN val
","

MERGE(dev:device{dwwn:val.device_wwn})

ON CREATE SET  dev.title='device',dev.sid=val.sid,dev.scsi_3_persistent_res
erve=val.scsi_3_persistent_reserve,
...
", {batchSize:1, iterateList:true, parallel:false});


you can leave off the "RETURN count(dev)"

and you can also use SET dev += val
to set all properties of the "val" map at once


On Wed, Jul 25, 2018 at 5:27 PM, Elyas Mohamed 
wrote:

> Hi,
>
> We have got about 8 roes to be loaded . We have created unique
> constrain for anode and try to load 8 rows it takes more than 30
> minutes. Any help appreciated. Below the query
>
> CREATE CONSTRAINT ON (n:device) ASSERT n.dwwn IS UNIQUE
>
> CREATE INDEX ON : device (dwwn);
>
>
>
> CALL apoc.load.json("file:///root/output/1532360242087/devices1.json")
> YIELD value AS row UNWIND row.devices as val  MERGE(dev:device{dwwn:val.devi
> ce_wwn})
>
>
> ON CREATE SET  dev.title='device',dev.sid=val
> .sid,dev.scsi_3_persistent_reserve=val.scsi_3_persistent_res
> erve,dev.raid_group_information_number_of_failing_members=va
> l.raid_group_information_number_of_failing_
>
>
> members,dev.megabytes=val.megabytes,dev.sqar_mode=val.sqar_m
> ode,dev.mirror_configuration_information_mirror_type=val.mir
> ror_configuration_information_mirror_type,dev.device_
> emulation_type=val.device_emulation_type,dev.product_
> revision=val.product_revision,dev.star_mode=val.star_mode,
> dev.device_sub_system_id=val.device_sub_system_id,dev.
> mirror_set_type=val.mirror_set_type,dev.mirror_set_da_
> status=val.mirror_set_da_status,dev.device_user_pinned=
> val.device_user_pinned,dev.product_id=val.product_id,dev.
> raid_group_information_raid_type=val.raid_group_information_raid_type,dev.
> raid_group_information_disk_group_number=val.raid_group_
> information_disk_group_number,dev.device_physical_name=val.
> device_physical_name,dev.device_configuration=val.
> device_configuration,dev.device_defined_label=val.
> device_defined_label,dev.device_serial_id=val.device_
> serial_id,dev.host_cache_registered=val.host_cache_
> registered,dev.device_status=val.device_status,dev.dif1_
> flag=val.dif1_flag,dev.device_external_identity_device_wwn=
> val.device_external_identity_device_wwn,dev.`512_byte_
> blocks`=val.`512_byte_blocks`,dev.extent_based_clone=val.
> extent_based_clone,dev.raid_group_information_mirror_
> number=val.raid_group_information_mirror_number,dev.
> encapsulated_device_flags=val.encapsulated_device_flags,dev.
> device_block_size=val.device_block_size,dev.cylinders=val.
> cylinders,dev.kilobytes=val.kilobytes,dev.device_service_
> state=val.device_service_state,dev.vendor_id=val.
> vendor_id,dev.as400_gk=val.as400_gk,dev.gatekeeper_
> device=val.gatekeeper_device,dev.star_recovery_state=val.
> star_recovery_state,dev.device_capacity_tracks=val.
> device_capacity_tracks,dev.raid_group_information_raid_
> group_service_state=val.raid_group_information_raid_group_
> service_state,dev.device_symmetrix_name=val.device_
> symmetrix_name,dev.device_capacity_megabytes=val.device_
> capacity_megabytes,dev.host_access_mode=val.host_access_
> mode,dev.raid_group_information_disk_group_name=
> val.raid_group_information_disk_group_name,dev.optimized_
> read_miss=val.optimized_read_miss,dev.raid_group_
> information_device_position=val.raid_group_information_
> device_position,dev.encapsulated_wwn=val.encapsula
> ted_wwn,dev.raid_group_information_protection_level=val.
> raid_group_information_protection_level,dev.device_capacity_
> kilobytes=val.device_capacity_kilobytes,dev.number_of_raid_
> groups=val.number_of_raid_groups,dev.encapsulated_device
> _name=val.encapsulated_device_name,dev.device_capacity_
> cylinders=val.device_capacity_cylinders,dev.attached_vdev_
> tgt_device=val.attached_vdev_tgt_device,dev.device_sa_
> status=val.device_sa_status,dev.device_defined_label_type=
> val.device_defined_label_type,dev.dynamic_rdf_capability=
> val.dynamic_rdf_capability,dev.device_capacity_geometry_l
> imited=val.device_capacity_geometry_limited,dev.mirror_confi
> guration_information_mirror_status=val.mirror_configuratio
> n_information_mirror_status,dev.dynamic_spare_invoked=val.dy
> namic_spare_invoked,dev.trackscylinder=val.trackscylinder,de
> v.star_recovery_capability=val.star_recovery_capability,dev.
> device_tags=val.device_tags,dev.mirror_configuration_infor
> mation_mirror_number=val.mirror_configuration_information_
> mirror_number,dev.encapsulated_array_id=val.encapsulated_arr
> ay_id,dev.sectorstrack=val.sectorstrack,

Re: [Neo4j] Neo4j & Angular 6

2018-08-06 Thread &#x27;Michael Hunger' via Neo4j
Hi,

did you see this one: https://github.com/adadgio/neo4j-js-ng2 perhaps
that's helpful.
Otherwise it should be pretty straightforward to wrap interactions.

Perhaps an object-graph-mapper like Adam's Neode would help?
https://medium.com/neo4j/interacting-with-neo4j-in-nodejs-using-the-neode-object-mapper-3d99cb324546

Benoit, Adam do you have other pointers for Garth?

Michael

On Sun, Aug 5, 2018 at 7:46 PM, Garth Mountain 
wrote:

> Hi all,
>
> Taken first steps and implemented a Neo4j db with my Angular 6 front end.
>
> Documentation around the net of these two playing together is a bit
> scarce... or I suck at Googling, dunno.
>
> If anyone has links to good resources I'd be very grateful.
>
> What I've found and used is the npm angular-neo4j package. Bolt driver
> wrapper. Nothing wrong with it but want to check out all options.
> Also spun up an instance of NEAN stack.. but getting my head around that
> in the time I've got might not be my quickest path to MVP.
>
> Also, suggestions, best practice, etc regarding bypassing Node server API
> and talking directly between front end and db?
>
> Many thanks.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Giving up on Neo4j Desktop since I don't know what the database pw is

2018-08-06 Thread &#x27;Michael Hunger' via Neo4j
Yes the two conflict,

best to go through Desktop as it auto-updates etc. So uninstall Homebrew
and go with Desktop.


On Mon, Jul 30, 2018 at 10:08 AM, Asko Kauppi  wrote:

> I'm evaluating Neo4j and came up with a very initial problem that prevents
> me from progressing.
>
> Neo4J Desktop does not let me in.
>
> I first installed the Homebrew version, but then noticed the Neo4J Desktop
> has a later one, and pulled that in as well. Maybe the two somehow disliked
> each other - anyhow the end result has been that I haven't seen a single
> graph. Neo4J tells to sign in, but does not accept bolt://localhost:7474,
> user: neo4j, pw: neo4j as the credentials.
>
> I was looking for a way to get direct support from Neo4j to this, but
> since I'm only evaluating, didn't find a place to call/chat/email.
>
> So. Will now uninstall the Desktop version, try again with Homebrew.
>
> Hope this makes it to the Neo4j support people, since my evaluation
> experience on the product so far has been a fail. For a very small and
> hopefully fixable reason.
>
> - Asko
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Cannot drop index with nested property (dot) in Neo4j using bolt

2018-05-22 Thread &#x27;Michael Hunger' via Neo4j
As that is not a valid identifier anymore you have to quote it with
backticks, like `id.id` same goes for labels and rel-types.

Michael

On Mon, May 21, 2018 at 6:26 PM, Davide D'Alto 
wrote:

> Hi,
> I was surprised to see the following error:
>
>
> Neo.ClientError.Statement.SyntaxError: Invalid input '.': expected an
> identifier character, whitespace, ',' or ')' (line 1, column 38 (offset:
> 37)) "DROP INDEX ON :SingleBoardComputer(id.id)"
>
> How is it that I can create the index but I cannot drop it? Is there a
> special syntax?
>
> Thanks,
> Davide
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j: count the size of array

2018-05-09 Thread &#x27;Michael Hunger' via Neo4j
return filter(x in [10,20,30] where x <> 20)

On Wed, May 9, 2018 at 11:55 PM, Ebtihel Hannachi <
hannachi.ebti...@gmail.com> wrote:

> I have another question, please!
> What about if I would like to delete a specific value from an array
> without knowing the indices of it in the array  (example array[10,20,30)
> and the result will be [10,30]).
> any suggestions, please? I'll be so grateful!
>
> 2018-05-09 22:47 GMT+01:00 Ebtihel Hannachi :
>
>> it worked form me with index !! i really appreciate it :)
>>
>> 2018-05-07 10:31 GMT+01:00 'Chris Vest' via Neo4j > >:
>>
>>> If you want this to be a fast thing to query for, you can put the array
>>> length in a separate property on the nodes, and then create an index for
>>> it. Then change your queries to be for `v.length = 1`, etc.
>>>
>>> --
>>> Chris Vest
>>> System Engineer, Neo Technology
>>>
>>>
>>> > On 7 May 2018, at 11.10, 'Michael Hunger' via Neo4j <
>>> neo4j@googlegroups.com> wrote:
>>> >
>>> > Your query looks ok, it could be shortened to:
>>> >
>>> > Cypher is case sensitive so perhaps you have a misspelling somewhere?
>>> >
>>> > match (v) where size(v.value) = 1 return v.name
>>> >
>>> > you can check with
>>> >
>>> > match (v) return v.name, size(v.value) limit 20
>>> >
>>> >
>>> > On Sat, May 5, 2018 at 3:56 PM, Ebtihel Hannachi <
>>> hannachi.ebti...@gmail.com> wrote:
>>> > Hi,
>>> > I am new in graph databases and I need your help, please!
>>> > so I have created a set of nodes, every node has as properties name
>>> and an array of integers.
>>> > I would like to know how to get all nodes have only a single integer???
>>> > I tried this query but it gave no results "MATCH (v) WITH
>>> length(v.value) as size WHERE size=1 RETURN v.name".
>>> >
>>> > --
>>> > You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> > To unsubscribe from this group and stop receiving emails from it, send
>>> an email to neo4j+unsubscr...@googlegroups.com.
>>> > For more options, visit https://groups.google.com/d/optout.
>>> >
>>> >
>>> > --
>>> > You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> > To unsubscribe from this group and stop receiving emails from it, send
>>> an email to neo4j+unsubscr...@googlegroups.com.
>>> > For more options, visit https://groups.google.com/d/optout.
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to neo4j+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] How to save polygon data in neo4j and query if a latitude and longitude is within the polygon using Java

2018-05-07 Thread &#x27;Michael Hunger' via Neo4j
That was old code in the 4 year old version of Spring Data Neo4j which is
no longer maintained.

For now you'll have to use the procedures.

It's also better to go with a Neo4j server.

Michael


On Mon, May 7, 2018 at 2:22 PM, hema  wrote:

> Thank you so much, for your response.
>
> *Please find the attachements*
>
> I want it to be done using Java. I found through some documentation we can
> do it using GraphRepository and SpatialRepository.
>
> I am trying to do using neo4j-spatial dependency.But i am unable to add
> GraphRepository and SpatialRepository to my project.
> I have attached pom.xml of my project .Please help me with this issue.
>
>
> Regards,
>
> Roja V A
>
>
> On Monday, May 7, 2018 at 2:42:31 PM UTC+5:30, Michael Hunger wrote:
>>
>> Please check out William Lyons Blog as a great example:
>> http://www.lyonwj.com/2016/08/09/neo4j-spatial-proc
>> edures-congressional-boundaries/
>>
>> Cheers, Michael
>>
>> On Fri, May 4, 2018 at 9:10 AM, hema  wrote:
>>
>>> Hi,
>>>
>>>
>>> I am very new to neo4j database. Just started trying out neo4j spatial
>>> plugin.
>>> Excuse me if my doubts are silly. As it is very new for me facing little
>>> difficult to start.
>>>
>>>
>>> I want to save a list of polygon data to neo4j database and then query
>>> with some latitude and longitude to check whether the location is within
>>> the polygon.
>>>
>>> Link to my question on stackoverflow : https://stackoverflow.com/q/
>>> 50152029/6756805
>>>
>>> Any help is greatly thankful.
>>>
>>> Hema
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Neo4j" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to neo4j+un...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] How to save polygon data in neo4j and query if a latitude and longitude is within the polygon using Java

2018-05-07 Thread &#x27;Michael Hunger' via Neo4j
Please check out William Lyons Blog as a great example:
http://www.lyonwj.com/2016/08/09/neo4j-spatial-procedures-congressional-boundaries/

Cheers, Michael

On Fri, May 4, 2018 at 9:10 AM, hema  wrote:

> Hi,
>
>
> I am very new to neo4j database. Just started trying out neo4j spatial
> plugin.
> Excuse me if my doubts are silly. As it is very new for me facing little
> difficult to start.
>
>
> I want to save a list of polygon data to neo4j database and then query
> with some latitude and longitude to check whether the location is within
> the polygon.
>
> Link to my question on stackoverflow : https://stackoverflow.com/q/
> 50152029/6756805
>
> Any help is greatly thankful.
>
> Hema
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j: count the size of array

2018-05-07 Thread &#x27;Michael Hunger' via Neo4j
Your query looks ok, it could be shortened to:

Cypher is case sensitive so perhaps you have a misspelling somewhere?

match (v) where size(v.value) = 1 return v.name

you can check with

match (v) return v.name, size(v.value) limit 20


On Sat, May 5, 2018 at 3:56 PM, Ebtihel Hannachi  wrote:

> Hi,
> I am new in graph databases and I need your help, please!
> so I have created a set of nodes, every node has as properties name and an
> array of integers.
> I would like to know how to get all nodes have only a single integer???
> I tried this query but it gave no results "MATCH (v) WITH length(v.value)
> as size WHERE size=1 RETURN v.name".
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Load rdf data into neo4j

2018-05-03 Thread &#x27;Michael Hunger' via Neo4j
Perhaps starting with a subset makes sense?

Jesus did you ever import wikidata?

Did you see the neosemantics library by my colleague Jesus Barrasa which
supports loading RDF into Neo4j: https://github.com/jbarrasa/neosemantics
Explained a bit here:
https://jbarrasa.com/2016/06/07/importing-rdf-data-into-neo4j/

For wikidata I also found these:
https://github.com/findie/wikidata-neo4j-importer
https://neo4j.com/blog/navigate-knowledge-spring-neo4j/

Cheers, Michael


On Fri, May 4, 2018 at 12:48 AM, Sun Yuhan  wrote:

> I am trying to load wikidata into neo4j which I download from this link:
>
> https://dumps.wikimedia.org/wikidatawiki/entities/20180222/
>
> After unzipping, the total size is about 300GB. How can I efficiently load
> that into neo4j? Any suggestion?
>
> Thanks,
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Error in getting embedded neo4j database in java application

2018-04-30 Thread &#x27;Michael Hunger' via Neo4j
Only one process can use the same database.

If you use neo4j embedded you have to make sure to have all dependencies
provided with your build tool, e.g. maven or gradle.

so use `neo4j:neo4j.3.3.5` as the proper top-level dependency which
includes all the transitive ones.

Michael

On Fri, Apr 27, 2018 at 2:05 PM,  wrote:

> Hi,
>
> When I am trying to embed a neo4j database in my java application. I have
> a neo4j database and verified it by running it on neo4j server. But I am
> having problems in using it in my java application.  While debugging I
> observed that the debugger goes to line 79 of class LuceneIndexImplementation
> inside init() method
> this.dataSource = new LuceneDataSource ( storeDir, config,
> indexStore.get(), fileSystemAbstraction, operationalMode );
>
> and then I could step into it and it directly goes to line 98 of same
> class inside shutdown() method
>this.dataSource.shutdown();
> the value of dataSource object at this point is null.
>
>
> Below is the code I have used in my java application followed by the error
> stack trace.
>
> GraphDatabaseService graphDb = new GraphDatabaseFactory().
> newEmbeddedDatabaseBuilder("Path of neo4j db").newGraphDatabase();
>
>
> java.lang.RuntimeException: Error starting 
> org.neo4j.kernel.impl.factory.GraphDatabaseFacadeFactory,
> /Users/carora/Documents/graph.db
> at org.neo4j.kernel.impl.factory.GraphDatabaseFacadeFactory.initFacade(
> GraphDatabaseFacadeFactory.java:211)
> at org.neo4j.kernel.impl.factory.GraphDatabaseFacadeFactory.newFacade(
> GraphDatabaseFacadeFactory.java:126)
> at org.neo4j.graphdb.factory.GraphDatabaseFactory.newDatabase(
> GraphDatabaseFactory.java:137)
> at org.neo4j.graphdb.factory.GraphDatabaseFactory.newEmbeddedDatabase(
> GraphDatabaseFactory.java:130)
> at org.neo4j.graphdb.factory.GraphDatabaseFactory$1.newDatabase(
> GraphDatabaseFactory.java:107)
> at org.neo4j.graphdb.factory.GraphDatabaseBuilder.newGraphDatabase(
> GraphDatabaseBuilder.java:193)
> at org.apache.ctakes.rest.service.CtakesRestController.getNeo4jDatabase(
> CtakesRestController.java:265)
> at org.apache.ctakes.rest.service.CtakesRestController.getRecommendation(
> CtakesRestController.java:247)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(
> InvocableHandlerMethod.java:205)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:133)
> at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:97)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandlerMethod(
> RequestMappingHandlerAdapter.java:827)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:738)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:967)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:901)
> at org.springframework.web.servlet.FrameworkServlet.processRequest(
> FrameworkServlet.java:970)
> at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:872)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:846)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:231)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:193)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:166)
> at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:199)
> at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:96)
> at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:137)
> at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:81)
> at org.apache.catalina.valves.AbstractAccessLogValve.invoke(
> AbstractAccessLogValve.java:651)
> at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:87)
> at org.apache.catalina.connector.CoyoteAdapt

Re: [Neo4j] Java and loop relationships

2018-04-30 Thread &#x27;Michael Hunger' via Neo4j
Your startNode is the parent again. You have to access the endNode to get
the sons.

and your forEach gets passed in the relationships, then you can access
either start/end-nodes, types or properties.

If you're unsure about Java8 streams, there are tons of materials to look
up syntax for forEach and the other operations.

Michael

On Wed, Apr 25, 2018 at 12:37 PM,  wrote:

> i am trying to do :
>
> Node node1= 
> parentNode.getSingleRelationship(RelationshipType.withName("SON"), 
> Direction.OUTGOING).getStartNode();
>
> node1.getRelationships(RelationshipType.withName("SON"),Direction.OUTGOING).forEach(Relationship
>  *xxx *: *yyy*){};
>
> the part that i am missing is *xxx *: *yyy*
>
>
> *idea?*
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Query Performance Question

2018-04-24 Thread &#x27;Michael Hunger' via Neo4j
You should add an index/constraint on :Event(id)

I think a general suggestion goes with your first query.
And then elevating a portion of that timestamp into the relationship-type,
which is similar to inlining.

e.g. (:Event)-[:HAS_STATE_2018_04]->(s:State {time:23492804})

depends on the granularity you need.
you can then eg. filter by enumerating the relevant rel-types in your query
with a small query generator.

Michael

On Tue, Apr 24, 2018 at 9:04 AM,  wrote:

> Database has record event, that points to a lot of nodes with label state.
> It is possible to have a lot of event nodes, each with their own state
> nodes. Each State node has time property on it, that represents timestamp.
>
> I am trying to come up with the most efficient query to do so. So far this
> is the best I can do:
>
>
> profile match (:Event {id:'test'})-->(s:State)
>
>with (s)
>
>where s.time > 1524842390
>
>return s;
>
> This is what I get:
>
> +--++--+-+--
> -++-
> ---+
>
> | Operator | Estimated Rows | Rows | DB Hits | Cache H/M |
> Identifiers| Other  |
>
> +--++--+-+--
> -++-
> ---+
>
> | +ProduceResults  |   1080 | 2323 |   0 |   0/0 |
> anon[61], anon[27], anon[7], s | 0.0|
>
> | |++--+-
> +---++--
> --+
>
> | +Filter  |   1080 | 2323 |   0 |   0/0 |
> anon[61], anon[27], anon[7], s | 0.0; ReferenceFromSlot(0)  |
>
> | |++--+-
> +---++--
> --+
>
> | +Projection  |   1440 | 7200 |7200 |   0/0 |
> anon[61], anon[27], anon[7], s | 0.0; {s : s,  : s.time > {  AUTOINT1}} |
>
> | |++--+-
> +---++--
> --+
>
> | +Filter  |   1440 | 7200 |7200 |   0/0 |
> anon[27], anon[7], s   | 0.0; s:State   |
>
> | |++--+-
> +---++--
> --+
>
> | +Expand(All) |   1440 | 7200 |7201 |   0/0 |
> anon[27], anon[7], s   | 0.0; (anon[7])-->(s)   |
>
> | |++--+-
> +---++--
> --+
>
> | +Filter  |  0 |1 |   5 |   0/0 | anon[7]
>   | 0.0; anon[7].id = {  AUTOSTRING0}  |
>
> | |++--+-
> +---++--
> --+
>
> | +NodeByLabelScan |  2 |5 |   6 |   2/0 | anon[7]
>   | 1.0; :Event|
>
> +--++--+-+--
> -++-
> ---+
>
> Question:
>
> 1) Is there any way to optimize away the Filter (7200), Projection (7200)
> part, and why is it even there?
>
> 2) Is there a more efficient way to do this? I have tried indexing time
> attribute on State object, however, as the number of states records in the
> database growth, the number of records scanned.
>
>
> 3) Ideally what I want to do is match event, get all state nodes connected
> to it, and then use indexed property time on to filter out the records. I
> have been trying to get that to work using 'USING' keyword with something
> like this:
>
>
> profile match (:Event {id:'test'})-->(s:State)
>
> with (s)
>
> using index s:State(time)
>
> where s.time > 1524842390
>
> return s
>
> but it does not work
>
> I know some people will suggest using just match with index, here it is
> and where is what I get:
>
> profile match (:Event {id:'test'})-->(s:State)
>
> using index s:State(time)
>
> where s.time > 1524842390
>
> return s
>
>
> +-++---+
> -+---+--+---
> +
>
> | Operator| Estimated Rows | Rows  | DB Hits | Cache H/M
> | Identifiers  | Other
>   |
>
> +-++---+
> -+---+--+---
> +
>
> | +ProduceResults |108 |  2323 |   0 |  40/0
> | anon[27], anon[7], s | 1.

Re: [Neo4j] Unable to import mysql database to neo4j

2018-04-24 Thread &#x27;Michael Hunger' via Neo4j
Stay tuned, we have some updates and bugfixes coming this week.

Michael

On Wed, Apr 18, 2018 at 2:25 PM, John McKown 
wrote:

> On Tue, Apr 10, 2018 at 6:41 AM,  wrote:
>
>> Hello everyone ,
>>
>> I am new to neo4j. I have been trying to add import my mysql database to
>> neo4j using neo4j etl tool .
>> But every time the neo4j tool gets stuck at any random step and does not
>> proceed forward .  I have also tried the desktop application of neo4j . The
>> ETL application although shows that data has been imported successfully ,
>> no changes are reflected in the database .
>>
>>
>> What could be the possible problem and it's solution . Is there any
>> alternate way to import my mysql db in neo4j ?
>>
>
> ​I'm a newbie with Neo4j. But would it be possible to export your MySQL
> data base into a CSV (comma separated values) file, then use the Neo4J
> import command? Sorry if this is a stupid idea.
>
> ref: https://neo4j.com/developer/guide-import-csv/
> ref: http://www.mysqltutorial.org/mysql-export-table-to-csv/​
>
>
>
>>
>> Regards
>>
>> Anurag Shukla
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to neo4j+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> We all have skeletons in our closet.
> Mine are so old, they have osteoporosis.
>
> Maranatha! <><
> John McKown
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Building a graph database

2018-04-24 Thread &#x27;Michael Hunger' via Neo4j
Did you follow the steps to create local database and start it?
And then start Neo4j Browser from Neo4j Desktop?

What is your OS and version?

Michael

On Wed, Apr 18, 2018 at 2:45 PM, Myles Lee  wrote:

> New to graph databases. I am trying to build one myself but have a few
> questions. (1) What are the differences/benefits of building it remote vs
> local graph? (2) When i try to manage my graph it requests that i sign in.
> Then is says WebSocket connection failure. Due to security constraints in
> your web browser, the reason for the failure is not available to this Neo4j
> Driver. Please use your browsers development console to determine the root
> cause of the failure.
>
> What does this mean? How do I get around it?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] How to merge two neo4j databases into one

2018-04-17 Thread &#x27;Michael Hunger' via Neo4j
Whats the size? You could use apoc.export.cypher to dump the 2nd into cypher 
statements which you can import into the first one 

Von meinem iPhone gesendet

> Am 13.04.2018 um 08:37 schrieb anurag.shu...@raxa.com:
> 
> I have two different neo4j databases , first one is already running in the 
> neo4j . Second one is available in dump form. How can I merge both of the 
> databases into one like importing the dump into existing running databse 
> without over-writing the exisiting data ?
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] I cannot open Neo4j Desktop correct (only blank window)

2018-04-17 Thread &#x27;Michael Hunger' via Neo4j
32 bit or 64?



Von meinem iPhone gesendet

> Am 05.04.2018 um 13:38 schrieb Oleksandr Trunov :
> 
> I installed Neo4j Desktop App from official Website Neo4j successful. After 
> installation I cannot open App correct. I am seeing only blank window with 
> menu-bar.
> OS is Win 7.
> 
> thx.
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Change node names (unnamed nodes with node property)

2018-04-17 Thread &#x27;Michael Hunger' via Neo4j
Use the same property eg "name" for both 
And create a relationship in between 

The browser renders one property as caption per type

If you really need the additional source target info add a label or a boolean 
property 

Von meinem iPhone gesendet

> Am 04.04.2018 um 06:03 schrieb Victoria Stuart :
> 
> Hello: this should be simple but I'm finding that it is it is not.  Consider
> 
> LOAD CSV WITH HEADERS FROM "file:/mnt/Vancouver/glycolysis_relations.csv" AS 
> row
> MERGE (s:GlycolysisRelations {source:row.source})
> MERGE (t:GlycolysisRelations {target:row.target}); 
> 
> I'm getting this:
> 
> 
> 
> where the (s) nodes are properly created with the node names as the source 
> name, but the (t) nodes are missing the names on the nodes.
> 
> File "glcolysis_relations.csv" is of the form
> 
> source,relation,target
> α-D-glucose,substrate_of,hexokinase
> hexokinase,yields,glucose 6-phosphate
> glucose 6-phosphate,substrate_of,glucose-6-phosphatase
> glucose-6-phosphatase,yields,α-D-glucose
> ...
> 
> Thanks.
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
> 

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Database constraints have changed error what is the actual behavior

2018-04-14 Thread &#x27;Michael Hunger' via Neo4j
Would you mind creating a GitHub issue at github.com/neo4j/neo4j sharing
your commands and error message

You didn't share the actual queries that create the ` :12356Person`.

Michael

On Fri, Apr 13, 2018 at 5:38 AM, George & Sherin 
wrote:

> Already present Constraint create constraint on (n:Tenant) assert n.id is
> unique
>  each of this transaction contain
> Txn1
> create (n:Tenant {id:1234})
> create constraint on (n:1234Person) assert n. ssn is unique
> Txn2
> create (n:Tenant {id:12356})
> create constraint on (n:12356Person) assert n. ssn is unique
>
> Txn3
> create (n:Tenant {id:12345})
> create constraint on (n:12345Person) assert n. ssn is unique
>
> When I look at it the data in any of the transactions are not affected by
> the new constraints added in the transaction.
>
> On Thu, Apr 12, 2018 at 10:34 PM, Lexia Fantasy 
> wrote:
>
>> Hi all,
>>
>> https://neo4j.com/developer/kb/explanation-of-error-database
>> -constraints-have-changed-txid-84-after-this-transaction-txid-81-started/
>>
>> I ran into this problem
>> I have a constraint on label Tenant  id  is unique
>>
>> create constraint on (n:Tenant) assert n.id is unique
>>
>> Now when I create a  Tenant node with with label Tenant I am trying to
>> create a new unique constraint for another sets on nodes having labels
>> tenantidPersons
>> create constraint on (n:Persons) assert n.ssn is unique
>>
>> I am getting the below error when I try to multiple tenants concurrently
>> where each tenant creation try to create a constraint for its persons
>>
>> org.neo4j.kernel.api.exceptions.TransactionFailureException: Database
>> constraints have changed (txId=3937) after this transaction (txId=3936)
>> started, which is not yet supported. Please retry your transaction to
>> ensure all constraints are executed
>>
>> As per the example the second constraint is only applicable for a person
>> is created in a tenant. But I get the error while creating the tenant
>> itself.
>>
>> Is this bug or expected behavior. IS the option only to retry the
>> transaction which does not sound right.
>>
>>
>> George S
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Neo4j" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to neo4j+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j Data Migration from 2.x to 3

2018-04-03 Thread &#x27;Michael Hunger' via Neo4j
Hi George,

The indexes are migrated automatically.

If you already have schema indexes that will be taken care of.

Michael

On Fri, Mar 30, 2018 at 3:14 PM, Lexia Fantasy 
wrote:

> Hi all,
>
> I have a neo4j database which is currently running on 2.3.11. Now I am
> thinking of using the 3.x version. I am thinking of doing this
>
> Take an online back up of data from neo4j 2.x then
> use import tool in 3.x to import the data and turn on db store migration
> on.
>
>
> But my requirement is that since 3.x has native indexes. I would like to
> have only Nodes, Relationships and Labels in my 3.x instance and want to
> create the indexes and constraints I need after the migration
>
>
> I did not see any option in the toolset which allows me to exclude indexes
> and constraints
> Could some one throw some light on how I can achieve this, may be like
> deleting some directories in the backup data or so or some other alternate
> approach for this migration
>
> Regards
> -George S
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Any dotnet library for Neo4j with Gremlin?

2018-04-03 Thread &#x27;Michael Hunger' via Neo4j
You should be able to use regular Gremlin Drivers for .Net with Gremlin
Server.

On Tue, Apr 3, 2018 at 7:23 AM,  wrote:

> Is there any dotnet library to connect to Neo4J Database using "Gremlin
> Queries".I could see dotnet library "Neo4K.Driver.dll".
> I guess this DLL supports only Cypher queries? Is there anyway I can use
> "Gremlin Query" using dotnet library?
>
>
> Thanks,
> Anoop
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Need help with simple query to sort & filter duplicates

2018-04-03 Thread &#x27;Michael Hunger' via Neo4j
Hi,


You could do two things:

1. Mark the last run with  a dedicated label, that you update if you insert
new data.
And use that label for querying for the last one.

e.g.

OPTIONAL MATCH (n:HP:Last) WHERE n.id = $id  REMOVE n:Last
CREATE (n:HP:Last {id:$id, })


MATCH (a:HP:Last) WHERE a.project='CHP' and a.type='test-instance' and
a.`cycle-id` ='11743' RETURN distinct a.id, a.`test-id`, a.`exec-date`,
a.`last-modified`, a.status, a.name, a.owner order by a.id


2. Alternatively you can sort them by id and date


MATCH (a:HP) WHERE a.project='CHP' and a.type='test-instance' and
a.`cycle-id` ='11743'
WITH a ORDER BY a.id ASC, a.`exec-date` DESC
WITH a.id, head(collect(a)) as last
RETURN distinct last.id , last.`test-id`, last.`exec-date`,
last.`last-modified`, last.status, last.name , last.owner
order by last.id 

HTH Michael

On Tue, Apr 3, 2018 at 8:04 AM,  wrote:

> I am new to Neo4j Cypher queries. I am getting HPALM data in Neo4j & then
> rendering it on grafana. HPALM creates a new row with every test run under
> the same "test-id". Due to this the summary test status shows wrong count
> due to duplicate entries with one row showing as status=Passed (latest
> run) & another as status=Failed (older run). But I need only the latest row
> data, the one with status=Passed in this example. below is the query which
> shows sample data having duplicate enrties/ rows but with different test
> 'status' & different 'last-modified' time. I need query to extract the
> unique / distinct latest entries & filter out older duplicate entries/
> rows.
> you can see first 2 rows with same id=44079, test-id=72534 but different
> status Failed & Passed & different 'last-modified' date time.
>
> MATCH (a:HP) WHERE a.project='CHP' and a.type='test-instance' and
> a.`cycle-id` ='11743' RETURN distinct a.id, a.`test-id`, a.`exec-date`,
> a.`last-modified`, a.status, a.name, a.owner order by a.id
>
> ╒═╤═══╤═╤═══╤═╤══╤═══╕
> │a.id │a.`test-id`│a.`exec-date`│a.`last-modified`  │a.status 
> │a.name│a.owner│
> ╞═╪═══╪═╪═══╪═╪══╪═══╡
> │44079│72534  │2018-03-09   │2018-03-09 07:42:30│Failed   
> │(null)│g942477│
> ├─┼───┼─┼───┼─┼──┼───┤
> │44079│72534  │2018-03-20   │2018-03-20 13:01:31│Passed   
> │(null)│g942477│
> ├─┼───┼─┼───┼─┼──┼───┤
> │44080│72533  │2018-03-07   │2018-03-07 11:12:54│Failed   
> │(null)│g942477│
> ├─┼───┼─┼───┼─┼──┼───┤
> │44080│72533  │2018-03-21   │2018-03-21 10:42:11│Passed   
> │(null)│g942477│
> ├─┼───┼─┼───┼─┼──┼───┤
> │44081│72532  │2018-03-05   │2018-03-05 11:51:28│Passed   
> │(null)│g942477│
> ├─┼───┼─┼───┼─┼──┼───┤
> │44082│72526  │2018-03-05   │2018-03-05 11:56:54│Failed   
> │(null)│g942477│
> ├─┼───┼─┼───┼─┼──┼───┤
> │44082│72526  │2018-03-21   │2018-03-21 10:57:40│Not 
> Completed│(null)│g942477│
>
>
> Additionally if this is resolved I need to inject the same logic in below 
> summary query to filter out the duplicates:
>
> Currently the real count of Failed, No Run & Not Completed shows higher than 
> expected due adding up of duplicates.
>
> MATCH (a:HP)
> WHERE  a.project='CHP'  and a.type='test-instance' and a.`cycle-id`='11743'
> RETURN  a.status , count(*) as cnt, a.`cycle-id` order by a.status
>
> ╒═╤═══╤╕
> │a.status │cnt│a.`cycle-id`│
> ╞═╪═══╪╡
> │Failed   │4  │11743   │
> ├─┼───┼┤
> │No Run   │2  │11743   │
> ├─┼───┼┤
> │Not Completed│5  │11743   │
> ├─┼───┼┤
> │Passed   │31 │11743   │
> └─┴───┴┘
>
> Any help to resolve this is most appreciated. I need help forming query with 
> "Group by" & "having" clause here with example. I also need help creating 
> query for sorting by date time.
>
> Cannot find correct functions for date time addition / subtraction & sorting 
> as the field type is "string". Let me know if you need more information.
>
> I am using version 3.0.6 of Neo4j
>
>- Version:
>3.0.6
>- Name:
>graph.db
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this gr

Re: [Neo4j] Help with query

2018-03-26 Thread &#x27;Michael Hunger' via Neo4j
Somehow your query is not showing correctly.
Can you send them again? And check that they render correctly?

Are you using Neo4j enterprise? And what is your machine setup + memory
config
How big is your db on disk?

I would filter out nodes (customers) above and below a certain view count.

Do you have indexes / constraints on :Product(idProduct) and
:Customer(idCustomer) ?





On Mon, Mar 5, 2018 at 2:37 PM, Rodrigo Lacerda 
wrote:

> Hello!
>
> I need help with a query that is very slow.
>
> My data models:
>
> 2379k categories (vertex)
> 1746315k users (vertex)
> 376900k products (vertex)
>
> 40m views (client -> view (date) -> product)
> 2m belong (product -> belong -> category)
>
> I want to display recommendations from "Who view also view:
>
> I have two basic queries, one with category filter and one without.
>
> Query without filter:
> MATCH (p: Product {idProduct: "178293"}) <- [: VIEW] - (c: Customer) - [:
> VIEW]
> RETURN rec.idProduct AS recommendation, COUNT (*) AS views
> ORDER BY views DESC LIMIT 25
>
> It's taking about 10 seconds to run.
>
> Query with filter:
> MATCH (p: Product {idProduct: "178293"}) <- [: VIEW] - (c: Customer) - [:
> VIEW] "173"})
> RETURN rec.idProduct AS recommendation, COUNT (*) AS usersWhoAlsoWatched
> ORDER BY usersWhoAlsoWatched DESC LIMIT 25
>
> It's taking about 60 seconds to run.
>
> I would like to receive some tips to tune this query.
>
> Thank you!
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] neo4j data modelling for student curricullum path

2018-03-26 Thread &#x27;Michael Hunger' via Neo4j
There are a number of graphgists in this area:

https://portal.graphgist.org/graph_gists/77ee9035-cb5c-49e0-8da7-fbece062f238
https://portal.graphgist.org/graph_gists/a123a6fc-d881-4206-b42a-f864b7bfbbd3

Otherwise it would be good to share what you already have and ask for help
to iterate, best on neo4j.com/slack in #neo4j-modeling.

Michael


On Sun, Mar 25, 2018 at 5:31 PM, Rabindra Gaan 
wrote:

>
> 0down votefavorite
> 
>
> Use Cases : Suppose I want to Chemical Engineering as my major and I have
> go through certain mandatory course category like Math,Science,Engineering
> Depth. Again there is various paths to fulfill Math,Science and Engineering
> Depth for 4 years . If I want to give a student his course path if he
> chooses chemical engineering as his major
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Graph traversal - applying actions to each node

2018-03-23 Thread &#x27;Michael Hunger' via Neo4j
You can use triggers with apoc, that check e.g. when a node with label
:Yellow is added:

CALL apoc.trigger.add('create-new-yellow-node','
UNWIND apoc.trigger.nodesByLabel({createdNodes},'Yellow') AS this
MATCH (this)<-[:CHILD_OF*]-(p) WHERE p.value = this.value *SET ...*
', {phase:'before'})

Michael

On Tue, Mar 20, 2018 at 6:35 PM, Ynoa  wrote:

>
>
>
>- *Neo4j version*: 3.3.1 Enterprise
>- *Driver*: Javascript-driver
>- *Used Language*: Typescript / Angular 2
>- *OS*: Windows 10
>
>
>
> I have a series of nodes with RED being the Root-node, and YELLOW is
> always the parent of ONLY a green node (GREEN always the child of ONLY
> YELLOW).
>
> For this example the nodes contain a single char.
>
>
> 
>
>
>
>
> Each time a YELLOW node is created with a given value, I want to traverse
> the tree, and compare all visited nodes with the value in the newly created
> YELLOW-node. If they contain the same value, and then do something wether
> this is true or not.
>
>
>
> I have read about the traversal API (java only, apparently) which allows
> me to imperatively manage the traversal, and apply a function to each node
> visited (visitor function). This would be good to use in this case.
>
> But I use the javascript driver, and coding in Typescript, so I don't have
> this option. It seems I have to rely on Cypher, and here's my question(s):
>
>
>
>- Using Cypher, how do I control traversal in way, that I can apply a
>function to each visited node in a given tree?
>- Are there other ways of achieving the traversal if I can't do this
>with Cypher?
>
>
> Any help or links to helpful articles or the neo4j documentation would be
> greatly appreciated.  In the meantime, I will keep trying :)
>
> Kind Regards
>  Joe
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j Desktop not working on macOS 10.13.3 ?

2018-03-19 Thread &#x27;Michael Hunger' via Neo4j
You resolved it by deleting the desktop directory? Right?

On Sun, Mar 18, 2018 at 12:16 AM, Joseph Ahn  wrote:

> Hi there!
>
> I've installed neo4j-desktop-offline 1.0.18 and have been using it just
> fine but after updating to macOS 10.13.3, the UI doesn't show when I launch
> the program.
>
> If there's any other information that might be useful please let me know!
>
> Any ideas on what I can try ?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Database failed to create: Error: Could not change password ? What does it mean?

2018-03-18 Thread &#x27;Michael Hunger' via Neo4j
Which OS version and desktop version?
Can you try to upgrade to the latest?

Von meinem iPhone gesendet

> Am 12.03.2018 um 10:41 schrieb F3dikx98fkkxZDF EWDC9873jdjSSa 
> :
> 
> 
> Neo4j Desktop.
> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Host username and password,

2018-03-18 Thread &#x27;Michael Hunger' via Neo4j
Localhost

It should be automatically set

Von meinem iPhone gesendet

> Am 09.03.2018 um 01:24 schrieb ahmed.ahmed778...@gmail.com:
> 
> 
> 
> Hi,
> 
> I am new to Neo4j. When I open the browser it asks for host, username and 
> password. I know that uname/pass is neo4j/neo4j but whats the host? 
> 
> 
> THanks,
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
> 

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Question about transaction handling within apoc periodic commit

2018-03-04 Thread &#x27;Michael Hunger' via Neo4j
Yes apoc.periodic.iterate would help you there which you can combine with
apoc.load.xxx as driving statement.

It's about the memory needed for tx state.
apoc.periodic.iterate creates new transactions (in separate threads) to be
independent of the running top-level tx.

HTH Michael



On Sat, Mar 3, 2018 at 2:57 PM, Marco P  wrote:

> Hi,
>
> I need to create a large number of nodes with data loaded from a file. I
> was planning to implement this as a stored procedure because of performance
> reasons. I might even get around implementing it myself by using one of the
> load procedures from apoc. But in any case I need to split this up in
> several transactions to avoid getting out of memory. Is it possible to use
> one of the apoc periodic procedures for this as this example for loading
> data
> 
> in the apoc documentation suggests? I was wondering whether this works with
> top level transactions which would help to avoid getting out of memory or
> if this is more about nested transactions and doesn't help in my case. Any
> explanations on this would be very helpful.
>
> Best,
>
> Marco
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Store synonyms as node label

2018-03-04 Thread &#x27;Michael Hunger' via Neo4j
I don't think it makes sense in general.

As synonyms are usually about data not structure. Labels are about
structure / roles.

If you REALLY want to do that (be warned):

How many synonyms do you have in total. Usually nodes should have just a
few (< 5) labels and the total number of labels should also kept in check.

Otherwise youc an use

match (n:Item)
call apoc.create.addLabels(n, n.synonyms)

On Wed, Feb 28, 2018 at 7:46 AM, satish kumar  wrote:

> I have a large graph. Each node has attributes like name and a list of
> synonyms. Synonyms need to be indexed as find node by synonym is required.
> Can we store them as node label? Synonyms are variables and can be added or
> removed from a specific node. Is there any option to do it by cypher. I am
> getting an error that cypher query doesn't allow labels as parameters.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Re: How to start neo4j from command line

2018-03-04 Thread &#x27;Michael Hunger' via Neo4j
Install neo4j desktop and let us know if that worked for you.

michael

On Mon, Feb 26, 2018 at 3:35 PM, Rahul Kinkar 
wrote:

> Hi Anand,
>
> I am also facing the same issue.
>
> Did you get any solution for this?
>
> If you can help that would be great.
>
> Thanks,
> Rahul
>
>
> On Tuesday, March 22, 2016 at 3:26:18 AM UTC+5:30, Anand M A wrote:
>>
>> When i navigate to C:\Program Files\Neo4j CE 2.3.2\bin\ in windows
>> command prompt (DOS) and type "neo4j-ce.exe  start" I'm able to start neo4j
>>
>> but when i write a batch command to run the same, viz
>>
>> start "" "C:\Program Files\Neo4j CE 2.3.2\bin\neo4j-ce.exe"  start
>>
>> its not working, the neo4j windows does shows up, but i have to manually
>> click the start button
>>
>> Anand
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Match the node on the basis of properties values

2018-02-22 Thread &#x27;Michael Hunger' via Neo4j
You only returned `u` so a single node
if you then double click that it expands all the connected data.

If you want to return your query results do `RETURN *`



On Thu, Feb 22, 2018 at 11:04 AM,  wrote:

>
> 
>
> I have a large graph I need to find exact graph.
> My match query is :
> MATCH (u:SQL_Query)-[:FROM]->(c:from_SQL), (u)-[:SELECT]->(c2:select_SQL)
> ,(u)-[:WHERE]->(c3:where_SQL) ,(v:where_SQL)-[:HAS]->(c4:where_value_data)
> WHERE (c.from_sql IN [' user_view_status_logs ']) AND (c2.select_query IN
> [' (1) AS a ']) AND (c3.select_query IN [' (user_view_status_logs.event_id
> = 86 AND user_view_status_logs.user_id = 35 AND
> user_view_status_logs.log_type = Program) LIMIT '])  AND (c4.where_value IN
> [' user_view_status_logs.user_id = 35 ',' user_view_status_logs.event_id =
> 86 ' ])
> RETURN u
>
> I got the graph it works given above in attachment():-
>
> Issue:-
> My issue is number of node connected is 3 but i ask for only 2 with value.
> IN function does not match exactly.
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Does the neo4j cypher shell query on a subset of the DB?

2018-02-22 Thread &#x27;Michael Hunger' via Neo4j
Nope. Full db.

Can you share your query and your domain model?

Feel free to join neo4j.com/slack for quick answers.

Michael

On Mon, Feb 19, 2018 at 3:00 AM, YuLing Chen  wrote:

> Hi All,
>
> I'm new to neo4j and was wondering if the cypher shell only queries on a
> subset of the DB or any query sent from the cypher shell would apply to the
> entire DB?
>
> The reason I'm asking is that when my dataset is big (about 957,440 nodes,
> and 770,455 relationships), the same query returns much fewer results;when
> my dataset is small(about 213,044 nodes, 168,150 relationships), the query
> returns much more results.
>
> So I was wondering neo4j cypher shell would get a subset of the database
> and query when the DB size exceeds a certain number of nodes/relationships?
>
> Thanks,
>
> YuLing
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Getting started...

2018-02-19 Thread &#x27;Michael Hunger' via Neo4j
There is no version 3.4.2 ?

You can use the spatial procedures to do the import, loading, and querying

This might help you as a practical example:
http://www.lyonwj.com/2016/08/09/neo4j-spatial-procedures-congressional-boundaries/

You can also join neo4j.com/slack and ask William Lyon there directly.

Michael




On Thu, Feb 8, 2018 at 5:44 AM, Sami Kibria  wrote:

> Hello guys, I hope you don't mind this newbee question, but I am trying to
> get things up and running.
>
> I have gotten neo4j (3.4.2 up and running) and spatial installed in the
> plugin directory (when I do a curl on my machine, I see the plugin)...so,
> now I am trying to do some custom development (I am writing an app that
> pulls some data from other systems into the neo4j graph db.
>
> So, here is what I am trying to do right now..I want to import the US
> Census Bureau shape files (standard ESRI .shp file) , for city, states, zip
> codes, etc...but I am not sure how to go about doing this?  From there, I
> will enter a bunch of other spatial data from other systems.  Do I need to
> write my own custom import utility - since I want to rename some of the
> labels?  Also, what are some the key jar files needed to get my java
> environment for development?
>
> I hope you guys don't mind this question.
>
> Thanks a million for everyone's help!
>
> :)
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] neo4j enterprise deploy

2018-02-19 Thread &#x27;Michael Hunger' via Neo4j
See the docs: http://neo4j.com/docs/operations-manual/current/installation/

On Sat, Feb 17, 2018 at 10:40 PM, akash gupta  wrote:

> how can i deploy neo4j enterprise?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] SPARQL plugin for NEO4J 3.x

2018-02-19 Thread &#x27;Michael Hunger' via Neo4j
What do you want to do? Usually Cypher is more expressive and much faster
too than SparQL on Neo4j.

The library you referred to wraps the gremlin based sparql implementation.

Michael

On Tue, Feb 13, 2018 at 10:58 PM, Ahmad Chan  wrote:

> Hi,
> Is there any working SPARQL plugin for NEO4J 3.x.x? This plugin code has
> license issue and it does not compile.
> I have found an working code here https://github.com/
> niclashoyer/neo4j-sparql-extension. This code compiles but the plugin is
> not compatible with NEO4J 3.X.X.
> Thanks
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Enter data through the browser, is it plugin possible?

2018-02-19 Thread &#x27;Michael Hunger' via Neo4j
Not 100% sure what you mean?

Usually one would create a small application for that.  You can even parse
the markdown and create the structure automatically no manual input needed.

Perhaps you have a concrete example ...

Michael

On Tue, Feb 13, 2018 at 8:41 PM, Darin Simmons 
wrote:

> I have a project converting ordinal data to graph data (think H1, H2, H3,
> markdown conversions) to the corresponding to nodes and groups in neo4j.
> Neo4j does this wonderfully.  The community needs to tie the rest of the
> relationships together e.g. H2[2] and H2[5] create H2[13].  This is context
> specific to the domain and a handful of experts could finish it in very
> little time (think Wikidata for a specific domain).
>
> The neo4j browser is js based and open-source.  Before I head off to
> attempt this project...
>
> Can it be done?
>
> Has it been done before?
>
> Any suggestions on where I might start looking or working on such a thing?
>
> Thank you for your time,
>
> Darin Simmons
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Neo4j Mapper for C#

2018-02-05 Thread &#x27;Michael Hunger' via Neo4j
It has no docs and seems to be WIP.

Best create an issue and ask the owner.

M

On Mon, Feb 5, 2018 at 10:04 AM, Ryan Velasco  wrote:

> Does anyone have experience using Blueprint41
> ?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Neo4j" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to neo4j+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [Neo4j] Loading nodes matching an indexed UUID

2018-02-01 Thread &#x27;Michael Hunger' via Neo4j
Glad to hear that.

Perhaps we see each other during the graph tour in Europe :)

Cheers, Michael

On Thu, Feb 1, 2018 at 3:09 PM, Vincent Mooser 
wrote:

> Hi Michael,
> I applied all your recommendations and performance are better now. Next
> step will be the SSD.
>
> Thank you for your help
> Vincent
>
> On Tuesday, January 30, 2018 at 7:34:30 PM UTC+1, Michael Hunger wrote:
>>
>> Hi Vincent,
>>
>>
>> On Tue, Jan 30, 2018 at 4:27 PM, Vincent Mooser 
>> wrote:
>>
>>> Hi,
>>>
>>> How much memory does the machine have?
>>>
>>> The machine has 64g of memory, so I think I can increase my page cache.
>>> But I should have at least twice this memory to be able to load the whole
>>> graph in the page cache.
>>>
>>
>> I would definitely increase the page-cache,
>>
>> If it's only 100k nodes that you're  loading it should be fine.
>> The page-cache is emptied by utilization (LRU-K) so if those 100k nodes
>> keep getting used, their pages stay in.
>> Although if a lot of other data is loaded they might get unloaded.
>> There is no idle eviction.
>>
>> For the node-properties there are separate pages.
>> From your description it would be 2 or at most 3 property-records per
>> node.
>>
>> The disk is the biggest issue, if you can compensate with the larger
>> page-cache to avoid disks hits that will help (at least for reads).
>>
>> Switch to 3.3.2
>> Use 12G heap
>> Use 48G page-cache
>>
>> Then this should be better.
>> Also try my query suggestion.
>>
>> Cheers, Michael
>>
>>
>> In my use case, as Solr only contains a subset of the FOLDER nodes (about
>>> 10 nodes), I was thinking of executing a query that selects these
>>> 10 nodes at start, for warming up the cache and to be sure that the
>>> page cache contains (at least) these nodes. Will they be evicted of the
>>> page cache after a certain amount of time ?
>>>
>>> Which properties of the nodes do you need to be returned? the full nodes?
>>>
>>> Yes, the full nodes have to be returned. They contain 1 oid (String), 1
>>> property 'name' (String), 4 boolean properties used as flags for business
>>> tasks and 2 long properties (creation and modification date)
>>>
>>> Thank you,
>>> Vincent
>>>
>>> On Tuesday, January 30, 2018 at 3:04:50 AM UTC+1, Michael Hunger wrote:
>>>>
>>>> Hi,
>>>> this query should be better:
>>>>
>>>> match(node : FOLDER) where node.oid IN {uuidList} return node
>>>>
>>>> You have definitely a really bad system for this graph size:
>>>> How much memory does the machine have?
>>>>
>>>> 0. Switch to Neo4j Enterprise 3.3.2 which is more memory efficient
>>>> 1. *use an SSD*
>>>> 2. use more memory
>>>> 3. use a constraint instead of an index
>>>>
>>>> Otherwise you are effectively measuring disk speed.
>>>>
>>>> The problem is that the nodes might be distributed across the disk and
>>>> then it might have to load up to 200 pages with the HDD having to seek to
>>>> each of the blocks.
>>>>
>>>> Which properties of the nodes do you need to be returned? the full
>>>> nodes?
>>>>
>>>>
>>>> On Mon, Jan 29, 2018 at 5:11 PM, Vincent Mooser 
>>>> wrote:
>>>>
>>>>> Hi,
>>>>> I am currently facing some performance problems when loading nodes
>>>>> using an indexed UUID. My use case is the following:
>>>>>
>>>>> - I initiate a search query in Apache Solr which returns a list of 200
>>>>> UUID (max)
>>>>> - I load the 200 nodes corresponding to the uuid with the following
>>>>> cypher:
>>>>>
>>>>> unwind {uuidList} as uuid
>>>>> match(node : FOLDER { oid : uuid}) return node
>>>>>
>>>>> The uuidList is a query param containing the list of UUID (string)
>>>>>
>>>>> When the query has no page fault, it takes about 10-20ms to load the
>>>>> 200 nodes. But when some page faults appears in the query log, the query
>>>>> time can take up to 4 seconds. I understand that some nodes have to be
>>>>> loaded directly from the disk, but for 200 nodes, it looks very slow to 
>>>>> me.
>>>>>
>>

Re: [Neo4j] Neo4j plugin works slowly

2018-01-31 Thread &#x27;Michael Hunger' via Neo4j
As during a sort those weight sums will be built up time and again it's better 
to cache them per path e.g. in an identity hashmap.

You can also use branch state for sorting afaik.

Michael

> Am 31.01.2018 um 16:29 schrieb Svetlana Usacheva :
> 
> Thanks a lot! Try follow your recommendations. 
> 
> createPaths just show me found paths. It takes about second.
> 
> And yeah, i tried to leave sorting and without it plugin worked faster. 
> 
> Here my sort and now i use only sorting by "weight":
> 
> public class PathSorting implements Comparator{
> 
> private String sortType;
> 
> public PathSorting(String sortType){
> this.sortType=sortType;
> }
> 
> @Override
> public int compare (Path path1, Path path2){
> 
> switch (sortType){
> case "length" :
> if (path1.length()!=path2.length()) {
> return path1.length() }else return 0;
> 
> case "weight" :
> long p1Weight_0 = 0, p2Weight_0 = 0;
> 
> for (Relationship r : path1.relationships()){
> p1Weight_0 += (long)r.getProperty("weight");
> }
> 
> for (Relationship r : path2.relationships()){
> p2Weight_0 += (long)r.getProperty("weight");
> }
> 
> if (p1Weight_0!=p2Weight_0) {
>     return p1Weight_0 }
> else return 0;
> default:return 0;
> }
> }
> 
> }
> 
> 
> 2018-01-31 18:13 GMT+03:00 'Michael Hunger' via Neo4j 
> :
> Do you have an index or constraint on :nodes(id) ?
> If not create one
> 
> Don't do this
>> db.getNodeById(db.findNode(Labels.nodes, "id", 
>> "9149892904013846978").getId()))
> but
> 
>> db.findNode(Labels.nodes, "id", "9149892904013846978")
> 
> Find the nodes once upfront and assign them to variables
> and not during every step of the travesal.
> 
> Don't use a list for lookup but a Set
> 
> You can use Uniqueness.NODE_PATH to assure that a node only appears once in a 
> path
> Only ONE Uniqueness can be used.
> 
> As you continually check for nodes on each  branch in the evaluator, you only 
> have to test the endNode
> 
> return includeNodesSet.contains(path.endNode()) ? return INCLUDE_AND_CONTINUE 
> : EXCLUDE_AND_CONTINUE;
> 
> What does createPath do?
> your procedure doesn't return anything?
> 
> You don't use the start-point.
> 
> Try to leave off the sorting and see if it helps.
> 
> Run the procedure multiple times to see what the warmed up time is.
> 
> Add a counter to your evaluator and output that counter so you see how many 
> Paths it touches.
> 
> If possible you should limit it to certain rel-types or labels.
> 
> 
>> Am 31.01.2018 um 14:37 schrieb Miosota :
>> 
>> Yes, i didn't use RestGraphDB in my plugin. I used it in my test project for 
>> connection from Intellij idea project to neo4j database. Database consists 
>> of about 50K nodes and 100K relationships. 
>>  
>> 
>> I'm running neo4j 3.3.1. For plugin creation use neo4j-kernel 3.3.1 .
>> 
>> For test i created a procedure below. It finds paths from one point to 
>> another including at least one point from a set of 3 points. Traverser spend 
>> too much time to find this paths. 17-20s.  
>> And i really need bidirectional. And the graph later will be much more 
>> bigger (millions elements). 
>> 
>> May be i need to change smth in neo4j properties? I dont know.
>> My RAM 8G. 
>> dbms.memory.heap.initial_size=1000m
>> dbms.memory.heap.max_size=2000m
>> dbms.memory.pagecache.size=5000m
>> 
>> @Procedure(value = "mytraverser.pathIncludingAtLeastOneNode")
>> @Description("createIncludingAtLeastOneNode")
>> public void createIncludingAtLeastOneNode(@Name("startPoint") String 
>> startPoint, @Name("endPoint") String endPoint) {
>> 
>> try (Transaction tx = db.beginTx()) {
>> TraversalDescription td = db.traversalDescription().depthFirst()
>> .uniqueness(Uniqueness.NODE_PATH)
>> .uniqueness(Uniqueness.RELATIONSHIP_PATH)
>> .relationships(RelationshipTypes.rel, Direction.BOTH)
>> .evaluator(Evaluators.includingDepths(0, 10));
>> 
>> Traverser tr = td
>> 
>> .evaluator(Evaluators.includeWhereEndNodeIs(

  1   2   3   4   5   6   7   8   9   10   >