Latest Activity
Hi Team, I am using spark driver in denodo to query the data. While i directly query objects in S3, the column datatype is shown as an array, but when we onboard it to denodo it is onboarded as "text" and I don't see a dataype as an array in denodo. D...
I need to select distinct values from few array columns in a view. My view consists few Array columns and I cannot group by them. SELECT * from {view} where {parameter} = '03645' Parameter Column 2 Column 3 Column 4 ...
Hi Team, Is there a way to do vertical pivoting in denodo? I have one data element which is a combination of 3 fields basically seperated by ~. Example: abc~dfv~1234 cvfdv~as~23 So the first seperation till ~ belongs to field A, second part belongs to...
I have an array that has been created by a Denodo custom function that stores parsed ID numbers from 2 string fields concatenated; parsed_id. The field shows as an array in the view. I am trying to get the first element of the array and have tried, ...