So, I was doing this query to find the top 5 actors who had acted in the most movies. I don't think the query is correct for what I am trying to do since the result does not seem to be right. However, when I first ran this query:
I got an error saying that it could not find "personid" for this specific vertex id. I did the following for the vertex id:
gremlin> g.V(5578792).valueMap()
==>[]
This told me that I had a vertex that did not have a personid for some reason. That was my phantom vertex. I dropped it and then the above query ran. The result of the above query is ==>[1,2,3,4,5], which I know is not right. From my SQL query using our product EsgynDB running on Apache Trafodion, I get: