CSV import issues (hashtag2720)

[vikramsubramanian]

Hello, I am trying to run the Python Colab examples (which use kuzu version 0.0.7) on my machine (which uses kuzu 0.1.0), and I have encountered problems when importing the CSV files, i.e. when running conn.execute('COPY tableName FROM "./fileName.csv" (HEADER=true)') Specifically, the problems arise in two examples: the node property prediction example ([link]( and the link prediction example ([link](

Both times the errors are due to some characters in the csv files:

• for the Node prediction example, the error is in the paper.csv file;
• for the Link prediction example, the error is in the movies.csv file. I could fix the movies.csv file, by simply replacing the name of the movie with one that does not contain special characters, while I couldn't figure out the solution to the Node prediction example.

This is what I tried and learned:

• If I downgrade kuzu version to 0.0.7 or 0.0.8, the error is somehow solved and the code runs until the end;
• If I downgrade kuzu to version 0.0.9, the CSV import works, but the code doesn't run until the end. This line fails conn.execute("MATCH (a:paper) WHERE a.id = $pid SET a.category = $pred", [("pid", paper_id), ("pred", prediction)])
• if i use version 0.1.0 I can load elements in the database as long as the rows of the csv file (including the header) are 22; versions in between

I hope this can be helpful, and we can find a solution. )

[mayil-ai[bot]]

Summary: Issues with importing CSV files in kuzu version 0.1.0 causing errors due to special characters, which are resolved by downgrading to earlier versions.

Possible Solution

Based on the provided information, the issue seems to be related to CSV import functionality and database query execution in different versions of Kùzu. The error occurs when importing CSV files with special characters and executing a particular MATCH query in version 0.0.9. Here is a solution to address the issue:

• Ensure that the CSV files paper.csv and movies.csv are properly formatted and encoded in UTF-8 to avoid issues with special characters.
• Check the release notes or change logs between Kùzu versions 0.0.7, 0.0.8, 0.0.9, and 0.1.0 to identify any changes in CSV import functionality or query execution that could cause the observed issues.
• If the CSV import command has changed in newer versions, update the import command syntax in the Python Colab examples to match the new version's requirements.
• For the failing MATCH query in version 0.0.9, verify that the query syntax is correct and compatible with the version. If there are syntax changes in the newer version, update the query accordingly.
• If the issue persists, consider reporting it to the Kùzu development team, providing the error logs, CSV file samples, and detailed steps to reproduce the issue.
• As a temporary workaround, continue using the version that works for your use case (0.0.7 or 0.0.8) until the issue is resolved in newer versions.

Note: The provided code snippets from various language APIs and documentation files do not directly address the issue at hand, so they are not included in the solution.

Code snippets to check

• tools/python_api/test/conftest.py

  This file contains code for initializing and loading CSV data into the database, which is directly related to the CSV import issue described.

• tools/python_api/src_py/init.py

  This file contains example usage of the Python API for Kuzu, including CSV data loading, which may need to be reviewed for compatibility with different versions of Kuzu.

• tools/python_api/test/test_query_result_close.py

  This file includes a test case that loads CSV data into the database, which could be relevant for understanding the CSV import issue.