Re: [orientdb] Server side functions

2015-04-22 Thread Luigi Dell'Aquila
Hi Diaa, if you are implementing your functions in Javascript you can refer to this http://orientdb.com/docs/last/Functions.html To implement functions in Java, instead, you have to implement OSQLFunction interface and register functions in the database using

Re: [orientdb] De-duplication is very slow?

2015-04-22 Thread Luigi Dell'Aquila
the less, it should be possible to do such transactions also on remote. So that it is possible for multiple worker to upload data to the database. Any ideas how to make this faster? Regards, Sven Am Dienstag, 21. April 2015 17:11:19 UTC+2 schrieb Luigi Dell'Aquila: much *F*aster of course

Re: [orientdb] De-duplication is very slow?

2015-04-21 Thread Luigi Dell'Aquila
much *F*aster of course, not *m*aster... 2015-04-21 17:10 GMT+02:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Ok, I saw the remote only now. If you want to go much master you should use plocal (this avoids network overhead). If you need other clients to connect to the db in remote mode

Re: [orientdb] De-duplication is very slow?

2015-04-21 Thread Luigi Dell'Aquila
Hi Sven, how are you connected to the db (remote or plocal)? Could you post the details of your db schema, in terms of classes, properties and index definitions? Thanks Luigi 2015-04-21 17:03 GMT+02:00 Sven Hodapp sven.hod...@gmail.com: Hi together, for my project I want to import a lot

Re: [orientdb] De-duplication is very slow?

2015-04-21 Thread Luigi Dell'Aquila
Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi Sven, how are you connected to the db (remote or plocal)? Could you post the details of your db schema, in terms of classes, properties and index definitions? Thanks Luigi 2015-04-21 17:03 GMT+02:00 Sven Hodapp sven.hod...@gmail.com

Re: [orientdb] How to speed up queries

2015-04-21 Thread Luigi Dell'Aquila
Hi cr0xfyre, how are you measuring these times? Are you reading the query EXPLAIN? I ask because this could be just the time Studio takes to render the results, a query like this should take a few tens milliseconds to execute. Luigi 2015-04-21 13:01 GMT+02:00 cr0xfyre achi...@gmail.com: Hi

Re: [orientdb] Indexing strategy for documents with big number of fields

2015-04-20 Thread Luigi Dell'Aquila
Hi Valeri, composed indexes in some cases can be used also in basic queries, eg. if you have an index defined on properties A, B and C, the following will use the index too: select from Foo where A = 1 It is only true if the fields in the query are a prefix of the index itself (eg. properties

Re: [orientdb] Returning a tree structure

2015-04-20 Thread Luigi Dell'Aquila
Hi Caleb, which API are you using? You can get this result just with a SELECT FROM a FETCHPLAN *:-1 2015-04-19 12:07 GMT+02:00 cloveret...@gmail.com: Hi all, Suppose that I have a tree like this: - d | - b || a--- - e | - c - f

Re: [orientdb] Want understand the concept.

2015-04-20 Thread Luigi Dell'Aquila
Hi Mahesh, I will give you two examples, one with documents and links and the other with vertices and edges. Ex1: You have a class Person with a link property father that points to another person you can do traverse father from (select from Person where name = 'Bill') while $depth 3 you will

Re: [orientdb] Re: list() function in distributed mode

2015-04-20 Thread Luigi Dell'Aquila
Hi, no, it's not the expected behavior, query execution is supposed to return the same results in single node and in distributed. Could you please open an issue and (if you can) provide a simple test case? Thanks 2015-04-17 11:41 GMT+02:00 ccasen...@axway.com: Anyone to help ? -- ---

Re: [orientdb] Re: Is $current not working with traverse?

2015-04-15 Thread Luigi Dell'Aquila
Hi Vitor, I'm looking at that (actually thanks to this I found a regression on 2.1-snapshot and I'm fixing it too). I'll give you a feedback ASAP Luigi 2015-04-14 21:08 GMT+02:00 Vitor Enes Duarte vitorenesdua...@gmail.com: Sorry to push this. Is this an issue or am I missing something?

Re: [orientdb] Graph API and Indices on Edge Properties

2015-04-15 Thread Luigi Dell'Aquila
Hi Stefano, this cannot work, because the document structure you have under the hood is this: (dataset vertex record) --(lives edge record)-- (collection vertex record) so the out_lives will not contain a collectionid, but one or more record ids of edges that then point to the collection. I

Re: [orientdb] Select if multiple paths are fullfilled

2015-04-15 Thread Luigi Dell'Aquila
Hi Patrick a way to do this is the following SELECT FROM (SELECT expand(out(Owns)) from #16:1) where out(Located) contains #17:0 another way is with the intersect, that is supposed to work... I see that at the beginning of main select there is a spare parenthesis, maybe that's the problem. If

Re: [orientdb] schema-less index support

2015-04-08 Thread Luigi Dell'Aquila
Hi Jeff, this functionality is not currently in our roadmap. You could open a feature request on OrientDB issue tracker, we will take it into consideration Regards Luigi 2015-04-07 19:44 GMT+02:00 jwcarp...@gmail.com: Hi, I don't believe it is currently possible in OrientDB to create

Re: [orientdb] Re: Getting an error while searching for a string containing a single quote from java

2015-04-08 Thread Luigi Dell'Aquila
Hi Muley, could you please try it with 2.1-SNAPSHOT or develop branch? I think it was fixed it this release. Luigi 2015-04-08 8:13 GMT+02:00 Muley savi.mu...@gmail.com: Hi, The problem is with single quote only. The same query is working properly for normal string searching full error

Re: [orientdb] Is it possible to filter on multiple indexed properties in one query

2015-04-07 Thread Luigi Dell'Aquila
Hi, current query executor cannot handle multiple indexes for multiple AND clauses. To do this you have to use a simple trick: execute two subqueries with LET assignment and then use intersect() function. eg. select intersect($a, $b) let $a = (subquery1), $b = (subquery2) 2015-04-04 14:10

Re: [orientdb] InstantiationException when using traversedElement

2015-04-07 Thread Luigi Dell'Aquila
Hi Elliot, I noticed that in some cases traversedElement() acts in a strange way when used in outer queries (referring to inner query traversal). I'd like to go deeper into this, could you please: 1) try with select traversedElement(-2) ... and let me know what happens 2) post the full stack

Re: [orientdb] evaluating OrientDB

2015-04-07 Thread Luigi Dell'Aquila
Hi Mihai, This use case is typical for a graph database, so I think OrientDB is a perfect fit. You already have Dijkstra function, so you can use it or modify it to create your own custom logic. About connected subgraphs, you will be able to find what you need with very simple TRAVERSE queries

Re: [orientdb] Re: Get access to OrientDB through Matlab, possible?

2015-04-07 Thread Luigi Dell'Aquila
Hi Kun, MATLAB also supports HTTP/REST http://it.mathworks.com/help/matlab/ref/webread.html You can use it to query OrientDB http://www.orientechnologies.com/docs/last/OrientDB-REST.html Regards Luigi 2015-04-04 22:01 GMT+02:00 Mattox Beckman mattoxbeck...@gmail.com: Matlab seems to have a

Re: [orientdb] Getting an error while searching for a string containing a single quote from java

2015-04-07 Thread Luigi Dell'Aquila
Hi, which OrientDB version? Thanks Luigi 2015-04-06 14:24 GMT+02:00 Muley savi.mu...@gmail.com: HI, I'm trying to search for a string from java application.My search string is for ex : abc's and my search query is select * from ( select expand( out('ProfileMasterTagEdge') ) from

Re: [orientdb] In memory distributed graph database .

2015-04-07 Thread Luigi Dell'Aquila
Hi Mahesh, an embedded database has a physical representation of data in files (clusters) and a partial memory copy of them (disk cache). When you read data, if they are not in memory, cluster pages are loaded from files to disk cache. When you insert/update records, they are written in disk

Re: [orientdb] Customize graph visualization

2015-04-01 Thread Luigi Dell'Aquila
at 11:52:32 AM UTC-4, Luigi Dell'Aquila wrote: Hi Fabio, OrientDB Studio is open source, you can find source code here: https://github.com/orientechnologies/orientdb-studio It would be great if you could improve the standard behavior and become an OrientDB contributor! Regards Luigi 2015

Re: [orientdb] schema reflection and extension

2015-04-01 Thread Luigi Dell'Aquila
Hi in OrientDB you can obtain schema information with select expand(classes) from metadata:schema or from java API with db.getMetadata().getSchema() and this will give you all the information about classes, properties and indexes You can also add custom metadata to classes and properties using

Re: [orientdb] Customize graph visualization

2015-04-01 Thread Luigi Dell'Aquila
should have been an RTFM question :) On Wednesday, April 1, 2015 at 7:52:10 AM UTC-4, Luigi Dell'Aquila wrote: Hi Cameron Studio at this time does not have an internal structure for plugins and there are no plans for that, but you know, many decisions come from community needs, so if it's

Re: [orientdb] interesting question (unanswered) on stackoverflow: does OrientDB support hypergraphs

2015-03-28 Thread Luigi Dell'Aquila
IMHO it's merely a bug, edge creation should check that both ends are vertices Luigi 2015-03-26 13:12 GMT+01:00 MrFT frederik.til...@vsko.be: http://stackoverflow.com/questions/28781749/am-i-supposed-to-be-able-to-create-edges-between-two-edges-and-or-an-edge-and-a Am I supposed to be

Re: [orientdb] Cluster and class in OrientDB

2015-03-26 Thread Luigi Dell'Aquila
Hi Kun, the answer to your question is no, in a single cluster you will find only instances of a single class (that are also instances of its superclasses of course). Luigi 2015-03-25 22:35 GMT+01:00 Kun Liu liukunofc...@gmail.com: Hi All, I am new to OrientDB and learning it now. I wonder

Re: [orientdb] Hooks on vertices and edges

2015-03-26 Thread Luigi Dell'Aquila
Hi David, you can just let V and E extend OTriggered, or define your hooks in Java if you want to avoid it. Regards Luigi 2015-03-26 0:40 GMT+01:00 David Carr dcarr...@gmail.com: After a bit of trial and error, I have been able to get hooks working on custom classes extended from the

Re: [orientdb] find_or_create in OrientDB?

2015-03-25 Thread Luigi Dell'Aquila
is a class exists (using SQL)? Thanks, Patrick On Monday, March 23, 2015 at 1:31:49 AM UTC-6, Luigi Dell'Aquila wrote: 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

Re: [orientdb] Customize graph visualization

2015-03-25 Thread Luigi Dell'Aquila
Hi Fabio, OrientDB Studio is open source, you can find source code here: https://github.com/orientechnologies/orientdb-studio It would be great if you could improve the standard behavior and become an OrientDB contributor! Regards Luigi 2015-03-25 14:34 GMT+01:00 Fábio Costa

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] 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
for command request: sql.upsert On Wednesday, February 4, 2015 at 9:08:04 AM UTC-6, Luigi Dell'Aquila wrote: Hi Artem, have you tried with UPSERT? Here you can find all the references: http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Update.html Regards Luigi 2015-02-04 13

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] Determine record owner?

2015-03-19 Thread Luigi Dell'Aquila
to implement hierarchical access to data so that field has more than just the owner. It has the owner and all of the owner's parents so not an easy way to determine which in fact is the owner of the data. Any other way I can get the owner? On Tuesday, March 17, 2015 at 8:50:35 AM UTC-7, Luigi

Re: [orientdb] Determine record owner?

2015-03-18 Thread Luigi Dell'Aquila
V and E? Are there special powers associated with V and E that I would lose in such a case? Thanks very much! Patrick On Tuesday, March 17, 2015 at 9:50:35 AM UTC-6, Luigi Dell'Aquila wrote: Hi Rob, if your class extends ORestricted, the owner is tracked in one of the following fields

Re: [orientdb] Determine record owner?

2015-03-17 Thread Luigi Dell'Aquila
Hi Rob, if your class extends ORestricted, the owner is tracked in one of the following fields: _allow _allowRead _allowUpdate _allowDelete 2015-03-17 16:39 GMT+01:00 Rob Gratz gratz@gmail.com: Is there a way to obtain which user created or owns a record? -- --- You received this

Re: [orientdb] Time series query

2015-03-16 Thread Luigi Dell'Aquila
Hi Vadim, I don't know how many items you expect in your db, but I think your data representation could take you to very expensive queries... I suggest you to take a look at this, maybe you can pick some ideas http://www.slideshare.net/LuigiDellAquila/orientdb-time-representation Luigi

Re: [orientdb] Re: What is the fastest way to save 10M edges in OrientDB?

2015-03-13 Thread Luigi Dell'Aquila
Hi Joao, it depends on how your source data are represented. If you have sequential integer/long keys for vertexes, you can use OGraphBatchInsert class Luigi 2015-03-13 10:30 GMT+01:00 Vitor Enes Duarte vitorenesdua...@gmail.com: graph.declareIntent(new OIntentMassiveInsert()); // inserts

Re: [orientdb] Lightweight vs Standard/Regular Edges

2015-03-12 Thread Luigi Dell'Aquila
Hi Jeffrey, I think you looked at this: http://www.orientechnologies.com/docs/last/orientdb.wiki/Lightweight-Edges.html In terms of performance lightweight edges are better, but they are harder to manage because: - you cannot refer a lightweight edge by its RID (a lightweight edge is not a

Re: [orientdb] Re: Lightweight vs Standard/Regular Edges

2015-03-12 Thread Luigi Dell'Aquila
Exactly 2015-03-12 18:03 GMT+01:00 Jeffrey Auguste mrjaugu...@gmail.com: Ah, so I can create an edge class extended from E and it will still be lightweight, Its when/if I add link properties to it, that it will then become an edge document. On Thu, Mar 12, 2015 at 12:57 PM, Luigi

