Re: [Virtuoso-users] Using column store structure for exiting data

2014-05-17 Thread Purohit, Sumit
I do store RDF data into virtuoso. Initial data was loaded into v 6.x.x. then gradually virtuoso was uploaded to v 7.0.0 and recently it has been upgraded to v 7.1.0 When is a database gets created if you load a rdf file into virtuoso using ld_dir_all() ?? thanks sumit

Re: [Virtuoso-users] Graph List does not get updated after RDF load

2014-05-17 Thread Purohit, Sumit
1. status of ttl file does changes from 0 to 2 when i use "select * from DB.DBA.load_list" 2. Most of the time it happens with smaller file. Recently it happened with a .ttl file with 1947 statements. 3. I have tried running "checkpoint" on isql command but that does not update the list. 4. sta

Re: [Virtuoso-users] Cryptic error when BINDing a variable

2014-05-17 Thread Hugh Williams
Hi Oliver, I have reported this issue to development to look into, will let you know when there is a fix ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://ww

Re: [Virtuoso-users] Using column store structure for exiting data

2014-05-17 Thread Hugh Williams
Hi Sumit, By default all SQL tables would be created as row wise, if the ColumnStore=1 setting is in place then any new SQL tables created will be column wise, but any existing table will not be auto converted or reindexed. The one exception are the RDF_QUAD and associated tables and indexes us

Re: [Virtuoso-users] Graph List does not get updated after RDF load

2014-05-17 Thread Hugh Williams
Hi Sumit, What is the version of Virtuoso being used: ./virtuoso-t -? What are the datasets being load and the expected triple count ? What does the output of running the Virtuoso status command run from isql report ? When you complete the loading of the data is a "checkpoint" run to

[Virtuoso-users] Using column store structure for exiting data

2014-05-17 Thread Purohit, Sumit
Hi All, I am using Virtuoso (Open Source) 7.1.0 and read about support of column-store structure in virtuoso. http://docs.openlinksw.com/virtuoso/databaseadmsrv.html Does setting ColumnStore=1 affect only tables created after the change OR DOES IT RE-INDEX / RE-STRUCTURE exiting tables and ind

[Virtuoso-users] Graph List does not get updated after RDF load

2014-05-17 Thread Purohit, Sumit
Hi, I have observed many times after loading rdf data into a named graph using ld_dir() or ld_dir_all(), updated list of graph does show up either on conductor->linked data-> Graphs or using query like SELECT DISTINCT ?g WHERE { GRAPH ?g { ?s ?p ?o } } Behavior is quite random and som

[Virtuoso-users] Fwd: Cryptic error when BINDing a variable

2014-05-17 Thread Olivier Rossel
Hello, I try this query on dbpedia.org: SELECT DISTINCT ?Label0 WHERE { < http://www.w3.org/2000/01/rdf-schema#label> ?Label0 . < http://www.w3.org/1999/02/22-rdf-syntax-ns#