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.

Need to delegate the date column's data into two different databases-Hadoop and Oracle, but facing issue.
answered 23-10-2017 09:56:53 -0400

Hi Team, Scenario is like that: I have a Union View which is based on Hadoop+Oracle. Now, when I am mentioning any date condition like 'dd-MON-yy' (while executing), I am getting the result from Oracle but from Hadoop( Impala) I am not getting any re...

Answers: 1

DENODO

How to Delegate to_date function instead of to_timestamp into Oracle DB-at runtime
answered 23-10-2017 09:31:53 -0400

Hi, I created base view with interpolation variable (where expression) where I am passing “where” condition at runtime. But when I am passing the date value from denodo, from execution plan I do see the date value is converting to timestamp always and...

Answers: 3

DENODO

Getday/months function mask to two digits number
answered 23-10-2017 07:05:19 -0400

Hey denodo team, Is it possible to get a two digits number for those months that are lower to 10? I'm using the getday and getmonth functions to join both date fields (because they are on different times and I only want the date information). We use...

Answers: 3

Date Conversion Data Mask getday

Change user-agent in Denodo
answered 23-10-2017 03:21:53 -0400

Hi. I'm using Denodo Express (current version - June 2017) on my local machine for evaluation purposes. When I try to access web resources over http, I have the problem, that our proxy blocks the user agent that Denodo provides (MSIE 5.5; Windows NT5.0...

Answers: 1

Latest update available and its information
answered 23-10-2017 03:14:57 -0400

Hi team! Just a quick question, which is the latest update available for version 6 and where I can see the fixes/enhancements it contains? Thanks in advance! Best, Fabian

Answers: 1

patch upgrade update

DEN60EDUD01 Final Exam locked
answered 21-10-2017 08:10:01 -0400

I completed watching the videos and the lab material, but in the final exam, could not pass. I took two reattempts, and now its showing me as locked. Why is it?

Answers: 2

exam training locked ondemand

Creating a Data Source to HIVE and XML
answered 20-10-2017 06:41:17 -0400

I have a HIVE table (named EVENT) based on several XML files. To create this table I'm using hivexmlserde-1.0.5.3.jar library. I want to create a Data Source that connects to the EVENT table. The connection to HIVE service works well, however when I t...

Answers: 5

Logging User Roles and Privileges
answered 20-10-2017 06:17:32 -0400

Team, Suppose I have a Normal User "User A" with READ privilege on "Database A". Now, user privileges are modified to READ and WRITE on "Database A". Will this modification be logged anywhere ? That on this date and time by this admin user, privilege...

Answers: 5

Role and User Management

Deletion of Materialized views
answered 20-10-2017 04:50:56 -0400

Hello, How Can I delete multiple Materialized views that are created in Denodo at once ? Is there any way to do this activity. Thanks for your help in advance.

Answers: 3

Date view parameter with DB2 for z/os
answered 19-10-2017 11:23:26 -0400

I am attempting to create a view that requires an "as of" date parameter. My database is DB2 for z/os I created a parameter of type DATE named as_of_date. The default value is CURRENT_DATE(). I am using this as a filter in the WHERE clause. When I ex...

Answers: 4