If I run that query with access DB I got a result back in 1 second SELECT dwhElement.dwhSysID, dwhElement.dwhStructID, dwhElement.dwhElementName, aifElement.aifElememtID, aifElement.aifSysID, aifElement.aifStructID, aifElement.aifElementName FROM (dwhElement INNER JOIN dwh2aif ON dwhElement.dwhElememtID = dwh2aif.dwhElementID) INNER JOIN aifElement ON dwh2aif.aifElementID = aifElement.aifElememtID;
Am Mittwoch, 15. April 2015 10:27:30 UTC+2 schrieb Andreas Dernbauer: > > I tried to connect to graphs by using a Bridge table > > MATCH (a:dwhElement),(b:aifElement),(c:dwh2aif) > where a.ElementID = c.dwhElementID and c.aifElementID = b.ElementID > CREATE (a)-[r:dwh_FEEDS_aif]->(b) > return r; > > *After at least one hour I got as result uknown error,* > > MATCH (a:dwhElement) > return count(a); > *returns 3842 rows* > > MATCH (a:aifElement) > return count(a); > *returns 938 rows* > > MATCH (a:dwh2aif) > return count(a); > *returns 2755 rows* > > > > > *MATCH (a:dwhElement),(b:dwh2aif)where a.ElementID = b.dwhElementIDreturn > count(a),count(b);count(a) = 2755count(b) = 2755Any Ideas ? Thank you * > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
