[Neo4j] LOAD CSV creates nodes but does not set properties

Hi there, I'm experimenting with Neo4j while benchmarking a bunch of NoSQL databases for my graduation paper. I'm using the web interface to populate the database. I've been able to load the smaller tables from my SQL database and LOAD CSV works fine. By small, I mean a few columns (4-5) and

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

I'd probably use a commit size in your case of 50k or 100k. Try to use the neo4j-shell and not the web-interface. Connect to neo4j using bin/neo4j-shell Then run your commands ending with a semicolon. Just curious: Your data is imported as one node per row? That's not really a graph structure.

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

I've tried using the shell and I get the same results: nodes with no properties. I've created the csv file using MsSQL Server Export. Is it relevant? About you curiosity: I figured I would import first the nodes, then the relationships from the connection tables. Am I doing it wrong? Thanks

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

Perhaps something with field or line terminators? I assume it blows up the field separation. Try to run: LOAD CSV WITH HEADERS FROM file:/Users/pauld/Documents/Client.csv AS c RETURN { Id: toInt(c.Id), FirstName: c.FirstName, LastName: c.Lastname, Address: c.Address, ZipCode: toInt(c.ZipCode),

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

Well, for all properties it sets null values. The data is read well from the file. Is it ok if I have NULL values in the file? Would that be a problem? joi, 5 iunie 2014, 12:05:18 UTC+3, Michael Hunger a scris: Perhaps something with field or line terminators? I assume it blows up the field

[Neo4j] Re: dijkstra bidirectional

No update? Il giorno giovedì 8 maggio 2014 17:04:32 UTC+2, Antonio Grimaldi ha scritto: Hi, Is there an implementation of Bidirectional Dijkstra? Thanks Antonio -- You received this message because you are subscribed to the Google Groups Neo4j group. To unsubscribe from this group and

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

Also, the properties are not in the same order as in the csv file.. joi, 5 iunie 2014, 12:29:43 UTC+3, Paul Damian a scris: Well, for all properties it sets null values. The data is read well from the file. Is it ok if I have NULL values in the file? Would that be a problem? joi, 5 iunie

[Neo4j] Re: Load csv in neo4j 2.1 and 2.0

Thx for your responses. My index are online. In fact my problem is not exactly the one I described : This request is very long on 2.1.0-RC2 and 2.1.1 CREATE INDEX ON :Joueur(IDJoueur); CREATE INDEX ON :Tech(Tech); USING PERIODIC COMMIT LOAD CSV FROM file:///tmp/X.csv AS csvLine WITH csvLine[0]

Re: [Neo4j] Improving the performance of read queries over HTTP. Full domain info included!

Hey Mark, Thanks for your continued help. The output does include Schema Index as follows: - == Filter(pred=(any(-_-INNER-_- in Collection(List(Literal(Oblivion Ring), Literal(Lightning Bolt), Literal(Mana Leak), Literal(Mulldrifter), Literal(Llanowar Elves), Literal(Counterspell),

Re: [Neo4j] Improving the performance of read queries over HTTP. Full domain info included!

Hey Mark, The query isn't actually used anywhere on the site just yet. For the time being you draft against 7 rudimentary rules-based bots that aren't very good. I'm looking to take their AI to the next level! The concept of adding a person is interesting. At the moment I'm relying on

Re: [Neo4j] Improving the performance of read queries over HTTP. Full domain info included!

Good recommendations all around. Be sure to spice up your results with rand() on the top section to avoid too strong of a feedback loop. :) Wes -- You received this message because you are subscribed to the Google Groups Neo4j group. To unsubscribe from this group and stop receiving emails

[Neo4j] big data and neo4j

Hi, I am doing a project to graph the relation between players on a game. Each day there is more than 10 millions nodes and 50 millions relationships. I wonder if neo4j can scale more than 34 billions nodes and relationships. Storing all this data in neo4j is a good idea? or should I store it in

Re: [Neo4j] big data and neo4j

Right now the latter if you have more data than 34bn Soon we'll lift this artificial limit Sent from mobile device Am 05.06.2014 um 13:53 schrieb Comte Frédéric ezreal92...@gmail.com: Hi, I am doing a project to graph the relation between players on a game. Each day there is more than

[Neo4j] START VS WHERE clauses performance

Using Neo4J = 2.0.0. Can I assert that the following ways of doing are similar in performance: MATCH (c: Car) WHERE c.id = 345 // id being indexed with CREATE INDEX ON :Car(id) RETURN c MATCH (c: Car {id: 345}) RETURN c Let's imagine 100 Car nodes in the graph. Thanks a lot,

Re: [Neo4j] START VS WHERE clauses performance

Do a PROFILE before each in neo4j-shell. It should provide some incite into what neo4j was doing under the hood. However those should be the same. However that isn't comparing START vs WHERE. On Thu, Jun 5, 2014 at 5:49 PM, Michael Azerhad michael.azer...@gmail.com wrote: Using Neo4J =

[Neo4j] Could not determine type for: java.util.Set for Jpa/Neo4J Cross Store Entity (Update)

Could not determine type for: java.util.Set for Jpa/Neo4J Cross Store Entity (Update) I made some changes since my last post, I have replaced 'Neo4jConfiguration' with 'CrossStoreNeo4jConfiguration' (see code below), however the Exception is the same hibernate MappingException: Could not

[Neo4j] Neo4j-community-2.1.1 problems

Hi all, I updated neo4j to 2.1.1 from 2.1.0-M01 and I encountered some problems: 1. I could not use https to log in to the web console. To be specific, I can log in via http://localhost:7474/browser, but I cannot log in by using https://localhost:7473/browser. (port settings are correct.)

[Neo4j] I'd like to merge collections and get the nodes from them

With the following query, I get two rows filled with nodes. START src=node(38), dest=node(24) MATCH p=src-[:KNOWS*1..6]-dest RETURN filter(x IN nodes(p) WHERE x src and x dest) [Node[39]{name:KX},Node[15]{name:QQ},Node[29]{name:QP},Node[26]{name:ux}]