W3C home > Mailing lists > Public > public-sparql-dev@w3.org > January to March 2016

Loading SPARQL 1.1 Query Results CSV Format to Oracle

From: John Walker <john.walker@semaku.com>
Date: Fri, 15 Jan 2016 18:30:59 +0100 (CET)
To: public-sparql-dev@w3.org
Message-ID: <803343755.101702.1452879059267.JavaMail.open-xchange@oxweb02.eigbox.net>
Hi SPARQL fans,

For a project I'm currently working on we are using SPARQL to provide tabular
views of an RDF dataset.
These views need to be loaded to Oracle and we are planning to use SQL*Loader to
load SPARQL query results (in SPARQL 1.1 Query Results CSV Format) to the Oracle
DB.

However we run into problems where the RDF literals contains newline characters.

So in the CSV results we see:

foo,bar,baz
1,2,3
a,b,c
d,"some
multi
line
text",f

The control file we use is something like this:

OPTIONS ( SKIP=1 )
load data
infile myfile.csv        "STR '\r\n'"
TRUNCATE
into table my_table
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS 

However this treats each new line as a new record.

I guess this is not a SPARQL thing directly, but hopefully someone on the list
has attempted something similar and can provide some sage advice :-)

Regards,

John Walker
Principal Consultant & co-founder
Semaku B.V.
SFJ 4.009, Torenallee 20, 5617 BC Eindhoven
Mobile: +31 6 475 22030
Email: john.walker@semaku.com
Skype: jaw111

KvK: 58031405
BTW: NL852842156B01
IBAN: NL94 INGB 0008 3219 95

 
Received on Friday, 15 January 2016 17:31:26 UTC

This archive was generated by hypermail 2.3.1 : Friday, 15 January 2016 17:31:27 UTC