Re: [Neo4j] RDBMS to neo4j migration

[Michael Hunger]

The question is: what is your use-case.

That drives your graph model.

Do yo have an example for your table? Is it a big denormalized table?


On Tue, Dec 9, 2014 at 8:12 PM, Nikhil Rathi  wrote:

> Hi,
> we have a RDBMS table where each column is a code to something meaningful.
> The complete rows is unique in the Table. Each column in row must be
> connected to other in the same row.
>
> The graph model must retain the exact rows. I can see that the graph out
> of a table would be a cyclic graph with  R * NC2 Edges.
> R is rows in RDBMS, N is number of columns.
>
>
> Can Signle RDBMS Table could give better performance in neo4j when each
> column is connected to other?
>
> --
> 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] Tinkerpop 2.6 and Neo4j 2.1.5

[Michael Hunger]

Yes it should suffice, perhaps you can send it back to the tinkerpop
repository as a pull request?

Thanks a lot

Michael

On Wed, Dec 10, 2014 at 5:18 AM, Nipa Shah  wrote:

> Hi,
>
> I was looking at the pom for Neo4j implementation file and my observation
> is that it depends on neo4j version 2.0.1 community edition. What I am
> looking is to use the enterprise edition of Neo4j and potentially the
> latest version such as 2.1.5 or 2.1.6. Have you certified Tinkerpop 2.6 to
> work with any other version of Neo4j?
>
> From the Neo4J documentation here
>
> http://neo4j.com/docs/2.1.4/tutorials-java-embedded-setup.html, it seems
> I should be able to do
>
>
> org.neo4j
> neo4j-enterprise
> 2.1.5
> pom
>
> Would this approach be correct if this works? also if I run all the tests
> that come with Tinkerpop 2.6 with the above mentioned configuration, would
> that suffice?
>
> thanks,
> Nipa
>
> --
> 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] RDBMS to neo4j migration

[Nikhil Rathi]

Hi,
we have a RDBMS table where each column is a code to something meaningful.
The complete rows is unique in the Table. Each column in row must be 
connected to other in the same row.

The graph model must retain the exact rows. I can see that the graph out of 
a table would be a cyclic graph with  R * NC2 Edges.
R is rows in RDBMS, N is number of columns.


Can Signle RDBMS Table could give better performance in neo4j when each 
column is connected to other?

-- 
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] Tinkerpop 2.6 and Neo4j 2.1.5

[Nipa Shah]

Hi,

I was looking at the pom for Neo4j implementation file and my observation 
is that it depends on neo4j version 2.0.1 community edition. What I am 
looking is to use the enterprise edition of Neo4j and potentially the 
latest version such as 2.1.5 or 2.1.6. Have you certified Tinkerpop 2.6 to 
work with any other version of Neo4j?

>From the Neo4J documentation here

http://neo4j.com/docs/2.1.4/tutorials-java-embedded-setup.html, it seems I 
should be able to do


org.neo4j
neo4j-enterprise
2.1.5
pom

Would this approach be correct if this works? also if I run all the tests 
that come with Tinkerpop 2.6 with the above mentioned configuration, would 
that suffice?

thanks,
Nipa

-- 
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] Re: UpdatePuller generating approximately 300Mb of garbage each cycle

[Eric Pederson]

PS.  I am planning on going to the NYC Neo4j Graph Days later this week.  
Will there be someone there who I can talk about these types of questions?

On Monday, December 8, 2014 6:20:22 PM UTC-5, Eric Pederson wrote:
>
> Hi there - 
>
> We are running Neo4j 2.1.6 HA.   We are noticing that on an otherwise 
> totally idle system, the update pulling process is generating around 300Mb 
> of garbage in the space of a second or so, on both sides (master and 
> slave).   The database itself is about 6Gb on disk.
>
> Is this expected? 
>
> 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.

Re: [Neo4j] 'Using Periodic Commit' throws a invalid syntax exception

[Michael Hunger]

Hi,

your email format seems to be off, I can't read it.

What is it you want to do?

Periodic commit is now limited to LOAD CSV and can't be used outside of it
anymore (since 2.1.0)

Cheers,

Michael


On Mon, Dec 8, 2014 at 4:57 PM,  wrote:

