Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

NaN values can not be handled by the storage #48

Closed
MichaelRoeder opened this issue May 9, 2017 · 1 comment
Closed

NaN values can not be handled by the storage #48

MichaelRoeder opened this issue May 9, 2017 · 1 comment

Comments

@MichaelRoeder
Copy link
Contributor

Problem

The open source virtuoso version hosted on docker hub can not handle "NaN"^^xsd:double triples.

Virtuoso S0022 Error SQ200: No column NaND.

SPARQL query:
define sql:big-data-const 0 
#output-format:text/html
define sql:signal-void-variables 1 PREFIX  bench: <http://w3id.org/bench#> 
PREFIX  xsd:  <http://www.w3.org/2001/XMLSchema#>
INSERT DATA {   
    GRAPH <http://hobbit.org/graphs/PublicResults> {
        bench:Precision_Observation23_for_1494323941934 bench:precision "NaN"^^xsd:double .
    }
}

Solution

Mirko pointed out, that the issue of handling "NaN" values should be fixed in newer versions of the open source Virtuoso (see openlink/virtuoso-opensource#354 )

  1. Check whether the problem is solved in the latest version
  2. Compile the latest version, create a newer Docker image and uploading it to docker hub so that it can be used for the platform
@mjovanovik
Copy link
Contributor

I explored this problem further and did some testing, and unfortunately, the issue still exists in all latest VOS versions:

The issue linked above refers to a different problem with "NaN" values, which seems to be solved.

MichaelRoeder added a commit that referenced this issue Feb 28, 2018
Developed version 2.0.0 of the platform. Moved to Docker swarm (using Docker services instead of docker-compose) (#100, #158, makes #24 obsolete). Updated VOS version and made sure that future updates of the version can be done easily (#48). Added cluster health checks (#97). Added support for gathering statistics about the usage of resources (#98). Added the visualization of complex data as diagrams (#125). Cleaned up deployment process (#162).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants