[orientdb] Re: Sticky sharding / sharding by sub-graph?

2015-03-23 Thread Cho Ten Van
oh. I see there is a limit *You can create up to 32,767 (2^15-1) clusters in a database*... http://www.orientechnologies.com/docs/last/Tutorial-Clusters.html so I wouldn't be able to create shards/partitions for 10mln users :( as I understand the only hope for me is to rely on hazelcast to

[orientdb] vertex as document usage

2015-03-23 Thread Aris Alexis
hi, sorry for the noob question but i am using the graph database but some vertices i would like them to be documents. for example the user vertex has a lot of sub documents for the location, phones etc. can I do in my code ODocument od=vertex? and then how to save it? can I use the variables

[orientdb] Re: Sticky sharding / sharding by sub-graph?

2015-03-23 Thread Cho Ten Van
well... I guess, I could use some generic class for all entities, so there is only one class - *Item*, with type and userId attributes on each node, ex: - *User*(id:123,name:john,age:99)-*Item* (type:user, userId:123, name:john,age:99) -

[orientdb] Re: LET clause stocking only last record. Bug or am i doing something wrong ?

2015-03-23 Thread Mihai Pricop
Noone can help me with this ? vineri, 20 martie 2015, 13:19:19 UTC+2, Mihai Pricop a scris: Hi, I am trying to use the LET clause to stock some information in an sub-query, keep the information relative to the record. After another select from the query where I save the variable, the

Re: [orientdb] Upgrade to 2.0.2: Could not initialize class com.orientechnologies.orient.ODatabaseRecordThreadLocal

2015-03-23 Thread Roar
Hi, Tried again today with 2.0.5 and had the same issue: *java.lang.NoClassDefFoundError: Could not initialize class com.orientechnologies.orient.core.db.ODatabaseRecordThreadLocal* Are there any plans to fix this issue? I'm stuck on 1.7.10 as long as this doesn't work and I really need to

[orientdb] I can log into my database without any name or password and I'm always root

2015-03-23 Thread 'Curtis Mosters' via OrientDB
Well I noticed that I do not even have to give any credentials into the login mask. It *always *gives my *access *to any database. I never mentioned that before. Also if I create a new database via studio and then login without giving anything in. I'm logged in. Is this a usual behaviour and

Re: [orientdb] Re: vertex as document usage

2015-03-23 Thread Aris Alexis
Hi. I am using the setProperty but I want to keep nested documents in that property like options for the user or accounts that are not just list string but maps. Any nice way of doing this with a vertex? if i use a document object can i create edges for it? because my data is highly connected.

Re: [orientdb] Extreamly slow startup when creating a database (2.0.5 embedded)

2015-03-23 Thread Luigi Dell'Aquila
Hi Stefan, could you give us additional information about this machine? eg operating system, JVM version Thanks Luigi 2015-03-20 22:36 GMT+01:00 ste...@activitystream.com: Hi, We are seeing the strangest thing here. We have an embedded orentdb (2.0.5 / plocal) that create a new database

Re: [orientdb] Extreamly slow startup when creating a database (2.0.5 embedded)

2015-03-23 Thread Stefán
Hi Luigi, It's Ubuntu 14.04 (LTS) and Java 1.8.0.40. I can give you access to it if it helps. Thank you, -Stefan On Monday, 23 March 2015 07:27:41 UTC, Luigi Dell'Aquila wrote: Hi Stefan, could you give us additional information about this machine? eg operating system, JVM version

[orientdb] Re: OrientDB in(), out(), both() - why do we need direction?

2015-03-23 Thread Gregory Pierce
Okay that's perfect. Thanks for the clarification. Definitely need the documents to be updated to help understand the duality of the database and the differences between the two modes. Many times the tutorials/videos will describe an approach and its not clear if they are talking about a vertex

[orientdb] Re: vertex as document usage

2015-03-23 Thread Colin
Hi Aris, A vertex is not a document but does make use of one internally. You can treat a vertex like a document in that you can call setProperty with the same types that ODocument.field() can use. Do note that save() is implicit when using a vertex. If you don't wish to use OrientVertex

Re: [orientdb] Re: Sticky sharding / sharding by sub-graph?

2015-03-23 Thread Luca Garulli
Hi Cho, You could use, let's say, 1,000 shards for your client and provide an hash function that return one of such shard. In this way you can still partitionate your data. Lvc@ On 23 March 2015 at 13:41, Cho Ten Van choten...@gmail.com wrote: oh. I see there is a limit *You can create up to

Re: [orientdb] Re: ETL and edges csv

2015-03-23 Thread Luca Garulli
You're looking up Occupation.id, so an index there would be needed. The rule of the thumb is: create indexes to speedup lookups, like you would do with a RDBMS. Lvc@ On 23 March 2015 at 16:45, Gianpaolo Altamura g.altam...@gmail.com wrote: Hi Luca, thank you for your repl I have created

[orientdb] ETL and edges csv

