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 fast approaches to sort data

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 : > 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 from JAVA .Index type FULLTEXT is not supported by the engine

2017-10-05 Thread Enrico Risa
Hi Maxim you should add orientdb-lucene in your pom.xml if you use maven as dependency. 2017-10-05 15:23 GMT+02:00 Maxim Nikolaev : > I success connect using Console.sh and plocal mode, but when I launch > jar I see this error : > > > Oct 05, 2017 4:12:43 PM com.orientechnologies.common.log.OL

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

2017-10-04 Thread Enrico Risa
, I would never expect the result to be for it > to "hang" (that's why I have both .error and .catch in my example--I don't > think both should be necessary, but neither were working). How should it > work? > > > On Wednesday, October 4, 2017 at 3:17:23

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 : > Hi Eric > > let me check on this > > 2017-10-03 14:46 GMT+02:00 Eric24 : > >> Can anyone a

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 > about--I'm asking a

Re: [orientdb] orientjs: query result Bag.all() returns empty array

2017-09-19 Thread Enrico Risa
Hi Micheal did you change the setting for the property RID_BAG_EMBEDDED_TO_SBTREEBONSAI_THRESHOLD to -1 ? If not do you have a script to reproduce it? I tried this and worked fine https://gist.github.com/maggiolo00/cda5589a1b63403aaf107770a26e9d9f Thanks 2017-09-19 9:56 GMT+02:00 : >

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 not yet functional. > h

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, > > Thank you for your quick resp

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 *geospatial position* I > want to

Re: [orientdb] Orientdb query geospatial bad result

2017-06-14 Thread Enrico Risa
|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't see on my TabzIndex &g

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 > > create property TabzInde

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 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 Enrico

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: "102.124.29.128", > port: 2424,

Re: [orientdb] Facet Creation Issue

2016-08-06 Thread Enrico Risa
t; On Aug 6, 2016, at 11:01 PM, Enrico Risa 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 : > >> Hi Ruitu >> >> That is why facets are not supported. >> That was an exper

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 : > 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

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
ot 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 wrote: > >> Hi Tore >> >> the docs is not incorrect. >> The Spatial Module uses the spatial refe

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 http://

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 out('E').out('E').in('E').name contains '" + >

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 product with node.js application

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' : 5000}]

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 < orient-database@

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: > https://www.digitalocean.com/community/tutorial

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 using the .NET API as my previous codeb

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 name > > What is the equivalent in t

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

