The TSV format is the lossless form of you want that style of output.
> I am testing a very simple case with a ResultSet of just 4 rows.
> Using Jena 2.11.0
>
> Any thoughts?
Upgrade? 2.11 is quite old.
Andy
On 08/09/16 14:42, Rob Vesse wrote:
The CSV format is explicitly defined to be a lossy format so some information
can and will be lost when serialising to CSV. Specifically the datatypes and
language tags for literals and literals/URIs may not be distinguishable due to
their encoding.
From the spec
(http://www.w3.org/TR/2013/REC-sparql11-results-csv-tsv-20130321/#intro):
The SPARQL Results CSV Results Format is a lossy encoding of a table of results. It does
not encode all the details of each RDF term in the results but instead just gives a
string without indicating the type of the term (IRI, Literal, Literal with datatype,
Literal with language, or blank node). This makes it simple to consume data, such as text
and numbers, in applications without needing to understand the details of RDF. In some
applications, guesses as to which elements are hyperlinks are made pragmatically, for
example, guessing that strings starting "http://"; are links.
Rob
On 08/09/2016 14:04, "Nikolaos Beredimas" <[email protected]> wrote:
I have a method that does a SPARQL select query and returns results in XML,
JSON and CSV using
outputAsCSV
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSetFormatter.html#outputAsCSV-java.io.OutputStream-org.apache.jena.query.ResultSet->
(OutputStream
<http://docs.oracle.com/javase/7/docs/api/java/io/OutputStream.html?is-external=true>
outStream, ResultSet
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSet.html>
resultSet)
outputAsJSON
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSetFormatter.html#outputAsJSON-java.io.OutputStream-org.apache.jena.query.ResultSet->
(OutputStream
<http://docs.oracle.com/javase/7/docs/api/java/io/OutputStream.html?is-external=true>
outStream, ResultSet
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSet.html>
resultSet)
outputAsXML
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSetFormatter.html#outputAsXML-java.io.OutputStream-org.apache.jena.query.ResultSet->
(OutputStream
<http://docs.oracle.com/javase/7/docs/api/java/io/OutputStream.html?is-external=true>
outStream, ResultSet
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSet.html>
qresults)
When trying to unit test it I have a problem with the CSV case.
I have tried
ResultSetCompare
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/sparql/resultset/ResultSetCompare.html#ResultSetCompare-->
.equalsByTerm
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/sparql/resultset/ResultSetCompare.html#equalsByTerm-org.apache.jena.query.ResultSet-org.apache.jena.query.ResultSet->
(ResultSet
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSet.html>
rs1, ResultSet
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSet.html>
rs2)
ResultSetCompare
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/sparql/resultset/ResultSetCompare.html#ResultSetCompare-->
.equalsByValue
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/sparql/resultset/ResultSetCompare.html#equalsByValue-org.apache.jena.query.ResultSet-org.apache.jena.query.ResultSet->
(ResultSet
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSet.html>
rs1, ResultSet
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSet.html>
rs2)
ResultSetCompare
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/sparql/resultset/ResultSetCompare.html#ResultSetCompare-->
.isomorphic
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/sparql/resultset/ResultSetCompare.html#isomorphic-org.apache.jena.query.ResultSet-org.apache.jena.query.ResultSet->
(ResultSet
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSet.html>
rs1, ResultSet
<https://jena.apache.org/documentation/javadoc/arq/org/apache/jena/query/ResultSet.html>
rs2)
and they all fail to return true.
Compared ResultSet objects are converted to ResultSetRewindable before
comparing.
JSON and XML cases work as expected (return true), but CSV fails.
I am testing a very simple case with a ResultSet of just 4 rows.
Using Jena 2.11.0
Any thoughts?
Nikos.
