search

ldbc / ldbc_snb_interactive_v1_impls

Reference implementations for LDBC Social Network Benchmark's Interactive workload.
https://ldbcouncil.org/benchmarks/snb-interactive
Apache License 2.0
98 stars 85 forks source link

Loading data fails #1

Closed ArVr closed 7 years ago

ArVr commented 9 years ago

Hello,

I have a problem when i try to loaded the data in to Virtuoso:

*\ Error 42001: [OpenLink][Virtuoso ODBC Driver][Virtuoso Server]SR185: Undefined procedure DB.DBA.ft_set_file.at line 1 of Top-Level:ft_set_file ('comment_f', 'outputDir/comment_0_0.csv', delimiter => '|', skip_rows=>1) SQL>

Am I doing something wrong?

I have tried so far:

PS.

I am doing a Master research project at the VU Amsterdam to compare SQL with Prolog and CQL. After (literally) days of troubles shouting I finally manage to export the correct CSV files (merges foreign keys) from the Data generator. I want setup Virtuoso to so that I can test the queries that I develop. As a basis I use the SQL queries form the paper "D2.2.4 Benchmarking Complex Queries" (http://ldbcouncil.org/publications). I need some kind of environment where I can execute these queries, if someone have some kind of a SQL dump that I can use that would be great. I am also open for any suggestions.

Thanks,

Aron

ArVr commented 9 years ago

I found the fault!

I used the sudo apt-get install virtuoso-opensource to install the virtuoso for Ubuntu. For windows I used a pre-built version. After deleting the Ubuntu packed, if still got strange fault trying to build (https://github.com/openlink/virtuoso-opensource/issues/228). After a new installation of Ubuntu everything and the correct version everything works fine.