[orientdb] Re: About customizing node labels on studio

2016-06-28 Thread Luca Son
Hi, the vertices labels can't be displayed outside the circle. About the string length, you could modify the *Radius *value in the *Graph *tab to make the node able to contain the string (or to make the string more legible) like this way:

[orientdb] Re: помогите пжл не понимаю в чем ошибка обясните ктот нибудь

2016-05-13 Thread Luca Son
Hi, If I launch your command from console I obtain your same error: orientdb {server=remote:localhost/}> create database remote:localhost/people root root local Creating database [remote:localhost/people] using the storage type [local]...Cannot create the remote storage: people

[orientdb] Re: Is it possible to rename a remote database?

2016-05-09 Thread Luca Son
Hi Pablo, I tried to rename the remote DB but it doesn't seem possible. In the official documentation I found the parameters supported by the ALTER DATABASE command. Hope to have been helpful. Luca -- --- You received this message

[orientdb] Re: Can't import Properly

2016-05-06 Thread Luca Son
Hi, if you have a database BACKUP, you have to execute this command: RESTORE DATABASE path/to/db you can find more details at this link: http://orientdb.com/docs/2.1/Backup-and-Restore.html. Hope it helps Luca -- --- You received this message because you are subscribed to the Google

[orientdb] Re: orient db disconnect/timeout

2016-05-04 Thread Luca Son
Hi Mihai, the reasons of the issues can be diffferent (e.g. network problems) but similar issues have been fixed in the latest OrientDB versions. Could you try to update to the latest 2.1.16 ? Thanks -- --- You received this message because you are subscribed to the Google Groups

[orientdb] Re: unable to display Stats under server management

2016-05-02 Thread Luca Son
Hi, I'm posting the answer to this question provided on StackOverflow . -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this

[orientdb] Re: how do I get null values in a class with a property = a list of objects ?

2016-04-18 Thread Luca Son
Hi pabloa, what type is 'activities' (embedded, embeddedlist, embeddedmap,...) ? Thanks Luca -- --- 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

[orientdb] Re: Distributed mode with multicast enabled don't work.

2016-03-20 Thread Luca Son
Hi Luc, I tried your case by using Oracle VM VirtualBox and the following configurations: - 3 nodes and "root" password for each node; - in hazelcast.xml; - other configurations all default. When I start up the 3 nodes they work correctly as distributed, do you have any other

[orientdb] Re: Distributed mode with multicast enabled don't work.

2016-03-20 Thread Luca Son
Hi Luc, could you post your hazelcast configuration ? Did you add the members IPs ? Luca -- --- 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

[orientdb] Re: Can we connect to OrientDB with remote protocol which is running as "in memory" process ?

2016-03-19 Thread Luca Son
Hi Satish, I tried your case by creating a new 'memory'storage type database named e4798tr0sPM. This is the simple my structure: create class New extends V create property New.field string create vertex New set field = 'Test' Now if I try to connect with remote protocol and query the class New

[orientdb] Re: Insert Multiplke data from file

2016-03-02 Thread Luca Son
Hi Eswar, is the error the same you had got previously ? In my posted code I added '//added instruction' comment without closing the double slash and a part of the code has been commented, but I don't know if this could be the reason... -- --- You received this message because you are

[orientdb] Re: Insert Multiplke data from file

2016-03-02 Thread Luca Son
Hi Eswar, I tried your case and I found that the reason is that you have to create the class 'table1' before inserting the records. If you change your code in this way it should work: OrientGraph g=new OrientGraph(currentPath); System.out.println("Connessione stabilita"); OClass

[orientdb] Re: Insert multiple Records using gremlin

