Re: [Virtuoso-users] Question about combining LEFT JOIN and UNION ALL

rror. On Thu, Mar 5, 2015 at 2:05 PM, Medha Atre wrote: > Hi, > > I am trying to run some SPARQL queries translated to SQL on NATIVE > Virtuoso columnstore, which involve combination of left join and UNION > statements. > > A sample SPARQL query is given below: > >

[Virtuoso-users] Question about combining LEFT JOIN and UNION ALL

Hi, I am trying to run some SPARQL queries translated to SQL on NATIVE Virtuoso columnstore, which involve combination of left join and UNION statements. A sample SPARQL query is given below: *Q1:* SPARQL SELECT * FROM WHERE { ?a . OP

Re: [Virtuoso-users] SET PROFILE ON not working

ww.facebook.com/OpenLinkSoftware > Universal Data Access, Integration, and Management Technology Providers > > On 19 Sep 2014, at 07:50, Medha Atre wrote: > > Hi, > > I am using Virtuoso opensource version 7.0, I tried "SET PROFILE ON;" > as given on > http:

[Virtuoso-users] Create index with partition

Hi, I was following the RDF performance tuning tutorial on http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning For an index created as -- "CREATE DISTINCT NO PRIMARY KEY REF COLUMN INDEX RDF_QUAD_SP ON DB.DBA.RDF_QUAD (S, P) PARTITION (S int (0hex00));" W

[Virtuoso-users] SET PROFILE ON not working

Hi, I am using Virtuoso opensource version 7.0, I tried "SET PROFILE ON;" as given on http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery But I get following error: SQL> SET PROFILE ON; *** Error 42S22: [Virtuoso Driver][Virtuoso Server]SR077: Bad

Re: [Virtuoso-users] Loading relational data into Virtuoso

n 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 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 t

Re: [Virtuoso-users] Loading relational data into Virtuoso

the jar by a java -jar druid.jar, and then point > it to the JDBC driver of your database, and you can do most of the > things you need (loading, querying, etc). > > Hope it helps. > > On Tue, Sep 9, 2014 at 8:35 AM, Medha Atre wrote: >> Hi Hugh, >> >> This is

Re: [Virtuoso-users] Loading relational data into Virtuoso

/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,

Re: [Virtuoso-users] Loading relational data into Virtuoso

ny/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:0

Re: [Virtuoso-users] Loading relational data into Virtuoso

.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 wrote: > > Hi, > > I want to us

[Virtuoso-users] Loading relational data into Virtuoso

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 -