Issues from LDBC SNB interactive query workload

[anuchak]

The following are some of the issues encountered while adding the LDBC SNB interactive queries to our benchmark:

• https://github.com/ldbc/ldbc_snb_interactive_impls/blob/main/cypher/queries/interactive-complex-4.cypher Causes our benchmark server's BM to go out of memory, sample run example: https://github.com/ldbc/ldbc_snb_interactive_impls/blob/main/cypher/queries/interactive-complex-4.cypher

• https://github.com/ldbc/ldbc_snb_interactive_impls/blob/main/cypher/queries/interactive-short-7.cypher Same as above, causes to BM to go OOM: https://github.com/kuzudb/kuzu/actions/runs/4080454073/jobs/7033096943#step:5:2839

• This is the short query 3 from the benchmark, it is taking more time than it should (around 45 secs). It seems to be doing a full table scan and hash (PROFILE reveals most time ~ 42 seconds taking time in this step):

// IS3. Friends of a person
/*
:param personId: 933
 */
MATCH (n:Person {id: $personId })-[r:KNOWS]-(friend)
RETURN
    friend.id AS personId,
    friend.firstName AS firstName,
    friend.lastName AS lastName,
    r.creationDate AS friendshipCreationDate
ORDER BY
    friendshipCreationDate DESC,
    toInteger(personId) ASC

[anuchak]

q39 - https://github.com/ldbc/ldbc_snb_interactive_impls/blob/main/cypher/queries/interactive-complex-8.cypher

This query also seems to be running out of memory, it had to be rewritten since the exact rel tables were not there.

MATCH (start:Person {ID: 143})<-[:comment_hasCreator|:post_hasCreator]-(:Post:Comment)<-[:replyOf_comment]-(comment:Comment)-[:comment_hasCreator]->(person:Person) RETURN person.ID AS personId, person.firstName AS personFirstName, person.lastName AS personLastName, comment.creationDate AS commentCreationDate, comment.ID AS commentId, comment.content AS commentContent ORDER BY commentCreationDate DESC, commentId ASC LIMIT 20