Re: [orientdb] [Newbie Question][Web Development] Where should I extract OrientDB ?

Hi Peter, I'm afraid there is no way to decide the path per single DB, the configuration is at server level, so you can change the place when you put all the databases (a symbolic link is enough on Linux), but it's all or nothing. All this applies to the stand-alone installation of course. If the

Re: [orientdb] Can I upsert an Edge instead of just grah.addVertex

Hi Tia, OrientDB has UPSERT for edges, but with limited support, ie. it only checks if the edge already exists between the two vertices and it needs a unique index. See https://orientdb.org/docs/3.0.x/sql/SQL-Create-Edge.html I hope it helps Thanks Luigi Il giorno dom 23 feb 2020 alle ore

Re: [orientdb] Price of Orient DB Enterprise edition

Hi Neerav, Glad to know you are interested in OrientDB an in our Enterprise services. I suggest you to contact the email address orientdb_enquir...@sap.com for all the commercial details Thanks Luigi Il giorno gio 10 ott 2019 alle ore 14:46 Neerav Singh ha scritto: > Hello > > I am speaking

Re: [orientdb] Orient DB Server unreachable frequently - Urgent - Severe business impact

dentify the root cause and overcome the issue. > > Regards, > Ram > > > > > > > > On Wed, Aug 21, 2019 at 7:36 PM Ram Karthik > wrote: > >> Hi Luigi, >> >> Thanks for your reply. >> >> Database size 40GB >> >> Typical

Re: [orientdb] Orient DB Server unreachable frequently - Urgent

Hi Ram It's hard to give you a quick solution with so few information. V 2.0 is EOL so we will hardly release a community patch, but we can try to troubleshoot the problem and see if we can work around it. Can you provide a bit more information, eg. server logs, typical workload, some information

Re: [orientdb] Automatic daily backups

Hi Tiziano, If you check orientdb-server-config.xml you'll find the following: In the Community Edition it is a blocking full bacup, that means that the DB will be in read-only mode during the backup operation. In the Enterprise Edition you also have

Re: [orientdb] Query compatibility

Hi Tiziano, Can you please post a simple dataset to reproduce the problem? Thanks Luigi Il giorno lun 5 ago 2019 alle ore 00:30 Tiziano Fortin ha scritto: > Hey guys please help me... > > with orient 2.0.11 I used to run this query with success: > > SELECT

Re: [orientdb] OrientDB 3 & Tinkerpops

the recommended API to access OrientDB via Java as it is more > complete and optimised, isn't? > > Regards, > Rafa > > On Monday, 10 June 2019 08:42:45 UTC+1, Luigi Dell'Aquila wrote: >> >> Hi Rafa, >> >> Apache TinkerPop is still fully supported, there i

Re: [orientdb] OrientDB 3 & Tinkerpops

Hi Rafa, Apache TinkerPop is still fully supported, there is a specific OrientDB distribution that includes a Gremlin server and all the TP APIs. The Muti-Model API in v3.0 is a logical step in the direction of making OrientDB API as simple and complete as possible; in previous versions there

Re: [orientdb] OrientDB query to receive last vertex before a given date

nt studio if I execute: >>> >>> SELECT FROM ANYVERTEX WHERE t < 999 AND id=... ORDER BY t DESC >>> LIMIT 1 >>> >>> >>> it takes 0.133 sec (which improves with caching) and with >>> >>> SELECT FROM ANYVERTEX WHERE t <

Re: [orientdb] Orientdb 2.0.18 automattically stopped

Hi Ram, OrientDB v 2.0 is not supported anymore, I strongly suggest you to upgrade to latest version. About the specific problem, do you have any error in the logs? It could also be the OS who stopped the process because of low system resources, in this case you won't see any errors, but OrientDB

Re: [orientdb] Is this concat possible?

SELECT DriverID, DriverName, list(CarCost) FROM ( ... ) GROUP BY DriverID, DriverName Il giorno gio 7 mar 2019 alle ore 12:27 Luigi Dell'Aquila < luigi.dellaqu...@gmail.com> ha scritto: > oh, sorry, I didn't scroll the screen :D > > You have to use a set() or list() aggrega

Re: [orientdb] Properties typed as an interface?

this a feature request ;-) > > Thanks, > Michael > > > > On Tuesday, February 26, 2019 at 2:27:58 AM UTC-5, Luigi Dell'Aquila wrote: >> >> Hi Michael, >> >> OrientDB does not have a concept for interfaces, but you can use abstract >> classes and ma

