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

Date Formatting
answered 21-08-2018 14:22:36 -0400

Hello, Here is my issue. I am working in Alteryx, pulling a table from Denodo. I'm looking to convert some odd date values to the equivalent format of Current_Date(). Like 2018-07-31 00:00:00. The date values I'm looking to convert are like such. 9101...

Answers: 4

Date Conversion Date

Denodo VDP Start Issue
answered 21-08-2018 14:21:58 -0400

Hi Team, All of a sudden when we were trying to bring up the vdp services we see the below entries, which never showed up earlier. Error Recursive call to appender FIleout Vdp services showed up fine, but want to know what is this Error about which ...

Answers: 1

Add users in Denodo 6.0 through Web service, Logging mechanism to store user activity, Pass user name and pwd in API request URL
answered 21-08-2018 12:32:55 -0400

Is there any API or Web service in Denodo to add Users and their roles. Is there any logging mechanism, where it stores Users activity like which User is accessing which API. How to pass username and password when security is enabled in Denodo...

Answers: 1

Create User API Security

Import SAS dataset
answered 21-08-2018 11:49:50 -0400

We need help in importing a SAS Dataset, I have read of custom java wrappers, please point us the right resources

Answers: 3

Denodo 7

ITPilot case function doesn't work fine
answered 21-08-2018 07:15:43 -0400

Hi! I am working with ITPilot wrapper trying to process output record and create a new field with into a value editor. I have a field date as string and I try to format with two patterns (with and without hours) case max(indexof(Iterator_1_output.dat...

Answers: 2

ITPILOT CASE

Creating views over files in S3
answered 21-08-2018 05:09:17 -0400

Should I use EMR's hive or Athena or CSV data source? What's the recommended approach?

Answers: 1

How to check by vql query for a view if "Enable Statistics" option has been checked
answered 21-08-2018 01:32:43 -0400

Hi, Instead of manually opening each view in a new window, how may I check by a vql query in Denodo if the "Enable Statistics" checkbox for a view has been checked Thanks in advance

Answers: 3

ERROR message 'Error parsing response'
answered 20-08-2018 09:50:05 -0400

Hello, I am receiving the error below when I run a vql script. What I am having trouble understanding is that when I add one additional criteria to call for a specific record the script comopletes fine with no errors. Any assistance on how I can resolv...

Answers: 3

Error parsing response

Performance issues in Data loading
answered 20-08-2018 01:25:58 -0400

Hi Team, We have a one job in Denodo Prod Region and data was loading into Cache DB, earlier it was taking very less than 10 min time, but now its taking more than 2 hours, really we could not able to find out the where is the issues and why its taking...

Answers: 1

change query-log values
answered 20-08-2018 00:05:52 -0400

Hi, by exploring the logfiles, in vdp-queries.log is one column called "server_name", having the value "vdp" in all logfiles. Is it possible to configure denodo to show the physical name of the server in this column?

Answers: 5

query logs