Latest Activity

code

Compatibility Concerns: i9 Laptops and Denodo Versions

Hello Denodo community, I hope this post finds you all well. I've been exploring the capabilities of i9 laptops for my work with Denodo, and I wanted to reach out to the community for insights into potential compatibility concerns. If you've had any e...

code

Rest Api - No of Records

hi all, I am using denodo vdp to create rest api. After executing I get the data but I am unable to get total number of records along with the output of data. adding $count give just total number of records, while i want both data and total number of r...

code

How to split column into more columns

Hi teams, I have one column, the content is 60 X 30 X20 mm. Now I want to split them into three columns call length, width, height. The delimiter is 'X'. How can I implement it? When I use the function SPLIT, the column includes an array. How to conve...

code

Databrick/Denodo integration (databricks as a consumer)

Do we have any documentation or any process where we can connect denodo from databricks, here databricks will work as consumer and it will pull data from denodo(source)?

code

insert into a materialized view using select

Hi there, I have 2 questions: Can you please provide a syntax for this example below. I want to add 2 more set of rows: Washington, WA, Seatle and Colorado, CO, Denver into this table 'usa_state' which has 3 fields: state, abbreviation, capital ...

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...