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

2015-02-12 Thread 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: > > Hi, > > I am doing some testing on the SELECT IN operation. The is a Employee > class in the database with 2 columns (Name, Age). Only 1 record had been > ins

[orientdb] Importing XML Into OrientDB

2015-02-12 Thread Arch
Hi I am new to orientDB. I am using OrientDB version 2.0.1 I want to import xml file into orientdb database. Thank you -- --- 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

[orientdb] How to modify the default cluster id for a class?

2015-02-12 Thread Sally Ahn
Hello, I'm having trouble finding the right command to set the default cluster id for a class. I created a Datacenter class, added 3 clusters to it (usa_datacenter, asia_datacenter, europe_datacenter), and deleted the original default datacenter cluster. So now, my Datacenter class does not hav

[orientdb] Re: How can I decode the OrientDb network binary token in my client app?

2015-02-12 Thread greenpea
Ok, excellent, that's helpful, I should be able to figure out from that. Thank you! On Thursday, February 12, 2015 at 8:52:03 PM UTC, Christian Kramer wrote: > > Hey, > > sorry i've missed the forest for the trees. The token is not base64 > encoded ;). It's just raw byte concatenated to one big

[orientdb] Link Creation between two big data full classes

2015-02-12 Thread sagir . pro
Hi Buddies, Here I am sharing one concern about link establishment of Big Data. In one situation of our project we are trying to establish link after creating the class and dumping 10 rows into each class. In this situation it is taking more than expected time like 5 hours to just process

[orientdb] Re: Liquibase for OrientDB

2015-02-12 Thread Andrey Kovalev
Hi, I haven't found any orientdb extension for liquibase so I wrote a simple prototype which at least can proccess simple sql-based changesets. But for that orientdb jdbc driver must be modified slightly. You can check it in repositories below: https://github.com/young-druid/orientdb-jdbc https:/

[orientdb] Re: How can I decode the OrientDb network binary token in my client app?

2015-02-12 Thread Christian Kramer
Hey, sorry i've missed the forest for the trees. The token is not base64 encoded ;). It's just raw byte concatenated to one big byte array. You have to split it manually. See orientdb/server/src/main/java/com/orientechnologies/orient/server/token/OBinaryTokenSerializer.java and especially t

Re: [orientdb] OTimeoutException: Can not lock record for 2000 ms. seems record is deadlocked by other record

2015-02-12 Thread Luca Garulli
Hi Alexander, Could you attach full exception log? Lvc@ ᐧ On 11 February 2015 at 15:17, alexander anguiano wrote: > orientdb 2.0.1 > java 7 > window & linux > sql and the java api > > I have a multi-thread environment with multiple threads updating and > reading. date from my graph database. >

Re: [orientdb] AWS Ami

2015-02-12 Thread Luca Garulli
Hi Enrico, Upgrading AMI to 2.0.2 id in our roadmap. If you need it now, just use AMI of 1.7 and update OrientDB manually. Lvc@ ᐧ On 12 February 2015 at 17:52, Enrico Di Marco wrote: > Hi is there an aws orient 2.x AMI ? > > any other dev ready cloud solution ? (like the gloriosus nuvolabase)

[orientdb] Re: User, Roles, Links and Embedded Links with ETL

2015-02-12 Thread 'Curtis Mosters' via OrientDB
csv excel or crypted? Anyway you should export as csv and then sure it should work well with etl Am Mittwoch, 11. Februar 2015 08:12:47 UTC+1 schrieb Gregor Frey: > > Hi, > is it possible to create User and Roles with ETL (from an Excel)? And how > about Links and Embedded Links? Can they be cre

[orientdb] Re: Orient 2.0.1 ClassCastException

2015-02-12 Thread dakotarnaproject
Was it fixed in 2.0.2? On Thursday, February 12, 2015 at 1:10:54 PM UTC-5, dakotarn...@gmail.com wrote: > > I am runni two instances of Orient DB 2.0.1 community edition in > distributed mode on the same host. > I am not able to connect using to the DB using Http RESTFUL and I see the > followi

[orientdb] Orient 2.0.1 ClassCastException

2015-02-12 Thread dakotarnaproject
I am runni two instances of Orient DB 2.0.1 community edition in distributed mode on the same host. I am not able to connect using to the DB using Http RESTFUL and I see the following exceptions in the logs: [DAKOTA_NODE2] Saving distributed configuration file for database 'StaticDataPersisted'

[orientdb] Re: difference between two datetime parameters

