Q&A BY TAG 'query'

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

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

Base View from query
answered 31-01-2019 05:42:13 -0500

Hi Team, Denodo 5.5 How to create a Base View from Query on stored procedure 'element_metadata()' Please tell. I also intend to use interpolation variables. Thanks.

Answers: 2

Query Stored Procedure

Extracting query with the hardcoded values not parameterized.
answered 29-08-2018 05:33:44 -0400

Hi, Currently we are running a query which has a lot of hard coded values. The query in its execution plan shows up like below Select as column1, as column2 from table; parameters = [<parameter1>, <parameter2>] How can I extract a que...

Answers: 1

query plan Parameterize Query Execution plans Parameter

track failed query
answered 25-06-2018 17:31:49 -0400

A user is hitting Denodo from tableau, He is facing issue with some tableau dashboards. While working with him we found that we can see 'active session with the query hitting from tableau to denodo', but we are unable to track failed query which was hi...

Answers: 3

query

Denodo & SQL Question - Temporary Tables & Updates
answered 25-06-2018 11:58:33 -0400

Hello, I am finding myself creating the majority of my base views by using the create from query function. I have a query I am looking to use to create a base view and in the query I have created temporary tables followed by update statements. The reas...

Answers: 1

Query SQL Temp Tables

ERROR: operator does not exist: timestamp without time zone >= character varying'
answered 19-06-2018 12:38:06 -0400

Hello, I am new to Denodo and because I have a strong background in SQL I have been using my SQL skills by creating base views off a query. When I get to the next step of creating my derived view witha a date parameter I continue to receive the followi...

Answers: 1

query Parameter Date timestamp