I'm experiencing a very strange behaviour when using the in-memory
database. I'm using the graph java api and v2.0.10 of orientdb.
I have some code similar to following:
OrientGraph graph = graphFactory.getTx();
graph.executeOutsideTx(noTx - {
noTx.createVertexType(test);
return null;
Hi alltogether,
is the feature of storing Funtions in the Database still usable?
I followed documentation and got completely lost.
First: I fired a simple SQL-Query
Schema: contracts [n-link-1] subcategories [n-link-1] categories
[n-link-1] industries
To query all contracts belonging to a
I'm not certain but I think there's a bug in Studio that is causing an
error with orient.getDatabase()
On Wednesday, June 3, 2015 at 1:32:40 PM UTC-7, hartmut bischoff wrote:
Hi alltogether,
is the feature of storing Funtions in the Database still usable?
I followed documentation and got
Hi.
I have created your schema, the graph i get is:
https://lh3.googleusercontent.com/-GmOpS3vQjVY/VW7Qzuk7AkI/ACw/fgCDsrzlBNI/s1600/grafo.png
https://lh3.googleusercontent.com/-GmOpS3vQjVY/VW7Qzuk7AkI/ACw/fgCDsrzlBNI/s1600/grafo.png
Hi Lior,
try this query
select distinct(id) as id from (select expand( $c ) let $a = ( SELECT
outV() as id FROM Called WHERE start_time10 AND end_time11 ), $b = (
SELECT inV() as id FROM Called
WHERE start_time10 AND end_time11 ), $c = unionAll( $a, $b ))
Alessandro
--
---
You
Thanks Luigi!
How to add traverse to this query, lets say you have the next graph
V1 --related -- V2
V1 --related -- V2
V1 --related -- V2
V2 --related -- V1
V2 --related -- V1
V1 --related -- V3
V1 --related -- V3
V3 --related -- V1
So the result for query for V1 would be
V2 5
V3 3
Thanks a lot.
Tried to contact you via email (so as not to disturb others who may find my
questions are not relevant or too simply)
On Friday, 29 May 2015 12:18:31 UTC+1, James Wang wrote:
Hi All,
I am new to OrientDB and trying to import data from a CSV file using the
ETL tool.
Do I
Hi David,
I'm not sure I understood your problem... are you having problems in
defining 1..N relationships with edges?
If it's the case, you can just avoid to define schema for edge links and
the graph engine will do the job for you.
Eg.
CREATE VERTEX Directory set name = 'ParentDir'
#12:0
Thanks Nagu!
But I also need to group by vertices I related to.
On 3 June 2015 at 07:02, nagaraja sosale ramaswamy nagud...@gmail.com
wrote:
select sum(count) from RELATED where in = #11:0 or out = #11:0
hope that helps...
~nagu.
On Wednesday, June 3, 2015 at 2:26:24 PM UTC+5:30, SavioL
Hi Clark,
yes, creating edges that involve different shards is supposed to work fine.
Could you please open an issue and provide a simple test case?
Thanks
Luigi
2015-06-02 10:40 GMT+02:00 Clark Peng htc.clark.p...@gmail.com:
Hi all,
I'm having issue while using OrientVertex.addEdge()
Hi James,
there is a lot of improvement in the roadmap of OETL, we know that right
now it is not optimized. If you are doing a one-shot import I suggest you
to go with embedded and after that start the server.
If you need very high performance you should consider Java API or
OGraphBatchInsert
perhaps you could try this:
select distinct(@rid) from (select expand(bothv()) from related)
let me know if it works for you.
regards,
~nagu.
On Wednesday, June 3, 2015 at 3:59:16 PM UTC+5:30, alessand...@gmail.com
wrote:
Hi Lior,
try this query
select distinct(id) as id from (select
Ok. Thanks. I think I read somewhere that vertices in a graph db are
automatically created with Oversize=2?
Scott
--
---
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
Hi,
for the first question you can use the DISTINCT clause,
for example : SELECT distinct(outV()) FROM Called WHERE start_timeX AND
end_timeY
Bye, Alessandro
Il giorno lunedì 1 giugno 2015 20:36:59 UTC+2, Lior Neudorfer ha scritto:
Hi,
two small questions from an OrientDB beginner...
I
I've now read in the docs there is an option to do preallocation (oversize)
to, I think, basically pack on extra space for changing record sizes
(through updates), in order to avoid movement of records. The documentation
is a bit thin on explaining it. Could someone expand on this feature
Hi Scott,
Try looking for oversize in Documentation search box.
Best Regards,
Luca Garulli
CEO at Orient Technologies LTD
the Company behind OrientDB
http://about.me/luca.garulli
On 3 June 2015 at 11:02, scott molinari scottamolin...@googlemail.com
wrote:
I've now read in the docs there is
That's not enough - it only gives me one side. And I can't use bothV()
instead - it will give me distinct couples, which is not what I'm looking
for.
On Wednesday, June 3, 2015 at 10:25:41 AM UTC+3, alessand...@gmail.com
wrote:
Hi,
for the first question you can use the DISTINCT clause,
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()
i get
I did. And I still stand by what I said. The documentation is a bit thin on
explaining it.
What is the reason for oversizing? Is it the same as with MongoDB MMap and
the avoidance of document movement on disk?
What does Oversize do exactly? What are the differences in the settings?
What
Hi,
is it possible to implement a kind of Change Management in OrientDB to
manage different Versions of records and to make them reproducible?
- how is this possible? ;-)
Thanks!
Sysos
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To
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
select sum(count) from RELATED where in = #11:0 or out = #11:0
hope that helps...
~nagu.
On Wednesday, June 3, 2015 at 2:26:24 PM UTC+5:30, SavioL wrote:
Hi Ziink,
I created V1 and V2, and i linked them so:
V1 --related -- V2
V1 --related -- V2
V1 --related -- V2
V2 --related
hi
I'm trying to get all vertices that have no incoming edges. How do I do
that?
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
Hi Thomas,
it depends on following factors:
- do you need bi-directional traversal? In case an edge is better
- do you plan to store information on the links? in case an edge is better;
in case not, with linkset you will save some space and performance
- do you plan to delete events? In case you
Hi
is there a way to get an answer of my 4 issues?
Please tell me whether I was asking too much.
I do not see any of my mails any more in this mailing list.
Thank you
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this
Hi SavioL,
It's not Ziink was asking it's me.
Thanks a lot for your answer, I'll try it shortly. This is quite a work
you've done right there, I do appreciate it.
I have concerns regarding performance of this query on large sets of data...
And I still need to add one tweak, I don't know how
Hi altogether,
I just discovered that its very easy to populate a linkset just by
assigning an array of Record (or Vertex)-Links to it.
Unfortunatly I don't know enough java -
In ruby, hashes and arrays are robust ie:
a= Array.new
a 9
a 3
a 'z'
gives always [9,3,'z'], thus an
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 where
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; ilist.length;
Hi there,
is there any sample code or gist that show how to create a function wich
handle time serie with graph api triggered by vertex creation?
i think this is a common pattern
thank you
Il giorno mercoledì 3 giugno 2015 15:55:43 UTC+2, Luigi Dell'Aquila ha
scritto:
Hi Thomas,
it
Luigi,
Thanks for your reply. My problem came from the way my code evolved and
not understanding that you couldn't use labels AND heavy-weight edges. I
had originally started with lightweight edges and was actively using the
'label' of the edge to represent information - in this case, the
Hi David,
try this query:
select from V where @rid not in (select expand(out()) from V)
in this way you should find all the vertices that have no incoming edges.
Bye, Giulia
Il giorno mercoledì 3 giugno 2015 13:51:03 UTC+2, David de Sousa Seixas ha
scritto:
hi
I'm trying to get all
Just wanna to share:
If run in stand alone (i.e. server.sh), I managed to import 2500 vertices
per seconds - 12 times quicker than running in the distributed mode
(dserver.sh)
Great.
:-D
On Friday, 29 May 2015 12:18:31 UTC+1, James Wang wrote:
Hi All,
I am new to OrientDB and trying to
Hi,
I just want to be sure I understand the basics correctly.
If I create a database as a document type, I cannot use vertices or edges.
But, if I create a database as a graph type, I can, and I must use vertices
as documents and create the relations between them with edges?
If that is
select * from Issue fetchPlan:-1
On Monday, June 1, 2015 at 12:10:14 PM UTC+5:30, SavioL wrote:
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
Hi Dan,
try this query:
select @rid as RidAccount, name, $path, $depth, outE().@rid as RidLink,
outE().link_quality as LinkQuality from (traverse out('link') from #14:14)
Bye, Giulia
Il giorno martedì 2 giugno 2015 00:24:21 UTC+2, Dan Fellars ha scritto:
OrientDB noob, having trouble with
see if this helps:
select v,sum(count) from (select if(eval(in=#11:0),out,in) as v,count
from E where in=#11:0 or out=#11:0) group by v
~nagu.
On Wednesday, June 3, 2015 at 5:15:52 PM UTC+5:30, Andrey Yesyev wrote:
Thanks Nagu!
But I also need to group by vertices I related to.
On 3
you need to look for the tag 2.0.10, not branch.
On Wednesday, June 3, 2015 at 2:01:39 AM UTC+5:30, Andrey Yesyev wrote:
Never mind, found them
https://github.com/orientechnologies/orientdb/releases
On Tuesday, June 2, 2015 at 4:19:36 PM UTC-4, Andrey Yesyev wrote:
How to get sources for
try clicking on the 'wiki' link on
https://github.com/orientechnologies/orientdb-docs
On Monday, June 1, 2015 at 7:47:00 PM UTC+5:30, Ziink A wrote:
https://github.com/orientechnologies/orientdb-docs is empty.
--
---
You received this message because you are subscribed to the Google
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
to
i'm facing same problem while json_encode suggest me what to do
On Tuesday, April 22, 2014 at 7:23:34 PM UTC+5:30, jaya raj wrote:
hi,
I can't access data of oreintdb record in ajax
the below code i used
* server side code*
try {
$this-odb = new
In case of LINKLIST the order is maintened, the LINKSET not maintain the
order.
by the way in a LINKLIST you can add only LINKS
On 03/06/15 14:58, hartmut bischoff wrote:
Hi altogether,
I just discovered that its very easy to populate a linkset just by
assigning an array of Record (or
HI Guilia - thanks for the reply. Yes, that will do the job. I had seen
the inE(), outE() functions used in examples but never saw any
documentation of what they were used for. Now they make sense and exactly
what I was looking for.
Thanks for the help!
Dan
On Wednesday, June 3, 2015 at
Hi i am using OrientDB version 2.0.8 and as far as i can see the AVG()
method only returns the integer part of the result and discards the decimal
part.
Would be helpful if it supports an optional param:
Select AVG(rating, true) from Ratings will return the decimal part as well.
Regards
Hi,
if your rating is an integer variable, the method avg() will return an
integer value. So either you change the type of the variable, or use this
query
select AVG(rating.asFloat()) from Ratings
Alessandro
--
---
You received this message because you are subscribed to the Google
Hi,
Il giorno mercoledì 3 giugno 2015 17:13:29 UTC+2, acsandeep ha scritto:
Hi i am using OrientDB version 2.0.8 and as far as i can see the AVG()
method only returns the integer part of the result and discards the decimal
part.
Would be helpful if it supports an optional param:
On Wednesday, June 3, 2015 at 5:12:24 PM UTC+2, Emanuele wrote:
In case of LINKLIST the order is maintened, the LINKSET not maintain the
order.
Thanks,
I just checked ... It loads an Array of RID-items and returns the same.
Perfect
--
---
You received this message because you are
On Thursday, June 4, 2015 at 12:15:11 AM UTC+2, Ziink A wrote:
I'm not certain but I think there's a bug in Studio that is causing an
error with orient.getDatabase()
This is what I thought first, too.
Then I tested the feature with the HTTP/REST-API --- same result – even if
I change
Hi Luca ,
Thank you for reply , Now i am moving from memory to plocal storage for
distributed graph database . Orientdb helped me alot through this analysis
process . Got to learn many things. Orientdb created new era in graph
databases . I hope it is future of technology .
--
---
You
49 matches
Mail list logo