2016-03-02 Thread Luca Son
Hi Rahul, could you try this code ? public class MyClass { public static void main(String[] args){ OrientGraph g = new OrientGraph("remote:localhost/dbName","root","root"); // Create class and properties OClass

[orientdb] Re: Best Approch For GUI?

2016-03-01 Thread Luca Son
Hi Eswar, are you using the OrientDB Studio interface ? -- --- 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

[orientdb] Re: Insert data from user end

2016-03-01 Thread Luca Son
Hi Eswar, you could use a loop to insert multiple records. Here's my code: BufferedReader reader = new BufferedReader(new InputStreamReader(System.in)); System.out.println("Insert the number of record to create: "); String input = null; input = reader.readLine(); int num =

[orientdb] Re: Extract Structure of Database

2016-02-29 Thread Luca Son
Hi, I haven't a specific link about embedded fields to share, but here you'll find a lot of useful informations about the OSQL query syntax. Hope it helps Luca -- --- You received this message because you are subscribed to the Google Groups

[orientdb] Re: Extract Structure of Database

2016-02-28 Thread Luca Son
Hi, I created this query to retrieve the properties name, type and the belonging class name. select from (select name, type, $class.name as className from (select expand (globalProperties) from metadata:schema) let $class=(select name from (select expand(classes) from metadata:schema) where

[orientdb] Re: Extract Structure of Database

2016-02-27 Thread Luca Son
Hi, in OSQL you can use this query: select expand(classes) from metadata:schema that retrieves the informations about the schema classes. Hope it helps Luca -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group

[orientdb] Re: EDGE creation using Gremlin api in java

2016-02-24 Thread Luca Son
Hi Eswar, I tried your code and I solved the problem by adding the last instruction of this code: OrientGraphFactory factory = new OrientGraphFactory(currentPath).setupPool(1 , 10); Graph g = factory.getTx(); Vertex v = g.addVertex("class:BUS"); v.setProperty("Name", "hyd"); Vertex

[orientdb] Re: How Do I use stored geometries in the Spatial functions?

2016-02-19 Thread Luca Son
I'm posting the answer given on StackOverflow about this question: http://stackoverflow.com/questions/35498121/how-do-i-use-stored-geometries-in-the-spatial-functions -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this

[orientdb] Re: Select with let subquery not working

2016-02-07 Thread Luca Son
Hi Mark, which are the names and types of the properties ? Thanks -- --- 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

[orientdb] Re: wat is the query to get the count of edges in a database in orient db

2016-01-29 Thread Luca Son
Hi Ravi, try this query: select count(*) from E Hope it helps Luca -- --- 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

[orientdb] Re: getting object properties in gremlin

2016-01-25 Thread Luca Son
Hi Leonid, I created this simple DB to try the query and I think that the structure it's similar than yours In Gremlin the query I used to obtain the start_id, tail_id and tail_class it's

[orientdb] Re: help looking into 2 classes at the same time

2016-01-25 Thread Luca Son
Hi Renzo, if you want to obtain data from Business and BusinessLocation after the checks you can use this query: select expand($ris) let $a = (select from Business where title = 'negocio 1'), $b = (select from BusinessLocation where address = 'Direccion prueba nro 2 negocio 1'), $ris =

[orientdb] Re: How to speed up a query with non-indexable field in WHERE

2016-01-22 Thread Luca Son
Hi Hung Tran, I understand, unfortunately it is not currently possible to create indexes across multiple classes. Could you try with this SB-TREE index ? CREATE INDEX EntityInfo.State ON EntityInfo (State) NOTUNIQUE instead of your HASH_INDEX CREATE INDEX EntityInfo.State ON EntityInfo

[orientdb] Re: Query with a combination of LET and Subselect is very slow

2016-01-22 Thread Luca Son
Hi Hung Tran, yes, if it were possible it would help a lot. Thanks Luca -- --- 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

[orientdb] Re: Query with a combination of LET and Subselect is very slow

2016-01-22 Thread Luca Son
Hi, thanks for the DB. To compare the results, could you tell me what's your best execution time about the above query ? Thanks Luca -- --- 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 speed up a query with non-indexable field in WHERE

2016-01-21 Thread Luca Son
Hi Hung Tran, a possible approach would be to create an index SB -TREE EntityInfo.State NOTUNIQUE instead of a NOTUNIQUE_HASH_INDEX to avoid the sorting in the use of this index . This is because the indexes SB - TREE retain sorting , making it unnecessary sorting operations (like ORDER BY).

[orientdb] Re: Query with a combination of LET and Subselect is very slow

2016-01-21 Thread Luca Son
Hi Hung Tran, could you post the entire schema to try the query ? Thanks Luca -- --- 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

[orientdb] Re: LET is error with aggregation

2016-01-19 Thread Luca Son
Hi Hung Tran, I would advise you to use your first 'Working SQL' in this case but if you want to use the LET statement in your queries this could be a solution: select Name, $v1.max from TestClass let $v1=(select max(IntF) from TestClass where $parent.current.Name in Name) group by Name Which

[orientdb] Re: LET is error with aggregation

2016-01-19 Thread Luca Son
Hi Hung Tran, could you post your code or do you have a small DB test to reproduce the issue ? Thans Il giorno martedì 19 gennaio 2016 03:30:49 UTC+1, Hung Tran ha scritto: > > Hi, > > I am migrating from version 1.7.8 to version 2.1.8. The below query is > failed to execute > > SELECT $v1

[orientdb] Re: Missing from documentation insert into index

2016-01-04 Thread Luca Son
Hi, in your case you could try the creation of the index and then proceed with the insertions of the records like this: create class Person extends V create property Person.name string create property Person.address string create index Person.name on Person(name) NOTUNIQUE I used NOTUNIQUE to

[orientdb] Re: Special characters and/or spaces in the database URL

2015-12-21 Thread Luca Son
Hi, if you want to open the databases that contain special characters in their path you have to use the quotes in the piece of path where you used them. For example (I used your indication): connect plocal:C:/"database$"/orient/MyDb admin admin It also works with spaces: connect

[orientdb] Re: Lucene text search not working with nested queries?

2015-12-07 Thread Luca Son
Hi Davide, I tried your DB in OrientDB 2.1.6 and after launching your query I get this exception com.orientechnologies.orient.core.exception.OQueryParsingException: Error on parsing command at position #0: LUCENE condition is allowed only when query target is a Class or an Index because you