search

RumbleDB / rumble

⛈️ RumbleDB 1.22.0 "Pyrenean oak" 🌳 for Apache Spark | Run queries on your large-scale, messy JSON-like data (JSON, text, CSV, Parquet, ROOT, AVRO, SVM...) | No install required (just a jar to download) | Declarative Machine Learning and more
http://rumbledb.org/
Other
213 stars 82 forks source link

File path error on Windows system #680

Open zpgeng opened 4 years ago

zpgeng commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 3 years ago

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 commented 2 years ago

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!