Re: [orientdb] Re: Lightweight vs Standard/Regular Edges

2015-03-12 Thread Luigi Dell'Aquila
Yes, it's right, you can turn lightweight edges on in any moment. Actually to create a regular edge (instead of lightweight), defining a class for it is not enough, you just have to explicitly add a property to that. Luigi 2015-03-12 17:55 GMT+01:00 Jeffrey Auguste mrjaugu...@gmail.com: So it

Re: [orientdb] Re: how to handle property 'id' in a class

2015-03-12 Thread Luigi Dell'Aquila
Hi Aaron, TinkerPop Blueprints considers id as a reserved property name, so you cannot use it, unless you disable standard constraints (exactly what you did!) Luigi 2015-03-12 21:45 GMT+01:00 Aaron Gooch eodgo...@gmail.com: I was able to get around this issue by setting

Re: [orientdb] Re: Rename a Edge class causes the retention of connected Vertexes in/out ridbag names ?

2015-03-12 Thread Luigi Dell'Aquila
Hi guys, we have an open issue about this https://github.com/orientechnologies/orientdb/issues/2081 A work-around is to do a massive update on V class immediately after edge rename, eg. update V set out_NewEdgeClassName = out_OldEdgeClassName update V remove out_OldEdgeClassName update V set

Re: [orientdb] Create distribution from maven repository

2015-03-09 Thread Luigi Dell'Aquila
Hi Alexander, AFAIK you cannot create a full distribution from maven repositories. If you want a particular Git branch or tag, I suggest you to clone it locally (see https://github.com/orientechnologies/orientdb ) and then launch ant clean install you will have a full distribution in

Re: [orientdb] compound index seems to be ignored

2015-03-06 Thread Luigi Dell'Aquila
for testing, or some test data with the query and index I'm using? Best regards, Mate On Thursday, March 5, 2015 at 10:51:26 AM UTC+1, Luigi Dell'Aquila wrote: Hi Mate, there are no limitations in the number of properties that can be indexed, so there must be a bug somewhere. Could you

Re: [orientdb] compound index seems to be ignored

2015-03-05 Thread Luigi Dell'Aquila
Hi Mate, there are no limitations in the number of properties that can be indexed, so there must be a bug somewhere. Could you provide a test case to reproduce it? Thanks Luigi 2015-03-04 22:25 GMT+01:00 Máté Gábri gabrim...@gmail.com: Hi, I'm trying to get familiar with OrientDB's

Re: [orientdb] security profiling

2015-03-03 Thread Luigi Dell'Aquila
Hi Raffaela, at this time the only section about security is chapter 5. We are enriching the documentation every day, with a continuous and iterative work, so if you have any suggestions about what you want to see covered, we will be happy to take them into consideration Thanks Luigi

Re: [orientdb] Re: Need Data Modeling Help

2015-03-03 Thread Luigi Dell'Aquila
Hi Kiheung, answers below: 2015-03-02 23:39 GMT+01:00 Kiheung Park kihpar...@gmail.com: Hi Colin, Question 1: You'll just embed another document (or vertex) in the contact property. Are you trying to do this from the Java API? -- Yes or no. I was trying to modeling through studio. If Java

Re: [orientdb] No index use when using sub query

2015-03-02 Thread Luigi Dell'Aquila
in github for this? Thanks, Jamie On Monday, March 2, 2015 at 4:55:51 PM UTC, Luigi Dell'Aquila wrote: Hi Jamie, this is a known issue, we are working hard on the new query parser and executor and one of the main goals of all this is query optimization. Thanks Luigi 2015-03-02 17:11

Re: [orientdb] No index use when using sub query

2015-03-02 Thread Luigi Dell'Aquila
Hi Jamie, this is a known issue, we are working hard on the new query parser and executor and one of the main goals of all this is query optimization. Thanks Luigi 2015-03-02 17:11 GMT+01:00 Jamie Blair jamie.bl...@gmail.com: The following query returns a set of `@rid` and completes in

Re: [orientdb] in and out

2015-02-25 Thread Luigi Dell'Aquila
Hi, you can use CONTAINS instead of = (because in_* and out_* are collections) I also suggest you to use in() and out() functions, eg. select in(Owns).userID from items Luigi 2015-02-25 8:18 GMT+01:00 Dlpnet dlp...@gmail.com: Hello I have a simple DB: users -- Owns -- items when I

Re: [orientdb] Can not get sub-query with variable to work. Some help would be great!

2015-02-24 Thread Luigi Dell'Aquila
15:55 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi Julian, first of all let's make your query work, this is the right one: select from FOrder where user IN (select @rid from FUser where userId = 642255) Please note that I used IN operator instead of = because a query returns

Re: [orientdb] Re: Get available edge types for a vertex - Java API

2015-02-20 Thread Luigi Dell'Aquila
Hi Stefan, there is no explicit support to this (you can open a feature request on the issue tracker if you want), but there is a work-around to obtain this information: OrientVertex v = ... ODocument doc = v.getRecord(); String fieldNames = doc.fieldNames(); ListString edgeClassNames = new

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-19 Thread Luigi Dell'Aquila
, I tried doing a plocal (create a DB as plocal ? ) can you please help me how to go with it? I am a newbei to orientdb. We are trying to have a data model as DWH like facts and dimensions in orientdb. Thanks, Shivanandan Gupta On Thursday, 19 February 2015 13:26:58 UTC+5:30, Luigi

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-19 Thread Luigi Dell'Aquila
2015 14:40:04 UTC+5:30, Luigi Dell'Aquila wrote: Hi Shivanandan, you can just replace this loader: { orientdb: { dbURL: remote:localhost/databases/indb, dbUser: root, dbPassword: root, dbAutoCreate: true, tx: false, batchCommit: 1, dbType: graph

Re: [orientdb] Bulk data load Performance Benchmark and Tuning

2015-02-18 Thread Luigi Dell'Aquila
Hi Shivanandan, the easy way to go faster is using plocal instead of remote, but I don't know if in your case it's possible (other instances OrientDB have to be shut down for the time ETL works...) Luigi 2015-02-19 7:19 GMT+01:00 Shivanandan Gupta shivnandangu...@gmail.com: Hi All, I tried

[orientdb] A taste of OrientDB 2.1

2015-02-16 Thread Luigi Dell'Aquila
TO MAKE IT PERFECT!!! Thanks Luigi -- Luigi Dell'Aquila Orient Technologies LTD -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr

Re: [orientdb] Clustering

2015-02-11 Thread Luigi Dell'Aquila
by Luca, http://stackoverflow.com/questions/22606111/orientdb-problems-with-clusters-concept. I thought I might be missing out something. On Wednesday, February 11, 2015 at 5:42:27 PM UTC+8, Luigi Dell'Aquila wrote: Hi Goh, That post is really misleading... In OrientDB you can define multiple

Re: [orientdb] help query edge

2015-02-11 Thread Luigi Dell'Aquila
Hi Renzo, the first query should be something like select expand(inE('owner')[color ='red'].outV()) from car where name = 'Ferrari' The second one is just select out.name as ownerName, color, in.name as carName from owner Luigi 2015-02-10 22:08 GMT+01:00 Renzo Ludeña

Re: [orientdb] Clustering

2015-02-11 Thread Luigi Dell'Aquila
Hi Goh, That post is really misleading... In OrientDB you can define multiple clusters per class, and all the sharding architecture is based on that. To have a better idea of this I suggest you to check the following links

Re: [orientdb] Restrict ShortestPath and Dijkstra to a specific Edge class

2015-02-10 Thread Luigi Dell'Aquila
the first path ? It seems like a bit of a hack, don't you think ? :( I'm using OrientDB 2.0.1 BTW. Thanks ! On Tuesday, February 10, 2015 at 8:53:58 AM UTC+1, Luigi Dell'Aquila wrote: Hi Georg, in current implementation it's not possible. Anyway Dijkstra and ShortestPath functions

Re: [orientdb] Restrict ShortestPath and Dijkstra to a specific Edge class

2015-02-09 Thread Luigi Dell'Aquila
Hi Georg, in current implementation it's not possible. Anyway Dijkstra and ShortestPath functions are quite simple (links to the source code below), you could just implement your own version starting from them and (why not?) send a pull request and become OrientDB contributor.

Re: [orientdb] UnsupportedOperationException When Creating in Memory Distributed Database

2015-02-06 Thread Luigi Dell'Aquila
Hi Andy, This is a known issue, you can find all the details here: https://github.com/orientechnologies/orientdb/issues/3203 Luigi 2015-02-05 16:58 GMT+01:00 dakota.pric...@gmail.com: Hello, I am unable to create an in MEMORY distributed database due to the following exception:

Re: [orientdb] Insertion into Graphs using txt file

2015-02-04 Thread Luigi Dell'Aquila
Hi Arinath, if it's just a one-shot batch insert, you can write a simple Java program and use OGraphBatchInsertBasic class, that is specifically designed for this simple use case. Otherwise you could think about using OrientDB ETL and define a simple importer from CSV, see

Re: [orientdb] Strict Schema Mode : Adding and removing properties

2015-02-04 Thread Luigi Dell'Aquila
Hi, current implementation of schema manipulation is not so strict, and especially is not related to already existing data, but only to new operations. We know this is an issue and we are addressing it, you will find important changes about this in next releases Luigi 2015-02-03 18:28

Re: [orientdb] find_or_create in OrientDB?

2015-02-04 Thread Luigi Dell'Aquila
Hi Artem, have you tried with UPSERT? Here you can find all the references: http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Update.html Regards Luigi 2015-02-04 13:25 GMT+01:00 Artem Shoobovych shybovy...@gmail.com: Hi there! Lately, I've been playing with OrientDB of 1.7.10

Re: [orientdb] OrientDB slow query performance

2015-01-30 Thread Luigi Dell'Aquila
; } public double Height { get; set; } public DateTime DateOfBirth { get; set; } public decimal Salary { get; set; } } On Friday, January 30, 2015 at 5:31:29 PM UTC+8, Luigi Dell'Aquila wrote: Hi Siang, all hash indexes do not support range queries (they are based on hash

Re: [orientdb] Best time to create vertex properties

2015-01-30 Thread Luigi Dell'Aquila
Hi Oleg, do you mean that you are adding properties to the schema or that you are adding property values to existing vertexes? What I suggest you is: - create schema with properties before the insert operations (this will save space on the disk because property names are not stored in the record

Re: [orientdb] OrientDB slow query performance

2015-01-30 Thread Luigi Dell'Aquila
have any suggestion? Thanks. On Friday, January 30, 2015 at 4:43:25 PM UTC+8, Luigi Dell'Aquila wrote: Hi Siang, which kind of index did you define? Not all types of index support range queries Luigi 2015-01-30 9:05 GMT+01:00 Siang Hwee Goh gohsia...@gmail.com: I am evaluating

Re: [orientdb] Best time to create vertex properties

2015-01-30 Thread Luigi Dell'Aquila
Of course I meant use plocal instead of remoTe Just a typo ;-) Luigi 2015-01-30 11:29 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi Oleg, do you mean that you are adding properties to the schema or that you are adding property values to existing vertexes? What I suggest you

Re: [orientdb] OrientDB slow query performance

2015-01-30 Thread Luigi Dell'Aquila
Hi Siang, which kind of index did you define? Not all types of index support range queries Luigi 2015-01-30 9:05 GMT+01:00 Siang Hwee Goh gohsiangh...@gmail.com: I am evaluating OrientDB right now and I tried to inserts 1.2 million simple records inside one of the database. It is an

Re: [orientdb] How to delete a property of a schema-less document?

2015-01-30 Thread Luigi Dell'Aquila
oh, sorry, I saw only now that I wrote remote instead of remove ;-) anyway you got the point :) Luigi 2015-01-30 12:49 GMT+01:00 florin flo...@wisemart.com: Thanks! On Friday, January 30, 2015 at 2:29:21 AM UTC-5, Luigi Dell'Aquila wrote: Hi Florin, null is a valid value for a property

Re: [orientdb] Re: Best time to create vertex properties

2015-01-30 Thread Luigi Dell'Aquila
Hi Oleg, it seems to be ok, the throughput depends a lot on the size of single documents, on the number and type of indexes you use (I can say that Lucene indexes demonstrated to have the best performance in insert) and on the type of connection you are using (plocal or remote). 1M per minute

Re: [orientdb] How to delete a property of a schema-less document?

2015-01-29 Thread Luigi Dell'Aquila
Hi Florin, null is a valid value for a property, so setting it to null just leaves it there, in the document. If you want to completely remove a property you have to use this statement: update MyClass remote myPropertyName where... regards Luigi 2015-01-30 1:09 GMT+01:00 florin

Re: [orientdb] Studio graph behavior changed by not showing direct relations straight away

2015-01-26 Thread Luigi Dell'Aquila
to that ? Because from what I can see, I've done nothing different from Rc1 and RC2 to final1. On Monday, January 26, 2015 at 12:05:27 PM UTC, Luigi Dell'Aquila wrote: Hi, this must be because of disabled lightweight vertices. In Graph Studio tab only fetched records and their neighbors

Re: [orientdb] Re: Schema advantage ?

