File path error on Windows system

[zpgeng]

Hi there, I am running queries locally on Windows 10. But I get stucked by

%%rumble
for $i in json-file("D:\ETHz\2020 Spring\Big Data for Engineers\confusion-2014-03-02.json")
return $i

this code chunk on Jupyter notebook. Its error code shows:

'Unexpected error. We should investigate this. Please contact us or file an issue on GitHub with your query.'

I am completely new to this query language and I was wondering how can I solve this problem? Thank you!

[zpgeng]

Update: I tried "D:\\ETHz\\confusion-2014-03-02.json", but the error code shows:

Error [err: FODC0002]LINE:1:COLUMN:10:Malformed URL: D:\ETHz\confusion-2014-03-02.json

[ghislainfourny]

We investigated this The following should be used, as paths must be valid URIs:

"file:/D:/ETHz/confusion-2014-03-02.json"

"or file:///D:/ETHz/confusion-2014-03-02.json"

I hope it helps!

[rajhub28]

Hello Ghislain, Thanks for giving us RumbleDB! I used it in my class this past semester. Related to the above issue, it appears that file paths should not contain spaces; I get an error when I use let $data := json-doc("./sbib.json") in a directory whose absolute path contains the space character, e.g. the above file is located in directory /Users/raj/Google Drive/8711/sp21/json/jsoniq-rumbledb/examples Is there a way this could be fixed? I have a work-around; simply work from another directory whose absolute path does not contain spaces. Thanks!

[ghislainfourny]

Thank you for your comment, @rajhub28! Apologies as I only see your comment now.

The space issue will be fixed in the next release.

Delighted to hear you use it in your class!