Re: [orientdb] We've a new committer: Luigi Dell'Aquila!

; > > On 04/04/14 21:03, Luca Garulli wrote: > > Hi all, > I'm glad to announce Luigi Dell'Aquila as new committer of OrientDB > Project. Maybe some of you already know Luigi as a OrientDB Academy Teacher. > > Luigi's main contribution are about performance

Re: [orientdb] Calling OrientDB function from SQL command

Hi Gaurav, I'd like to see your function code to be sure, but I guess you are trying to access the "request" object (eg. trying to retrieve a request parameter). Request object is not present when invoking a function inside a query. Let me explain in depth, you can invoke JS functions in many ways

Re: [orientdb] Calling OrientDB function from SQL command

> {"@type":"d","@rid":"#14:4","@version":2,"@class":"MasterCountry","name":"American > Samoa","code":"AS","resetFlag":true}, > {"@type":"d","@rid&qu

Re: [orientdb] Re: OrientDB and Grails

Hi, Thank you very much for your feedback, I'm in charge of this task and I'm about to start it. I'm not a parser expert, so I'm still studying all these frameworks (I did something with JavaCC in the past, but nothing very complex). My first impression is that JavaCC is very good for low level co

Re: [orientdb] Re: OrientDB and Grails

it is easier if you follow some working example. > > Take care! > > Fidel H Viegas > > > On Mon, Aug 11, 2014 at 10:24 AM, Luigi Dell'Aquila < > luigi.dellaqu...@gmail.com> wrote: > >> Hi, >> >> Thank you very much for your feedback, I'm in ch

Re: [orientdb] Data persistence with "in-memory" OrientDB server

ups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to orient-database+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Luigi Dell'Aquila Orient Technologies LTD

Re: [orientdb] 2.0M2 bug? Java API batch example from documentation doesn't create any vertex or edge

Hi Keith, I tried it against latest snapshot and it seems to work, maybe it was an issue on previous milestone. To be sure that it is actually solved, could you please try it on this https://oss.sonatype.org/content/repositories/snapshots /com/orientechnologies/orientdb-community/2.0-SNAPSHOT/

Re: [orientdb] Grouping a result set with fields from a traversing class.

> > Thanks , > > Olakunle > > -- > > --- > 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] Reusing a Parameter query? No Result?

Transaction.TXTYPE.OPTIMISTIC); > oCategory.getFacetFields().add(facetField); > orientDBServer.getDatabase().save(oCategory); > orientDBServer.getDatabase().commit(); > } >

Re: [orientdb] SQL query performance with OR in the WHERE clause

Hi, what version of OrientDB are you using? We had two issues related to OR operators and index usage: https://github.com/orientechnologies/orientdb/issues/2898 https://github.com/orientechnologies/orientdb/issues/2893 and we fixed them some days ago. Could you try again on latest SNAPSHOT? tha

Re: [orientdb] SQL query performance with OR in the WHERE clause

OrientDB 2.0-M2 > community edition. > Is this the latest SNAPSHOT? > > > On Tuesday, October 21, 2014 2:23:04 AM UTC-5, Luigi Dell'Aquila wrote: >> >> Hi, >> >> what version of OrientDB are you using? We had two issues related to OR >> operators

Re: [orientdb] Migration document management database to OriendDB, does it make sense?

Hi Bojan in general IMHO all this makes sense. I guess edge creation speed can be improved with some tuning or code tricks, but I should see your import code.. Anyway, if you decided to go with links and you need 1:n or n:n, you can use LINKLIST or LINKSET properties instead. About procedure tran

Re: [orientdb] Migration document management database to OriendDB, does it make sense?

t; edge.setProperty(); > } > rs.close(); > statement.close(); > > graph.commit(); > > > I used both OrientGraph and OrientGraphNoTx but I didn't see a big > difference > > > > > On Wednesday, 22 Oct

Re: [orientdb] Prepared statements and linked maps..

oglegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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

Re: [orientdb] OrientDB operations questions

Hi Santosh I'll answer your questions below: > 1. I was reading the documentation for distributed database on multiple > servers here > . > I see that we need to configure several files like > orientdb-dser

Re: [orientdb] Re: classcastexception when mixing object API and graph API

Hi Wouter, I think it's an issue of Object database implementation, we can fix it quickly just testing database type in OObjectLazySet.getDatabase() and wrapping it in an OObjectDatabaseTx instance if it's a different type. Could you please open an issue about this? thanks Luigi 2014-11-03 8:

