zazuko / cube-creator

A tool to create RDF cubes from CSV files
GNU Affero General Public License v3.0
14 stars 2 forks source link

Cannot delete cube #1320

Closed PDumasBAR closed 1 year ago

PDumasBAR commented 2 years ago

I'm trying to delete cubes in Stardog Studio with the [ad hoc query],(https://github.com/zazuko/cube-creator/wiki/Manually-removing-published-cube)

Even for small cubes (<1000 observations, <10'000 triples) Stardog fails with the error :

QEQOE2: com.complexible.stardog.plan.eval.ExecutionException: Query execution cancelled: Execution time exceeded query timeout 120000

Tested so far: https://environment.ld.admin.ch/foen/ubd000501/1 https://environment.ld.admin.ch/foen/ubd000501/10 https://environment.ld.admin.ch/foen/ubd000502/1 https://environment.ld.admin.ch/foen/ubd000502/10 https://environment.ld.admin.ch/foen/ubd000502test/1 https://environment.ld.admin.ch/foen/ubd000502test/3 https://environment.ld.admin.ch/foen/fab_ubd000502_debug/1

l00mi commented 2 years ago

Can you try to add "LIMIT 10000" to the end, and see if that works? If so, we would need to delete in Badges.

PDumasBAR commented 2 years ago

Salut Michael,

Désolé ça ne marche pas. Il manque peut-être quelque chose :

?set cube:observation ?observationS .
?observationS ?observationP ?observationO .

} } LIMIT 10000

QE0PE2: com.complexible.stardog.plan.eval.ExecutionException: Encountered " "limit" "LIMIT "" at line 61, column 1. Was expecting one of:

";" ... ";" ... A+ Pierre From: Michael Luggen ***@***.***> Sent: Dienstag, 1. November 2022 13:08 To: zazuko/cube-creator ***@***.***> Cc: Dumas Pierre BAR ***@***.***>; Author ***@***.***> Subject: Re: [zazuko/cube-creator] Cannot delete cube (Issue #1320) Can you try to add "LIMIT 10000" to the end, and see if that works? If so, we would need to delete in Badges. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>
tpluscode commented 1 year ago

Do I recall @l00mi that you improved the documented query to remove cubes?

PDumasBAR commented 1 year ago

Salut Tomasz,

Michael wrote a new version of the delete query and updated the doc.

I think everything is ok.

Kind regards and happy new year

Pierre

From: Tomasz Pluskiewicz @.> Sent: Donnerstag, 22. Dezember 2022 13:01 To: zazuko/cube-creator @.> Cc: Dumas Pierre BAR @.>; Author @.> Subject: Re: [zazuko/cube-creator] Cannot delete cube (Issue #1320)

Do I recall @l00mihttps://github.com/l00mi that you improved the documented query to remove cubes?

— Reply to this email directly, view it on GitHubhttps://github.com/zazuko/cube-creator/issues/1320#issuecomment-1362756672, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AIPR4LAI553YVVBI4LBOHVTWOQ7HRANCNFSM6AAAAAART66GF4. You are receiving this because you authored the thread.Message ID: @.***>

tpluscode commented 1 year ago

Glad to hear. Happy New Year to you too 🎆