Import using cypher- what's wrong here?

Hi, I wonder why The result is wrong.
I did redo all challenges for this mission(Import using cypher) But The error message repeatedly. T^T

The verification of this Challenge has a problem that we are in the process of fixing. If your import is correct, this code should return true which we will correct in the course:

call apoc.meta.stats() yield labelCount, relTypeCount, propertyKeyCount, nodeCount, relCount
with labelCount, relTypeCount, propertyKeyCount, nodeCount, relCount
return labelCount + relTypeCount + propertyKeyCount + nodeCount + relCount = 195158 as outcome

Elaine

when I run the above query, I get 195160, and not 195158. I did it twice, is this right?

When I run your code, it returns False. Which one is right? 195160 or 195158? Please help me, I cannot complete the course. Thank you.

Hello @venkat1 and @yoga.yustiawan and Welcome to the Neo4j Community!

Did you delete all nodes and relationships at the beginning of the Challenge?

Do you have exactly 4 constraints defined?

Elaine

Thanks for the follow-up, Elaine.

This is what I get, for a total of 195160.
{'labelCount': 6, 'relTypeCount': 4, 'propertyKeyCount': 26, 'nodeCount': 28863, 'relCount': 166261}

I did it twice, for the same result. (BTW, I cheated, dropped a couple of relations to pass the test, in case you notice, I have successfully completed it.)

Hi Elaine,

I had same trouble as others. Resolved by using a new Blank Sandbox, adding these four constraints:

CREATE CONSTRAINT User_userId ON (x:User) ASSERT x.userId IS UNIQUE;
CREATE CONSTRAINT Person_tmdbId ON (x:Person) ASSERT x.tmdbId IS UNIQUE;
CREATE CONSTRAINT Movie_movieId ON (x:Movie) ASSERT x.movieId IS UNIQUE;
CREATE CONSTRAINT Genre_name ON (x:Genre) ASSERT x.name IS UNIQUE ;

And then pushed through "Run in Sandbox" (and with a second test, own copy-pasted Cypher).

PASSED :smile:

After adding the first batch (Movie) nodes, outcome cypher script should produce 29508.

Regards,
Cliff

PS. Thank you so much for GraphAcademy. Looking very much to getting Certified.

(post deleted by author)

Congratulations!

We are updating the course to show the constraints you should have in the graph before the import.

Thank you all for your feedback so we can improve the course.

Elaine

Thanks, Cliff. Did you have to drop the prev constraints? or just creating them was sufficient?