Re: [orientdb] Properties typed as an interface?

Hi Michael, OrientDB does not have a concept for interfaces, but you can use abstract classes and make them extends V (so that you can then create edges between them) I hope it helps Thanks Luigi Il giorno lun 25 feb 2019 alle ore 16:17 Michael Faughn < m.fau...@prometheuscomputing.com> ha

Re: [orientdb] Gremlin vs SQL?

Hi Michael, As an OrientDB maintainer, I can tell you that SQL is much more optimized than Gremlin, so if you need good performance I strongly suggest you to use SQL. Tinkerpop (and Gremlin) is intended to be a standard, so it allows easier migration from a product to another; this said,

Re: [orientdb] RAM Usgae

Hi, Which OrientDB version are you referring to? Thanks Luigi Il giorno ven 14 dic 2018 alle ore 09:53 Praveenkumar K < krishmi...@gmail.com> ha scritto: > Hi All, > > OrientDB consume high RAM usage while inset and select query > execute concurrently. > > How I can resolve

Re: [orientdb] kill select query

Hi Praveenkumar, How are you running the query? From Studio? Which OrientDB version? Thanks Luigi Il giorno mer 12 dic 2018 alle ore 11:38 Praveenkumar K < krishmi...@gmail.com> ha scritto: > Hi, > > How I can stop or kill long running query in OrientDB? > > -- > > --- > You received this

Re: [orientdb] Indexed queries on 2.2.26

ure > out what actually happens in the lower levels. > > Are there exceptions to the rules you gave? > Erik > > > On Tue, Dec 11, 2018 at 2:46 AM Luigi Dell'Aquila < > luigi.dellaqu...@gmail.com> wrote: > >> Hi Erik, >> >> In general: >>

Re: [orientdb] Export single class

Hi, You can use -includeClass option in EXPORT DATABASE, see https://orientdb.com/docs/3.0.x/console/Console-Command-Export.html Thanks Luigi Il giorno mar 11 dic 2018 alle ore 13:47 Praveenkumar K < krishmi...@gmail.com> ha scritto: > Hi All, > > How to export single class from

Re: [orientdb] Indexed queries on 2.2.26

Hi Erik, In general: - queries with NOT are not indexed - LIKE operator cannot be used with indexes in general - AND operations can be indexed if you have a multi-property index, but not on multiple indexes on the same query - the new SQL executor in v 3.0 is much smarter at query optimization

Re: [orientdb] Create relationship between vertex

Hi, What do you mean exactly? You can use a CREATE EDGE XXX FROM (SELECT FROM V WHERE ) TO (SELECT FROM V WHERE ) the conditions can match multiple vertices, so multiple edges will be created. If you need a manual iteration, you can use WHILE and FOREACH loops in batch scripts

Re: [orientdb] Issues with using while and where in a match clause

Hi Petra, First of all, are you using v 2.2. or v 3.0? Thanks Luigi Il giorno mer 5 dic 2018 alle ore 20:33 Petra Geigenfeind < petra.geigenfe...@gmail.com> ha scritto: > Hello everybody, > > I've built a litte social network based on some characters from the > Simpsons. There's Lisa, Bart,

Re: [orientdb] how to unwind multiple collection

I'm not sure you can do it, just because there is no deterministic way to do it. It is not even guaranteed that the second and third collection have the same number of items, so in general it is not a consistent operation. Perhaps you can consider to review your domain? Thanks Luigi Il giorno

Re: [orientdb] InvolvedIndex issue when executing Explain query

Hi I'm not sure I got the point, could you please provide a full SQL script to reproduce the problem? Thanks Luigi Il giorno sab 17 nov 2018 alle ore 06:29 axon musthaq ha scritto: > i have created several indexes in an vertex class > > example > > VERTEX > 1.employee as an index firstname >

Re: [orientdb] Remove special character from the attribute

Hi You can use replace() method: SELECT ip.replace(".", "") FROM V Thanks Luigi Il giorno ven 16 nov 2018 alle ore 19:50 axon musthaq ha scritto: > I have an property called ip in an vertex class > example > > ip:127.0.0.1 i need get the value as 127001 by removing dot(.) special >

Re: [orientdb] Match Two Vertex Class without creating edge

