Questions tagged [orientdb-2.1]

Use this tag for questions specific to the 2.1 version of Orient DB of Orient Technologies.

OrientDB is a 2nd Generation Distributed Graph Database with the flexibility of Documents in one product. Its family is NoSql database.

It is possible use OrientDB in two different version:

Community Edition (free) Enterprise Edition (commercial)

142 questions
7
votes
0 answers

OrientDB, Initial DB replication

I'm trying to setup OrientDB in distributed mode on AWS, behind a ELB, in an ASG. So far so good, but the initial DB replication have only happened in one out of fifteen tries! That is, after a new node have joined the cluster, only ONE DB is…
Fransurbo
  • 357
  • 2
  • 13
4
votes
1 answer

OrientDB create vertex type

I'm working with OrientDB with Java API. I have this warning, and I don't understand why: The command 'create vertex type 'Users' as subclass of 'V'' must be executed outside an active transaction: the transaction will be committed and reopen right…
besil
  • 1,308
  • 1
  • 18
  • 29
3
votes
1 answer

Orientdb GC overhead limit exceeded/out of memory error and slow performance

My orientdb database has around 2.3 million records. I'm trying to query all duplicate records (there are around 750,000 of them) using statement- SELECT FROM (select PROP1, PROP2, count(*) as c from vin_data group by PROP1 ) where c > 1. When I set…
3
votes
2 answers

Can we UPSERT an EDGE in orientdb?

Is it possible to get an example to upsert an edge in orientdb. IF it does not exist is there a way to check if the edge exist, if it does then just update the edge else create a new edge. I am using Orientdb 2.1.13 version. Thank you
howard roark
  • 628
  • 7
  • 27
3
votes
1 answer

How disk cache in OrientDB is separated by read and write cache (percentages)

I found out from the Docs that, given 100% usage of disk cache by orientdb, it uses a maximum size of 70% for read cache and 30% for write cache…
michelepatrassi
  • 2,016
  • 18
  • 32
3
votes
0 answers

Improve performance of in() out() and both()

Consider we have Vertex User, Post and Edge FriendsWith, HasPost. FriendsWith can be in both directions out and in (usually it is either out or in between 2 users). User is owner of Post. We got 600000 users and 75 million of Posts I use to get user…
Fedir Petryk
  • 497
  • 3
  • 16
3
votes
1 answer

Loading random Vertex in OrientDB

I need to load random Vertex or Edge record. Is there any way to do this very fast? Query select @rid from User skip 300000 limit 1 is very slow. Thank you
Fedir Petryk
  • 497
  • 3
  • 16
3
votes
1 answer

Orient db Query for getting Sample db Grateful Dead Concerts data in Jasper Reports

I am new to OrientDB and Jasper reports. I have successfully connected the Jasper-soft studio with OrientDB using jdbc driver But when I query the sample OrientDB Grateful Dead Concerts in Jasper reports, it returns some fields and their class type…
Farrukh Cheema
  • 85
  • 1
  • 2
  • 7
3
votes
1 answer

OrientDB, Find Index Insertion point

I have a 'bill' vertex with 'date' property and made an automatic SB-tree not unique index on the bill's date for faster searches, now I want every inserted bill to have edge with next bill and create a linked nodes structure, the solutions I got so…
DrAhmedJava
  • 731
  • 8
  • 16
2
votes
1 answer

Orient DB distributed replica on embedded server

We are setting a distributed OrientDB database on an embedded server (we are using OrientDB v.2.2.31). We would like to have a master-replica configuration, but we have encountered some issues in doing that. We have setted the…
2
votes
0 answers

How to perform non-transactional commit using orient jdbc driver

I am connecting to remote database as following using JDBC driver v2.2.13 Connection conn = (OrientJdbcConnection) DriverManager.getConnection("jdbc:orient:remote:" + ip + ":" + port + ";" + ip + ":" + port2 + "/" + appName,…
Prakash P
  • 3,582
  • 4
  • 38
  • 66
2
votes
1 answer

orientdb select does not return all vertices

I'm using OrientDB studio for creating vertices from a certain type (NodeType1). I created 29 vertices by using OrientDB studio and when I run: select count(*) from NodeType1 I get 29 records. However, when I run: select * from NodeType1 I get a…
Shoham Ben-Har
  • 317
  • 1
  • 4
  • 16
2
votes
2 answers

How to change input type in orientdb

I have a class with name "employee" , in that class i have a property named "salary" with input data-type string. So, my question is can i change input data-type of "salary" from string to integer ? and if yes then how ?
2
votes
1 answer

rdbms "view" equivalent on orientdb

Is there a "view" equivalent on orientdb? I have a rdbms background and am looking for a way to save a query as an object which i can query directly. Take for example the following query SELECT mobile_number AS…
2
votes
1 answer

OrientDB import edges only using ETL tool

I already used the OETL to insert all my Vertex to the graph. Now I have a file that outlines the edges at the following way: node_1,rel_type,node_2 11000001,relation_A,10208879 11000001,relation_A,10198662 11000001,relation_B,10159927 …
Dor Cohen
  • 16,769
  • 23
  • 93
  • 161
1
2 3
9 10