Comments (7)
Hi,
The offline mode supports using a single model to generate RDF from
multiple table. Here is an example invocation.
mvn exec:java -Dexec.mainClass="edu.isi.karma.rdf.OfflineRdfGenerator"
-Dexec.args="--sourcetype DB --modelfilepath .ttl --outputfile
--dbtype MySQL --hostname xxx.edu --username pedro --password
szekely --portnumber 3306 --dbname mydb --tablename mytable" &> xxx.log
You must execute this command in your Web-Karma installation directory. I
think you just need to substitute the --tablename value.
BTW, next week we will release an upgrade to the RDF generation that works
almost 100 times faster and can generate about 1M triples per minute.
Thanks for using Karma
Pedro
On Fri, Oct 25, 2013 at 3:57 AM, FrenkT [email protected] wrote:
Hi, I'm currently creating an R2RML model from karma web UI, publishing it
and using it to periodically generate RDF in batch mode. My problem is that
in the R2RML contains some reference about the name of the MySQL table that
I used to generate it, but I would like to use it with tables that have
different names but still the same content.
For example, I published the model using a table named "sensors1", I would
like to use the R2RML to publish RDF of a table named "sensors2" that has
the same columns as "sensors1". Is this possible to to this? Maybe using
some regular expressions in the R2RML? Thanks—
Reply to this email directly or view it on GitHubhttps://github.com//issues/39
.
from web-karma.
I'm using that invocation, and it usually works. The problem is that in the R2RML file there is some reference to the name of the table that I used to generate it, for example in my model I can see entries like this:
km-dev:sourceName "DB1"
:
rr:tableName "DB1"
I think that this makes me get an error if I call the offline RDF generation with --tablename DB2 , even if DB2 has the same columns as DB1. This is the error:
edu.isi.karma.webserver.KarmaException: Resource not found in model for the source: DB2
from web-karma.
We will try to replicate the problem. The idea is that the command line parameter should override the rr:tableName, and looks like this is not working properly.
Can you post the full stack trace of the error so we can be sure we are replicating your error.
from web-karma.
This is the terminal message and error. The table park_replica exists and i replaced all the table reference in the R2RML with another name.
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building ISI Karma Maven Webapp 0.0.1-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] >>> exec-maven-plugin:1.2.1:java (default-cli) @ webkarma >>>
[INFO]
[INFO] <<< exec-maven-plugin:1.2.1:java (default-cli) @ webkarma <<<
[INFO]
[INFO] --- exec-maven-plugin:1.2.1:java (default-cli) @ webkarma ---
Loading the R2RML model file...done
Generating RDF...
ERROR edu.isi.karma.rdf.OfflineRdfGenerator.main() - Error occured while generating RDF!
edu.isi.karma.webserver.KarmaException: Resource not found in model for the source: park_replica
at edu.isi.karma.kr2rml.WorksheetR2RMLJenaModelParser.(WorksheetR2RMLJenaModelParser.java:107)
at edu.isi.karma.rdf.DatabaseTableRDFGenerator.generateRDFFromWorksheet(DatabaseTableRDFGenerator.java:148)
at edu.isi.karma.rdf.DatabaseTableRDFGenerator.generateRDF(DatabaseTableRDFGenerator.java:135)
at edu.isi.karma.rdf.OfflineRdfGenerator.main(OfflineRdfGenerator.java:204)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:297)
at java.lang.Thread.run(Thread.java:724)
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 11.454s
[INFO] Finished at: Sun Oct 27 12:52:48 CET 2013
[INFO] Final Memory: 20M/210M
[INFO] ------------------------------------------------------------------------
from web-karma.
Thx for the stack trace. We will take a look.
from web-karma.
Issue fixed and pushed to development branch
from web-karma.
Pushed to master.
from web-karma.
Related Issues (20)
- File upload is not working HOT 1
- Files for museum tutorial
- Unable to connect to SQLServer using instance Browsing HOT 3
- Karma window not displaying anything, trouble connecting to server HOT 1
- Interface not responding + NullPointerException after compiling from source HOT 1
- Karma does not startup without any error HOT 1
- Apply R2RML Model: "Error occured while applying history!" HOT 1
- Build Failure HOT 11
- Ontology import failed! HOT 2
- Build fails due to not resolved dependencies because of connection timeout to karam.isi.edu:80 HOT 5
- Localhost:8080-Trouble connecting to server HOT 3
- Join csv tables HOT 2
- cannot import from file
- java.base does not opens.java.util to unnamed modüle @5da94a74 HOT 2
- jetty server: karma not able to talk to cleaning service properly HOT 1
- getFileMagic() only operates on streams which support mark(int) HOT 1
- Build failure HOT 1
- Wrong Karma App version string HOT 1
- Bug introduced in v2.5.3 when running jetty or docker HOT 8
- Dependency org.apache.httpcomponents:httpclient, leading to CVE problem HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from web-karma.