[BUG] SPARQL load error due to lack of escaping apostrophe ' #101
Assignees
Labels
bug
Something isn't working
Comments
|
Hi @xiaokunx, thanks for the report. Can you please provide the following info:
|
|
I launched the Jupyter Notebook from the AWS Console, Neptune UI, by clicking "Create Notebook". The notebook is hosted by a Sagemaker notebook instance with type "ml.t3.medium". I supposed the notebook is connected to the Neptune Reader and Writer endpoint on port 8182. The graph-notebook version I supposed is 2.0.9 via pip info. Here are some info I get by running bash command from the jupyter notebook, hopefully useful: I think it would be great if there is an intro on how does all those jupyter magic like %%sparql and %%seed work. There are perhaps obvious to power user by pretty cryptic to find out, i.e. how the ipython profile is loaded, and from the profile, what package or path has been imported so the jupyter could find them, how the jupyter lab extension and notebook extension are same or different, etc. Want to say thanks a lot for this package, really make the exploration and visualization easy for first time graph database user. |
|
Thanks for the info! Looks like you are on
There are two options for upgrading your
When either of the two options are done, you can run the following to verify the version that is in-use by your ipython kernel: Lastly, thanks for the feedback on docs, good to know where the gaps are! If you have anything specific in mind feel free to cut us an issue summarizing it. Otherwise, we'll take what you've highlighted above and see what we can do going forward. |
|
Thanks for the prompt response. I tried both methods suggested, but neither worked.
which produced some warnings: Now running the line magic So I restarted browser, went to the notebook again, now magic works. but loading the airpot data leads to same error. Behind the scene, I wonder how does this repo in general handel the special chars in the data file and/or queries? Stackoverflow (e.g. https://stackoverflow.com/questions/55970745/how-to-handle-apostrophe-in-sparql) suggestd some excaping methods which works in my attempt. |
|
I'll have to take some time to reproduce this on my end since upgrading didn't seem to make a difference. I'll check back in after a few days |
|
Was able to reproduce on Neptune on a fresh IAM cluster: Seems like this issue doesn't manifest itself when we are running Neptune without IAM auth. Will continue to investigate. |
|
Based on some local testing, looks like an outstanding PR will fix this issue: Once that is merged in we will revisit this |
Merged
|
Circling back to this, I created a fresh neptune cluster with our latest release and was able to successfully use our |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Describe the bug
on Jupyter notebook from the Sagemaker notebook instance launched from Neptune Console UI. On notebook
/Neptune/02-Visualization/Air-Routes-SPARQ.ipynb, section "Let's load some RDF Data". After choosing SPARQL and Airport from the drop down list and clicking the submit button, got following error:I suspect that it is the processing of "O'Hare Airport" causing the error when the data loader can't handle unescaped Apostrophe "'". The same error also occurred in the
EPL-SPARQLnotebook when loading the Football data set where "St. Mary's Park" and "St. James Park" caused same error message. After modifying the query to triple quote """St. Mary's Park", the load worked.The text was updated successfully, but these errors were encountered: