[Virtuoso-users] "csv_load_file" fucntion removes left zeros

Hi, I'm populating a table with VARCHAR columns trough a CSV file. The CSV fields are delimited with quotes, but the left zero values in the fileds are removed. csv_load_file('.csv',0, null, 'IOT_AGUEDA.i4m.InvoicesData', null, vector ('csv-delimiter', ',', 'csv-quote', '\')); How can I avoi

[Virtuoso-users] Create sparql view with composite Primary Keys

Hi, How can I create a sparql view with composite Primary Keys? CREATE VIEW AS SPARQL {SELECT ?s ?o ?p FROM ... Regards -- Open source business process management suite built on Java and Eclipse Turn processes into busi

[Virtuoso-users] virtuoso-t constantly segfaulting

Hi, The virtuosos process stop's after a while when I loading RDF data. virtuoso-t[5163]: segfault at 8 ip 00916f94 sp 7f713d8f5c90 error 4 in virtuoso-t[40+b65000] virtuoso-t[12171]: segfault at 8 ip 00916f94 sp 7f8533398c90 error 4 in virtuoso-t[40+b65000] virt

[Virtuoso-users] Create view as sparql with incremental identity

Hi, How can I create a view as sparql with incremental identity? I tried the following, but it always return 0. CREATE VIEW I4M.Dimensions.Dim_Equipment AS SPARQL { SELECT bif:row_count() AS ?incrementalID ?some_value FROM Regards --

[Virtuoso-users] SQL query inside SPARQL query

Hi, Can I have SQL query inside a SPARQL query? Exist any function to provide that? bif:(SELECT ContractID FROM I4M.Dimensions.Dim_Contract WHERE ContractorFiscalID = '000') AS ?ContractID CREATE VIEW I4M.Dimensions.Dim_Equipment AS SPARQL { SELECT bif:row_count() AS ?EquipmentID ?E

[Virtuoso-users] External Data Sources

Hi, I'm performing data aquisitiont trough RDF and then creating SPARQL queries to populate RDBMS views. I need to support OLAP queries over that data, but virtuoso doesn't support that. Currently I cannot afford to buy the commercial version to support the External Data Sources and populate ot

[Virtuoso-users] REST Web Services

Hi, how can I publish a REST web service through a Stored Procedure? I read the Virtuoso Server Pages (VSP), but it wasn't clear to me. I create the following procedure: create procedure "WS"."WS"."/i4m/electricity/average_consumption_by_month.vsp" (IN meterID VARCHAR, IN month_num tinyint, IN

[Virtuoso-users] virtuoso service stops

Hello, I'm trying to create a view with the output of a query SPARQL, but the virtuoso service stops. The output log gives: 13:23:34 /usr/local/virtuoso-opensource/bin/virtuoso-t() [0x60acc2] 13:23:34 /usr/local/virtuoso-opensource/bin/virtuoso-t() [0x60f41c] 13:23:34 /usr/local/virtuoso-opensou