2015-03-23 Thread Gianpaolo Altamura
I have an csv ratings.dat (http://files.grouplens.org/datasets/movielens/ml-100k.zip) that contains this fields: userID movieID rating 1 1 5 2 1 4 I imported with ETL the user class and movie class now i want to create with ratings.csv edges

Re: [orientdb] ETL and edges csv

2015-03-23 Thread Luca Garulli
Hi Gianpaolo, Have you created indexes against Movies.id and Users.id? Lvc@ On 23 March 2015 at 16:40, Gianpaolo Altamura g.altam...@gmail.com wrote: I have an csv ratings.dat (http://files.grouplens.org/datasets/movielens/ml-100k.zip) that contains this fields: userID movieID rating 1

[orientdb] Re: ETL and edges csv

2015-03-23 Thread Gianpaolo Altamura
Hi Luca, thank you for your repl I have created indexes against Movies.id and Users.id: User.json { config: { log: info, parallel: false }, source: { file: { path: D:\\ETL\\users.dat } }, extractor: { row: { } }, transformers: [{ csv: { separator: ^, columnsOnFirstLine: false, columns: [id,

[orientdb] Re: ETL and edges csv

2015-03-23 Thread Gianpaolo Altamura
Hi Luca, when I created Occupation class I have created an index on Occupation.id . *[58:command] DEBUG executed command=sql.create edge rated from (select from Users where id = $input.userId) to (select from Movies where id = $input.movieId) set ratings = $input.ratings , rating_date =

[orientdb] Re: ETL and edges csv

2015-03-23 Thread Gianpaolo Altamura
This is the output of debug console: [58:csv] DEBUG Transformer input: 2^648^4^978299913 [58:csv] DEBUG parsing=2^648^4^978299913 [58:csv] DEBUG document={userId:2,movieId:648,rating:4,timestamp:Mon Jan 12 08:44:59 CET 1970} [58:csv] DEBUG Transformer output:

[orientdb] Re: ETL and edges csv

2015-03-23 Thread Gianpaolo Altamura
Solved! The problem are the variables. I changed $input.attribute in ${input.attribute} Ratings.json { config: { log: info, parallel: false }, source: { file: { path: D:\\ETL\\ratings.dat } }, extractor: { row: { } }, transformers: [{ csv: { separator: ^, columnsOnFirstLine: false, columns:

Re: [orientdb] Re: vertex as document usage

2015-03-23 Thread Colin
When you say nested documents, do you mean like a map or set of embedded or linked documents? You can use all the same types in a vertex as you can with a document. Just think of an OrientVertex as a hybrid of a node and a document. Just stick with the Vertex and create edges for it while

[orientdb] Re: OrientDB in(), out(), both() - why do we need direction?

2015-03-23 Thread Colin
Agreed! That's something we're working on to improve the documentation and the tutorials to be more clear. Thanks, -Colin Orient Technologies The Company behind OrientDB On Monday, March 23, 2015 at 9:40:12 AM UTC-5, Gregory Pierce wrote: Okay that's perfect. Thanks for the clarification.

Re: [orientdb] Re: Sticky sharding / sharding by sub-graph?

2015-03-23 Thread Cho Ten Van
Lvc@ thank you for your reply, I will consider this option :) On Monday, March 23, 2015 at 6:44:05 PM UTC+3, Lvc@ wrote: Hi Cho, You could use, let's say, 1,000 shards for your client and provide an hash function that return one of such shard. In this way you can still partitionate your

Re: [orientdb] Re: insert or select?

2015-03-23 Thread Luigi Dell'Aquila
Hi, I already answered in your previous email ;-) 2015-03-22 0:44 GMT+01:00 pumplerod pumple...@gmail.com: I'm sorry, I thought I was in the pyorient group. Though perhaps someone here can answer the question. On Saturday, March 21, 2015 at 6:43:21 PM UTC-5, pumplerod wrote: is there

Re: [orientdb] find_or_create in OrientDB?

2015-03-23 Thread Luigi Dell'Aquila
Hi Upsert is just a keyword in the UPDATE statement, eg. update V set id = '12', name = 'foo' upsert where id = '12' you can find all the docs here http://www.orientechnologies.com/docs/last/SQL-Update.html Luigi 2015-03-22 0:17 GMT+01:00 pumplerod pumple...@gmail.com: Is there example

Re: [orientdb] Strip Javascript and/or HTML code when inserting/updating

2015-03-23 Thread Luigi Dell'Aquila
Hi Stas, you could implement a hook for this. You can do this in Java or Javascript (see http://www.orientechnologies.com/docs/last/Hook.html ), just ensure to * bind your application logic on the following events: onBeforeCreate, onBeforeUpdate * let your hook functions return RECORD_CHANGED

Re: [orientdb] Re: Is using ElasticSearch with OrientDB possible?

2015-03-23 Thread Kevin I
Thanks all for the suggestions. From what I've understood so far, I think it's better to go with Orientdb-Lucene for now. I don't think its worth the effort to make ES work with OrientDB as it clearly requires some additional work in updating the indices in ES, since the application I am working

[orientdb] EXPLAIN for gremlin

2015-03-23 Thread kyle
1) Is there any way to get query explanations for gremlin queries like EXPLAIN does for osql? 2) My understanding is that gremlin queries are translated into osql queries, is there any way to see this translation? It would be helpful for performance tuning and learning osql. -- --- You