Re: [orientdb] "order by" approaches

2017-10-12 Thread Enrico Risa
Hi André which is the query that you want to order by? Is it a simple `select from class order by field` ? 2017-10-11 23:55 GMT+02:00 André Toscano : > Hello everyone, > firstly, congratulations for everything. It's a real nice community. > I would like to ask about

Re: [orientdb] Can't Connect to DataBase using Plocal from JAVA .Index type FULLTEXT is not supported by the engine

2017-10-05 Thread Enrico Risa
Are you building a single executable JAR? 2017-10-05 15:58 GMT+02:00 Maxim Nikolaev <pyz...@gmail.com>: > I'm using InlelliJ IDEA ...Add dependence on orientdb-lucene to SCOPE > provided - not help me > > четверг, 5 октября 2017 г., 16:26:42 UTC+3 пользователь Enrico Risa &

Re: [orientdb] Can’t connect to database using Plocal

2017-10-04 Thread Enrico Risa
Hi Maxim if you have a running server with that database, you cannot open it in plocal, since the server holds the exclusive lock on it. You can do this only if the JVM is the same.For example if you embed OrientDB in your application. Thanks Enrico 2017-10-04 14:57 GMT+02:00 Maxim Nikolaev

Re: [orientdb] Not possible to use server after db = server.use?

2017-10-04 Thread Enrico Risa
Hi Eric Seems a bug on session management, i've created an issue here https://github.com/orientechnologies/orientjs/issues/279 2017-10-03 16:56 GMT+02:00 Enrico Risa <enrico.r...@gmail.com>: > Hi Eric > > let me check on this > > 2017-10-03 14:46 GMT+02:00 Eric24 <

Re: [orientdb] Not possible to use server after db = server.use?

2017-10-03 Thread Enrico Risa
Hi Eric let me check on this 2017-10-03 14:46 GMT+02:00 Eric24 : > Can anyone answer this question? > https://stackoverflow.com/questions/46536616/not- > possible-to-use-server-after-db-server-use > > PS - I'm not sure what the comment about opening a github request is all >

Re: [orientdb] Re: OrientDB 3.0m2 and gremlin-python

2017-09-06 Thread Enrico Risa
Hi Bailey yes the support for Gremlin Server is not yet completed. I think it will be available for testing once the 3.0RC1 is out. 2017-09-06 14:55 GMT+02:00 Bailey Glen : > I believe that the functionality I am looking for is currently being > implemented, but is likely

Re: [orientdb] Restore backup created from a different instance

2017-08-30 Thread Enrico Risa
Hi the metadata of the backups are stored inside the OSystem database. In order to restore the same situation of backups you should also copy 1) The file $ORIENTDB_HOME/config/backups.json 2) The OSystem database 2017-08-30 18:49 GMT+02:00 AnSDE007 : > Luca, > >

Re: [orientdb] Re: Inconsistent versions in distributed setup

2017-08-01 Thread Enrico Risa
Hi Zeeshan probably this should fix your issue https://github.com/orientechnologies/orientdb/commit/e9d9f6f41eb2722e5657e8242954286c085a0990 You can try the snapshot once it's rolled out, or you can wait the 2.2.25 GA that should be out tomorrow Thanks 2017-08-01 16:19 GMT+02:00 Zeeshan Ahmad

Re: [orientdb] Orientdb put Geospatial point on a vertex with Json script

2017-07-26 Thread Enrico Risa
Hi John since the format of the Point is WKT you can use ST_GeomFromText function in order to create the Geometry http://orientdb.com/docs/2.2/Spatial-Index.html#stgeomfromtext 2017-07-26 16:10 GMT+02:00 John : > I'am using *Orientdb 2.2*. I have a *CSV* with

Re: [orientdb] Orientdb query geospatial bad result

2017-06-14 Thread Enrico Risa
t; 05:38:01|Personne|29.0| > |29 |#23:544|Tabz |176 |832 |tag832 |OPoint{coordinates:[2]}|6.0 > |2003-02-18 18:43:57|Personne|17.0| > ++---+--++-+---+ > ---++---+++ > > the orange is the lanes I don'

Re: [orientdb] Orientdb query geospatial bad result

2017-06-14 Thread Enrico Risa
Hi John do you have an example of records with coordinates that fails to return with the index? Thanks 2017-06-14 12:10 GMT+02:00 John : > > I use Orientdb 2.2 I create a class:TabzIndex with coordinate geospatial > (Opoint) > > > > create class TabzIndex extends V >

Re: [orientdb] OrientDB 2.2.14 Graph Editor

2016-12-27 Thread Enrico Risa
Hi Tore With Physics switch you can freeze/unfreeze the graph layout force https://github.com/d3/d3/blob/master/API.md#forces-d3-force Link distance is the distance Node to Node. If you have a high connected Graph the layout could be a mess. If you increment this value the rendering will be

Re: [orientdb] orientdb-spatial: should I extend OPoint?