2015-01-08 Thread Luigi Dell'Aquila
Hi, with current version (as Keith said) schema-defined fields are more compact in terms of disk space. In next releases you will also have additional advantages in terms of query speed. But the most significant difference is that defining properties you can - enforce constraints on fields (min,

Re: [orientdb] Business key vs RID

2015-01-06 Thread Luigi Dell'Aquila
Hi George, link traversal is O(1) operation because the RID is like a physical pointer to data. Using UUID would mean relying on an index to find the RID corresponding to the UUID. SBTree index you will give you O(logN) performance. HashIndex will give you a near O(1) performance in the average

Re: [orientdb] case clause?

2014-12-19 Thread Luigi Dell'Aquila
Hi Andrei, In OrientDB you can use the if() function to do what you need. I just added it to the documentation, please check this wiki page. https://github.com/orientechnologies/orientdb/wiki/SQL-Functions Soon it will also be in the official Docs page Luigi 2014-12-19 8:51 GMT+01:00 Andrei

Re: [orientdb] [2.0-RC1] Problem with class named Content

2014-12-18 Thread Luigi Dell'Aquila
Hi Stéphane, content is a reserved word in OrientDB SQL syntax, current parser implementation does not complain about it (while it should), but final result is unpredictable, like this. The new parser implementation is more strict and will report an error at parse time. Strict query syntax

Re: [orientdb] Re: Lightweight Edges vs Other Edges

2014-12-18 Thread Luigi Dell'Aquila
Hi Sajal, lightweight edges are still available and the alter database command is the right way to enable them, so if you are not able to create one maybe there is an error in your code or an issue in the release. Could you provide a snippet of code (or better, a test case) to replicate the

Re: [orientdb] i can't find how to list all databases in java..

2014-12-17 Thread Luigi Dell'Aquila
...? On Wed, Dec 17, 2014 at 12:25 PM, Ankit Jain foranki...@gmail.com wrote: ok.. On Wed, Dec 17, 2014 at 12:22 PM, Ankit Jain foranki...@gmail.com wrote: ok. On Wed, Dec 17, 2014 at 12:21 PM, Luigi Dell'Aquila luigi.dellaqu...@gmail.com wrote: Hi, sorry, I saw this email only now

Re: [orientdb] i can't find how to list all databases in java..

2014-12-16 Thread Luigi Dell'Aquila
+01:00 Ankit Jain foran...@gmail.com: we can find out that from jar file..can u tell in which jar it is?? On Monday, 15 December 2014 19:58:44 UTC+5:30, Luigi Dell'Aquila wrote: Hi, OServetAdmin is in package com.orientechnologies.orient.client.remote Apparently all the client package

Re: [orientdb] Re: Problem with local clusters in distributed mode

2014-12-15 Thread Luigi Dell'Aquila
Hi Stéphane, I suggest you to wait a few hours, as OrientDB RC1 will be released shortly Luigi 2014-12-15 17:01 GMT+01:00 Stéphane Schild stephane.sch...@gmail.com: Hello, You're right, I should not have supposed that this version was stable. However, I need to evaluate OrientDB for my

[orientdb] Re: Limit the # of traversed objects returned: fetchPlan VS traverse VS select?

2014-11-25 Thread Luigi Dell'Aquila
Hi Simon, you can do something like this select set($comments[0], $comments[1], $comments[2]) from SOME_POST_ID let $comments = sort(out('PostHasComment')) or but edges are not guaranteed to be sorted, so you have to write your own sort() function. If you are using M3 or earlier, function

Re: [orientdb] java.lang.IllegalStateException: Missing closed string character: ''' with function

2014-11-25 Thread Luigi Dell'Aquila
Thanks a lot Luigi 2014-11-25 8:25 GMT+01:00 l...@emaxsrl.com: Done! https://github.com/orientechnologies/orientdb/issues/3094 Il giorno lunedì 24 novembre 2014 18:52:05 UTC+1, Luigi Dell'Aquila ha scritto: Hi Luca, this is clearly a bug, could you please report it in OrientDB issue

Re: [orientdb] Re: Limit the # of traversed objects returned: fetchPlan VS traverse VS select?

2014-11-25 Thread Luigi Dell'Aquila
,percentile,median,variance,difference,first]` On Tuesday, November 25, 2014 3:26:46 AM UTC-5, Luigi Dell'Aquila wrote: Hi Simon, you can do something like this select set($comments[0], $comments[1], $comments[2]) from SOME_POST_ID let $comments = sort(out('PostHasComment')) or but edges

Re: [orientdb] Re: Limit the # of traversed objects returned: fetchPlan VS traverse VS select?

2014-11-25 Thread Luigi Dell'Aquila
, Luigi Dell'Aquila wrote: Hi Simon, my mistake, I was not clear at all, the sort() function is not a built-in function, my proposal was to implement your own function called sort() in javascript and use it in the query Luigi 2014-11-25 16:55 GMT+01:00 Simon L si...@pumpup.co: Thanks

Re: [orientdb] Copy a Document

2014-11-25 Thread Luigi Dell'Aquila
Hi Stefan, try to remove parentheses from your query, like this: insert into GermanyClient from select from Client where country = 'Germany' current SQL parser implementation sometimes is not so friendly, we are completely rewriting it and the new one will be released in 2.1 About the fromMap,

Re: [orientdb] Assign label to Lightweight Edge from command line

2014-11-25 Thread Luigi Dell'Aquila
Hi Riccardo, what TinkerPop calls labels is represented by OrientDB classes. You can create a lightweight edge of a particular class with this syntax: CREATE EDGE MyLabel FROM #14:1 TO #14:0 Of course the class MyLabel has to exist and has to extend E If you use the SET labelName = value, the

Re: [orientdb] java.lang.IllegalStateException: Missing closed string character: ''' with function

2014-11-24 Thread Luigi Dell'Aquila
Hi Luca, this is clearly a bug, could you please report it in OrientDB issue tracker? https://github.com/orientechnologies/orientdb/issues We will fix it ASAP thanks Luigi 2014-11-24 18:32 GMT+01:00 l...@emaxsrl.com: Hello, I'm using OrientDB version : 2.0-M3. I created a test function

Re: [orientdb] Querying OrientDB documents slower than expected - advise needed

2014-11-14 Thread Luigi Dell'Aquila
Hi Jan, in this use case you will not have big advantage from typical NoSQL features like index free adjacency (that means fast traversal) or dynamic schema management. You are actually using OrientDB as a relational db. Anyway performance you are having is definitely too slow! I suggest you to

Re: [orientdb] Querying OrientDB documents slower than expected - advise needed

2014-11-14 Thread Luigi Dell'Aquila
ah, for cases where you know that you don't need range queries I suggest you to use OClass.INDEX_TYPE.NOTUNIQUE_HASH_INDEX, it's much much faster! Luigi 2014-11-14 10:04 GMT+01:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi Jan, in this use case you will not have big advantage from

Re: [orientdb] Re: installing OrientDB in a non controlled environment

2014-11-14 Thread Luigi Dell'Aquila
Hi Charles, at this moment there is no built-in procedure to encrypt root password, anyway IMHO this problem can be bypassed with some simple modifications. The real problem is another one: the DB files are not encrypted in any way, so if your customer copies the orient/databases/ directory on

Re: [orientdb] Re: CSV Field to collection field

2014-11-12 Thread Luigi Dell'Aquila
Hi, the best thing to do this should be something like this: update myClass set columnB = columnA.split(,) but unfortunately it's NOT supported at this time. As a work around, you can define your own split() function like this - two parameters: inputString and separator - this function body:

Re: [orientdb] New to Graphs - best schema for data collection?

2014-11-07 Thread Luigi Dell'Aquila
Hi Mark, one or two years ago I tested OrientDB on Raspberry PI and it worked fine (of course the performance was not the same as on my laptop, but it was more than acceptable). At that time I used Java8 alpha for ARM and that gave me very good results. If what you are interested in is a time

Re: [orientdb] Re: Creating server side functions

2014-11-06 Thread Luigi Dell'Aquila
Hi Kristoffer, Invoking server side functions from inside other functions should be straightforward. Could you post some of your code? Maybe we can help you better that way. Luigi 2014-11-06 13:06 GMT+01:00 BojanV bboojja...@gmail.com: Did you try with sql batch?

Re: [orientdb] Re: Creating server side functions

2014-11-06 Thread Luigi Dell'Aquila
:10 UTC+1 torsdag 6. november 2014 skrev Luigi Dell'Aquila følgende: Hi Kristoffer, Of course you can use this approach, this is not bad practice in general, but sometimes you can find easier solutions to do that. Here are a couple of examples, they all work fine for me. I hope you can find

Re: [orientdb] Re: Java API - get the last out_edge of a certain type

2014-11-05 Thread Luigi Dell'Aquila
Hi Stefan, I think this can help you http://www.orientechnologies.com/docs/last/orientdb.wiki/Graph-Database-Tinkerpop.html#ordered-edges Luigi 2014-11-05 10:35 GMT+01:00 ste...@activitystream.com: bump ... again On Tuesday, 4 November 2014 08:10:37 UTC, ste...@activitystream.com wrote:

Re: [orientdb] OrientDB operations questions

2014-11-04 Thread Luigi Dell'Aquila
it though. Am I missing something in the release 2 M2 version ? Also, are you planning to have a backup to file system ( not snapshot) and without blocking writes in a future release ? Regards, Santosh On Wednesday, October 29, 2014 4:02:06 AM UTC-7, Luigi Dell'Aquila wrote: Hi Santosh

Re: [orientdb] LET ... not working

2014-11-04 Thread Luigi Dell'Aquila
Hi Frederik, this kind of issues is related to some legacy code in current query parser implementation. We are completely rewriting it, so it will be fixed in 2.1. If you want you can open an issue about this, I'll take care of it. About third query, I tried it in Studio with a fresh

<    1   2   3   4   5   6   7   >