Re: [orientdb] Re: Query over restful API returns invalid JSON ?

Hi, this could be related to this https://github.com/orientechnologies/orientdb/issues/2845 I'm working to fix it Luigi 2014-11-03 13:37 GMT+01:00 MrFT : > I used the laest SNAPSHOT > orientdb-community-2.0-20141031.225603-341-distribution.zip >

Re: [orientdb] OrientDB operations questions

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

Re: [orientdb] Delete records from multiple classes in one query

Hi of course you can, you just have to use square brackets around RIDs: Delete from [#13:12, #12:23, #12:24, #12:25] 2014-11-04 14:21 GMT+01:00 acsandeep : > Hi, I would like to delete multiple record IDs belonging to different > Classes. Eg: > > Delete from #13:12, #12:23, #12:24, #12:25 >

Re: [orientdb] LET ... not working

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 GratefulDeadC

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

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 : > bump ... again > > > On Tuesday, 4 November 2014 08:10:37 UTC, ste...@activitystream.com wrote: >> >> >> And on more.

Re: [orientdb] Re: Creating server side functions

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 : > Did you try with sql batch? > > https://github.com/orientechnologies/orient

Re: [orientdb] Re: Creating server side functions

de%2B2014-11-06%2Bkl.%2B15.53.30.png> > > > kl. 14:55: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 ca

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

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 ser

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

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 bo

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

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 de

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

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 : > Hi Jan, > > in this use case you will not have big advantage from

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

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 ano

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

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 : > Hello, > I'm using OrientDB version : 2.0-M3. > > I created a test function which return

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

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 ex

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

Thanks a lot Luigi 2014-11-25 8:25 GMT+01:00 : > 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,

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

tersect,last,max,in,coalesce,count,format,label,list,both,inv,gremlin,eval,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 >&

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

at position #0: No function with name 'sort', >>> available names are : [date,encode,distance,document,distinct,dijkstra, >>> traversedelement,sum,decode,bothv,uuid,out,mode,sysdate, >>> avg,min,shortestpath,traversededge,ifnull,traversedvertex,stddev,outv, &

Re: [orientdb] Copy a Document

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

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 l

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

Hi, OServetAdmin is in package com.orientechnologies.orient.client.remote Apparently all the client package is missing in the javadoc, thank you for reporting this, we will fix it as soon as possible Luigi 2014-12-15 14:36 GMT+01:00 Ankit Jain : > > http://www.orientechnologies.com/javadoc/late

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

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 : > > Hello, > > You're right, I should not have supposed that this version was stable. > However, I need to evaluate OrientDB for my company, so I think I w

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

? >> >> 2014-12-15 15:53 GMT+01:00 Ankit Jain : >>> >>> 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, >>

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

...? > > On Wed, Dec 17, 2014 at 12:25 PM, Ankit Jain wrote: >> >> ok.. >> >> On Wed, Dec 17, 2014 at 12:22 PM, Ankit Jain >> wrote: >>> >>> ok. >>> >>> On Wed, Dec 17, 2014 at 12:21 PM, Luigi Dell'Aquila < >>

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

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 valid

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

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 prob

Re: [orientdb] case clause?

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 S

Re: [orientdb] Business key vs RID

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 ca

Re: [orientdb] Re: 2.0RC1, containstext issue

Hi Erik, fulltext index is a very basic implementation of a full text search (probably it will be discontinued in next releases), it just splits sentences in words based on blank spaces and then performs search on single words, so if you use more than a word in a "containstext" constraint, it will

Re: [orientdb] Re: Schema advantage ?

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, m

Re: [orientdb] Re: Object DB nested single objects not saved with 2.0

Hi Kareem, how are you creating your documents? Do you have schema defined on your classes? Luigi 2015-01-25 20:39 GMT+01:00 Kareem Jabr : > Just found out that the saved embedded object is there in the > Account.person property... But not as a record in the Person table. How > to make it a se

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

Hi, this must be because of disabled lightweight vertices. In Graph Studio tab only fetched records and their neighbors are represented. If you have lightweight edges every vertex contains the IDs of other vertices, so Studio knows about them and can display them. If you use regular edges, every v

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

at this behavior is due 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 lightwei

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

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 : > Even when

Re: [orientdb] OrientDB slow query performance

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 : > I am evaluating OrientDB right now and I tried to inserts 1.2 million > simple records inside one of the database. It is an Employee class with > just f

Re: [orientdb] OrientDB slow query performance

my scenario. Do you 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 >&

Re: [orientdb] OrientDB slow query performance

{ get; set; } > > public string Key { get; set; } > > public string Revision { get; set; } > > > public string Name { get; set; } > > public string IcNumber { get; set; } > > public string Email { get; set; } > >

Re: [orientdb] Best time to create vertex properties

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 a

Re: [orientdb] Best time to create vertex properties

Of course I meant "use plocal instead of remoTe" Just a typo ;-) Luigi 2015-01-30 11:29 GMT+01:00 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? > Wha

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

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 : > Thanks! > > On Friday, January 30, 2015 at 2:29:21 AM UTC-5, Luigi Dell'Aquila wrote: >> >> Hi Florin,

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

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 wit

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

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 GMT+01:00

