Latest Activity

code

Can Denodo MPP work with Netezza?

Can Denodo MPP work with Netezza?

code

Column order alphabetical in Explorer vs ordinal in view Summary

When expanding a view in the Design Studio (Denodo 8), we noticed that columns in the Explorer are always listed in alphabetical order, whereas looking at the summary in VQL properties, the columns are listed ordinally as designed. However, in the Den...

code

Conversion of Teradata Text Column to Decimal with Conditional Zeroing in Denodo

I am currently facing a challenge in Denodo related to the conversion of a Teradata column named "Amount" with a data type of Text. The goal is to convert this column to Decimal to do sum operations. Additionally, I want to handle cases where the colum...

code

Text to decimal with Impala as source in Denodo

Hi, Im currently facing conversion challenge while using Impala as the source for denodo, while converting text to decimal. In teradata we are successfully using to_number for this conversion , but the same approach doesnt working with impala in denod...

code

Suddenly I can't log in anymore.

On Denodo platform 8.0, when I try to log in, all the tools that were available until yesterday become inaccessible. I have not made any configuration changes. The errors that appear when logging in are as follows Design Studio  Invalid authentication...

code

Pivoting a column to a row with example

I have a view with two columns as shown below: Label | Value Name | John Age | 29 Sex | M Name | Amy Age | 46 Sex | F It goes on and on like this. What I want is this: Name | Age | Sex John | 29 | M Amy | 46 | F But am having trouble with this. W...

code

How do we add an engine to existing 1 server cluster ?

We have 1 denodo engine running in our Development environment. How do we add another engine to it ?

code

denodo monitor log directory

Hi Denodo, How can i change the default denodo monitor log directory want to store it on separate drive patition? currently monitoring service running in solution manager. Thanks

code

query a long list of username doesn't work in Denodo

Hi there, My query is as simple as: select username, registration_date from member_table where username in ('abc', 'cde',...) (list of user here) The list of user needs to query is as long as about 30,000 users. I try to limit the list to 2000 use...

code

Views marked as invalid (red color) but still working

After a deployment lots of views (over 300) are coloured red and marked as invalid. When I execute one of these 'invalid' view, it is working normal. When I change 1 thing (p.e. add a character in the metadata) and save the view, the view is marked as ...