> Hi, I'm trying to use the query that Michael wrote:
>
> MATCH (a)
>
> LIMIT 1
>
> OPTIONAL MATCH (a)-[r]-()
> DELETE a,r
>
> RETURN count(*);
>
> And it doesn't work:
>
> Invalid input 'I': expected 'o/O' (line 2, column 2)
> "LIMIT 1"
>
> What can I do? I'm using the version 2.1.5
>
> Fran
>
> On Tuesday, 17 June 2014 15:11:54 UTC+2, ducky wrote:
>>
>> oh, that was a really useful command when updating large datasets. +1 for
>> this feature please.
>>
>>
>> On Tuesday, 17 June 2014 14:08:08 UTC+1, Michael Hunger wrote:
>>>
>>> Sorry, that feature was removed between M06 and 2.1.0 :(
>>>
>>> So what you have to do is to run this repeatedly:
>>>
>>> MATCH (a)
>>>
>>> LIMIT 1
>>>
>>> OPTIONAL MATCH (a)-[r]-()
>>> DELETE a,r
>>>
>>> RETURN count(*);
>>>
>>> until it returns 0.
>>>
>>> You can try higher limits though, depeding on the number of
>>> relationships per node, with 10 rels per node this will be 100k ops, with
>>> 100 -> 1M ops.
>>>
>>> Michael
>>>
>>> Am 17.06.2014 um 15:05 schrieb ducky :
>>>
>>> Hi,
>>> I am using Neo4j 2.1.2 and when I try to run the example given by
>>> Michael Hunger here
>>> :
>>>
>>> Query:
>>> USING PERIODIC COMMIT
>>> MATCH (a)
>>> OPTIONAL MATCH (a)-[r]-()
>>> DELETE a,r;
>>>
>>> Error:
>>> Neo.ClientError.Statement.InvalidSyntax
>>>
>>> Invalid input 'M': expected whitespace, comment, an integer or LoadCSVQuery 
>>> (line 2, column 1)
>>> "MATCH (a)"
>>>
>>>
>>> My question is: has the use of this command changed since this blog post?
>>>
>>> cheers
>>>
>>>
>>> --
>>> 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] 'Using Periodic Commit' throws a invalid syntax exception

[lara]

Hi, I'm trying to use the query that Michael wrote:

MATCH (a)

LIMIT 1

OPTIONAL MATCH (a)-[r]-()
DELETE a,r

RETURN count(*);

And it doesn't work:

Invalid input 'I': expected 'o/O' (line 2, column 2)
"LIMIT 1"

What can I do? I'm using the version 2.1.5

Fran

