Re: [Neo4j] auto indexes in REST in 1.4?
Same probelm here. Downloaded neo4j-enterprise-1.4.M02-unix.tar.gz with deafult installtion on Linux. Added the foolwoing lines to neo4j.properties file: node_auto_indexing=true node_keys_indexable=name,age relationship_auto_indexing=true relationship_keys_indexable=ROOT,KNOWS,CODED_BY Started the neo4j server, use neo4j-shell and added Neo4j Wiki Matrix example nodes relationships. From http://localhost:7474/db/data/, browser shows Neo4j REST interface links as: Root relationship_index /db/data/index/relationship node_index /db/data/index/node reference_node /db/data/node/0 However, the fisrt 2 links /db/data/index/relationship /db/data/index/node show nothing about the auto indexes for node relstionship I specified in neo4j.properties file. Not sure if this feature actually works in the current 1.4.M02 build. Can any one pitch in on this issue? -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-auto-indexes-in-REST-in-1-4-tp3159205p3205171.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] auto indexes in REST in 1.4?
Where is the GA version download link? I can't find it in http://neo4j.org/download. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-auto-indexes-in-REST-in-1-4-tp3159205p3206845.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
[Neo4j] How to cascade delete all connected nodes from neo4j shell?
Does any one know how to cascade delete all connected nodes from neo4j shell? We are in the process of refining bulk loading large number of nodes/edges process. It doesn't appear that in neo4j shell rmrel rmnode have the options to do that, does it? -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-cascade-delete-all-connected-nodes-from-neo4j-shell-tp3211267p3211267.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to cascade delete all connected nodes from neo4j shell?
I am looking for ways to delete all connected nodes that can be reached thought any or sepcific relationships, i.e., deleting all nodes/relationships other than the reference node (node 0). A smilar capability in RDBMS is called cascade delete through foreign keys from the parent table. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-cascade-delete-all-connected-nodes-from-neo4j-shell-tp3211267p3211742.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] auto indexes in REST in 1.4?
Does one need to specify the following list of node_keys_indexable relationship_keys_indexable in neo4j.property to enable auto indexing for those node/relationship properties? Also, will they work if those properties were created prior to adding the list in neo4j.property file? node_auto_indexing=true *node_keys_indexable=name,age* relationship_auto_indexing=true *relationship_keys_indexable=ROOT,KNOWS,CODED_BY * -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-auto-indexes-in-REST-in-1-4-tp3159205p3211749.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
[Neo4j] How to run webadmin for high availability neo4j custer?
I installed a 2-node HA neo4j linux cluster based on instructions provided in http://wiki.neo4j.org/content/High_Availability_Cluster. For standalone deafult neo4j server there is a neo4j-server.properties file in which it contains a line org.neo4j.server.webserver.port=7474 that allows webadmin to connect to that webserver port. However, I am not sure how to run webadmin for the high availability neo4j custer since there the same wiki page did not cover this part. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3216706.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to run webadmin for high availability neo4j custer?
The HA cluster is for testing initially. If everything works fine, we'll need to put them in production. if you have detailed production installation guide, that will be great. It appears that there are additonal setup procedure for the Neo4j coordinators. We also need similar weadmin or other monitoring tools for production HA as well. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3216859.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to run webadmin for high availability neo4j custer?
As I mentioned earlier in this thread, I have installed a 2-node neo4j HA server cluster with 3-node zookeeper as described in your wiki http://wiki.neo4j.org/content/High_Availability_Cluster. I wonder if the same steps are also the recommendation to deploy in Production? The reason I ask is because of (1) The wiki only shows example on ha-server[x].conf file but not other properties files as in default standalone server. That beg the question on how to setup webserver for each cluster node. (2) The wiki suggests coping an empty standalone db to hadb1 and runs a custom Java program to start the node -- This seems a rather ad-hoc way to install a Production HA cluster, doesnt' it? I would think there should be a much more detiled SOP (Std. Operating Procedure) guide to deploy them in Production. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3217398.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to run webadmin for high availability neo4j custer?
I am not clear how HA clsuter configuration inlcudes other neo4j property files so that webserver can start since in your wiki the recommended way to start HA clsuter includes only ha-server1.conf as shown below: $ java -cp all jars and StartLocalHaDb class StartLocalHaDb hadb1 ha-server1.conf -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3220207.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to run webadmin for high availability neo4j custer?
We installed neo4j HA cluster exactly as described in your wiki page http://wiki.neo4j.org/content/High_Availability_Cluster with the intent to move them to full production using commercial license if PoC proves to work for VERY LARGE SCALE graph data ( 200M node + 1B edges) in a HA environment. We want to use webadmin to view graph and Cypher to query the HA cluster data. Please provide us with detailed info on how to do that in HA cluster environment so that we can proceed with the PoC. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3222784.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to run webadmin for high availability neo4j custer?
On a separate note, I am having a hard time to use your Cypher query. The only example I found was http://blog.neo4j.org/2011/06/kiruna-stol-14-milestone-4.html and it is hardly usefull. If you could, I would like to get the following info for Cypher: (1) A step-by-step tutorial preferrably using the http://wiki.neo4j.org/content/Shell_Matrix_Example. I added the following lines to a standalone neo4j (I want to do the same in HA as well) neo4j.property file: node_auto_indexing=true node_keys_indexable=name,age relationship_auto_indexing=true relationship_keys_indexable=ROOT,KNOWS,CODED_BY so that I can use Cypher to query the Matrix example by node/egdge property values, not by node ID which is not really very usefull for those who are not familiar with the graph structure. For example, in the Cyper wiki the authors wrote: start user = (people-index, name john) ... I am not even sure where does people-index is defined? Is it related to node_keys_indexable I have in the property file? (2) Secondly, we also want to use SPARQL as query language beyond Cypher. I want to know if there is any similar tool neo4j support as Cypher? -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3222880.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to run webadmin for high availability neo4j custer?
Any one who is familiar with RDBMS will have no difficulty writing SQL to explore their data. In Microsoft SQL Server Management Studio, it even allows one to visually drag-n-drop tables and generates complex join SQL queries. That said, I am not asking neo4j to support this level of usability. However, without writing a line of code querying small numbers of nodes/edges in neo4j has proven to be challenging: (1) Using neo4j-shell is helpful to some extent as long as one knows his relative navigation position in the graph based on node id (2) Webadmin graph viewer is also helpful to the extent if one starts with known node id and is willing to explore one node at a time until the graph becomes cluttered and becomes illegible So, this is where I think Cypher or SPARQL query shell can be helpful if users want to perform set-oriented as in typical SQL or dot-oriented navigation queries as in other NoSQL products like MongoDB. My thought is that not all user knows which node ID to start with and it is a pain most of the time to find out, but they know property values associated with nodes or edges like user_name etc., -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3223111.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to run webadmin for high availability neo4j custer?
neo4j-sh (0)$ start morpheus = (node_auto_index, name, 'Morpheus') match morpheus-[:KNOWS]-zionist where zionist.age? 32 return zionist.name order by zionist.name desc skip 1 limit 5 org.neo4j.cypher.SyntaxException: string matching regex `(?i)\Qreturn\E' expected but `?' found -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3223382.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to run webadmin for high availability neo4j custer?
Thanks, the 2 Cypher queries you provided work now. In your sample (1) You put start x = (*node_auto_index *, name, However, in my neo4j.property it has *node_auto_indexing*=true. They don't really match literally, do they? (2) Is there a way in Cypher to select all property values as in SQL select *** from ... rather than literally specifying every property in the return list, e.g., return zionist.*name*? (2) How does one return node/edge id from Cypher? -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3223908.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to run webadmin for high availability neo4j custer?
Thanks Peter for puting together the new wiki page to help future neo4j users undersatanding how to use Cypher with the Matrix graph example -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3226115.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to run webadmin for high availability neo4j custer?
Hi Andreas, thanks for offering a sample application that shows how to configure webadmin with HA cluster. Kindly let me know when you have the infomation available in your Wiki, preferrably a link that can be navigated from the http://wiki.neo4j.org/content/High_Availability_Cluster -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/How-to-run-webadmin-for-high-availability-neo4j-custer-tp3216706p3226135.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to connect Neoclipse remotely
Hi Michael, I was trying to run Win32 Neoclipse 1.4 on Linux Neo4j HA standalone servers to replace the webadmin graph. I wonder if you have figured out a way to do that other than exporting the Samba/NFS from Linux side? Also like other Neo4j clients, Neoclips should not be the sole user that requires exclusive lock on graph.db folder as in Windows. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-How-to-connect-Neoclipse-remotely-tp2822321p3229174.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to connect Neoclipse remotely
2. change the mode to remote Where is the place in Neoclips that I can set this remote mode? 4. open the dialog again, the Database Resource URI field is now enabled. Where does the Database Resource URI field shows up in Neoclipse? -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-How-to-connect-Neoclipse-remotely-tp2822321p3236021.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Easy to switch from Embedded to HighAvailability graph?
If your project plans to switch to HA cluster, you may want to take a look at the topic How to run webadmin for high availability neo4j custer? I posted. As of now, I am still waiting for someone from Neo4j dev team to respond to my reqeust: Hi Andreas, thanks for offering a sample application that shows how to configure webadmin with HA cluster. Kindly let me know when you have the infomation available in your Wiki, preferrably a link that can be navigated from the http://wiki.neo4j.org/content/High_Availability_Cluster -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-Easy-to-switch-from-Embedded-to-HighAvailability-graph-tp3233300p3236143.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Easy to switch from Embedded to HighAvailability graph?
Thanks Andreas for the update on this topic. Please keep us posted once you finish the wiki doc. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-Easy-to-switch-from-Embedded-to-HighAvailability-graph-tp3233300p3237217.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] How to connect Neoclipse remotely
Hi Andreas, In later versions of Neoclipse, there's no remote mode. To inspect a running DB you can use the read-only mode Not sure what do you mean by use read-only mode to inspect running DB. The question here is how to connect Neoclipse to remote server and you said that it is not supported in current version even though it was avilable in v1.2 (not sure why dropping this feature though). For local Windows neo4j server, I can connect Neoclips to with either read-only or read-write. -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-How-to-connect-Neoclipse-remotely-tp2822321p3239138.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Neo4J SQLIMporter question
it appears that one of the SQL Importer component LuceneIndexBatchInserterImpl from https://svn.neo4j.org/laboratory/users/peter/sqlimport/ is no longer supported in current v1.4 (last supported in v1.2). ISo that begs the question if SQL Importer still a via way to import SQL data into Neo4j? -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Re-Neo4j-Neo4J-SQLIMporter-question-tp2508296p3239511.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Neo4J SQLIMporter question
Thanks for the offer. I try to attach the data model diagram I intend to import into Neo4j. However, once I click either Insert Image or Upload a file button, the Post Message button dispperas from my IE Firefox brower. Please advise how can I send you the diagram. A quick question on data import: almost all DB offers some sort of command line utility to import/export data in/out their DB w/o the need to write any code. Shouldn't Neo4j do the same? -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Re-Neo4j-Neo4J-SQLIMporter-question-tp2508296p3239655.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Neo4J SQLIMporter question
Please download data model diagram from: http://s1218.photobucket.com/albums/dd412/dhsieh4/Neo4j/?action=viewcurrent=Data_Model.jpg -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Re-Neo4j-Neo4J-SQLIMporter-question-tp2508296p3239939.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Neo4J SQLIMporter question
to comment on that diagram, can items be in one category, and be part of a product that is part of another category? Yes, that is possible Also, what does the SQL you are trying to import look like? Should it be converted into this schema? Yes, pleaes use this schema as the source and the SQL insert looks like: insert into item (item_id, item_name) values (1001, 'item_1001'); insert into seller (seller_id, seller_name) values (2001, 'seller_2001'); .. etc., -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Re-Neo4j-Neo4J-SQLIMporter-question-tp2508296p3239973.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
Re: [Neo4j] Replication corner cases?
According to http://docs.neo4j.org/chunked/stable/ha-architecture.html, this is my understanding and I would like for confirmation from Neo4j: A slave will handle writes by synchronizing with the master to preserve consistency. It sounds like 2-phase commit between write initiated slave master nodes. Updates will however propagate from the master to other slaves eventually so a write from one slave is not immediately visible on all other slaves. It sounds like eventual consistency from master to other slaves. if so, I am interested in finding out details about Neo4j HA member nodes voting quorum arbitrater setup (assuming using zookeeper) -- View this message in context: http://neo4j-community-discussions.438527.n3.nabble.com/Neo4j-Replication-corner-cases-tp3246146p3247312.html Sent from the Neo4j Community Discussions mailing list archive at Nabble.com. ___ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