Hi, Are you talking about some kind of JOIN operation without edges? OrientDB is a graph database and is explicitly designed to avoid such kind of operations. What is the purpose of using a graph database if you don't want to use edge? Thanks Luigi Il giorno gio 15 nov 2018 alle ore 15:01

Re: [orientdb] OutOfMemoryError

redi 26 octobre 2018 11:17:18 UTC+2, Luigi Dell'Aquila a écrit : >> >> Hi, >> >> Which OrientDB version are you using? Perhaps your dataset is now bigger >> and the query is returning a bigger result set? >> >> Thanks >> >> Luigi >> &

Re: [orientdb] OutOfMemoryError

Hi, Which OrientDB version are you using? Perhaps your dataset is now bigger and the query is returning a bigger result set? Thanks Luigi Il giorno ven 26 ott 2018 alle ore 11:10 C L ha scritto: > Hello, > Recently a new problem appeared on my server : > >

Re: [orientdb] Installation

Hi Rony, I think this problem is related to Java itself, not to OrientDB. See https://stackoverflow.com/questions/22489398/unsupported-major-minor-version-52-0 Thanks Luigi Il giorno ven 19 ott 2018 alle ore 19:18 Rony Armon ha scritto: > Hello, I'm trying to install the server on my Mac

Re: [orientdb] Dynamic record fieled update on every update of that record data.

Hi Peter, I just answered here https://github.com/orientechnologies/orientdb/issues/8596 Thanks Luigi Il giorno gio 11 ott 2018 alle ore 23:00 Peter V ha scritto: > > I just need to update the timestamp field every time somebody update the > data in record. Does anyone know how to do this

Re: [orientdb] OrientDB3.0.2 create embeddedList via console or Java results into incompatible type