On Tuesday, 17 June 2014 15:11:54 UTC+2, ducky wrote:
>
> oh, that was a really useful command when updating large datasets. +1 for 
> this feature please. 
>
>
> On Tuesday, 17 June 2014 14:08:08 UTC+1, Michael Hunger wrote:
>>
>> Sorry, that feature was removed between M06 and 2.1.0 :(
>>
>> So what you have to do is to run this repeatedly:
>>
>> MATCH (a)
>>
>> LIMIT 1
>>
>> OPTIONAL MATCH (a)-[r]-()
>> DELETE a,r
>>
>> RETURN count(*);
>>
>> until it returns 0.
>>
>> You can try higher limits though, depeding on the number of relationships 
>> per node, with 10 rels per node this will be 100k ops, with 100 -> 1M ops.
>>
>> Michael
>>
>> Am 17.06.2014 um 15:05 schrieb ducky :
>>
>> Hi,
>> I am using Neo4j 2.1.2 and when I try to run the example given by Michael 
>> Hunger here : 
>>
>> Query:
>> USING PERIODIC COMMIT
>> MATCH (a)
>> OPTIONAL MATCH (a)-[r]-()
>> DELETE a,r;
>>
>> Error:
>> Neo.ClientError.Statement.InvalidSyntax
>>
>> Invalid input 'M': expected whitespace, comment, an integer or LoadCSVQuery 
>> (line 2, column 1)
>> "MATCH (a)"
>>
>>
>> My question is: has the use of this command changed since this blog post?
>>
>> cheers
>>
>>
>> -- 
>> 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.

Re: [Neo4j] Neo4j 2.2.0.M01 - NoSuchMethodError

[tobias . lindaaker]

Hi Florent,

Thank you for reporting this. As Chris said, this was not a planned 
incompatible, nor was it a necessary one.
It has been fixed for future releases of Neo4j 2.2 (as part of this change 
set 

).

Cheers,
Tobias

On Thursday, December 4, 2014 10:29:29 AM UTC+1, Chris Vest wrote:
>
> Hi,
>
> Good catch. It’s not a planned incompatibility, so we’ll fix it before GA. 
> I think you might be able to work around it by building your own neo4j-jdbc 
> against 2.2.0-M01, but I’m not sure because I haven’t tried.
>
> --
> Chris Vest
> System Engineer, Neo Technology
> [ skype: mr.chrisvest, twitter: chvest ]
>
>  
> On 03 Dec 2014, at 20:41, Florent Biville  > wrote:
>
> Hi, 
>
> I've just run a build against the 2.2.0.M01 milestone and I get the 
> following error:
>
> java.lang.RuntimeException: java.sql.SQLException: 
> java.lang.NoSuchMethodError: 
> org.neo4j.cypher.javacompat.ExecutionEngine.execute(Ljava/lang/String;Ljava/util/Map;)Lorg/neo4j/cypher/javacompat/ExecutionResult;
>
>   at com.google.common.base.Throwables.propagate(Throwables.java:160)
>
>   at 
> org.liquigraph.core.writer.ChangelogReader.read(ChangelogReader.java:34)
>
>   at 
> org.liquigraph.core.api.MigrationRunner.readPersistedChangesets(MigrationRunner.java:70)
>
>   at 
> org.liquigraph.core.api.MigrationRunner.runMigrations(MigrationRunner.java:50)
>
>   at org.liquigraph.core.api.Liquigraph.runMigrations(Liquigraph.java:40)
>
>
>
> Original code is here: https://github.com/fbiville/liquigraph/.
> Public build is here: 
> https://travis-ci.org/fbiville/liquigraph/jobs/42898830.
>
> Is this a planned incompatibility?
> If so, is there a backwards-compatible workaround?
>
> Best regards,
> Florent
>
> -- 
> 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.

Re: [Neo4j] How to modify the search criteria

[Sukaant Chaudhary]

Michael,
Actualy, my requirement was only

MATCH (program:Program) WHERE program.genre =~ '(?i).*(*coo*).*' RETURN
program.genre;

And this is for explaining the possibilities

*coo|coc|tail|ler*

I guess the above query wont be slow.


-Sukaant Chaudhary


On Tue, Dec 9, 2014 at 1:15 PM, Michael Hunger <
michael.hun...@neotechnology.com> wrote:

> Best google for regexp tutorial.
>
> In general () is grouping, | is alternatives.
>
> But that kind of search won't be fast.
>
> MATCH (program:Program) WHERE program.genre =~ '(?i).*(*coo|coc|tail|ler*).*'
> RETURN program.genre;
>
> probably better to index your genre via lucene as fulltext index and then
> use lucene query syntax to find your programs.
>
> see: http://jexp.de/blog/2014/03/full-text-indexing-fts-in-neo4j-2-0/
>
> On Tue, Dec 9, 2014 at 7:47 AM, Sukaant Chaudhary <
> sukaant.chaudh...@gmail.com> wrote:
>
>> Hi,
>> I've the following data:
>>
>> neo4j-sh (?)$ MATCH (program:Program) RETURN program.genre;
>> ==> +-+
>> ==> | program.genre |
>> ==> +-+
>> ==> | "Coolers, Cocktail"  |
>> ==> | "Baking" |
>> ==> | "Savoury Dish"   |
>> ==> +-+
>> ==> 3 rows
>> ==> 1 ms
>>
>> Now, Please help me to modify the following query:
>> MATCH (program:Program) WHERE program.genre =~ '(?i)coc.*' RETURN
>> program.genre;
>>
>> such that,
>>
>>
>>
>> *if I'll put program.genre = coo / coc / tail/ lerit should return
>> "Coolers, Cocktail"*
>>
>> *or if I put program.genre = Sav / Di / Dish / Savouryit should return
>> "Savoury Dish"*
>>
>> -Sukaant Chaudhary
>> 
>>
>> --
>> 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.