[orientdb] Re: Performance Issue using multiple Let query

Hai, could you share all the involved schema (classes + properties + indices)? thanks Il giorno sabato 10 giugno 2017 07:12:34 UTC+2, Pugazharasan Thirumalai ha scritto: > > Ya we are using index, > Type : NOTUNIQUE > -- --- You received this message because you are subscribed to the Google

[orientdb] Re: Traverse skip and limit are not working

So, I suppose that select expand(out('store_has_package')[is_deleted = false]) from #48:1635 returns a list of package_master, right? In this case I think you can limit them like select from (traverse out('package_has_service') from (*select from (*select

[orientdb] Re: Traverse skip and limit are not working

ok, could you better explain your DB structure , or at least the part involved in this query? thank you Ivan -- --- 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

[orientdb] Re: Traverse skip and limit are not working

why are you using such an old version?! > > -- --- 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 orient-database+unsubscr...@googlegroups.com. For more

[orientdb] Re: Traverse skip and limit are not working

try select from (traverse out('package_has_service') from (select expand(out('store_has_package')[is_deleted = false]) from #48:1635)) skip 0 limit 1 Il giorno giovedì 8 giugno 2017 13:17:42 UTC+2, Pugazharasan Thirumalai ha scritto: > > Hai, > > We are using OrientDB version : 2.0.18, > >

[orientdb] Re: Without where key word check condition for < and > between parentheses

HAI, you can't use < > in square parenthesis conditions. Il giorno lunedì 5 giugno 2017 12:59:37 UTC+2, Pugazharasan Thirumalai ha scritto: > > > Hai , > > select outE('store_has_billing').inV()*[gross_value =100]* as grossValue > from #48:1635 > > If i run the above query it will execute,

[orientdb] Re: Export/Import on 2 node cluster

have you already read http://orientdb.com/docs/2.2.x/Console-Command-Export.html and http://orientdb.com/docs/2.2.x/Console-Command-Import.html ? btw you can even use the backup command (only plocal for community edition) http://orientdb.com/docs/2.2.x/Console-Command-Backup.html Il giorno

[orientdb] Re: Select next record data to current record data

you will need a javascript function (screenshots attached):

[orientdb] Re: Select next record data to current record data

so, just to clarify, you want something like this? Il giorno venerdì 26 maggio 2017 13:28:57 UTC+2, Pugazharasan Thirumalai ha

[orientdb] Re: orientdb schema question

Hello, what do you think about creating a LINK property on V4 class? create property V4.basedOn LINK Il giorno martedì 10 gennaio 2017 19:39:56 UTC+1, loadedlux ha scritto: > > Given that it is not possible to have an edge between a Vertex and an > Edge, how can I properly model the

[orientdb] Re: Can't import data in orientdb

s.orient.core.exception.OSchemaException: Cannot create >> property 'name' inside a transaction >> DB name="GratefulDeadConcerts" >> END ETL PROCESSOR > > > > Ivan Mainetti於 2017年1月3日星期二 UTC+8下午5時49分58秒寫道： >> >> does the id property actually ex

[orientdb] Re: Can't import data in orientdb

me in my server > class? or I should create the column of my index? > > ETL process has problem: >> com.orientechnologies.orient.core.exception.OSchemaException: Cannot create >> property 'id' inside a transaction > > DB name="GratefulDeadConcerts" >

[orientdb] Re: Can't import data in orientdb

this error ETL process has problem: java.lang.IllegalArgumentException: No enum constant com.orientechnologies.orient.core.metadata.schema.OType.NAME means that name isn't a valid type. you should use String "indexes": [{

[orientdb] Re: Can't import data in orientdb

how did you defined the index on Server class? Il giorno giovedì 29 dicembre 2016 11:22:10 UTC+1, Anthony Wong ha scritto: > > I would like to upload the data in OrientDB, but have errors. Here is the > json file: Try to upload the data in csv file and make the linkage with > server and

[orientdb] Re: ST_Distance_Sphere rooted search question

xpand this to > get me all the Source->Dest pairs of vertices that are within 2km of each > other without having to specify a specific vertex? > > Thanks! > > > > On Monday, December 12, 2016 at 10:43:46 PM UTC-7, Ivan Mainetti wrote: >> >> SELECT * FROM GeoGlyphWKT &

[orientdb] Re: ST_Distance_Sphere rooted search question

SELECT * FROM GeoGlyphWKT LET Target = (SELECT Location FROM GeoGlyphWKT WHERE Name="Hands") WHERE ST_Distance_Sphere(Location, $Target.Location[0]) <= 2000 Il giorno martedì 13 dicembre 2016 01:57:36 UTC+1, William ha scritto: > > I'm working on a progression where my ultimate goal is to be

[orientdb] Re: Can't select data from connected document

t. > > Is there a way to get it in a single traversal or is it just not possible? > The reason its important for us because we'll have other similar queries > that can go deeper in traversals and really need to avoid the multiple > traversals. > > > On Thursday, December 1, 2016

[orientdb] Re: Can't select data from connected document

2016 04:21:39 UTC+1, Borov ha scritto: > > I did, but it doesn't work. It pulls the entire 'account' object. > > System.out.println("acc rid = "+ d.field("account.@rid")); > System.out.println("acc rid = "+ d.field("account")); > > acc

[orientdb] Re: Good query for for edges regarding start and end vertex.

not sure if this may work for you, but you could query via sql something like select from E where out contains [, , ] and in contains [, , ] and = "something" Il giorno mercoledì 30 novembre 2016 15:19:24 UTC+1, Ray Neiheiser ha scritto: > > I have some performance problems with reading

[orientdb] Re: Can't select data from connected document

com/orientechnologies/orient/core/record/impl/ODocument.html) > > and it doesn't have .getProperty(...) method. > > Can I get the account.@rid from the SQL API and not the Graph API? > > > > On Wednesday, November 30, 2016 at 3:14:43 PM UTC-8, Ivan Mainett

[orientdb] Re: Can't select data from connected document

; What is the way to get account @rid from this field "in('Employs')[0] as > account"? I can get all fields, but not the @rid. > > > > On Monday, November 28, 2016 at 2:42:13 PM UTC-8, Ivan Mainetti wrote: >> >> Hi, >> >> in('Employs') returns a l

[orientdb] Re: Good query for for edges regarding start and end vertex.

please help me understand, you need to search edges knowing start and end vertices? Il giorno mercoledì 30 novembre 2016 15:19:24 UTC+1, Ray Neiheiser ha scritto: > > I have some performance problems with reading edges depending on their > start and end nodes. Is there a better way than

[orientdb] Re: It is possible to find a field in an array without knowing the path

could you add examples of query you tried? Il giorno mercoledì 30 novembre 2016 12:50:43 UTC+1, Academia Learning Centro de inglés y de formación ha scritto: > > I need to retrieve all Compositions that have the temperature field but do > not get their path since they are inside nested arrays

[orientdb] Re: [HELP] Order by date not working

please try with select value.uid.value as id, value.context.start_time.value as date from CompositionVersions order by date desc limit 5 Il giorno martedì 29 novembre 2016 14:18:25 UTC+1, Academia Learning Centro de inglés y de formación ha scritto: > > I have tried with this query and I

[orientdb] Re: Can't select data from connected document

Hi, in('Employs') returns a list, if you know that it can be only one document in it you can try modifying your query adding *[0]* *String sql= " select @rid.asString() as userRid, firstName, lastName, "+ " active as userActive, in('Employs')[0] as account "

[orientdb] Re: Database is closed Exception

have done > graph.shutdown();) > > > > El jueves, 24 de noviembre de 2016, 12:05:38 (UTC+1), Ivan Mainetti > escribió: >> >> could you post the exception? >> which part of the code throws it? >> >> >> Il giorno giovedì 24 novembre 2016 11:04:08

