Latest Activity


LDAP User on where clause

Hi everyone, I´ve been searching for a few hours before writing this post but unfortunatelly had no luck, most likely cause it´s not posible or use case it´s so rare but would like the hear the opinion of the community which has more experience. . Wha...

denodo security WHERE CONDITIONS #LDAP-ServiceAccounts


Timestamp From 24 Hours Ago of Current Timestamp

Hello, I know that I can get the current timestamp using the currenttimestamp function. I wanted to know what is the right way to subtract 24 hours from the timestamp returned from that function, in order to find the timestamp of exactly 24 hours befo...

local timestamp Date time function WHERE CONDITIONS timestamp


How to use dynamic dates in where clause

I am creating a view out of a Teradata database that has the date columns formated as YYYYMM and YYYY-MM-DD. Rather than a date WHERE condition based off of a static date such as '2019-10-31', I want a range based of a dynamics dates such as "ADD_MONTH...



Denodo Cached View Issue (returns 0 records)

I am seeing a strange issue with my Denodo cached view where it returns 0 records if I put a where statement and limit the columns. No issue if I select all columns though. Is this a bug, or I am missing the error? Please help me get the tailored view ...

Query Full Cache WHERE CONDITIONS Cache


WHERE Clause in query

I have created dervied view's using Baseview views and query also has an where clause at the end on one the Base view. When I run the new derived view the where condition is executed at the end. I dont see this helping peformance. please let me know, I...

query plan Sql performance WHERE CONDITIONS


Restrict UDF to WHERE CLAUSE Only

Is there a way to apply a restriction on UDF such that it can only be executed in a WHERE Clause, and not at any other place. For example, SELECT UDF(123) FROM DUAL(); ---> It should be invalid SELECT * FROM <TableName> WHERE UDF(COLUMN1) = ...

UDF WHERE CONDITIONS User Defined Function


Managing Null Array or no result due to where clause in flattening a view

I have a view where certain array that I need to flatten may be null or may not contain the specific row that I am looking for. When flattening such array, I get an empty result. How do I manage such array during flattening? Eg. Say I have this data I...