Re: [orientdb] SQL Select fields that have no data (null) in result set

Hi Scott is the field photo declared in the schema? 2015-09-08 17:32 GMT+02:00 Scott Wruble : > If I have a vertex, users, that has the following properties: firstname, > lastname, photo. Photo can be null. If I have the following records: > > Jane | Doe | > John | Doe | > John | Smith

[orientdb] Re: What is the best way to retrieve multiple connected vertexes as a nested object?

So I haven't found a good solution to this, as of now I'm making this query: SELECT *, out('hasEdge') as first_vertexes, out('hasEdge').out('hasEdge') as second_vertexes FROM #11:1 FETCHPLAN first_vertexes:1 second_vertexes:1 and in the resulting rows that I get I manually match the the in's and

[orientdb] OrientDB database as service

So, I love what I've seen and used from OrientDB. The data-design is perfect for my application use case, but there is one thing holding us back. We are a small team and have to database administrators. We are using managed hosting for everything we can, but can't find any quality database-as-a

[orientdb] Is opening a database connection an expensive operation?

The "database connection per user" approach is not used in typical applications that use relational databases. Instead, database connection pooling is used. Does the same apply to OrientDb? -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group

[orientdb] Re: Best practice for Edges with same names

Your VENUEROLE, PROJECTROLE, COMPANYROLE edges can subclass ROLE edge, so you can traverse specific role or all roles. I also use module based prefixes to prevent name clashes: Authentication_Role, Company_Role ... Dne úterý 8. září 2015 17:39:48 UTC+2 Scott Wruble napsal(a): > > Just learning O

[orientdb] SQL collect path in tree

I've got a tree where each node (vertex of class Scope) has property "key" and nodes are connected to it's parent by "childOf" edge (edge is directed from child to parent). I need a query which would traverse a tree from a known root and create a path to each node by concatenating "key" properti

[orientdb] Re: Best practice for Edges with same names

Hi, I think it is more correct to define VENUEROLE, PROJECTROLE, COMPANYROLE in which every edge has its specific properties. Kind regards, Alessandro -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop re

[orientdb] Best practice for Edges with same names

Just learning OrientDB... If I have these verticies: PERSON, VENUE, PROJECT, COMPANY What is the best practice for defining schema (or not) and use of EDGES with the same name? For example: PERSON -> ROLE -> VENUE PERSON -> ROLE -> PROJECT PERSON -> ROLE -> COMPANY where ROLE may have differ

[orientdb] SQL Select fields that have no data (null) in result set

If I have a vertex, users, that has the following properties: firstname, lastname, photo. Photo can be null. If I have the following records: Jane | Doe | John | Doe | John | Smith | pic1.jpg Using this SQL in JDBC: select firstname, lastname, photo from users I get the expected resul

[orientdb] OrientDB 2.1.1 no way to screening keywords

Hi all, who know how to avoid incorrect query parsing? In next example class name Contains parsed as keyword: CREATE EDGE Contains FROM #14:0 TO #14:1 Return exception "Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #0: Encount

Re: [orientdb] Re: why getVertexByKey was deprecated?

Hm.. It is too complex than last api. 2015. 9. 8. 20:34에 "Johan Sjöberg" 님이 작성: > Use the Iterable > > getVertices(String > > iKey, Obje

[orientdb] Re: ETL v.2.1.0 error

Hi Igor, I had the same error message and I fixed the problem by following the installation instractions of etl: - Clone the repository on your computer, by executing: - git clone https://github.com/orientechnologies/orientdb-etl.git - Compile the module, by executing: - mvn

[orientdb] Can not open remote database using token

Is this a wanted behaviour or a bug? Is there any near term plan to support 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...@goo

[orientdb] error during import

I am trying to import a table from mysql called 'activity_log'..the oetl give below error: [orientdb] DEBUG orientdb: found metadata field 'null' Exception in thread "main" com.orientechnologies.orient.core.exception.OSchemaEx ception: The database contains some schema-less data in the property

[orientdb] Re: why getVertexByKey was deprecated?

Use the Iterable getVertices(String iKey, Object iValu

[orientdb] Re: why getVertexByKey was deprecated?

Hi, with studio you can use this query select expand(rid) from (select rid from index:Index.name) where rid=#11:0 while with JAVA API you can use this code Iterable result=g.command(new OSQLSynchQuery("select expand(rid) from (select rid from index:Index.name) where rid=#11:0")).execute(); for(

[orientdb] Changing property to boolean throws errorr

Imported table users ...trying to add properties manually...when I try to change isActive to boolean it says : Error: com.orientechnologies.orient.core.exception.OSchemaException: The databas e contains some schema-less data in the property 'tnode.isActive' that is not co mpatible with the type