[orientdb] Re: How to get the type of class from a vertex?

chemas / tables only the records > > El lunes, 21 de noviembre de 2016, 10:52:38 (UTC+1), Ivan Mainetti > escribió: >> >> why you don't just delete and recreate the entire db? >> >> Il giorno lunedì 21 novembre 2016 10:28:55 UTC+1, Academia Learning >&g

[orientdb] Re: How to get the type of class from a vertex?

why you don't just delete and recreate the entire db? Il giorno lunedì 21 novembre 2016 10:28:55 UTC+1, Academia Learning Centro de inglés y de formación ha scritto: > > Hello, I want to empty the db and I was testing this way (I do not know if > it's the right one) > > Iterable

[orientdb] Re: Can't rebuild index in distributed mode

which version were you using before? How did you migrated the db from the old installation to this? Could you post also the server log ? Il giorno venerdì 4 novembre 2016 13:37:54 UTC+1, André Toscano ha scritto: > > I updated my system (2.2.12) and now I can't rebuild index. > > #--- >

[orientdb] Re: Native windows client to connect orient Cluster

you can alwys use Studio browsing to http://:2480/studio/index.html#/dashboard/cluster note that this is supported only in Enterprise edition. Il giorno venerdì 4 novembre 2016 12:44:07 UTC+1, Suyog Kale ha scritto: > > Hi, > > Is there any native client too to connect remote Orient DB cluster?

