Latest Activity
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...
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
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...
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 ...
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...
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) = ...
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...