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

How to change database schema of Oracle base views
answered 07-05-2018 11:39:27 -0400

Hi, in our development system (denodo 6.0, latest update) we frequently want to change the database schema of many existing base views belonging to the same Oracle data source. The problem is that the schema name is included in every JDBC wrapper, fo...

Answers: 1

Denodo 6.0 JDBC oracle wrapper

How to limit the records while creating the derived view in denodo with Hive as the source
answered 07-05-2018 08:17:13 -0400

Hi Team, I have a limitation from Hive source that more than 1 GB data cannot be fetched from Denodo. If the data is more than 1 GB will throw error in Denodo saying more than 1 GB data cannot be retrieved. Now I need to create a derived view on top ...

Answers: 1

Denodo and Hive

Support for Azure Blob Storage
answered 07-05-2018 07:35:51 -0400

Does anyone know if Denodo can natively use Azure Blob Storage as a Data Source? I have a container of JSON files I'd like to work on.

Answers: 1

azure blobl storage

ODBC connection issue
answered 07-05-2018 06:50:51 -0400

I am trying to connect sql server 2014. I installed ODBC drivers provided from denodo but connection issue as below. What is the fix for this?? "Unable to establish connection: server closed the connection unexpectedly This probably means the server t...

Answers: 4

ODBC SQL Server

Apple os X el capitan
answered 07-05-2018 03:56:03 -0400

how do download denodo express into macbook with os X

Answers: 1

deleted view is still found in catalog search, causes errors in metadata scripts
answered 04-05-2018 10:25:54 -0400

Hi, a view was first created, and deleted some hours later. On recreating this view with the same name, this error pops up: Error storing view 'VIEWNAME': Error accessing the metadata while loading/storing objects checking Catalog Search, we fi...

Answers: 3

Views Metadata Catalog

How to connect Hadoop source with Kerbros configured
answered 04-05-2018 07:01:07 -0400

Hi, I'm trying to connect Hadoop using database adapter as Hive 1.1.0 for cloudera(HiveServer2) and with following url : jdbc:hive2://host:10000;databasename=default;authenticatiobmethod=kerbos;serviceprincipalname=hive/host@xxxx.com. But i am getting ...

Answers: 1

kerberos authentication client sampe code Denodo and Hadoop Hive Issue hive; hadoop

How to connect with Arango DB ?
answered 04-05-2018 06:12:12 -0400

Hi Team, Can you please help me if there is any connectors avaialbe to connect with Arango Database ? Regards, Genesh

Answers: 1

JDBC

Automated Process to store the result of derived view into CSV file
answered 04-05-2018 05:12:27 -0400

HI Team, I like to know that can we automate the process which will store result of derived view into a csv file and sent into a mail as attachemant on daily basis. Regards, Ganesh T (7875588330)

Answers: 6

VDP

Difference between blank space and NULL
answered 04-05-2018 05:09:11 -0400

What is the difference between blank space and null in denodo? I observed that the fields with blank space cannot be retrieved using IS NULL. So, How to retrieve the columns with blank space or how to change them to NULL?

Answers: 1