2015-10-12 Thread Enrico Risa
> "result": [ > { > "@type": "d", > "@version": 0, > "documentReads": 16, > "current": "#17:15", > "documentAnalyzedCompatibleClass": 16, >

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 class named Word and prope

Re: [orientdb] Persisting Graph Editor view

2015-10-08 Thread Enrico Risa
+02:00 Dennis O : > 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? >> >> root is a Server user, meanwh

Re: [orientdb] Persisting Graph Editor view

2015-10-08 Thread Enrico Risa
oot. > > > > 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 Google Groups > "OrientD

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 frustrating and I waste a lot > of

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 I've edited. > > I'd like the prope

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 : > 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 wrote: > >>

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

2015-10-06 Thread Enrico Risa
E [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 Pereira : >> >

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

2015-10-06 Thread Enrico Risa
hey 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 wrote: > >> Can you post the schema also? >> >> Did Supert

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

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

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, like so : > > create

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 = txGraph.getVertices("@rid", "

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 version 2.1.0 and it works I

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 they

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 you very much for your

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

2015-09-17 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 > connection when it is

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

2015-09-14 Thread Enrico Risa
es = 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 you inserting

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: ClassCastException while searching using Lucene (#4257) - still exists in rc6

2015-09-14 Thread Enrico Risa
> > IMHO it is meaningless to add functionality to the product, if it is just > broken > > > > On Monday, August 10, 2015 at 1:18:29 PM UTC+3, Enrico Risa wrote: >> >> This is not OrientDB problem, but the integration with lucene >> >> We have an open issu

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

2015-09-08 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 | Doe | > John | Smith

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 has_Inven

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

2015-09-02 Thread Enrico Risa
Hi Ajay can you post the explain of this query? 2015-09-02 10:54 GMT+02:00 Ajay Shenoy : > I have created a database with two vertices in it. *Stores*, *Products*. > Stores have a *GeoSpatial Index*. There is an Edge '*hasInventory*' from > store to products which holds quantity for each Product

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 Oper

Re: [orientdb] New User Problems with Studio

2015-08-30 Thread Enrico Risa
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 Aa

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 : > 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 is making it difficu

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 : > If you take a look at the attached image you'll see a class called "Song" > that has 4

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 : > Hi, > > We have modified the Lucene plugin slightly to allow for *document* based > indexing and will share that work as soon as it has been tes

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

2015-08-17 Thread Enrico Risa
used > > Then I put orientdb-lucene-2.1.0-dist.jar into /plugins dir on server and > tried again. > Result not changed - lucene indexes fully cleared after restart. > > понедельник, 17 августа 2015 г., 13:35:01 UTC+3 пользователь Enrico Risa > написал: >> >> Hi Albert &

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

2015-08-17 Thread Enrico Risa
from console, restart service: 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 август

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

2015-08-17 Thread Enrico Risa
Kovalchuk : > 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

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" ha scritto: > Hello, > > In 2.0.9 I have created database via Java script: > > OrientVertexType file = graph.createVertexType("File"); > file.createProperty("name", OType.STRING); > file

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 : > Hi All, > > I am unable to join two nodes into a cluster because of different cluster > name (1st node is orientDB and 2nd is Workbench) > > > Log from

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

2015-08-10 Thread Enrico Risa
nday, August 10, 2015 at 12: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 : >> >>> OK, it exists in 2.1

[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 fo

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 : > 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 always was > stoppe

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 : > 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 operations. >

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 : > 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 Contact(id) UNIQ

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 : > Hi, > > I was wondering, I wrote a function in Studio that does a couple of > queries and then returns a

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 : > Just to be sure I am doing things right. All I need to do is change the > enabled parameter and (re)start the server? > > "com.orientechnologies.orient.server.token.OrientTokenHandler"> > >

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 : > Another polite bump. > > Scott > > -- > > --- > You received this message because you are subscribed to the Google Groups

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 : > Another polite bump. > > This is also in regards to this issue with the PHP driver. > > https://github.com/Ostico/PhpOrient/issues/30 > > Scott > > -- > > ---

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 : > Chaitanya ... > > We have a custom OrientGraphDatabase object that we inject with Spring. > The OrientGraphDatabase owns the OrientGraphFactory and returns > transactional or non-transactional graphs for othe

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 : > Hello, > > I need help optimizing a query or maybe even update the graph structure. > > I have the following relation : > > User ( userid, country ) - - - - - Likes - - - - > Movie ( movieid ) > > m

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 : > 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 INTO X FRO

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 : > Hi Giulia, > > Thanks for replying. > > The query you suggested returns details of emp

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 : > 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 group and stop rec

Re: [orientdb] Re: Apache reverseproxy to Studio

2015-05-24 Thread Enrico Risa
accessing http://127.0.0.1:2480/studio/index.html Studio pops > out 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

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 : > Thanks for your answer, > navigating to 127.0.0.1:80/foo/studio/index.html >

Re: [orientdb] Re: OrientDB 2.1-RC2 and Spatial Queries Don't Appear to Work

2015-05-23 Thread Enrico Risa
Hi Joseph i think it could related to the new parser.Can you fill a bug here https://github.com/orientechnologies/orientdb-lucene/issues Thanks 2015-05-23 19:03 GMT+02:00 Joseph Macaulay : > Well, getting closer. Any suggestions would be appreciated. This is >> using OrientDB-2.1-RC3. I've

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 : > 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 MyIndex ON > MyObject (Myatt

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 : > 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 classes. > > Thank

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 : > 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 : > So finally I found wha

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 : > I've made a mistake with wrong db.config position. but now

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

2015-05-06 Thread Enrico Risa
gt; > I will be glad to get any help/advice/ guess. > > Thank you! > > 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

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 y

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 : > 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 plug

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] 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 : > works: select from test where name in ('test') > raises exception: select from test where name in ('test', 'test2') > > {"errors":[{"code":500,"reason":500,"content":"com.

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 : > 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 version 2.0.7) > > > orientdb

Re: [orientdb] Lucene Index Query Behavior Change

2015-04-14 Thread Enrico Risa
t; Thanks, > Tielman > > > 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 matc

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 : > > if

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 : > > > > > > He

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 : > I'm new to OrientDB and confused about the query from array in OrientDB. > > Say I have a class

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 : > Hi, > > I have exactly the same p

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 : > No one? > > Is there really no way to pass parameters via REST? As they works in the >

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 elas

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

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 : > title says it all. > graph database: > > create index City.name_description on City (name,description) FULLTEXT ENGINE > LUCENE > > is this valid if descriptio

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 : > 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 get ask

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 : > 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 > KeywordAnalyzer

  1   2   3   >