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.

Slow response from Denodo
answered 08-05-2018 07:56:13 -0400

Hi, Environment: Database Oracle 12c Denodo : 6.0 We have a table (sa_suppliers) with about 162,000 rows, 110 columns and occupying about 118 MB When we query this table (no join with anything else), the response is very slow. Typically, if we select ...

Answers: 1

Oracle 12c

Reading JSON form a database column
answered 08-05-2018 05:54:44 -0400

Hi, We have JSON stored within a column in a SQL (or PostGreSQL database) - I am looking to explode this out to a flat file table structure. I am aware of how to do this when accessing a JSON file directly, but would like to replicate this function...

Answers: 1

#json #insert #reading #normalisation

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