Re: [orientdb] Insertion into Graphs using txt file

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 http://www.orientechnol

Re: [orientdb] find_or_create in OrientDB?

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 : > Hi there! > > Lately, I've been playing with OrientDB of 1.7.10 and now 2.0.1. An

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

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 : > > Hello, > I am unable to create an in MEMORY distributed database due to the > following exception: > java.lang.UnsupportedO

Re: [orientdb] Query question...

Hi Julian, I suppose the relationship is directed like this: Class1 --Edge1-> Class2 The first one is very simple (if I got it right) SELECT expand(in("Edge1").id) from Class2 where text='foo' the second one could be something like select expand(inV()) from ( select expand(outE("Edge1")) from

Re: [orientdb] Query question...

Hi Julian, that query is supposed to work using the index, could you post the index definition for a double check? About indexes with multiple keys, that link refers to latest version, but please use this one, that refers to the official documentation (same content anyway) http://www.orientechnol

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

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. https://github.com/

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

good idea to add a "userConnectionWeight" attribute to Connected > edges with value 0 and to Follow and FoundedBy edges with value > so that the dijkstra algorithm would return the first path ? It seems like > a bit of a hack, don't you think ? :( > I'

Re: [orientdb] help query edge

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] help query edge

Or better, with clean graph notation: select outV().name as ownerName, color, inV().name as carName from owner Luigi 2015-02-11 9:45 GMT+01:00 Luigi Dell'Aquila : > Hi Renzo, > > the first query should be something like > > select expand(inE('owner')[color =

Re: [orientdb] Evaluating OrientDB as reliable distributed DB. Migration, deployment, questions

Hi Viktor, My answers below: 2015-02-10 23:35 GMT+01:00 Viktor Alexandrov : > Hi all! > > I'd like to begin using OrientDB in a project that needs to hold some > amount on data in a distributed (elastic) database. The amount is about > 200-500 GB of data. We need consistency, low latency, high t

Re: [orientdb] How to effectivly implement tagging with OrientDb

Hi Georg, I know, StackExchange sometimes is not actually "friendly" ;-) The approach you described is probably the most commonly used from OrientDB users, so I suggest to go with that Luigi 2015-02-11 6:47 GMT+01:00 Georg Göttlich : > I want to add tagging to a OrientDb class. My current app

Re: [orientdb] Clustering

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 http://www.orientechnologies.com/docs/last/orientdb.wiki/Tutorial-Clusters.

Re: [orientdb] Clustering

ed 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 rea

Re: [orientdb] Re: SELECT IN doesn't return the result accurately

Hi Goh, thanks for reporting, this seems to be a bug. Could you open an issue about it? Thanks Luigi 2015-02-13 8:14 GMT+01:00 Siang Hwee Goh : > Hi, > > Any idea about the SELECT IN problem? > > Cordially, > Goh > > > On Wednesday, February 11, 2015 at 5:44:23 PM UTC+8, Siang Hwee Goh wrote:

Re: [orientdb] System Catalog

Hi Nick, I think this is what you need: select expand(classes) from metadata:schema 2015-02-13 18:48 GMT+01:00 Nick Pratt : > Does OrientDB have a concept of a system catalog that we can query to > inspect DB metadata? > > -- > > --- > You received this message because you are subscribed to th

[orientdb] A taste of OrientDB 2.1

on... If you have some time, please try it out and give us your feedback, WE NEED YOUR HELP 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" grou

Re: [orientdb] Re: SELECT IN doesn't return the result accurately

2015 at 4:14:33 PM UTC+8, Luigi Dell'Aquila wrote: >> >> Hi Goh, >> >> thanks for reporting, this seems to be a bug. >> Could you open an issue about it? >> >> Thanks >> >> Luigi >> >> >> 2015-02-13 8:14 GMT+01:00

Re: [orientdb] Re: SELECT IN doesn't return the result accurately

ket there in the future. By the way, > shall I log in github for future questions? Thanks. > > On Tuesday, February 17, 2015 at 3:53:23 PM UTC+8, Luigi Dell'Aquila wrote: >> >> Hi Goh, >> >> this is the URL of OrientDB issue tracker >> >> https:

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

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 : > Hi All, > > I tried loading data from csb

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

installed, 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

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

, > Shivanandan Gupta > > > > On Thursday, 19 February 2015 14:50:02 UTC+5:30, Shivanandan Gupta wrote: >> >> Thanks Luigi I changed it and it worked. the statics is given below: >> >> *RecordsLoaded* >> >> *AttributesPerRecords* >> >

Re: [orientdb] Re: How to browse through records in in-memoryDB

Hi Shivanandan, sorry for late answer. To do what you want to achieve you have to start an embedded server and then use the ETL from the Java API. This way the ETL will be executed in the same VM of the server, and when the ETL terminates the server will remain up and running and you will be able

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

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(); List edgeClassNames = new ArrayList()

Re: [orientdb] Going from Hibernate to OrientDb, have several questions

Hi Kamen, did you check TinkerPop frames? https://github.com/tinkerpop/frames/wiki I think it's what you are looking for Regards Luigi 2015-02-22 20:20 GMT+01:00 Kamen Ivanov : > Hello everyone, I'm a Java guy who's been working with hibernate for 2 > years now, but now i'm starting to work on

Re: [orientdb] Problem with orientdb jdbc driver?

Hi, I think the problem is in the connection port. Could you try to use 2424 (binary protocol) instead of 2480? Thanks Luigi 2015-02-23 21:01 GMT+01:00 AW Tahhan : > I'm trying to use the jdbc driver, I'm using netbeans as my IDE and the > following is the Jar and configurations I used: > > >

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

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 a result set, that is a collection. But all this is just for the

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

erId) 2015-02-24 15:55 GMT+01:00 Luigi Dell'Aquila : > 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 o

Re: [orientdb] in and out

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 : > Hello > > > I have a simple DB: > users -- Owns --> items > > when I do: > sel

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

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 : > The following query returns a set of `@rid` and completes in about ` > 0.012sec` > > S

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

track 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 goal

Re: [orientdb] security profiling

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 2015-03-0

Re: [orientdb] Re: Need Data Modeling Help

Hi Kiheung, answers below: 2015-03-02 23:39 GMT+01:00 Kiheung Park : > 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 API is the >

Re: [orientdb] compound index seems to be ignored

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 : > Hi, > > I'm trying to get familiar with OrientDB's indexing to make some >

Re: [orientdb] compound index seems to be ignored

using 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 propert

Re: [orientdb] Create distribution from maven repository

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 ../release

Re: [orientdb] OCommandSQLParsingException: Error on parsing command at position

Hi Sean, old OrientDB parser is very sensitive to white spaces. In 2.1 we completely rewrote it, to solve this and many other problems. Regards Luigi 2015-03-08 6:32 GMT+01:00 sean lee : > orientdb-community-2.0.4 > > first: > > orientdb {db=test}> select * from BasAddress where idnum<100 lim

Re: [orientdb] Re: Exception while query - (com.orientechnologies.orient.core.exception.ODatabaseException)

Hi Noorul, it seems that "db" is closed but never set to null (first method), and then not initialized again before data manipulation. Is it possible that some other threads are setting/closing it in a race condition? Luigi 2015-03-10 9:53 GMT+01:00 Noorul Farhan Ahmed : > Anyone please. > > T

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

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] Lightweight vs Standard/Regular Edges

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 docum

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

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 : > So it seems that both can

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

Exactly 2015-03-12 18:03 GMT+01:00 Jeffrey Auguste : > 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, Lu

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

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 : > I was able to get around this issue by setting > > graph.setStandardElementConstrain

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

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 : > graph.declareIntent(new OIntentMassiveInsert()); > // inserts > graph.declareIntent(nul

  1   2   3   4   5   6   7   8   >