Q&A BY TAG 'query'

You must sign in to ask a question. If you do not have an account, you can register here

Error loading database while deploying the query
answered 21-09-2021 00:56:21 -0400

Hi Denodo Team, Can you help me with this error that i get when i want to deploy the query to the database. The error is "Error loading database " databasename"". any suggestion what to fix in order to work? thank you.

Answers: 1

query Data Catalog deploy

Prior year last business day retrivel
answered 24-08-2021 03:11:16 -0400

Hi there, I am trying to retrive last business day of last year though this query select dateadd(yy,datediff(yy,-1,@date),-1)[In sql], but in denodo I am not able to find any solution here, so can you please help me out, Thanks,

Answers: 1

denodo7 query

Query delegation
answered 12-08-2021 12:43:20 -0400

Hi, How many columns(fields) I can delegate to the soure from denodo? I am facing an exception 'ORA-01722 invalid number' while delegating more than 160 columns to the source? So is there any limit set on source side or denodo side? Kindly assist, T...

Answers: 1

oracle query delegation denodo 7

VQL to show all cached sources and when it was last refreshed?
answered 01-06-2021 17:37:03 -0400

Is there a way to get a result set that has the view, number of rows and the last cache refresh date? I want to make this a data set availbe easily to end-users to see when the cache was last updated. I have scoured the user documentation but do not ...

Answers: 1

vql query LASTCACHEREFRESH Cache

case insensitive for querying view purpose
answered 01-06-2021 03:49:41 -0400

Hi Team, Can Denodo support this function, to make the view name case insensitive, eg. I have one exact view like : DERIVED_VIEW_A, and when query the view, I may write the query like: select from "derived_view_a", or select from "Derived_View_a", an...

Answers: 1

view name query case insensitive

Denodo Cached View Issue (returns 0 records)
answered 18-10-2019 07:33:53 -0400

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

Answers: 5

Query Full Cache WHERE CONDITIONS Cache

Denodo Cached Base View Issue: returns 0 records in left join
answered 23-09-2019 08:11:59 -0400

Nevermind! Figure out the issue.

Answers: 1

Base view Query Cache

Query on joining and updating.
answered 25-07-2019 05:24:23 -0400

I have a view, I need to update columnA with Column B if that columnA as null value , do we have denodo query for it.?

Answers: 1

Query

find base view from query
answered 11-06-2019 13:26:06 -0400

Hi Team, Denodo 7.0 Is there any scripted way (stored procedure), which can tell what base views are created from query and what otherwise. Please help. Thnaks.

Answers: 3

Base view Query

Query not getting delegated to hive
answered 28-05-2019 20:20:33 -0400

Hi, We have a report view that is run monthly and is critical from the end user perspective. This view is cached on a regular schedule. When we run the view in vdp and it does not have any functions like current date() or get quarter(), I see that the...

Answers: 1

Function Query Delegate