[orientdb] Re: Filter vertices collection with a wildcard operator

You can use this query: select expand(in('LTSval')) from ATS_NAMAbbr where dval LUCENE "ABS*" after you have created a *Fulltext index with Lucene and this metadata { "allowLeadingWildcard": true} *in the class ATS_NAMAbbr on field "dval" Il giorno lunedì 18 luglio 2016 16:24:31 UTC+2, Athan

[orientdb] Re: I'd like to know if it is possible to create a Vertex that requires an edge in order to be created.

Hi, i answered you in stack overflow. Il giorno giovedì 14 luglio 2016 17:27:45 UTC+2, yashpal singla ha scritto: > > > I'd like to know if it is possible to create a Vertex that requires an > edge in order to be created. > > For example, I want to create an Invoice class that has a HasCustomer

[orientdb] Re: from the orientdb console.sh ,I could't get the right server-configuration

I answered you on StackOverflow (http://stackoverflow.com/questions/37407953/from-the-orientdb-console-sh-i-couldt-get-the-right-server-configuration/37409508#37409508) Il giorno martedì 24 maggio 2016 10:19:29 UTC+2, GANG NG ha scritto: > > I set the db.pool.min and db.pool.max in the orientdb-s

[orientdb] Re: EDGES creations at RUN time

sorry, I did not understand well what is your goal? -- --- 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...@googlegroups.com. For more opti

[orientdb] Re: Any hint for Graph Database? (Suggerimenti per query orientate ai grafi?)

L'alias "numerocitazioni" non puoi usarlo direttamente, ma riesci a usarlo nella query esterna a quello in cui l'hai creato. Poi nel where devi usare 'in' e non >= perchè il risultato del max credo sia visto come una lista. Giusto per correttezza il nome dell'arco "cites" è piu corretto metterlo

[orientdb] Re: Any hint for Graph Database? (Suggerimenti per query orientate ai grafi?)

Per avere il numero di citazioni (conteggio archi entranti): To get the number of citations (counting incoming edges): SELECT nome, in().size("cites") AS numeroCitazioni FROM Articoli UNWIND numeroCitazioni risultato: +--+-+--- # |@CLASS|nome |numeroCitazioni +-

[orientdb] Re: Increase speed in populating database via Http API

An example of a class that performs 3 operations: - Create 10 verticies of class 'Person' (extend V) with two properties 'id', 'name'; - Creates the 'Link' class (extend E) - Connects via edge n vertices; *CLASS MAIN* public class threadSintetizzata { static final String REMOTE

[orientdb] Re: Any hint for Graph Database? (Suggerimenti per query orientate ai grafi?)

capisco, tieni presente che se fatto in java le API sarebbero poche ( connessione, salvarsi i vertici per esempio in un lista classica) e poi tutto il resto sono operazioni che implementano l'algoritmo. Altrimenti una soluzione potrebbe essere fare una funzione in Javascript. Questo se vuoi otte

[orientdb] Re: Any hint for Graph Database? (Suggerimenti per query orientate ai grafi?)

Per calcolare un cfc serve implementare un algoritmo (es SCC, Tarjan, ) non credo si possa fare tutto con query/traverse. Una classe Java fatta ad hoc che lo calcola potrebbe esserti utile? To calculate a cfc serves implement an algorithm (eg SCC, Tarjan,) I do not think you can do it with que

[orientdb] Re: Any hint for Graph Database? (Suggerimenti per query orientate ai grafi?)

quindi grafo orientato, (nell'immagine non si vedono i versi degli archi).. hai un'immagine che mostra la direzione? So directed graph, (in the picture there aren't lines of direction) .. have you an image that shows the direction? -- --- You received this message because you are subscribed

[orientdb] Re: Any hint for Graph Database? (Suggerimenti per query orientate ai grafi?)

Ok, (scusa ho letto velocemente e al posto di 'cita' o inteso 'citta'). Quindi nel tuo caso, vorresti trovare tutti i vertici "fortemente connessi" , senza la dipendenza della direzione (grafo non orientato), per cui otterresti come risultato tutti gli articoli presenti nell'immagine che hai pub

[orientdb] Re: Any hint for Graph Database? (Suggerimenti per query orientate ai grafi?)

Pensavo tu avessi uno scenraio del tipo Classe ArticoliScentifici, e una Classe Citta. (dato che sono due entita distinte) Una situazione simile a questa: I thought you had a scenario like ArticoliScentifici class, and a City Class. (Since they are two separate entities) A situation similar to th

[orientdb] Re: Creating each record into its own cluster

The cluster is nothing but a grouping of records. The equivalent of the relational world would be a table. In object-oriented model of OrientDB all instances of a class are stored in a clustered ad hoc. By convention, the name of the cluster and the class match, but you can change the schema at

[orientdb] Re: compression method

At this link there is a discussion relating to storage-compression . -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe f

[orientdb] Re: Import database from MS SQL Server 2012 Database to OrientDB

is url correct?.. The correct syntax should be: "Jdbc: sqlserver: //" + hostname + ":" + port + "; Database Name Database Name = {}"; in your url the ': port' is missing. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from th

[orientdb] Re: it is not possible register hook to remote grap database with adding lib file to server folder?

hi, I write you a working example that I had done so you can adapt it to your purposes: MAIN CLASS import java.io.IOException; public class Hook { static final String REMOTE = "remote:localhost/"; static final String NOMEDB= "hook"; static final String CURRENTPAT

[orientdb] Re: collection [] method broken in 2.1.9 for ranges?

Hi, in this link http://stackoverflow.com/questions/35093409/collection-method-broken-in-2-1-9-for-ranges there is a possible answer. Il giorno venerdì 29 gennaio 2016 21:22:11 UTC+1, Keith Freeman ha scritto: > > I've got these classes in my schema: > > create class hour extends V > create cl

[orientdb] Re: classic RDBMS or graph?

Hi, orientdb is a graph database.. if you want to see other information about it, you can try to see this link slide regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. T

[orientdb] Re: Tinkerpop3 support in OrientDB

Hi, there will most likely be in version 3.0 expected in November / December 2015 (looking the roadmap ) Regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this

[orientdb] Re: Incremental Backup?

hi, There will most likely be in version 2.2 which will be released in September / October 2015 (roadmap ) regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from thi

[orientdb] Re: Optimising Paginated Queries - Advise on best methodoloy

it would be possible for you export your db? (if it is not a problem and there are no sensitive data) .. because with the database orient populated, the tests are more significant. I repeat if these ores is not a problem for you regards, Savio L. -- --- You received this message because you

[orientdb] Re: Optimising Paginated Queries - Advise on best methodoloy

hi Sky, about indices there is no way to index the count, the important thing is to have indexed fields that are used. Great post about the pivot-class:), I try to do some tests on my db and see how you can eventually possibly optimize ... regards, Savio L. -- --- You received this message b

[orientdb] Re: Create and insert vertex and edges from a single json file.

Hi, I wanted to ask, the data that you want to insert into the database OrientDB take them from a csv file or are new ?? because if you take them from a csv, you can create the json file that creates vertex and edge; otherwise if you create new data, you can create a script file that allows you

[orientdb] Re: Distributed architecture - help setting replica

I copied the text from the guide (http://orientdb.com/docs/2.0/orientdb.wiki/Distributed-Configuration.html) reading it I think if the parameter 'hot alignment' is true then the queue is left when the node back online is updated, and if the parameter is false tail is removed. Regards, Savio L.

[orientdb] Re: Distributed architecture - help setting replica

Hi Ran, In case a node left the cluster hotAlignment the synchronization queue is left or not for hot alignment when the node will join the cluster again. It can be true or false Regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" gr

[orientdb] Re: Replication is failing

Hi, have you taken these steps? 1) modifying the file Hazelcast as follows on all PCs on the network you want to use as nodes: 2434 235.1.1.1 2434 *IP_PC_1:2434* *IP_PC_2:2434* 2) Run the first node by entering the

[orientdb] Re: Optimising Paginated Queries - Advise on best methodoloy

Hi, certainly a way to increase performance is to index the fields on which you make the query (i do not know maybe you've already done). For stable which approach is better, I think the only way is to experiment and compare between them. Regards, Savio L. -- --- You received this message be

[orientdb] Re: Index is not being updated after insert

Having experienced the same situation in another machine and having seen that it works is a good road, I think it is a problem only to that database instance on the machine that does not work well .. You might try downloading a new version (also always 2.0.13 or 2.0.14), and test if the issue i

[orientdb] Re: Can't find sample database when logged into root user

Hi Stephanie, which versione of orientb are you using? regards, Savio L. -- --- 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...@googlegro

[orientdb] Re: Index is not being updated after insert

Hi Ran, I tried your sql script and it works (at the beginning I had a mistake because in the insert command and select the id field is written upper case, and in the declaration of the id field was written lowercase, never mind this is not the problem :) .. In your log file (OrientDB folder / l

[orientdb] Re: Index is not being updated after insert

Hi, if this is the sequence that you used previous insert 1,2,3... select from Contact --> return all vertices with id 1,2 and 3 CREATE INDEX contactId on Contact(id) UNIQUE_HASH_INDEX insert into Contact (id) values (4) have you tried to get the last id added, with the query: SELECT FROM Co

[orientdb] Re: WrongTargetException

hi, the only difference between your file Hazelcast and my, is that you have the following lines in more: 10.0.20.175 and 10.0.20.175 try to remove them... some improvement? regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientD

[orientdb] Re: WrongTargetException

Hi, have you already tried to download the latest version 2.1? azelcast.xml the file is so configured on all nodes? 2434 235.1.1.1 2434 *IP1:2434* *IP2:2434* *IP3:2434* etc... regards, Savio L. -- --

[orientdb] Re: How to properly index edges?

Hi Sven, Why do you need another indexing? have you already tried to implement it with all your complete database? ..as well as the query is too slow? if you copy "inuuid" on edge you have a duplicate value since the same value exists in the vertex. If you move it from vertex to edge you sure th

[orientdb] Re: possibility to turn-off rest sessions in configuration ?

Hi, you have already tried to see if this post can help you? Security concern - Not good to pass username:password in every HTTP transaction regards, Savio L. -- --- You received this message because you are sub

[orientdb] Re: How to properly index edges?

Increasing vertices returned by subqueries, the intersect increase the computation time .. How much slower honestly do not know, the only way to understand it is to do some testing . I believe that intersect instruction compare simply RID of the vertices returned by subqueries (certainly less th

[orientdb] Re: How to properly index edges?

I'm back, we tried to reconstruct the query, try this if that is what you need .. back vertex Abstract that are connected to NormalizedNamedEntity with a uuid = "DBA002026" and uuid = "NO000357" select expand($c) let $a = (select expand(in('uima_annotated')) from (select from Nor

[orientdb] Re: error: Cannot open local storage with mode=rw

HI, I think not, because if the database is already open for writing by another process can not access it for reading. regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails

[orientdb] Re: How to properly index edges?

perfect, i'm downloading it.. -- --- 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...@googlegroups.com. For more options, visit https://gro

[orientdb] Re: How to properly index edges?

Hi, can you export and send me your Database so we can test it (if it isn't a problem for you).. regards, Savio L. -- --- 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 emai

[orientdb] Re: Slow performance

hi, i tried your db, leaving everything as it is and making the query I got this result: SBTREE To speed it up you could delete the index

[orientdb] Re: node merge history: best approach

hi, to resolve your question there are various way as rightly you have listed too. One of these ways, perhaps the simplest approach, might be the one shown in the picture: It should not (I th

[orientdb] Re: Slow performance

Hi Ivan, which version of Orientdb are you using? regards, Savio L. -- --- 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...@googlegroups.c

[orientdb] Re: Distributed orientdb performance

Hi, try putting an index of type NOTUNIQUE_HASH_INDEX on the 'rate' property. Have you some improvement? regards, Savio L. -- --- 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

[orientdb] Re: Is there a way to retrieve the latest created vertex in a javascript function?

HI, it's not very clear, you would create a scheme like this: then extract the RID of the superclass Person to create the edge between the person class and subclasses...

[orientdb] Re: Insert records without duplicates in N to 1 relationship

hi, depends of your idea how to do it, if there is a scope Particular .. I personally would have created a graph db, with two classes: Country and City connected by an edge. For example something like this:

[orientdb] Re: How to save a nested object in a server function?

try this changes: 1) in the class Employee, change the departement property as: LINKSET 2) in your function javascript, delete "db.save(employee);" and add "g.command( "sql", " insert into Employee(name,department) values ('John2',[#2:33]) ");" *example:var g= orient.getGraph(); var employ

[orientdb] Re: How to save a nested object in a server function?

Hi, in the class Employee, the field "department" is a property of type 'Link'?? or an other type? regards, Savio L. -- --- 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 em

[orientdb] Re: Load data from csv file

Hi, you may use the ETL tool in this OrientDB. With this you can import the data directly into csv OrientDB, it is necessary that you you structure your db defining classes and edge. More info with an example you can find on help for ETL: Import from a CSV file to a Graph

[orientdb] Re: exception-Transaction was rolled back more times than it was started.

Hi, this exception has emerged after what event? Sql queries, java function, etc .. regards, Savio L. -- --- 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

[orientdb] Re: not found orientdb-dserver-config.xml file

Hi, the orientdb-dserver-config.xml always should be in this path: orientdb-community-2.0.12/config/ If there isn't, you could try to re-download of the OrientDB version. regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To u

[orientdb] Re: Type cannot be serialized because is not part of registered entities (embedded mode + document API

Hi, you should use the "ODatabaseDocumentTx" to open db if you want create/use a Document database. replace OObjectDatabaseTx with ODatabaseDocumentTx (example ODatabaseDocumentTx db = new ODatabaseDocumentTx ("plocal:sampledb"); Regards, Savio L. -- --- You received this message becau

[orientdb] Re: What's "better": edges with properties or multiple edges?

Hi, maybe this link may help you: When use Lightweight Edges regards, Savio L. > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emai

[orientdb] Re: Trying to get the last 20 edges from a vertex

Hi, maybe this link may help you: ORDER BY performance - best practice regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientD

[orientdb] Re: Removing a field and value in a class, how to do it?

hi, if you click on the red icon to the trash next to the property, then you have to click save, and this will eliminate the value of the property. (see picture) If you choos

[orientdb] Re: Add edges only during the ETL process

hi, the database that you have in OrientDB, you've created from scratch, or is a database that you had saved in another DB ?? .. Because if you did you had saved in a previous DB ideally export as csv or json file .. so with ETL can import everything and as rightly you said you are much faster

[orientdb] Re: Removing a field and value in a class, how to do it?

Hi Scott, which version of orientdb are you using? regards, Savio L. -- --- 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...@googlegroups.

[orientdb] Re: Deleting Orphan Links

hi, can you try to go to tab "Graph" (in orientdb studio) to perform the following two queries: 1) select from V -> do run 2) select from E -> do run What do you see as image? regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group

[orientdb] Re: Applying SKIP before GROUP BY - 2.0.4 -bug?

hi, if i understand it, you do a query and add the group by on the @rid. In this case you would have the equivalent of a query without group by because the rid change forever and there will never be two or more rid equal, therefore you can not group anything regards Savio L. -- --- You rec

[orientdb] Re: How far can the dot notation go?

i'm not 100% sure but i think so Savio L. -- --- 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...@googlegroups.com. For more options, visi

[orientdb] Re: How far can the dot notation go?

hi, I think the dot notation, falls according nesting of the date That you created. example: case 1) set address = {street: "street Roma 1"} select Name, address.street as street_name from person where Name = "john" case 2) set address = {street: "street Roma 1," city: {name: "Roma", country:

[orientdb] Re: Using an index to query based on datetime property

Hi, *OrientDB side*: doing a field "name"(string) and "dataobject" (datetime), create the vertexs (ex: insert into Object (name, dateobj) values ("C","2015-06-22 11:00:00")) and then create the index (CREATE INDEX cercadata ON Object (dateobj) NOTUNIQUE). you should have the same situation show

[orientdb] Re: select from property

Hi Marco, Try to see if you entered the field "nome_prodotto" in this way: Once inserted so, making the query you should see the desired result.

[orientdb] Re: traverse and filtering based on edge property

hi, This query comes close to what you need, but only show the nodes connected to each other that have valid = 1, starting at node 1 (in my case # 12: 0). To find the shortest path, I think you need to create a specific java function. select outV().name, inV().name from (select from (traverse *

[orientdb] Re: Question about warning messages: "Element '#xx:xx' not found in traverse history

Hi, can you post your schema? (vertex, edge,...) regards, Savio L. -- --- 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...@googlegroups.co

[orientdb] Re: Creating edge between non-vertex classes

Hi anthony, maybe it could help you to the answer given to a similar question concerning the extension of class V and E: "Another question on basic concep

[orientdb] Re: Index type exception of SPATIAL

Hi, i try with java, the code below should work: public class Space { private static String remote = "remote:localhost/"; public static void main(String[] args) { String nomeDb = "GeoByJava10"; String currentPath = remote + nomeDb; OServerAdmin serverAdmin;

[orientdb] Re: Index type exception of SPATIAL

Hi, try this code (is a simple example): create class Spazio extends V CREATE property Spazio.name string CREATE property Spazio.latitude double CREATE property Spazio.longitude double insert into Spazio (latitude, longitude) values (32.78,-79.916667) insert into Spazio (latitu

[orientdb] Re: List of objects via EMBEDDEDLIST and ODocument? - is this the correct approach?

hi, you have already tried using java? With java the field @version, @type there are not (see the image) java code: public class TestObject{ private String value; public TestObject()

[orientdb] Re: HTTP-PUT on index - strange behaviour

hi Fadanner, you should create a unique constraint not only on IP, but both of ip that the new property "text", so is taken as a unique pair "ip-text" regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this

[orientdb] Re: How should time and spatial data be managed in OrientDB 2.0.10 ?

hi, Your problem is to use geospatial data or create the database from scratch ?? regards, Savio L. -- --- 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-da

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

i believe is a problem that occurs only on mac, because on linux and windows it is ok (i did test it now with this version of orientdb), but another my colleague he has a mac with the connect by console on his remote db has the same problem as you... -- --- You received this message because

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

ok perfect, to interact with the db Testing for example, there are these command: connect remote:localhost:2424/Testing root root CREATE CLASS V1 EXTENDS V CREATE VERTEX V1 SET name = 'name1' select from V1 +-+--+- # |@RID |@CLASS|name +-+--+- 0 |#13:0|V1|

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

with this command (written in the console): connect remote:localhost:2424 root root have you got immediately problem? Il giorno martedì 9 giugno 2015 09:24:03 UTC+2, Abhilash Panigrahi ha scritto: > > Every time I try to connect to a database, or create a database, i > encounter the follo

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

do you use the orientdb console or use the Java ide (for example eclipse to run your code)? Also I get a blank line if I write echo $CLASSPATH on my linux terminal... Il giorno martedì 9 giugno 2015 09:24:03 UTC+2, Abhilash Panigrahi ha scritto: > > Every time I try to connect to a database,

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

hi, that's what you need? -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this g

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

Hi, try this code, have you got the same error? import java.io.IOException; import com.orientechnologies.orient.client.remote.OServerAdmin; import com.tinkerpop.blueprints.Vertex; import com.tinkerpop.blueprints.impls.orient.OrientGraph; public class Test { private static String remote =

[orientdb] Re: Help optimize a query and/or graph design

Hi, you should take before all users Americans who likes as the id of the movie you want, and then filter by number. SELECT userid FROM ( select from (SELECT expand(in("Likes")) FROM Movie where movieid = 112) WHERE country="us" ) limit 500 regards Savio L. Il giorno mercoledì 10 giugno 201

[orientdb] Re: Can't connect to the database. Command Executor not foundcom

Hi, which version are you using?? -- --- 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...@googlegroups.com. For more options, visit https:

[orientdb] Re: Is there any starter sample?

Hi Chaitanya, The following guidelines for a small example: First: create the class Vertex you need it, for example Person to see the relations of friendship CREATE CLASS Person EXTENDS V Second create the class Edge to link the Vertex CREATE CLASS HasFriend EXTENDS E Third: populates the class

[orientdb] Re: Exception during commit when using EmbeddedSet type with custom object

Hi, a small improvement on the previous post Iterator i= testObjects.iterator(); while(i.hasNext()) { james.setProperty("testObjects2",((TestObject) i.next()).getName()); } bye, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group.

[orientdb] Re: Exception during commit when using EmbeddedSet type with custom object

Hi Damien, try add this james.setProperty("testObjects2",testObjects.iterator().next().getValue()); regards, Savio L. Il giorno lunedì 16 febbraio 2015 17:53:25 UTC+1, Damien Dussol ha scritto: > > Hello > > I want to use a field with EmbeddedSet value. In this field I want to put > Custom o

[orientdb] Re: Complex query

Hi Andrey, i'm sorry for the name in the previous answers, I do some test then I tell you... regards, Luigi S. -- --- 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 t

[orientdb] Re: Traverse all Vertecies without removing duplicates (orientdb-community-2.0)

Hi Emin, this is JavaScript function that you were looking for: var gdb = orient.getGraphNoTx(); var list = gdb.command( "sql", "select expand(in('link_to_school')) from Scuola"); var start; var scuola; var lista; var end; var loadlist = 0; var nomepersona var nomescuola for(i=0; i "+ nomesc

[orientdb] Re: Complex query

Hi Ziink, the result you were looking for, is return with (not easy:) query: select name, sum from (select expand($totale) let $v2 = (select name, sum(sum) from ( select expand($c) let $a = (select name, sum(count) from (select name, count(*) from (select expand(out("Related")) from Vertex wher

[orientdb] Re: Edge Query Issue

Hi Thomas, you can try a query like this: select name_event from (select expand(out('registered')) from Hour where value = '23') regards, Luigi S. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop rece

[orientdb] Re: Complex query

Hi Ziink, I created V1 and V2, and i linked them so: V1 -->related --> V2 V1 -->related --> V2 V1 -->related --> V2 V2 -->related --> V1 V2 -->related --> V1 so i have 3 link from V1 to V2, and 2 link from V2 to V1. With this query: select count(*) FROM Related LET $c = in.size()

[orientdb] Re: SQL commands for bulk database manipulation

Hi Ropel, try this function, should be the solution you are looking for. First you should create a User class with name, nameschool and then paste this code into functions tab and choose how j

[orientdb] Re: Newbiew SQL Question

Hi Sean, perhaps this is the query you were looking for: - insert with json parameters INSERT INTO PersonJson (my_prop) values ({"name": "James", "age": 23}) - get parameters in json format SELECT my_prop FROM PersonJson --> Result: {"age":23,"name":"James"} Bye, Luigi S. Il giorno sabato 30

[orientdb] Re: Extra spaces in SQL commands

Hi, most probably is expected behavior. The same behavior there is in the precedent stable version (2.0.8) Reguars. Luigi S. Il giorno sabato 30 maggio 2015 10:19:37 UTC+2, Sergei Pohilko ha scritto: > > > Hi! > > I noticed that SQL commands are sensitive to extra spaces between words: > > crea

[orientdb] Re: multiple shortest paths

Hi Boris, Can i ask you which is the exactly schema of your db (with Vertex and Edge)? so i can try to help you more.. regards Luigi S. Il giorno domenica 24 maggio 2015 06:27:54 UTC+2, Boris Wexler ha scritto: > > Is it possible to combine multiple Shortest Path requests in one query > when

[orientdb] Re: multiple shortest paths

try to look at the picture if it is a solution for you? Regars Luigi S. Il giorno domenica 24 maggio 2015 06:27:54 UTC+2, Boris Wexler ha scritto: > > Is it possible to combine multiple Shortes