Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Filtering File data source and Query execution plan
answered 28-12-2016 04:11:31 -0500

I have a base view which is running on top of file data source SELECT* FROM "baseview_1" WHERE to_date('MM/dd/yyyy', "ValidFrmDate") > addday(now(),-30) it's taking 6 Min to give me the results ,"ValidFrmDate" is text field in the file Also, consi...

Answers: 1

File data source filter

Denodo services getting stopped
answered 23-12-2016 08:33:36 -0500

Denodo VQL Server 6.0 getting stopped unexpectedly again and again. I have used the script mentioned in Knowledge Database to start the services whenever its down, but still its happening 7-8 times every day. I tried to play with : https://community.de...

Answers: 1

denodo 6.0 Denodo server starting trouble.

Services getting killed
answered 22-12-2016 07:13:08 -0500

Hi, Many of Denodo services getting stopped after starting.Checked the log got info as "win service stop - timeout 30000" So even changed the config file as per https://community.denodo.com/kb/view/document/VDP%20as%20Windows%20service%20with%20large%2...

Answers: 1

denodo 6.0 scheduler issue webtool denodo monitoring and diagnostic tool Denodo server starting trouble.

Timezone conversion
answered 21-12-2016 10:53:47 -0500

how to convert UTC time to CST ? I am looking for Oracle FROM_TZ equalent function in Denado. your inputs really appriciated!! thnaks!

Answers: 2

Timezone conversion

How to Connect to Hbase from denodo
answered 21-12-2016 07:37:02 -0500

Ubuntu14.0 hadoop-2.6-cdh5.8-psuedomode hbase2.0

Answers: 1

Blob Data Type in Denodo 6
answered 21-12-2016 06:16:57 -0500

Hi support Quick question... We have a few tables that were brought in from Oracle, which have blob (autodetect) fields. I did some reading and it looks like I can still use them in a join condition, pending they are of "varbinary" type (which they ar...

Answers: 1

blob oracle database connection

Denodo Function Executing VQL
answered 21-12-2016 04:56:20 -0500

Hi, Is it possible for a custom Denodo Function to execute a vql statement? I am trying to insert something like this into my function: ResultSet resultSet = getEnvironment().executeQuery(query, params); Thanks!

Answers: 3

VQL Custom Functions

Query Lineage information
answered 20-12-2016 11:10:43 -0500

We are trying to find lineage information of a denodo view from external system. While searching I found the query command "DESC" which produces the queries used to create the view and much more related information. Are there any other cammands that we...

Answers: 3

Lineage

Identify views/roles on which custom policy is applied
answered 20-12-2016 10:13:27 -0500

I have created a custom policy and have asked our denodo administrator to apply them on few roles and views. I would like to verify those details (since I do not rights to apply custom policies). Is there a stored procedure or function which will allow...

Answers: 1

custom policy list dependencies

Unable to rename a derived view
answered 20-12-2016 08:05:23 -0500

Hi, I am trying to rename a derived view "06_derived" to "05_derived" but im unable to do so howeveve im able to rename it with other name like "07_derived" etc.... Please let me know what can be the issue not much info on logs

Answers: 2

view derived view