2016-12-27 Thread Enrico Risa
Hi Gregory the spatial module cannot realize that your object is a OPoint. In order to use the spatial functions and the spatial index you should use directly OPoint as embedded property in your domain as written in the documentation http://orientdb.com/docs/2.2/Spatial-Index.html Thanks

Re: [orientdb] How to connect remote orientDB server using orientjs

2016-08-08 Thread Enrico Risa
Which exception do you get? 2016-08-08 15:29 GMT+01:00 Suyog Kale : > Hello, > > I am new to OrientDB, I am using nodejs npm OrientJs to connect remote > database. > > Below is sample: > > var ODatabase = require('orientjs'); > var server = ODatabase({ > host:

Re: [orientdb] Facet Creation Issue

2016-08-06 Thread Enrico Risa
t; On Aug 6, 2016, at 11:01 PM, Enrico Risa <enrico.r...@gmail.com> wrote: > > See the Roadmap here > > http://orientdb.com/docs/2.2/Roadmap.html#release-31 > > 2016-08-06 18:29 GMT+01:00 Enrico Risa <enrico.r...@gmail.com>: > >> Hi Ruitu >> >> That

Re: [orientdb] Facet Creation Issue

2016-08-06 Thread Enrico Risa
See the Roadmap here http://orientdb.com/docs/2.2/Roadmap.html#release-31 2016-08-06 18:29 GMT+01:00 Enrico Risa <enrico.r...@gmail.com>: > Hi Ruitu > > That is why facets are not supported. > That was an experimental version, absolutely not ready for production and

Re: [orientdb] Facet Creation Issue

2016-08-06 Thread Enrico Risa
Hi Ruitu That is why facets are not supported. That was an experimental version, absolutely not ready for production and not well tested. It is not documented and you should not use it. Thanks 2016-08-06 18:18 GMT+01:00 Ruituraj Gandhi (Knowledge Explosion) < ruitu...@knowledgeexplosion.info>:

Re: [orientdb] Spatial Module Doc available in 2.2.x examples mixes lat/long

2016-07-28 Thread Enrico Risa
d navigator. So why not say this explicitly - ODB does it > the opposite way? > > How come OrientDB selected EPSG:4326 ? > > T. > > > On 27 July 2016 at 21:01, Enrico Risa <enrico.r...@gmail.com> wrote: > >> Hi Tore >> >> the docs

Re: [orientdb] Spatial Module Doc available in 2.2.x examples mixes lat/long

2016-07-27 Thread Enrico Risa
Hi Tore the docs is not incorrect. The Spatial Module uses the spatial reference system EPSG 4326 http://spatialreference.org/ref/epsg/wgs-84/ and the x & y are projected in longitude (-180 +180) and latitude( -90 +90). See here http://geojson.org/geojson-spec.html#positions and here

Re: [orientdb] Re: Functions in Oreintdb

2016-07-25 Thread Enrico Risa
Hi Parvat if you want to use prepared statement you can use something like this db.command("sql","select from V where out('E').out('E').in('E').name contains ? ",[namein]) 2016-07-25 17:52 GMT+02:00 : > Hi, > you can use > > "select from V where

Re: [orientdb] orientjs : error returning decimal data type

2016-07-13 Thread Enrico Risa
Hi Renzo seems that the decimal type is not yet supported by the new native serializer https://github.com/orientechnologies/orientjs/issues/187 You should use Double type instead. 2016-07-13 17:07 GMT+02:00 Renzo Ludeña : > Hello friends > > I'm developing a

Re: [orientdb] use lucene lucene fulltext and geospatial in one query

2016-04-26 Thread Enrico Risa
Hi Renzo ca you post here the explain of select * from CommerceLocation where state = true and [description, title, keyword] LUCENE "text" and latitude is not null and longitude is not null and [latitude, longitude, $spatial] NEAR [-12.100518317393732,-77.03370729064943,{'maxDistance' :

Re: [orientdb] The query time in Studio.

2016-03-11 Thread Enrico Risa
For now if you want to know the core query timing the only way is with explain. If you do a normal query Studio uses OrientDB http protocol that gives back only the results set. So the execution time is taken client side. 2016-03-11 9:18 GMT+01:00 'scott molinari' via OrientDB <

Re: [orientdb] Cannot authenticate from web studio but console works - Digitalocean

2016-02-26 Thread Enrico Risa
Hi Payman Can you try with OrientDB 2.1.11? https://orientdb.com/download.php?file=orientdb-community-2.1.11.tar.gz 2016-02-26 22:04 GMT+01:00 Payman Samadi : > Hi, > > I just installed Orientdb on Digitalocean server according to the manual: >

Re: [orientdb] How to get all cluster IDs for a given class?

2015-10-14 Thread Enrico Risa
Hi Simon With Java you can use; db.getMetadata().getSchema().getClass("Test").getClusterIds(); Enrico 2015-10-14 17:08 GMT+02:00 Simon White : > OrientDB v2.1 > > > The .NET API gives me GetClusterIdsFor() returning a list of cluster ids > for a given class

Re: [orientdb] Massive Insert of Edges

2015-10-14 Thread Enrico Risa
Hi Simon which is your current rate? Do you need this as a batch import that you do one time? 2015-10-14 22:03 GMT+02:00 Simon White : > > I am using Orientdb v2.1.2 > > I need to insert several million edges between two EXISTING vertex. > > I started off

Re: [orientdb] Lucene does not work as expected in complicated query

2015-10-12 Thread Enrico Risa
Hi Eddy which version are you using of OrientDB? can you paste here the explain of the second query? explain select out.writing from word_language where in.abbreviation = 'en' and *out.writing lucene 'tru*'Enrico* 2015-10-12 10:33 GMT+02:00 Eddy Fosman : > I have a

Re: [orientdb] Persisting Graph Editor view

2015-10-08 Thread Enrico Risa
Dennis which user do you use admin or root? 2015-10-08 16:00 GMT+02:00 Dennis O : > +1 > Same here. > > I use the Studio a lot for modelling. > While experimenting I'm frequently changing queries and necessity to set > labels and circle sizes again is enormously

Re: [orientdb] Persisting Graph Editor view

2015-10-08 Thread Enrico Risa
Hi Adrian which user are you using in the login? 2015-10-08 14:28 GMT+02:00 Adrian Lynch : > Hello all. > > I'm developing a prototype graph and working in the Graph Editor is > proving frustrating as I can't seem to find a way to keep the vertices and > edges

Re: [orientdb] Persisting Graph Editor view

2015-10-08 Thread Enrico Risa
har...@gmail.com>: > Root. > > > > On Thursday, October 8, 2015 at 10:03:16 AM UTC-4, Enrico Risa wrote: >> >> Dennis >> which user do you use admin or root? >> >> >> -- > > --- > You received this message because you are subscribed to the

Re: [orientdb] Persisting Graph Editor view

2015-10-08 Thread Enrico Risa
+02:00 Dennis O <dennis.ohar...@gmail.com>: > Enrico, > > I'm using root for that my db as well. > Please advise. > > Dennis > > > > On Thursday, October 8, 2015 at 10:40:39 AM UTC-4, Enrico Risa wrote: >> >> Can you try with admin? >> >&g

Re: [orientdb] Issue with FULLTEXT using Lucene on 12.1.3

2015-10-06 Thread Enrico Risa
", > "recordReads": 30, > "elapsed": 18.605516, > "resultType": "collection", > "resultSize": 0, > "@fieldTypes": > "evaluated=l,score=f,documentAna

Re: [orientdb] Issue with FULLTEXT using Lucene on 12.1.3

2015-10-06 Thread Enrico Risa
3, Cpv4 > . They all extend from Cpv. > > All data created is of type Cpv1,2,3,4 . The lucene index is created on > Cpv in order to find all Cpvs that match a criteria. > > > On 6 October 2015 at 09:51, Enrico Risa <enrico.r...@gmail.com> wrote: > >> Can you

Re: [orientdb] Issue with FULLTEXT using Lucene on 12.1.3

2015-10-06 Thread Enrico Risa
LECT * FROM Cpv WHERE [description] LUCENE "limpeza" > > > > On Tuesday, October 6, 2015 at 10:57:51 AM UTC+1, Enrico Risa wrote: >> >> Maybe there is some issue with inheritance. >> >> I'm checking >> >> 2015-10-06 11:46 GMT+02:00 Rui Perei

Re: [orientdb] Issue with FULLTEXT using Lucene on 12.1.3

2015-10-06 Thread Enrico Risa
2015-10-06 13:12 GMT+02:00 Rui Pereira <sys...@gmail.com>: > Ok, when should I expect that to be released? > > I was upgrading from 2.0.4 . When was this new memory index implementation > introduced? > > Thanks for your help > > On 6 October 2015 at 12:03, Enrico Risa

Re: [orientdb] Issue with FULLTEXT using Lucene on 12.1.3

2015-10-05 Thread Enrico Risa
Hi syshex can you paste here the result of explain SELECT * FROM Supertable WHERE description LUCENE "limpeza*" 2015-10-05 20:07 GMT+02:00 syshex : > Hi everyone. > > I've got a table named Supertable with a String field called description. > > Created a Lucene index on it,

Re: [orientdb] Re: Spatial Query, Java API documentation, General documentation

2015-09-25 Thread Enrico Risa
Hi harith54 i think you can open a bug for this select from BBB where [lat,lon] NEAR [25.3648,85.3154] Maybe the default maxDistance is 0 so you will not get results back. Make sense by default to set like 1KM? 2015-09-25 12:59 GMT+02:00 : > Hi, > > I try it with

Re: [orientdb] finding a vertex using @rid through the Java API - orientdb 2.1.2

2015-09-25 Thread Enrico Risa
Hi Mihai "#12-0" is invalid record id #12:0 is the correct one You can use the api Vertex v = txGraph.getVertex("#12:0") 2015-09-25 13:47 GMT+02:00 Mihai Ocneanu : > Hello, > > I'm trying to find a vertex by @rid, using the Java Graph API: > > Iterable vertices =

Re: [orientdb] Is my database corrupted? SQL queries on same data returning different/odd results.

2015-09-22 Thread Enrico Risa
Hi Jean how do you remove edges between Channel and Account? 2015-09-23 5:33 GMT+02:00 Jean-Sebastien Lemay < jean.sebastien.le...@gmail.com>: > Using OrientDB 2.1.1 Community Edition > > Situation: > >- I have "Channel" and "Account" vertices. >- Users can join channels, and when

Re: [orientdb] Re: The create schema script to run in studio

2015-09-19 Thread Enrico Risa
Hi Guru which version of OrientDb do you use? in 2.1 you can execute batch from studio Go to the wrench icon in the type select choose batch instead of command Paste your script in the editor and then run. 2015-09-19 20:22 GMT+02:00 Gururaj Kulkarni : > Hi Tim, > > Thank

Re: [orientdb] Question about connection pool for multithread graph traversal

2015-09-18 Thread Enrico Risa
Hi Cong are you using OrientGraphFactory? http://orientdb.com/docs/last/Graph-Factory.html 2015-09-18 4:33 GMT+02:00 Cong Sun : > We are trying to do a multithread graph traversal by using a connection > pool. Currently, each thread has a new connection and we close each >

Re: [orientdb] Re: OClass.createProperty WITH vs WITHOUT OClass Parameter (PERFORMANCE)

2015-09-14 Thread Enrico Risa
Hi Bryan Are you inserting through plocal? how many records do you have to insert? After how many records do you see the slow down? Did you check the memory of your inserting batch? Enrico 2015-09-14 17:37 GMT+02:00 Bryan : > Okay, I created issue #4965 >

Re: [orientdb] Re: OClass.createProperty WITH vs WITHOUT OClass Parameter (PERFORMANCE)

2015-09-14 Thread Enrico Risa
LINKSET in the log > Set logEntries = log.field("log_events"); > logEntries.add(logEntryDocument.getIdentity()); > log.save(); > > db.commit(); > } > > > > On Monday, September 14, 2015 at 8:42:09 AM UTC-7, Enrico Risa wrote: >> >> Hi Bryan >> >> Are

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

2015-09-09 Thread Enrico Risa
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 |

Re: [orientdb] Re: Geo spatial query takes time on huge EDGE set

2015-09-02 Thread Enrico Risa
Hi Ajay if you se the tips "Query 'SELECT out.@rid FROM hasInventory WHERE in.sku = '8907103076739' AND quantity > 0' fetched more than 5 records: to speed up the execution, create an index or change the query to use an existent index" this query is executing full scan on the class

Re: [orientdb] Re: Roadmap for Lucene expansion, maybe?

2015-09-01 Thread Enrico Risa
Hi Scott The roadmap of OrientDB 2.2 is written here http://orientdb.com/docs/2.1/Roadmap.html#release-22. About Lucene I can tell you that we are rewriting the spatial module, that will be more advanced: Some of the features are -Indexing not only points (Polygon,Line..etc). -New Spatial

Re: [orientdb] New User Problems with Studio

2015-08-30 Thread Enrico Risa
Hi Aaron which user do you use to login in studio? 2015-08-30 15:57 GMT+02:00 Aaron Hunter aaron.hunt...@gmail.com: Hello, Just started to test OrientDB as a way to model our IT assets. I think its features make it a perfect fit for this task. I'm having issues with Studio, however, that

Re: [orientdb] New User Problems with Studio

2015-08-30 Thread Enrico Risa
noticed too that the list of properties in the Settings|Display dropdown are grayed out (though I can still select them). Could that have something to do with it? Thanks On Sunday, August 30, 2015 at 1:41:37 PM UTC-4, Enrico Risa wrote: Hi Aaron which user do you use to login in studio

Re: [orientdb] Querying field containing a RID.

2015-08-22 Thread Enrico Risa
Hi Chris if you look at select * from Song you can see that the field is colled PubisherId and not PublisherId so your query is correct that returns 0 records 2015-08-22 12:05 GMT+02:00 Chris Waldron christy.wald...@gmail.com: If you take a look at the attached image you'll see a class

Re: [orientdb] Modification to the Lucene plugin and upgrade to Lucene 5.x

2015-08-21 Thread Enrico Risa
Hi Stefan Great Contribution, i can help you with details of OrientDB. You can contact me at e.r...@orientdb.com Enrico 2015-08-21 8:35 GMT+02:00 ste...@activitystream.com: Hi, We have modified the Lucene plugin slightly to allow for *document* based indexing and will share that work as

Re: [orientdb] Lucene full text indexes cleared after orientdb service restart after upgrade to 2.1.0

2015-08-17 Thread Enrico Risa
: sudo service orientdb stop/start 6) go to console, connect, type info, see number of records in lucene fulltext indexes: all is 0 other indexes (usual unique/not_unique) remain consistent after restart. понедельник, 17 августа 2015 г., 12:13:21 UTC+3 пользователь Enrico Risa написал: Hi

Re: [orientdb] Lucene full text indexes cleared after orientdb service restart after upgrade to 2.1.0

2015-08-17 Thread Enrico Risa
Kovalchuk alberta...@gmail.com: Hi Enrico, there are no errors, only INFO FINE entries. I tried with latest 2.1.0-SNAPSHOT with same result. Attachment - log.zip file. воскресенье, 16 августа 2015 г., 21:53:03 UTC+3 пользователь Enrico Risa написал: Hi Albert do you have some error in log file? Il

Re: [orientdb] Lucene full text indexes cleared after orientdb service restart after upgrade to 2.1.0

2015-08-16 Thread Enrico Risa
Hi Albert do you have some error in log file? Il 16/ago/2015 20:43, Albert Kovalchuk alberta...@gmail.com ha scritto: Hello, In 2.0.9 I have created database via Java script: OrientVertexType file = graph.createVertexType(File); file.createProperty(name, OType.STRING);

Re: [orientdb] Changing cluster name

2015-08-11 Thread Enrico Risa
Hi Pradeep you can change the group name in the file hazelcast.xml in the config directory. Enrico 2015-08-10 22:52 GMT+02:00 Pradeep B K pradeepb...@gmail.com: Hi All, I am unable to join two nodes into a cluster because of different cluster name (1st node is orientDB and 2nd is

Re: [orientdb] Index is not being updated after insert

2015-08-10 Thread Enrico Risa
Hi Ran which version of OrientDB? 2015-08-10 11:19 GMT+02:00 Ran Mizrachi mizrachi...@gmail.com: Hi there, I see that my index is not being updated after insert operations. The index is a unique hash index and I'm creating it using the following command: CREATE INDEX contactId on

Re: [orientdb] Re: Index is not being updated after insert

2015-08-10 Thread Enrico Risa
Do you have some code/step to reproduce the issue? 2015-08-10 11:23 GMT+02:00 Ran Mizrachi mizrachi...@gmail.com: I'm using the latest version 2.0.13 On Monday, August 10, 2015 at 12:19:51 PM UTC+3, Ran Mizrachi wrote: Hi there, I see that my index is not being updated after insert

Re: [orientdb] Re: ClassCastException while searching using Lucene (#4257) - still exists in rc6

2015-08-10 Thread Enrico Risa
Hi i've checked it see here https://github.com/orientechnologies/orientdb/issues/4257 2015-08-10 11:26 GMT+02:00 valeri.anto...@gmail.com: OK, it exists in 2.1.0 GA. I posted simple code to reproduce, have you just fast-checked it? I tried to evaluate OrientDB (2.0 2.1) several times, and

Re: [orientdb] Re: ClassCastException while searching using Lucene (#4257) - still exists in rc6

2015-08-10 Thread Enrico Risa
:44:57 PM UTC+3, Enrico Risa wrote: Hi i've checked it see here https://github.com/orientechnologies/orientdb/issues/4257 2015-08-10 11:26 GMT+02:00 valeri@gmail.com: OK, it exists in 2.1.0 GA. I posted simple code to reproduce, have you just fast-checked it? I tried to evaluate

[orientdb] Re: Possible Lucene bug + undocumented facet functionality

2015-08-10 Thread Enrico Risa
Hi Stefan yes open an issue about using the 2 indexes on the same field. Il giorno sabato 8 agosto 2015 13:55:30 UTC+2, ste...@activitystream.com ha scritto: Hi again, I think, after looking at this for a while, that the index select by the query planner is the unique index created for

Re: [orientdb] Queries in functions block Orient thread?

2015-06-30 Thread Enrico Risa
Hi Joris can you elaborate more? what do you mean by your orientdb thread? OrientDb is multithread and can accept more requests in parallel. 2015-06-30 17:10 GMT+02:00 Joris de Geringel j.de.gerin...@gmail.com: Hi, I was wondering, I wrote a function in Studio that does a couple of

Re: [orientdb] Re: Token system and Studio

2015-06-25 Thread Enrico Risa
Scott just downloaded the 2.1-rc4 and activeted the token. Studio works just fine. Can you tell me how to replicate the problem? 2015-06-25 15:32 GMT+02:00 scott molinari scottamolin...@googlemail.com: Another polite bump. Scott -- --- You received this message because you are

Re: [orientdb] Re: Token system and Studio

2015-06-25 Thread Enrico Risa
I set enable true in TokenHandler 2015-06-25 16:50 GMT+02:00 scott molinari scottamolin...@googlemail.com: Just to be sure I am doing things right. All I need to do is change the enabled parameter and (re)start the server? handler class=

Re: [orientdb] Re: Token system and Studio

2015-06-24 Thread Enrico Risa
Hi scott what version of OrientDB? i do not experience this problem. Do you get any error ? 2015-06-24 8:46 GMT+02:00 scott molinari scottamolin...@googlemail.com: Another polite bump. This is also in regards to this issue with the PHP driver. https://github.com/Ostico/PhpOrient/issues/30

Re: [orientdb] Is there any one who is using Jersey and OrientDb?

2015-06-22 Thread Enrico Risa
Then you don't want to close it manually? 2015-06-22 18:46 GMT+02:00 W. Craig Trader craig.tra...@gmail.com: Chaitanya ... We have a custom OrientGraphDatabase object that we inject with Spring. The OrientGraphDatabase owns the OrientGraphFactory and returns transactional or

Re: [orientdb] Is there any one who is using Jersey and OrientDb?

2015-06-22 Thread Enrico Risa
I'm not really familiar with Jersey + Grizzly, but i guess you can write a custom Component that you inject in your service and you can use to get the database connection from the connection pool. but you have to close it manually. If you want to automatically close i think you should implement an

Re: [orientdb] Help optimize a query and/or graph design

2015-06-10 Thread Enrico Risa
Hi Khaled which version of OrientDB are you using? 2015-06-10 14:29 GMT+02:00 Khaled Bakhit k...@khaled-bakhit.com: Hello, I need help optimizing a query or maybe even update the graph structure. I have the following relation : User ( userid, country ) - - - - - Likes - - - - Movie (

Re: [orientdb] [2.1rc3] problem with INSERT INTO ... FROM ( SELECT ... )

2015-06-09 Thread Enrico Risa
hi kris try INSERT INTO X FROM SELECT FROM OUser 2015-06-09 10:42 GMT+02:00 kris mnt mnt.k...@gmail.com: Hi I'm getting Cannot find a command executor for the command request: sql.( SELECT FROM OUser ) trying to copy records to other class with commands below. CREATE CLASS X INSERT

Re: [orientdb] Re: Get vertex data of two classes with something similar to SQL join

2015-06-05 Thread Enrico Risa
Hi Kapli you can expand edges and then project on in/out select out.name, in.name from ( select expand(inE('worksAt')) from Department where ID_dept= 'dep1') Enrico 2015-06-05 9:25 GMT+02:00 Kapil Ranade kapilrana...@gmail.com: Hi Giulia, Thanks for replying. The query you suggested

Re: [orientdb] How do I run multiple queries in Studio?

2015-06-02 Thread Enrico Risa
Which version of OrientDB? 2015-06-01 21:04 GMT+02:00 isobretatel valery_tydy...@archibus.com: I have many CREATE queries. How do I run multiple queries in Studio? -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this

Re: [orientdb] Re: Apache reverseproxy to Studio

2015-05-24 Thread Enrico Risa
Hi Edo studio is a dynamic plugin and is placed under the plugins folder of OrientDB distribution 2015-05-24 16:26 GMT+02:00 Edo Ardo gygabyte...@gmail.com: Thanks for your answer, navigating to 127.0.0.1:80/foo/studio/index.html

Re: [orientdb] Re: Apache reverseproxy to Studio

2015-05-24 Thread Enrico Risa
and server is online. So it just seems a matter of configuration. How to tell Studio where to find the OrientDb-server? Thanks again! Il giorno domenica 24 maggio 2015 16:56:40 UTC+2, Enrico Risa ha scritto: Hi Edo studio is a dynamic plugin and is placed under the plugins folder of OrientDB

Re: [orientdb] ignore accent in lucen search and lucene index

2015-05-20 Thread Enrico Risa
Hi Karim i think you have to checkout the lucene documentation for that 2015-05-20 16:29 GMT+02:00 Karim Naghmouchi karim.naghmou...@hospimedia.fr : hi, I'm using odb with lucene index and i want to ignore accents for search. there is a specific anayser to use like this way : CREATE INDEX

Re: [orientdb] Query the names of all classes

2015-05-11 Thread Enrico Risa
Hi Kun try this select expand(classes) from metadata:schema 2015-05-11 18:54 GMT+02:00 Kun Liu liukunofc...@gmail.com: Dear all, Do you know how to write a query to get the names of all classes in a database? I know that in Console, we can just use Classes to list the information of all

Re: [orientdb] getting an error while starting workbench

2015-05-08 Thread Enrico Risa
Hi Mahesh Can you send the entire startup stacktrace? 2015-05-08 15:13 GMT+02:00 Mahesh Wabale maheshd7...@gmail.com: Hello everyone , I am using orientdb 2.0.3 entierprise edition and 2.0.3 orientdb workbench , i have got an error msg while starting an orinetdb workbench as

Re: [orientdb] Re: Studio does not work with embedded orientdb on Tomcat

2015-05-07 Thread Enrico Risa
It is not a bug. This is needed for development with grunt. i've forked your project moving all files in studio folder. Works for me https://github.com/maggiolo00/orientDBstudio On http://localhost:2480/studio/index.html#/ 2015-05-07 9:47 GMT+02:00 Dmitrii Rogozin dmit...@vaadin.com: So

Re: [orientdb] Re: Studio does not work with embedded orientdb on Tomcat

2015-05-06 Thread Enrico Risa
I found also this https://github.com/webjars/orientdb-studio but i didn't try it 2015-05-06 12:06 GMT+02:00 Enrico Risa enrico.r...@gmail.com: hi Dimitri i think you can solve it if you declare the $ORIENTDB_HOME in your code, so the server will load the studio plugin from the plugins

Re: [orientdb] Re: Studio does not work with embedded orientdb on Tomcat

2015-05-06 Thread Enrico Risa
hi Dimitri i think you can solve it if you declare the $ORIENTDB_HOME in your code, so the server will load the studio plugin from the plugins folder under the ODB dist. Otherwise you can use the orientdb.www.path in the xml file but you have to unpack the Studio zip under the www/studio folder

Re: [orientdb] Re: Studio does not work with embedded orientdb on Tomcat

2015-05-06 Thread Enrico Risa
to login or create new DB, exactly what Dave's 2nd post describes. Command not found: GET.api/listDatabases [ONetworkProtocolHttpDb] On Wednesday, May 6, 2015 at 1:06:48 PM UTC+3, Enrico Risa wrote: hi Dimitri i think you can solve it if you declare the $ORIENTDB_HOME in your code, so

Re: [orientdb] Re: Studio does not work with embedded orientdb on Tomcat

2015-05-06 Thread Enrico Risa
! On Wednesday, May 6, 2015 at 2:04:33 PM UTC+3, Enrico Risa wrote: Can you help me to set up a test Environment so i can help you. 2015-05-06 12:56 GMT+02:00 Dmitrii Rogozin dmi...@vaadin.com: Hi,Enrico, I have specified orientdb.www.path and extracted the zip Studio archieve there. I can

Re: [orientdb] Re: Studio does not work with embedded orientdb on Tomcat

2015-05-06 Thread Enrico Risa
Dimitrii for the test project to run studio just create a studio folder under www and copy all the content there. then you can access studio with http://localhost:1450/studio/index.html#/ 2015-05-06 15:46 GMT+02:00 Dmitrii Rogozin dmit...@vaadin.com: I've made a mistake with wrong db.config

Re: [orientdb] Exception on: select from test where name in ('test', 'test2')

2015-05-05 Thread Enrico Risa
I think the right syntax is select from test where name in ['test', 'test2'] Cheers 2015-05-05 17:59 GMT+02:00 Ziink A ziinkad...@gmail.com: works: select from test where name in ('test') raises exception: select from test where name in ('test', 'test2')

Re: [orientdb] creating lucene index, no keys found

2015-04-21 Thread Enrico Risa
If you do select count(*) from index:Personid ? 2015-04-21 23:20 GMT+02:00 sck2015 sonukhullar@gmail.com: Hi all, has anyone seen this behavior before, I am creating a lucene index and I don't see a match even though the index appears to have been successfully created (I am using

Re: [orientdb] Lucene Index Query Behavior Change

2015-04-14 Thread Enrico Risa
On Thursday, June 26, 2014 at 11:10:52 AM UTC-4, Enrico Risa wrote: Hi Brian, yes it is not intendend. Lucene index shouldn't be used with = operator. I will fix this preventing usage of Lucene index in exact match so it will works as expected. Enrico 2014-06-26 16:26 GMT+02:00 Brian

Re: [orientdb] Help with lucene query spatial

2015-04-06 Thread Enrico Risa
Hi Renzo i think the first query is not using the index, that is why is not working. Can you post the explain of that query? 2015-04-06 22:22 GMT+02:00 Renzo Ludeña mobius.dae...@gmail.com:

Re: [orientdb] Re: Help with lucene query spatial

2015-04-06 Thread Enrico Risa
Hi Renzo as you can see in the explain the indexes are not used. So the results set is empty. Indexes are used only when the target of a select is a class. in your case it is a subquery and the engine works with the results set of the nested query 2015-04-07 6:38 GMT+02:00 Renzo Ludeña

Re: [orientdb] Query from an arrray

2015-04-03 Thread Enrico Risa
Try this one select value.number from ( select expand(phoneNumbers) from contact WHERE firstName=John AND lastName=Smith ) where value.type = 'office' 2015-04-03 17:14 GMT+02:00 Tailai Wen wentl0...@gmail.com: I'm new to OrientDB and confused about the query from array in OrientDB. Say I

Re: [orientdb] Re: Question on querying lucene geospatial index by traversing graph

2015-04-01 Thread Enrico Risa
Hi Tom can you paste here the explain of this query? select from ( select expand(out('IN_REGION').out('IN_CITY')[category=1]) from #32:3) where [lat, lon, $spatial] NEAR [44.9060941, 12.0265446, {maxDistance:15}] 2015-04-01 20:38 GMT+02:00 Tom tomislav.milko...@gmail.com: Hi, I

Re: [orientdb] Re: Is using ElasticSearch with OrientDB possible?

2015-03-19 Thread Enrico Risa
Hi Guys, i'm the maintainer of Lucene Plugin, for the plugin i implemented a custom index engine. You can see some documentation here. http://www.orientechnologies.com/docs/2.0/orientdb.wiki/Custom-Index-Engine.html The integration should not be too hard. Once implemented You could create an

Re: [orientdb] Re: Pass parameters in REST command?

2015-03-19 Thread Enrico Risa
Hi Rasmus i think there is not such way to pass parameters via Rest. Query/Command api works with get where query is in the url or post where query is in the body. 2015-03-19 16:47 GMT+01:00 Rasmus Eneman pie.or@gmail.com: No one? Is there really no way to pass parameters via REST? As

Re: [orientdb] is lucene full text index possible on a ListString

2015-02-17 Thread Enrico Risa
Hi Aris https://github.com/orientechnologies/orientdb-lucene/issues/33 is not yet supported 2015-02-17 16:53 GMT+01:00 Aris Alexis snowboard...@gmail.com: title says it all. graph database: create index City.name_description on City (name,description) FULLTEXT ENGINE LUCENE is this

Re: [orientdb] Is the Studio working ?

2015-02-17 Thread Enrico Risa
Can you try the branch develop? 2015-02-17 11:09 GMT+01:00 Newbee to OrientDB sime...@gmail.com: Hi Guys, After running git clone https://github.com/orientechnologies/orientdb-studio.git sudo npm install -g yo bower compass npm install bower install At the end of bower install I

Re: [orientdb] Re: KeywordAnalyzer, no results

2015-02-10 Thread Enrico Risa
Hi Erick can you post the text that you are indexing? so i can double check? thanks 2015-02-11 3:10 GMT+01:00 Erik Peterson coach3p...@gmail.com: I've tested on 2.0.2 now and still no results for KeywordAnalyzer. Other index schemes return results though not adequate matches compared to what

Re: [orientdb] How to add Lucene ArabicAnalyzer

2015-02-08 Thread Enrico Risa
Hi Noorul should be available in the lucene jar http://lucene.apache.org/core/4_6_0/analyzers-common/org/apache/lucene/analysis/ar/ArabicAnalyzer.html You can change it using the Metadata Json when creating index See here

Re: [orientdb] Re: Lucene Index Error Relate to Database Close command.

2015-01-14 Thread Enrico Risa
: Great! Thanks. On Tuesday, January 13, 2015 at 3:06:57 PM UTC-8, Enrico Risa wrote: Hi Jing tomorrow i will roll a release with some backports from 2.0, so you can try if resolve this issue. I will send you the link 2015-01-14 0:03 GMT+01:00 Jing Chen jingj...@gmail.com: Hi Enrico

Re: [orientdb] Re: Lucene Index Error Relate to Database Close command.

2015-01-13 Thread Enrico Risa
Hi Jing i see this error: Caused by: org.apache.lucene.queryparser.classic.ParseException: Cannot parse '*hoxd3': '*' or '?' not allowed as first character in WildcardQuery is not a valid syntax syntax But after this error you got targetGen=14871 right? We have done a ton of fixes on lucene

Re: [orientdb] Issues with orientdb-2.0-rc1 lucene plugin, embedded in Play Framework

2015-01-12 Thread Enrico Risa
Can you post your build.sbt? where is located the plugin? 2015-01-12 17:55 GMT+01:00 Bertrand Quenin bertrand.que...@gmail.com: Hi, I'm having trouble in play framework when trying to use the Lucene plugin. Here is what my Global.scala look like: import

Re: [orientdb] jruby-complete dependency in Orientdb-lucene

2015-01-10 Thread Enrico Risa
Sorry my bad i'm removing it 2015-01-10 18:08 GMT+01:00 ste...@activitystream.com: Hi, Can somone please tell me why this: dependency groupIdorg.jruby/groupId artifactIdjruby-complete/artifactId version1.7.15/version /dependency is a

Re: [orientdb] jruby-complete dependency in Orientdb-lucene

2015-01-10 Thread Enrico Risa
Done 2015-01-10 18:13 GMT+01:00 Enrico Risa enrico.r...@gmail.com: Sorry my bad i'm removing it 2015-01-10 18:08 GMT+01:00 ste...@activitystream.com: Hi, Can somone please tell me why this: dependency groupIdorg.jruby/groupId artifactIdjruby-complete

Re: [orientdb] Re: Lucene Index Error Relate to Database Close command.

2015-01-09 Thread Enrico Risa
Hi Jing I see that seems that somehow the index was closed ad then start to give the second error. i'm trying to replicate it any hint on how can replicate it? 2015-01-09 19:09 GMT+01:00 Jing Chen jingjing...@gmail.com: Hi Enrico, Could you take a look of this problem? What could be the

Re: [orientdb] Memory footprint of Orient-Lucene index

2015-01-08 Thread Enrico Risa
Hi Jing from what i see in the memory profile, seems nothings is related to Lucene i will do so further inspection Have you tried to disable the lucene index? Do you still have the OOM exception? 2015-01-06 18:17 GMT+01:00 Jing Chen jingjing...@gmail.com: Hi Enrico, I have sent you some

  1   2   3   >