2015-02-12 Thread Rubens Ballabio
Worked! Thank you Tobie! On Thursday, February 12, 2015 at 3:54:42 PM UTC+1, Tobie Morgan Hitchcock wrote: > > You could also use > > select first( outE().timestamp ) as created_time, first( inE().timestamp ) > as closed_time > > > http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Fu

[orientdb] Re: Index optimisation

2015-02-12 Thread Tobie Morgan Hitchcock
I think there might be another issue with indexing... Doing a COUNT in sql uses the index, but still reads every record, instead of just issuing the count on the index. I think the issue has already been submitted here https://github.com/orientechnologies/orientdb/issues/3462 And i've added it

[orientdb] AWS Ami

2015-02-12 Thread Enrico Di Marco
Hi is there an aws orient 2.x AMI ? any other dev ready cloud solution ? (like the gloriosus nuvolabase) ? thank you -- --- 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: Index optimisation

2015-02-12 Thread Tobie Morgan Hitchcock
We are using OrientDB 2.0.2, what about you? Are there any other issues you have found with indexing? On Thursday, 12 February 2015 15:39:22 UTC, Keith Freeman wrote: > > Good post, showing some important limitations of orientdb indexing. Your > "Problem 2" has been an especially important issu

[orientdb] Re: Index optimisation

2015-02-12 Thread Keith Freeman
Good post, showing some important limitations of orientdb indexing. Your "Problem 2" has been an especially important issue for us, I hope they can address it. BTW, which version are you using? On Thursday, February 12, 2015 at 4:56:13 AM UTC-7, Tobie Morgan Hitchcock wrote: > > Hi, > > I've

[orientdb] Lucene index with PortugueseAnalyzer not returning values

2015-02-12 Thread syshex
Hi everyone, I'm creating a lucene index with the following sql queyr: create index Company.description_nif on Company(description,nif) FULLTEXT ENGINE LUCENE METADATA {"analyzer":"org.apache.lucene.analysis.pt.PortugueseAnalyzer"}" When I query the index with the following query I get no res

[orientdb] Re: difference between two datetime parameters

2015-02-12 Thread Tobie Morgan Hitchcock
You could also use select first( outE().timestamp ) as created_time, first( inE().timestamp ) as closed_time http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Functions.html#first Tobie On Thursday, 12 February 2015 14:49:43 UTC, Tobie Morgan Hitchcock wrote: > > Hi Rubens, > > The

[orientdb] Re: difference between two datetime parameters

2015-02-12 Thread Tobie Morgan Hitchcock
Hi Rubens, The thing about in(), out(), both(), inE(), outE(), inV(), outV() is that it should return an array of records (edges/vertices) and not a single value. To get the first edge from the query and ignore the other edges you could use the following... select outE()[0].timestamp as creat

[orientdb] Re: difference between two datetime parameters

2015-02-12 Thread Rubens Ballabio
Hi Tobie, the query i am doing is not retrieving datetime... that's the real issue. This is my query: select outE().timestamp as created_time, inE().timestamp as closed_time from Ticket where id='1' the output i see is something like this: ["2014-10-24 09:14:17"], ["2014-10-26 19:31:23"] basica

[orientdb] Re: difference between two datetime parameters

2015-02-12 Thread Tobie Morgan Hitchcock
Hi Rubens, There should be a couple of ways of making it work... 1. This uses eval to give you the time difference in milliseconds SELECT eval('deleted_at - created_at') AS diff FROM Friends 2. This uses eval to give you the time difference in seconds SELECT eval('(deleted_at - created_at) / 100

[orientdb] difference between two datetime parameters

2015-02-12 Thread Rubens Ballabio
Hi guys, do you know if there is any way to do a simple difference between two datetime parameters? i can't find the way to make it work. thank you in advance, Rubens -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this

[orientdb] Index optimisation

2015-02-12 Thread Tobie Morgan Hitchcock
Hi, I've been working with OrientDB for a while, and have come across some potential index problems, which might be bugs, but I am not sure, so I thought I would check here first. A detailed explanation of the index issues are on the following Gist: https://gist.github.com/tobiemh/807e4604ab8f

Re: [orientdb] Backup restore issue from 1.7.10 to 2.0.2

2015-02-12 Thread ranga welagedara
Thank you for the quick response. I am pretty sure that console,server is not running but I will double check and get back to you Thanks Ranga -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving

Re: [orientdb] Backup restore issue from 1.7.10 to 2.0.2

2015-02-12 Thread Luca Garulli
Hi Ranga, the error here seems pretty clear: *The process cannot access the file because another p**rocess has locked a portion of the file* ᐧ Double check you haven't OrientDB server, console or a running app that is using the database. Lvc@ On 12 February 2015 at 07:32, ranga welagedara wrot