Q&A

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

Query impala not working when run over VQL vdp client.
answered 14-09-2020 07:54:58 -0400

i have query VQL like this: select nmtkp, FORMATDATE('yyyyMM',cast(tglapprove as timestamp)) as blnlApprove, COUNT(distinct(sku)) as JlhBarang,SUM(price) as HargaTotal from dbmart.facttrans a where GETYEAR(cast(tgltrans as date))=2020 and jnsklaimreg=...

Answers: 2

vdp impala

dynamic parameter in derived view
answered 14-09-2020 05:40:12 -0400

How we can create a dynamic parameter to read the value for each run and then move to next condition till the condition statify please give some example

Answers: 1

dynamic parameter

Denodo Monitor - Stopping
answered 14-09-2020 03:59:28 -0400

Hi there, Quick question about the "denodo monitor". We have a need to log all queries from all users within VDP. I have followed the online steps and have enabled them on the server in question, but I see some strange behavior. We currently have d...

Answers: 3

denodo monitor

How to do the data sync from VDP to data Catalog?
answered 13-09-2020 12:54:59 -0400

Hi team, If I run some vql on vqp client, how can I do the daa sync from VDP to data catalog? I just found, when I run some vql which changed some metadata of my view, somthing like columns adding or deletion, but these changes are not synced to dataca...

Answers: 2

Data catalog data sync

Associations with Qlik Sense
answered 11-09-2020 08:37:30 -0400

Does associations in Denodo affects to Qlik Sense performance in some way?

Answers: 1

Qliksense

Setup connection with QlikSense
answered 10-09-2020 15:21:37 -0400

How to setup connection of Denodo Base and Derived VIews with QlikSense ? What is the port number to be used to make connection from ODBC driver ? In Our production setup, we have two Denodo server i.e., Production and DR how it will failover in case...

Answers: 1

#QlikSense

XML to CSV
answered 10-09-2020 13:16:54 -0400

Hi, I create a datasource for XML and and a view is created - basically a Wrapper is created and I can execute this view in the Execution panel. Question: Need guidance on who I can query or transform data into a csv or into a tabular form by rows. M...

Answers: 1

XML Data Source

Filtering Left Outer Joins with Automatic Simplification of Queries enabled causing execution plan to be complex
answered 10-09-2020 08:38:26 -0400

My development team is seeing strange behaviour with Denodo execution plans when using left outer joins and filters. We have a query that has multiple left joins to get data from a lookup table. When we execute the query, it takes approximately 20 se...

Answers: 1

Filter left join Query Simplification

Invalidate Cache
answered 10-09-2020 07:58:04 -0400

I had Full cache enabled for 3 views, they were scheduled to run everyday. But because of the large quantity of data, the temporary cache tables became too large and the jobs started failing citing lack of space as the reason. So I invalidated cache f...

Answers: 1

create a base view from Dremio data source, different sourcetypeid value for the same column of this base view
answered 10-09-2020 06:18:47 -0400

Hi Team, we are connection dremio data source to create base view, we found for the decimal column in source, such as decimal (10,0), deciaml (6,0), the sourcetypeid show different value in waprrer and table difinition, see below generated vql from dre...

Answers: 1

sourcetypeid value Dremio source