[orientdb] Re: If I delete vertex, does it take care of deleting all in/out edges?

yes, the delete vertex command also takes care of deleting all attached edges Il giorno venerdì 4 novembre 2016 12:13:15 UTC+1, Suyog Kale ha scritto: > > If I delete vertex, does it take care of deleting all in/out edges? > If not then what else is recommended approach? > OR is it ok to use

[orientdb] Re: How to update multiple @rid with single query?

update V set pippo="pippo" where @rid in [#9:2, #9:4, #9:9, #9:11, #9:14] Il giorno mercoledì 2 novembre 2016 12:51:30 UTC+1, Pugazharasan Thirumalai ha scritto: > > I want to update multiple @rid by single query, kind share the format and > sample query. > -- --- You received this

[orientdb] Re: Property Enums Support?

looking at the issue, it seems to be scheduled for 3.2 milestone Il giorno lunedì 24 ottobre 2016 17:42:07 UTC+2, boro...@gmail.com ha scritto: > > Thanks for the respond Alessandro, > > Can you or someone clarify if there is a plan to implement it? In the old > issue I couldn't figure out if

[orientdb] Re: custom function returns the same result

to get this work properly you need to do some mods: - in the function use the *size()* method instead of *count()* function (because *out()* returns a collection) return orient.getDatabase().query("SELECT out(hasComment).size() as countComment FROM Business WHERE @rid = " +

[orientdb] Re: Can't put more data into second level embedded map

seems like a bug to me Il giorno lunedì 10 ottobre 2016 21:38:46 UTC+2, boro...@gmail.com ha scritto: > > Hello, > > I'm sure I'm missing something, but I just can't figure it out from the > online docs. I have a Class "Account", inside it has Embedded class > "AccountSettings", which has

[orientdb] Re: Update vertex with ETL process

take a look at Teleporter http://orientdb.com/orientdb-labs/teleporter/ Il giorno sabato 1 ottobre 2016 03:58:34 UTC+2, Diego Cavalcante ha scritto: > > hello > > I would to know how i can update vertexs if it exist in database. > > I will get the datas from MySQL to Orientdb. > > Everyday i will

[orientdb] Re: Query for filter based on date of birth.

orientdb {compleanni}> select from V +-+--- # |@RID |dob +-+--- 0 |#9:9 |2016-03-29 00:00:00 1 |#9:10|2016-10-29 00:00:00 2 |#9:11|2016-11-29 00:00:00 3 |#9:12|2016-12-29 00:00:00 4 |#9:13|2016-01-29 00:00:00

Re: [orientdb] Re: How to import server side function and schema from one database to another?

I don't think there's such a feature in orientjs Il giorno giovedì 29 settembre 2016 07:09:41 UTC+2, Suyog Kale ha scritto: > > Hi Ivan, > > I am looking if there are any API using nodejs. > > Regards, > Suyog > > On Wednesday, 28 September 2016 21:39:04 UTC+5:30, Iv

[orientdb] Re: How do I connect via console to a server running on localhost only?

> Can you provide more detail? Is there a different file that I need to > edit? Is there a new element that needs to be added to the configuration > XML file? > > Thanks! > -William > > On Thursday, September 22, 2016 at 5:06:19 PM UTC-6, Ivan Mainetti wrote: >> &g

[orientdb] Re: How do I connect via console to a server running on localhost only?

Hi, in the listener configuration ip-address you need to insert the allowed source ip, for example if you want to allow only connection from your machine you need to insert your actual ip of net interface not the loopback one (127.0.0.1). Hope this is clear. Ivan Il giorno venerdì 23

[orientdb] Re: Calling a custom function from the console?

server when I try it... could that be part of the issue? > > -William > > > > On Wednesday, September 21, 2016 at 2:43:06 PM UTC-6, Ivan Mainetti wrote: >> >> Hi, >> which version of Orientdb are you using?* I'm trying on 2.2.10 and not >> getting that error.* &

[orientdb] Re: Calling a custom function from the console?

Hi, which version of Orientdb are you using? Il giorno mercoledì 21 settembre 2016 22:16:21 UTC+2, William ha scritto: > > Hi, > > I have a simple graph with date information on each node in which the > vertices are: > > id,date > A,2014-01-02 > B,2015-01-02 > C,2016-01-02 >

[orientdb] Re: Import Schema and Functions

the default > -preserveClusterIDs=false > > Is this an issue? > > Thanks, > Manmay > > On Wednesday, September 14, 2016 at 8:33:09 PM UTC+5:30, Ivan Mainetti > wrote: >> >> Are you performing the IMPORT in distributed mode? please retry in sin

[orientdb] Re: Import Schema and Functions

Are you performing the IMPORT in distributed mode? please retry in single instance mode Il giorno mercoledì 14 settembre 2016 16:48:54 UTC+2, Manmay Kudale ha scritto: > > Hello, > > I have a dev environment with OrientDB setup. > I have exported the database from command line using the below

[orientdb] Re: Fastest way to check if a RID is from a Vertex or an Edge

Hi, use this select from where @this instanceof 'V' --> to verify wheter it's a Vertex select from where @this instanceof 'E' --> to verify wheter it's an Edge Il giorno martedì 13 settembre 2016 15:06:35 UTC+2, André Toscano ha scritto: > > Hi guys, since now I was just watching the

[orientdb] Re: Feature or Mistake: quoted classname breaks the db

Hi, try with backtick: drop class `'stunde'` I've tried it on 2.2.7 an it works. Il giorno lunedì 22 agosto 2016 18:10:57 UTC+2, hartmut bischoff ha scritto: > > Due to some mishandling of strings, my application generated a class > 'stunde' (with quotes). > Although the class is created

[orientdb] Re: How to sync OrientDB data in Elastic for searching purpose?

http://orientdb.com/docs/last/Hook.html Il giorno venerdì 12 agosto 2016 06:11:27 UTC+2, Suyog Kale ha scritto: > > Hello, > > I want sync OrientDb data in ElasticSearch DB, does OrientDB support any > triggers on data Insert,update,delete ? if yes please share me reference > link. In case of

[orientdb] Re: Is it possible to create a class extending an existing class via the HTTP REST API?

Yes, you can POST against http://:2480/command//sql with the command inside the body eg create class test1 extends V Il giorno lunedì 8 agosto 2016 05:04:51 UTC+2, Mike Duffey ha scritto: > > Is it possible to create a class extending an existing class via the HTTP > REST API? > -- --- You

[orientdb] Re: batch-insert-in-orientd

Hi, I've answered you on SO Ivan Il giorno lunedì 8 agosto 2016 07:59:16 UTC+2, Krishna Kant ha scritto: > > I have posted my question at : > http://stackoverflow.com/questions/38821904/batch-insert-in-orientdb > Just wondering if I can get some advice on same from this group. > -- --- You

[orientdb] Re: CMS

english, please Il giorno sabato 16 luglio 2016 16:14:53 UTC+2, Rudolf Mletschnig ha scritto: > > Hallo hier, > ich starte neu mit OrientDB und möchte ein CMS > damit bedienen. Welche sind schon darauf ausgerichtet? > BG > > -- --- You received this message because you are subscribed to the

[orientdb] Re: Disk quota exceeded

> > OrientDB auto-config DISKCACHE=0MB (heap=455MB os=4,096MB *disk=0MB*) > [orientechnologies]java.util.logging.ErrorManager: 2 > java.io.IOException: Disk quota exceeded > apparently you ran out of disk space, is it possible? Il giorno mercoledì 6 luglio 2016 16:30:13 UTC+2, Pugazharasan

[orientdb] Re: Relational model vs. Graph database model

which kind of relation drug-demo is? 1-1, 1-n, n-1, n-m? which of the 2 classes contains more vertices? Il giorno venerdì 1 luglio 2016 10:13:27 UTC+2, Fabio Rinnone ha scritto: > > Hi there, > > I'm yet a bit confused about differences beetween relational model and > graph database model. I

[orientdb] Re: Relational model vs. Graph database model

please help me understand your use case. Which result are you expecting from the query above? thx Il giorno venerdì 1 luglio 2016 10:13:27 UTC+2, Fabio Rinnone ha scritto: > > Hi there, > > I'm yet a bit confused about differences beetween relational model and > graph database model. I have

[orientdb] Re: Relational model vs. Graph database model

Hi, could you post your RDBMS schema and the graph schema? thx Il giorno venerdì 1 luglio 2016 10:13:27 UTC+2, Fabio Rinnone ha scritto: > > Hi there, > > I'm yet a bit confused about differences beetween relational model and > graph database model. I have imported into OrientDB graph a

[orientdb] Re: UPSERT PUT to a LINKMAP property

Hello, I think that the only way to do what you need is by using a function: I wrote this javascript: parameters: rid, list_name, key_name, key_value var g=orient.getGraph(); var sel=g.command("sql","select expand("+list_name+"."+key_name+") from "+ rid+" where '"+key_name+"' in

[orientdb] Re: Get Edge between two vertices

running that query it evaluates all the edges in class E, so it a normal warning that you are receiving. Il giorno domenica 15 maggio 2016 14:54:57 UTC+2, K Major ha scritto: > > Hi, > I'm simply trying to get the edge between two vertices and get a property > weight on this edge. > I tried >

[orientdb] Re: How to speed up OrderBy with Where

Hello, could you post the result of the *EXPLAIN *of those queries? Thanks. Ivan Il giorno mercoledì 11 maggio 2016 13:28:53 UTC+2, David López Pérez ha scritto: > > Hi, > > I am using OrientDB 2.1.8 on Windows 2012 server platform. I have a table > about 1.117.549 records, with indices as

[orientdb] Re: SQL UPDATE EDGE command

mply updates the edge so I would have to manage the edges myself. The > documentation suggests that update edge would do this for me? > > On Wednesday, April 20, 2016 at 4:16:43 PM UTC+1, Ivan Mainetti wrote: >> >> Hi, >> >> use this: >> >> UPDATE 50:1

[orientdb] Re: deleting ORecordBytes from the physical Orient document database

Hi, it is the normal behaviour: the file size is not supposed to be decreased, it supposed to be reused for new records. -- --- 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

Re: [orientdb] Potential bug with OSQL when combined with Java

a list from it but > that would be not really efficient. > > I was wondering if there is a way/fonction that directly gives me a list > or even hashmap containing all the columns ? > > Le mardi 19 avril 2016 17:06:44 UTC+2, Ivan Mainetti a écrit : >> >> Hi, >&

Re: [orientdb] Potential bug with OSQL when combined with Java

Hi, you mean in studio, console, java or what? Seeing your question I think you're using java, so you need a method to convert the Iterable object into a List, is it correct? Il giorno martedì 19 aprile 2016 16:32:39 UTC+2, K Major ha scritto: > > Indeed, I changed from 2.1.11 to 2.1.15 and

[orientdb] Re: oetl problems loading csv data to a document database

Hi, try this json: { "source": { "file": { "path": "/home/ivan/Scrivania/etl/comm18-04/data.csv" } }, "extractor": { "csv": {} }, "loader": { "orientdb": { "dbURL": "plocal:/home/ivan/OrientDB/db_installati/enterprise/orientdb-enterprise-2.1.15/databases/comm1804",

[orientdb] Re: Creating each record into its own cluster

http://orientdb.com/docs/last/Tutorial-Clusters.html Il giorno mercoledì 30 marzo 2016 14:56:56 UTC+2, Mihai Ocneanu ha scritto: > > Normally, each class has its own cluster. > > - Would there be an incentive for each record (each instance) of that > class to have its own cluster? I see none,