Hi Hugh,
I was also trying to use the bulk loader script that you pointed me to
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtCsvFileBulkLoader.
I have a table created as "CREATE TABLE rdftest (s INT, p INT, o
INT);" My sample data looks like follows (the directory where data is
kept is "/work2/dataset/virtuoso/csv") -
test.csv.gz
-------------
1:2:3
2:3:4
test.cfg
-----------
[csv]
csv-delimiter=:
csv-quote='
header=
offset=0
test.tb
----------
rdftest(s int, p int, o int)
I create table and register procedures by copy-pasting the given
commands on the "isql-v" command line interface. They get registered
without any errors. But when I try to load the data via the given
procedures, I get the following error:
SQL> csv_register('/work2/dataset/virtuoso/csv', '*.gz');
Done. -- 1 msec.
SQL> csv_loader_run();
*** Error 22023: [Virtuoso Driver][Virtuoso Server]SR022: Type for
make_array must be float, double, long or any
at line 417 of Top-Level:
csv_loader_run()
SQL>
Could you please let me know what's going wrong here? I get the same
error even if I run the exact same example given on the page by just
replacing the folder path to the CSV file.
Thanks.
Medha
On Tue, Sep 9, 2014 at 12:05 PM, Medha Atre <medha.a...@gmail.com> wrote:
> Hi Hugh,
>
> This is in reference to our previous conversation about using Virtuoso
> as a pure DB store and using SQL commands.
>
> Basically I want to upload my own raw integer valued 3-column table
> (it's RDF data parsed and converted to integer IDs, as I don't want
> Virtuoso or any system to deal with the strings or URIs/IRIs).
>
> I was following the RDF performance tuning instructions given at
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning
> for Virtuoso, and I am confused about two points -
>
> 1) What is the difference between datatype IRI_ID_8 and INTEGER?
>
> 2) If I want to use INTEGER datatype in my tables (e.g. "CREATE TABLE
> rdftest (S INTEGER, P INTEGER, O INTEGER, PRIMARY KEY (P,S,O)
> COLUMN)"), how should the ALTER INDEX command like "ALTER INDEX rdf_s
> ON rdftest PARTITION (S INT (0hexffff00));" be re-written? What does
> "S INT (0hexffff00)" do? Does it depend on the datatype of the column
> or does it only specify the blocksize of partition?
>
> Could you please clarify this to me?
>
> Thanks.
> Medha
>
>
>
> On Mon, Aug 4, 2014 at 6:45 PM, Hugh Williams <hwilli...@openlinksw.com>
> wrote:
>> Hi Medha,
>>
>> What then is the form of the SQL data you are seeking to load, as if
>> standard ANSI SQL you are seeking to load this can done using the "load"
>> command of the isql command line tool:
>>
>> http://docs.openlinksw.com/virtuoso/isql.html#isqlcommands
>>
>> or if in CVS form it can be loaded with the CVS loader:
>>
>> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtCsvFileBulkLoader
>>
>> The following white paper details the Virtuoso RDF Quad Store implementation
>> on top of its SQL engine:
>>
>> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSRDFWP
>>
>> What does make or make install report then, I assume the compilation is
>> completed with out errors and you are running make install as a user that
>> has access to the location you are seeking to install to ? Is there a
>> Virtuoso binary in ~/binsrc/virtuoso/virtuoso-t as that would confirm the
>> compilation at least completed successfully ?
>>
>>
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc. // http://www.openlinksw.com/
>> Weblog -- http://www.openlinksw.com/blogs/
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>> Twitter -- http://twitter.com/OpenLink
>> Google+ -- http://plus.google.com/100570109519069333827/
>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>> Universal Data Access, Integration, and Management Technology Providers
>>
>> On 4 Aug 2014, at 13:07, Medha Atre <medha.a...@gmail.com> wrote:
>>
>> I do NOT want to map relational data to RDF!
>>
>> I simply want to use Virtuoso opensource as _a relational DB_! But all
>> the tutorials and instruction pages have only information of handling
>> RDF data. I believe Virtuoso is a native relational DB and support for
>> RDF is added "on top of it", am I right? So I want to use the native
>> relational DB.
>>
>> E.g. I want to load a relational table with say 5 columns A, B, C, D,
>> E in Virtuoso and run SQL queries on that data directly by creating
>> indexes etc.
>>
>> No RDF conversion required!
>> --------------------------------------------
>> I have a couple more questions/problems. My next question is unrelated
>> this the previous one.
>>
>> 1. If I want to load RDF data into Virtuoso opensource, are strings
>> and URIs in the RDF database mapped first to hash or integer (or some
>> IDs), and stored in that form? If yes, then if I run a SPARQL query,
>> say "select ?s ?o where {?s ?p ?o}", can I get values of ?s and ?o in
>> the hash or integer ID forms instead of string or URI forms? (This is
>> for the sake of measuring the "raw" query evaluation speed of
>> Virtuoso, where I do not want to account for the "ID --> String"
>> conversion time.
>>
>> 2. I tried to compile and setup Virtuoso-opensource 7.1 on Ubuntu
>> 12.04 LTS. I ran "autogen.sh", and "./configure
>> --prefix=/work/tools/virtinstall
>> --program-transform-name="s/isql/isql-v", and then "make", and "make
>> install", but even after all the steps completing successfully, I have
>> an EMPTY "bin" directory under "/work/tools/virtinstall" (the "prefix"
>> install path given to the configure script).
>>
>> Why is this happening? The "autogen", "configure", and "make" do not
>> show any errors, and all the required dependencies as mentioned on
>> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSMake#Package%20Dependencies
>> are installed on my machine!
>>
>> Could you please let me know answers of these questions?
>>
>> Thanks.
>> Medha
>>
>>
>>
>> On Mon, Aug 4, 2014 at 5:46 PM, Hugh Williams <hwilli...@openlinksw.com>
>> wrote:
>>
>> Hi Medha,
>>
>> Virtuoso open source does not have the necessary Virtual Database (VDB)
>> support for mapping relational databases (transiently or persistently) to
>> RDF using Virtuoso Linked Data Views [1][2] , as this is a commercial only
>> feature [3]. The commercial product is for evaluation download from [4].
>>
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc. // http://www.openlinksw.com/
>> Weblog -- http://www.openlinksw.com/blogs/
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>> Twitter -- http://twitter.com/OpenLink
>> Google+ -- http://plus.google.com/100570109519069333827/
>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>> Universal Data Access, Integration, and Management Technology Providers
>>
>> [1] http://docs.openlinksw.com/virtuoso/rdfviewsrdbms.html
>> [2] http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSSQL2RDF
>> [3] http://virtuoso.openlinksw.com/features-comparison-matrix/
>> [4] http://virtuoso.openlinksw.com/download
>>
>> On 4 Aug 2014, at 12:20, Medha Atre <medha.a...@gmail.com> wrote:
>>
>> Hi,
>>
>> I want to use the opensource edition of Virtuoso to load relational
>> data into it, create indexes, and run SQL queries on it.
>> Can someone point me to a tutorial or instructions for it? I mostly
>> came across instructions for RDF data loading.
>>
>> Thanks in anticipation.
>>
>> Medha
>>
>> ------------------------------------------------------------------------------
>> Infragistics Professional
>> Build stunning WinForms apps today!
>> Reboot your WinForms applications with our WinForms controls.
>> Build a bridge from your legacy apps to the future.
>> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Infragistics Professional
>> Build stunning WinForms apps today!
>> Reboot your WinForms applications with our WinForms controls.
>> Build a bridge from your legacy apps to the future.
>> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>>
------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce.
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
