Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

No space left on device
answered 29-01-2020 07:40:17 -0500

Hi all, Could you kindly explain what is this issue? Why is this timeout and what is this "space" issue? "[ERROR] No space left on device " Error executing query. Total time 1378.258 seconds. QUERY [PROJECTION] [TOO_MANY_WORKS_TIMEOUT] Work 'Access(...

Answers: 1

Error

Substring Error
answered 29-01-2020 06:14:57 -0500

version is a column in a table called bv_table values for version looks like Dec[10+2], Jan[1+11]. I am trying to extract the number 10, 1 from the string, any number before +, I am running the below query in the vql shell select SUBSTRING(version, ...

Answers: 1

instr function substring

Denodo Express 7.0 installation Failed on MacOs Catalina
answered 29-01-2020 06:06:23 -0500

Hi, I have downloaded Denodo Express 7.0 to my Macbook which is running on MacOs Catalina.I have installed JDK 1.8 and assigned $JAVA_HOME to "/Library/Java/JavaVirtualMachines/jdk1.8.0_231.jdk/Contents/Home" in .zshrc file. When i run the command ba...

Answers: 2

It's possible to deploy denodo in a Datacenter without X server
answered 28-01-2020 19:18:49 -0500

Dear all, Is it possible to install denodo using a CLI but I didn't find a web app to manage it. The only way is to use the graphical application like Virtual DataPort Administration Tool but it suppose an X server and the ssh X forward failed on it....

Answers: 1

Update data in Denodo
answered 28-01-2020 15:24:47 -0500

Good evening, I would like to know how the data is updated in Denodo. Ie upload the data on Monday, but on Wednesday I want to update my views as I would in that case. Greetings from Ecuador.

Answers: 1

DATE / TIMESTAMP fields are not reflecting the i18n mapping change.
answered 28-01-2020 13:26:05 -0500

When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( 'country' = 'US' 'datepattern' = 'MM/dd/yyyy' 'datesubtypepa...

Answers: 1

Date Conversion Denodo 7.0 i18n

How to identify or eliminate the pre-defined admin roles from LIST Roles
answered 28-01-2020 11:23:24 -0500

Dear Friends, I am using LIST ROLES to get list of all the roles from denodo. I don't want to see pre-defined admin related roles in my list of roles. I mean, I don't want to see the following pre-defined roles (data_catalog_admin, data_catalog_classi...

Answers: 1

Access and Role

unavailability of shared cache during deployments in mult-node architecture
answered 28-01-2020 11:10:19 -0500

we have a single cache DB ( shared cache) for multiple Prodution denodo nodes. but problem with this architecture is when we do deployment of views having cache associated with it on any of nodes . this makes the cache unavailable/invalid for other nod...

Answers: 1

shared cache Zero downtime Cache deployment

How to ignore view from VCS synchronization (git)
answered 28-01-2020 08:29:39 -0500

Hello team, I managed to implement dynamic base view in Denodo: In a Denodo custom stored procedure I call an Oracle Stored procedure which create a dynamic Oracle view (view definition is unknown upfront). Then I create the base view (from my Denodo ...

Answers: 2

GIT VCS

Function to make tables of dimensions and facts
answered 28-01-2020 07:20:26 -0500

Good afternoon, with what function I can make tables of facts and dimensions. I have used Join to integrate views and Selection to use formulas (SUM, Get). Greetings from Ecuador.

Answers: 1