Skip to content

Latest commit

 

History

History
57 lines (34 loc) · 1.46 KB

README.md

File metadata and controls

57 lines (34 loc) · 1.46 KB
Raw

Tarql: SPARQL for Tables

Tarql is a command-line tool for converting CSV files to RDF using SPARQL 1.1 syntax. It's written in Java and based on Apache ARQ.

See http://tarql.github.io/ for documentation.

Building

Get the code from GitHub: http://github.com/tarql/tarql

Tarql uses Maven. To create executable scripts for Windows and Unix in /target/appassembler/bin/tarql:

mvn package appassembler:assemble

Otherwise it's standard Maven.

HDT Fork

Note: This fork includes support to generate RDF/HDT files as output.

Building

Make sure you install the latest hdt-java 2.1-SNAPSHOT before compiling Tarql.

Usage

  1. Download geeky CSV file:

$ wget https://raw.githubusercontent.com/datasets/s-and-p-500-companies/master/data/constituents-financials.csv

  1. Write typical select all query to see what's in there in file all.sparql:
SELECT * WHERE {} LIMIT 50
  1. Run and see what is in the CSV file:

$ tarql all.sparql constituents-financials.csv

  1. Write final Tarql query into file query.sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX nas: <http://nasdaq.com/symbol/>

CONSTRUCT {
  ?uri <http://example.org/price> ?tprice .
} WHERE {
  BIND(URI(concat("http://nasdaq.com/symbol/",?Symbol)) AS ?uri)
  BIND(xsd:decimal(?Price) AS ?tprice)
}
  1. Run tarql and generate output HDT file:

$ tarql -base https://example.org/constituents-financials.csv --hdt out.hdt query.sparql constituents-financials.csv