;, "content":"some content", > "date":"datestring"}* > > *Encountered " "[" "[ "" at line 1, column 80.* > > This is from the console while attached to remote:localhost. *notes *is > an *embeddedlist *type within

Re: [orientdb] Deserialization issue (InvalidClassException) during communication with remote storage

t; > Simon > > Am Fr., 14. Sep. 2018 um 07:47 Uhr schrieb Luigi Dell'Aquila < > luigi.dellaqu...@gmail.com>: > >> Hi Simon, >> >> Are you using the exact same OrientDB version on both the client and the >> server? >> >> Thanks >> >

Re: [orientdb] Deserialization issue (InvalidClassException) during communication with remote storage

Hi Simon, Are you using the exact same OrientDB version on both the client and the server? Thanks Luigi Il giorno gio 13 set 2018 alle ore 14:16 'Simon Erhardt' via OrientDB < orient-database@googlegroups.com> ha scritto: > Hello community, > > we are using OrientDB in our product, and since

Re: [orientdb] how to perform deep traversal

rom > command() statement? > > On Tue, Aug 28, 2018 at 1:07 AM, Luigi Dell'Aquila < > luigi.dellaqu...@gmail.com> wrote: > >> hi Suraj, >> >> The TRAVERSE statement automatically skips already traversed nodes, this >> is why you don't see all the parents

Re: [orientdb] how to perform deep traversal

uraj Shankar < > surajhebbarshanka...@gmail.com> wrote: > >> Yes I am using the traverse command in sql >> >> On Tue, Aug 28, 2018 at 12:37 AM, Luigi Dell'Aquila < >> luigi.dellaqu...@gmail.com> wrote: >> >>> Hi Suraj, >>> >>> how do

Re: [orientdb] how to perform deep traversal

Hi Suraj, how do you do the traversal? in SQL? Thanks Luigi Il giorno mar 28 ago 2018 alle ore 09:31 Suraj Shankar < surajhebbarshanka...@gmail.com> ha scritto: > HI All, > I have a graph as following : > 1->1.1 > 1->1.2 > 2->2.1 > 2->2.2 > 2->2.3 > > Now when i start at any of the leaf

Re: [orientdb] How can I read edges from a cluster of E

Hi, The syntax is correct, if the clusters contain data they will be returned. Are you sure that clusters e_1, e_2 contain records? Thanks Luigi 2018-05-27 14:20 GMT+02:00 : > > I can run a query such as follow to read edges from cluster 1,2 of IP > class: > > >

Re: [orientdb] Web site no longer shows ODB 3.0.0 docs or release???

Hi Hristo, You're right, I'm fixing it Thanks Luigi 2018-05-18 0:41 GMT+02:00 Hristo Stoyanov : > DOCS-> > -> DOCS > -> RELEASES > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe

Re: [orientdb] Is OCommandSQL done synchronously?

> So what's the difference between OCommandSQL and OSQLSyncQuery? They seem > to be the same so why have two classes? > > On Thu, May 17, 2018, 3:30 AM Luigi Dell'Aquila < > luigi.dellaqu...@gmail.com> wrote: > >> Hi Erik, >> >> The query is executed synchronously. T

Re: [orientdb] OrientDB 3.x JCA adapter

Hi Hristo, Thank you very much for letting us know, I think this could be of interest for many users in the community. Please keep us updated on the progress and, if you need any advice during the development, please do not hesitate to ask Thanks Luigi 2018-05-17 0:04 GMT+02:00 Hristo

Re: [orientdb] Is OCommandSQL done synchronously?

Hi Erik, The query is executed synchronously. The result is returned as soon as all the result set is available. With the new API (v 3.0) the queries are still synchronous, but the result set is paginated, so the first results are returned as soon as they are available Thanks Luigi

Re: [orientdb] In 3.0.0 unlike ODatabaseDocumentTx , OrientDB constructor throwing exception for in memory DB

this case, but if you only have in-memory databases you can hard-wire it, as it will never be used) - the actual db name (neurosys_orientdb_odb) - the username - the password Probably you will have to do little changes to your application accordingly, but it should not be too complex I ho

Re: [orientdb] In 3.0.0 unlike ODatabaseDocumentTx , OrientDB constructor throwing exception for in memory DB

Hi Arjun, Thank you very much for reporting, I'll check it asap. Thanks Luigi 2018-05-14 7:23 GMT+02:00 arjun dhar : > Hi, > > *Summary* > Am on OrientDB 3.0.0 ; and am trying to avoid the use of Depreicated API > like: ODatabaseDocumentTx > However, when I replace it

Re: [orientdb] WAL Files

Hi Erik, When there is no space left on disk, OrientDB tries to the WAL (do a full checkpoint) and then delete the files. This also happens as a normal activity, so WAL files are eventually deleted even if there is still space left on disk Thanks Luigi 2018-05-09 20:19 GMT+02:00 Erik T

Re: [orientdb] DECIMAL data type is rounding values?

it on the client and won't help when you convert it to a number in js. Moreover, it will break backward compatibility in OrientDB, so I don't know if I can do it... Thanks Luigi 2018-05-07 12:45 GMT+02:00 Luigi Dell'Aquila <luigi.dellaqu...@gmail.com>: > Hi Peter, > > I just did a quick te

Re: [orientdb] DECIMAL data type is rounding values?

Hi Peter, I just did a quick test, the problem is only on the REST/JSON layer. If you do the queries from console (or from a binary driver) you'll see that the results are correct and the numbers are not rounded. Could you please open an issue here

Re: [orientdb] DECIMAL data type is rounding values?

Hi Peter, How are you instantiating the value? From SQL? Did you try to use decimal() function? Thanks Luigi 2018-05-07 1:25 GMT+02:00 : > Hi everyone. I'm quite new to OrientDB, but have found it because it > appeared it has support for large numbers. > > The

Re: [orientdb] Using OrientDB on Android?

Hi Alex, A few years ago some community users tried to do a porting of OrientDB for Android, but it was never completed. I never tried to run current OrientDB version on Android, but I'm pretty sure that it doesn't work out of the box. Thanks Luigi 2018-04-07 21:23 GMT+02:00 Alex Fowler

Re: [orientdb] Lucene query with sorting. Performance problem

Hi Mohammad, Lucene indexes do not provide ordering (or better, they return results based on their score, but it's not what you need). What you can do here is define an additional NOTUNIQUE index on "name", this will do the job Thanks Luigi 2018-03-31 23:45 GMT+02:00 Mohammad Hossein Ganjyar <

Re: [orientdb] OrientDB sql query involving multiple classes

gt; > IN SHORT my main problem is when i connect the Company And Personel > Classes, i want to see Company class informations over personelInformation > Query. But i dont want to restrict my query like , select from where rid = > 37 > i just want to get company information wihto

Re: [orientdb] Select from where traverse operator not working

gt; > Steve > > On Tue, Mar 20, 2018, 9:37 AM Steven Tomer <steven.to...@gmail.com> wrote: > >> Thanks so much! >> >> Steve >> >> On Tue, Mar 20, 2018 at 9:34 AM, Luigi Dell'Aquila < >> luigi.dellaqu...@gmail.com> wrote: >> >>&g

Re: [orientdb] Select from where traverse operator not working

-enable the old traverse() operator? > > Thanks, > > Steve > > On Tue, Mar 13, 2018 at 9:08 AM, Luigi Dell'Aquila < > luigi.dellaqu...@gmail.com> wrote: > >> Hi Steve, >> >> ah, got it, the old traverse() stopped when it found duplicates, while >>

Re: [orientdb] The value '1' is not supported for writeQuorum in distributed configuration

Hi Maxim, Try to just remove the quotes, I guess it's just a matter of "1" as a string vs. 1 as a number Thanks Luigi 2018-03-14 9:34 GMT+01:00 Maxim Nikolaev : > *I **receive error * > > > com.orientechnologies.orient.server.distributed.ODistributedStartupException: >

Re: [orientdb] Select from where traverse operator not working

hat query never returns (looks like it goes into an infinite loop). > > I had to kill the server process to make it stop. > > Any other ideas? > > Steve > > On Tue, Mar 13, 2018 at 8:16 AM, Luigi Dell'Aquila < > luigi.dellaqu...@gmail.com> wrote: > >>

Re: [orientdb] Select from where traverse operator not working

MyEdge -> Person -> MyEdge -> Person. The traverse > operator lets me hop over the edges. How do you do it with MATCH? > > Steve > > > > On Tue, Mar 13, 2018 at 2:07 AM, Luigi Dell'Aquila < > luigi.dellaqu...@gmail.com> wrote: > >> Hi Steven, >>

Re: [orientdb] Select from where traverse operator not working

Hi Steven, The traverse() operator was deprecated long time ago and is not fully supported anymore. I strongly suggest you to use TRAVERSE queries ( https://orientdb.com/docs/2.2.x/SQL-Traverse.html) or even better MATCH queries (https://orientdb.com/docs/2.2.x/SQL-Match.html) Another thing: if

Re: [orientdb] OOM Exception while fetching records with Functions

Hi Naveen, Can you please some more information on how to reproduce the problem? Do you have a database you can share to show this behaviour? Thanks Luigi 2018-02-28 10:04 GMT+01:00 Naveen Kumar : > Hello Team, > > I'm facing issue in using functions for fetching data

Re: [orientdb] Class name stored in every record in cluster PCL file

having a severe > impact on file size in our application. Please can you point me to the > classes where the issue is? > > Thanks, > Chris > > > On Thursday, February 8, 2018 at 11:47:19 PM UTC+10, Luigi Dell'Aquila > wrote: >> >> Hi Ata, >> >> It w

Re: [orientdb] Class name stored in every record in cluster PCL file

eak DB files compatibility then? > Maybe it is better to have such dramatic change before v3.0 is out (fix it > while moving from v2.x to 3.0), to make migration to next 3.X versions > smoother? > > > On Tuesday, February 6, 2018 at 1:46:53 PM UTC+5, Luigi Dell'Aquila wrote: >> >&

Re: [orientdb] Exception on create FullText LUCENE index from console (and from JAVA API)

Hi Maxim, Which OrientDB version are you using? Do you have a deterministic way to reproduce the problem? Thanks Luigi 2018-02-06 13:36 GMT+01:00 Maxim Nikolaev : > 2018-02-06 09:45:28:097 FINE {db=newdb17122017} Read record #367:465922 > v.3 size=142 bytes (thread=36

Re: [orientdb] ODB 3.X Vertex Inheritance

Hi Robert, That's correct, but I understand your concern, probably having an additional method like createVertexClass(name, superclass), that also checks that the supeclass is a vertex class, could be convenient. We will consider it in the near future Thanks Luigi 2018-01-29 16:13 GMT+01:00

Re: [orientdb] Re: ODB 3.0 SQL UPDATE - No more ADD|PUT?

uesday, January 2, 2018 at 2:23:32 AM UTC-6, Luigi Dell'Aquila wrote: >> >> Hi Eric, >> >> The alternatives are: >> >> >> PUT: just use dot notation >> >> UPDATE ADoc PUT aMap = "aKey", "aValue" >> >> can be

Re: [orientdb] Result sets not closing in 3.0RC1?

Hi Tielman The result sets are supposed to properly close when you do close(), if it's not the case, it could be related to some internals (eg. subqueries). Do you have a test case to reproduce the problem? Thanks Luigi 2018-01-05 22:30 GMT+01:00 Tielman Van Vleck : > Am I

Re: [orientdb] Re: ODB 3.0 SQL UPDATE - No more ADD|PUT?

Hi Eric, The alternatives are: PUT: just use dot notation UPDATE ADoc PUT aMap = "aKey", "aValue" can be written as UPDATE ADoc SET aMap.aKey = "aValue" or UPDATE ADoc SET aMap["aKey"] = "aValue" ADD: use array concatenation || UPDATE ADoc PUT aList = "aValue" can be written as UPDATE

Re: [orientdb] Re: SELECT QUERY ERROR

Hi Krishna, How can we reproduce this problem? Do you have a deterministic way to do it? Thanks Luigi 2017-12-23 20:23 GMT+01:00 Krishna Chandra Prajapati : > Hello Michelle, > > I'm using the latest version 3.0 > > Regards, > Krishna > > On Dec 23, 2017 9:48 AM,

Re: [orientdb] OrientDB V3.0RC Load Script Error

Hi Krishna, Could you please post the script? Thanks Luigi 2017-12-20 7:00 GMT+01:00 Krishna Chandra Prajapati : > Hello Guys, > > I'm getting the below error while loading data into class. > > orientdb {db=netdevices}> LOAD SCRIPT '/home/krishna/ag1.osql'; > > Loading

Re: [orientdb] Show name with vertex

Hi Krishna, In the graph panel, on the left, you have to select the edit tab (the second one), then you can choose the label you want to display on the graph from the vertex attributes Thanks Luigi 2017-12-16 6:01 GMT+01:00 Krishna Chandra Prajapati : > > Hello, > > I'm

Re: [orientdb] OrientDB Web Interface timeout

Hi Krishna, which version? In v 3.0 SNAPSHOT you can add this parameter to the command line: -Dnetwork.http.sessionExpireTimeout= In v 2.2 you should not have a session expire problem at all... Thanks Luigi 2017-12-15 12:20 GMT+01:00 Krishna Chandra Prajapati : >

Re: [orientdb] Arrange Graph

Hi Krishna, Unfortunately right now there is no option to arrange graph display as a tree, the visualization uses a force based algorithm Thanks Luigi 2017-12-14 7:14 GMT+01:00 Krishna Chandra Prajapati : > Hello, > > I'm a newbie for OrientDB. > > I would like to

Re: [orientdb] Re: Select * from V error

. November 2017 14:56:32 UTC+1 schrieb Luigi Dell'Aquila: >> >> Hi Raymond, >> >> Ok, it's quite unlikely that the problem is in the SQL executor (try the >> same query in the query browser to be sure), I think the problem is in the >> serialization of the resu

Re: [orientdb] Re: Select * from V error

Hi Raymond, Ok, it's quite unlikely that the problem is in the SQL executor (try the same query in the query browser to be sure), I think the problem is in the serialization of the result for the graph rendering. Do you have a chance to send me a stack trace to understand where the exception is

Re: [orientdb] Adding and Removing Clusters from a Class

Hi Eric, Moving records from a cluster to another is not supported, because re-calculating link references is a very expensive operation. There is a MOVE VERTEX command that (as you can guess) is specific to vertices, it takes into consideration edges and re-attaches them correctly Thanks Luigi

Re: [orientdb] Re: Concurrency during UPDATE ADD operation

PUT, but I just assumed > they would be). > > On Monday, November 13, 2017 at 2:19:43 AM UTC-6, Luigi Dell'Aquila wrote: >> >> Hi Eric, >> >> UPDATE ADD is just a normal record change, the record is completely >> overwritten and the version is increased, so you

Re: [orientdb] Lightweight Edges not maintained when using SQL DELETE VERTEX

#25:0 TO #25:1 >7. SELECT FROM SimpleE // empty result, provides that Lightweight >Edge was used >8. DELETE VERTEX #25:1 >9. SELECT FROM SimpleV // returns #25:0, with OUT still showing link >to #25:1 > > > > On Tuesday, November 14, 2017 at 2:18:3

Re: [orientdb] Lightweight Edges not maintained when using SQL DELETE VERTEX

Hi Eric, The main problem with lightweight edges is that they do not have an identity, so they don't "physically" exist. The big disadvantages are that: - you cannot point to a single lightweight edge by RID - you cannot count them, eg. SELECT FROM E will return a wrong result The DELETE VERTEX

Re: [orientdb] Re: Concurrency during UPDATE ADD operation

Hi Eric, UPDATE ADD is just a normal record change, the record is completely overwritten and the version is increased, so you will have a normal ConcurrentModificationException if two operations happen at the same time. My general advice in these cases is to use a commit/retry strategy. If you

Re: [orientdb] Query Performance Issue

hen to commit data into database like gremlin. In gremlin > we can specify after insertion of how many records the database should > commit. May be that can help me in getting better performance > > > > On Friday, November 3, 2017 at 2:08:15 PM UTC+5:30, Luigi Dell'Aquila > wrote: >>

Re: [orientdb] Query Performance Issue

Hi Shrikant, There are at least two factors that can impact performance here: - OrientDB does some caching of SQL statements, so the first time you execute a query it has to be parsed from scratch, while the second time you will have the AST in cache - there is a layer, called diskCache, that

Re: [orientdb] Match query issue

Hi Cyprien, it's a bit hard (and long) for me to answer without a minimal dataset to test, if you have a chance to provide one, I'll be happy to review the queries Thanks Luigi 2017-10-30 19:04 GMT+01:00 Cyprien Gottstein : > Greetings, > > OrientDB : Version

Re: [orientdb] Is there really any reason to create a "generic" class?

If you are not using graphs, then extending V is absolutely not needed. Anyway, class hierarchies have negligible overhead, so you can live with it Thanks Luigi 2017-10-29 18:44 GMT+01:00 Eric24 : > In other words, with ODB 2.2+ (and 3,0), is there really any downside to >

Re: [orientdb] SQL SELECT that returns specific properties from linked classes

Hi Eric, With plain SELECT: SELECT inV().vertexProp1, inV().vertexProp2, edgeProp1, edgeProp2 from ( select expand(outE("TheEdgeClass")) FROM V WHERE foo = ? ) With MATCH: MATCH {class:V, as: theRootNode, where:(foo = ?)} .outE("TheEdgeClass"){as:theEdge} .inV() {as:firstLevel} RETURN

Re: [orientdb] Behavior of elements in EMBEDDEDLIST

response. I'm not familiar with that option. What's > the syntax of the create property statement to do this? > > On Thu, Oct 26, 2017 at 8:25 AM, Luigi Dell'Aquila < > luigi.dellaqu...@gmail.com> wrote: > >> Hi Eric, >> >> Try to define the property as EMBEDDE

Re: [orientdb] Select Query issue

Hi Shirkant, Which version are you working with? How did you do the insert? Thanks Luigi 2017-10-26 12:02 GMT+02:00 Shrikant Pachauri < shrikant.pacha...@optimizory.com>: > I am new to orient DB and trying the technology > Actually i have inserted some records in the database. I want to query

Re: [orientdb] Behavior of elements in EMBEDDEDLIST

Hi Eric, Try to define the property as EMBEDDEDMAP with LINKEDTYPE = EMBEDDEDMAP, it should solve the problem Thanks Luigi 2017-10-26 4:37 GMT+02:00 Eric24 : > Using ODB 2.2.28, I have a simple Class that contains an EMBEDDEDLIST > called "data". If I update "data" like this: >

Re: [orientdb] Query on double indexing

Oh, sorry, you are trying to do a LIKE. Indexes cannot be used for LIKE operations with left and right wildcars Thanks Luigi 2017-10-23 10:08 GMT+02:00 Luigi Dell'Aquila <luigi.dellaqu...@gmail.com>: > Hi, > > The query seems to be correct, could you please post a si

Re: [orientdb] Query on double indexing

Hi, The query seems to be correct, could you please post a simple SQL script to reproduce the exact case? Thanks Luigi 2017-10-21 10:42 GMT+02:00 : > Hai, > > METADATAPROPERTIESINOUT > > @rid > @class > @version > mobile_no > created_date > email_id > name >

Re: [orientdb] Select * from NOT like '%partOfString%'

+1, I'll do it asap 2017-10-19 18:00 GMT+02:00 Raymond Willems : > Thanks! This works fine! I propose to take this example into the > documentation. > > Best regards > Raymond > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB"

Re: [orientdb] Re: Security Manager: Users list limited to 2 pages

By default Studio limits the result sets to 20. You can change this default clicking on the options (little button next to the yellow "explain", bottom right corner of the query panel) or you can explicitly add a LIMIT -1 to the SQL statement Thanks Luigi 2017-10-19 15:51 GMT+02:00 Raymond

Re: [orientdb] Select * from NOT like '%partOfString%'

Hi Raymond, Try this: Select * from OUser where not (name like '%a%') Thanks Luigi 2017-10-19 15:44 GMT+02:00 Raymond Willems : > Dear OrientDB-Community, > > I want to query for all users that do NOT have a certain character in the > name, e.g. search for all usernames that

Re: [orientdb] Security Manager: Users list limited to 2 pages

Hi Raymond, I just checked, there is a little bug there. As a temporary work-around you can just do an UPDATE OUser SET password = "xxx" WHERE name = "xxx" The password will be automatically encrypted. Just make sure to do it with an "admin" user, as other roles do not have the permission to do

Re: [orientdb] Can’t connect to database using Plocal

Hi Maxim, If you have a running server, you cannot access the db from another process. The server process locks the database to avoid concurrent access to the files, so if you want to connect in plocal you have to stop the server. Thanks Luigi 2017-10-04 14:57 GMT+02:00 Maxim Nikolaev

Re: [orientdb] Low Performance Creating EDGE

Hi Maxim, First advice: replace select AddressId from Person where @rid=%s with select AddressId from %s it will be faster. Then make sure you have an index on Address_Larix. SysId. To make sure it's correctly used, try to execute from Studio EXPLAIN select @rid from Address_Larix where

Re: [orientdb] Traverse not giving expected results

Hi, Your understanding is correct, so I guess there is a problem in your DB. Could you please share a sample db to demonstrate the problem? Thanks Luigi 2017-09-29 23:11 GMT+02:00 : > I am using orientdb version 2.2.0. I am trying to run some traverse >

Re: [orientdb] where count clause doesn't return anything

Hi, This is the same in old style RDBMS, you would have to use a HAVING it this case, but OrientDB doesn't support HAVING, so you have to use a subquery (that is what you are correctly doing) Thanks Luigi 2017-09-29 21:09 GMT+02:00 : > I am using orientdb

Re: [orientdb] Update edge in or out property not working

this 100% the result of version 2.2.0? I just want to > make sure before undertaking upgrading all of my test and production > systems. > > On Thursday, September 28, 2017 at 12:11:04 PM UTC-4, Luigi Dell'Aquila > wrote: >> >> Hi, >> >> This issue was fixed l

Re: [orientdb] Update edge in or out property not working

Hi, This issue was fixed long time ago, I suggest you to upgrade to 2.2.28, latest stable Thanks Luigi 2017-09-28 18:01 GMT+02:00 : > I have version 2.2.0 of orientdb on my system. I ran into a situation > where I need to change the out property of an edge

Re: [orientdb] Locked out from DB when accidentally changing permissions for admins from to "Deny all but".

Hi Raymond, Did you try to access with root credentials? Thanks Luigi 2017-09-22 17:57 GMT+02:00 Raymond Willems : > Dear Community, > > when looking around in the permissions UI of Studio, I accidentally > changed the admins permissions from "Allow all but" to "Deny all

Re: [orientdb] [Breaking News] CallidusCloud Acquires OrientDB, the Leading Multi-Model Database Technology

Sure it will! 2017-09-20 8:44 GMT+02:00 Christian MICHON : > Hi > > Will OrientDB remain opensource? > > Christian > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop

Re: [orientdb] Select * from V error

Hi Raymond, This is very strange, how are you performing the query? (Studio, Java binary driver, other drivers... remote, plocal, distributed) Do you have a DB or a deterministic way to reproduce the problem? Thanks Luigi 2017-09-19 16:18 GMT+02:00 Raymond Willems : > Dear

Re: [orientdb] Additional details of fix in 2.2.27 release

Hi Odysseas, There was a little difference on how LIKE and MATCHES managed multi-value elements (lists, sets), in particular lists of a single elements. We just made it consistent allowing LIKE to evaluate collections of a single element Here is the commit

  1   2   3   4   5   6   7   >