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 September 2019.

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.

How can we calculate DAYLIGHT SAVING TIME using Denodo functions dynamically?
answered 09-05-2018 06:36:53 -0400

Hi All, I want to calculate dynamically day light savings time using denodo functions. I see lots of in-built functions are available. Can someone please help calculating it? Thanks,

Answers: 1

Denodo 6.0

A synchronize error has been found
answered 09-05-2018 06:34:16 -0400

While creating a base view from database I'm getting this error "A synchronize error has been found"

Answers: 1

database Denodo 6.0 Error synchonization

Type conversion for Decimal point
answered 09-05-2018 05:00:45 -0400

HI, I am using the following formula, (qccount/transvalue) The value for qccount = 1 transvalue=47 so output is 1/47 = 0.021276596 but i am getting the 0 only. I tried to use cast('double',(qccount/transvalue)) but the output is 0.0 only and another...

Answers: 1

Decimal Type

Impala with Denodo
answered 09-05-2018 00:39:28 -0400

Hi, We have Impala 2.11.0+cdh5.14.0+0 and Denodo 6. Could you provide steps in connecting these two components? Thanks, Krish

Answers: 2

While executing a base view pointed to Postgre SQL from denodo, transaction is opened in Postgre SQL even we use Source configuration as SUPPORTEDDISTRIBUTEDTRANSACTIONS as false in the view defination
answered 08-05-2018 08:09:10 -0400

We have created a base view pointing to Greenplum and when we try to execute and verify query in Greenplum, we are seeing begin & commit transactions even for reading the data. We modified the view to use SUPPORTEDDISTRIBUTEDTRANSACTIONS property a...

Answers: 2

greenplum JDBC

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