Hi Ersin, There is no SQL statement to do this, but you can use Teleporter (included in OrientDB Studio) to do a full import from SQL to a pure graph.
About multiple classes as target in a query, you cannot do it that way, what you probably need is MATCH https://orientdb.com/docs/3.0.x/sql/SQL-Match.html Thanks Luigi 2018-03-03 19:57 GMT+01:00 Ersin Sevinc <ersinse...@gmail.com>: > Hi there, m new at orient db trying to figure out something about > relations , > In this code Line => create edge owns from (select from Person where name > = 'Matt') to (select from Car where model = 'Ferrari') > We have edge between record to record. Its fine for few records. But what > will happen if i ve millions of data ? Should i create edge from backend > for every new record? > Or can i just link the Property Fields like => create edge owns from > Person.Name to Car.model ?? > > I want to know that is there any possible way for relation database like > MSSQL , you know in ms sql , we can create PK and FK between Fields , with > that way we do not need to create relations for every new record. > > Here another question -> select car.model person.name from car, person > Where .............................. I think i can not use 2 different > class after FROM m i right ? > > 27 Mart 2014 Perşembe 17:03:33 UTC+3 tarihinde Andrey Lomakin yazdı: >> >> Hi, >> Could you try >> >> select name from Person where gender = 'M' and out('owns')[0].model = >> "Ferrari" and out('likes')[0].mov_name = "Need For Speed" >> >> >> On Thu, Mar 27, 2014 at 5:13 AM, Joel Mathew <meet...@gmail.com> wrote: >> >>> Hi group, >>> I have below schema with three classes >>> >>> orientdb {demo1}> select from Person >>> ----+-----+-----+------+--------+--------- >>> # |@RID |name |gender|out_owns|out_likes >>> ----+-----+-----+------+--------+--------- >>> 0 |#11:0|Matt |M |#12:0 |#13:0 >>> 1 |#11:1|Helen|F |#12:1 |#13:1 >>> ----+-----+-----+------+--------+--------- >>> >>> orientdb {demo1}> select from Car >>> ----+-----+-------+------- >>> # |@RID |model |in_owns >>> ----+-----+-------+------- >>> 0 |#12:0|Ferrari|#11:0 >>> 1 |#12:1|BMW |#11:1 >>> ----+-----+-------+------- >>> >>> orientdb {demo1}> select from Movie >>> ----+-----+--------------+-------- >>> # |@RID |mov_name |in_likes >>> ----+-----+--------------+-------- >>> 0 |#13:0|Need For Speed|#11:0 >>> 1 |#13:1|Matrix |#11:1 >>> ----+-----+--------------+-------- >>> >>> Person(name,gender) >>> Car(model) >>> Movie(mov_name) >>> Person > owns > Car >>> Person > likes > Movie >>> >>> I'm looking at a query which matches values across three classes across >>> the edges >>> Find Person.name where Person.gender='M' and who owns >>> Car.model='Ferrari' and who likes Movie.mov_name='Need For Speed' >>> >>> One way to achieve the same with gremlin is >>> g.V('@class','Car').has('model','Ferrari').in('owns').has('@ >>> class','Person').has('gender','M').as('x').out('likes').has( >>> '@class','Movie').has('mov_name','Need For Speed').select(["x"]) >>> I'm using OrientDB 1.7-rc2-SNAPSHOT.. >>> Please help me with some pointers towards equivalent orientdb sql. >>> >>> Thanks, >>> Mathew >>> >>> >>> -- >>> >>> --- >>> 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-databa...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Best regards, >> Andrey Lomakin. >> >> Orient Technologies >> the Company behind OrientDB >> >> -- > > --- > 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 options, visit https://groups.google.com/d/optout. > -- --- 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 options, visit https://groups.google.com/d/optout.
