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.

How can I customize errors in REST API?
answered 25-07-2018 16:03:28 -0400

How can I customize error in Denodo's REST API? (Format:JSON) E.g. Insted of this error - {"name":"derived view name","elements":[],"links":[{"rel":"self","href":"http://ServerName:Port/server/dbname/apiname/views/derived_view_name?columnname=value"}]}...

Answers: 1

REST API

Develop Custom Data catalog using Virtual dataport
answered 25-07-2018 08:45:49 -0400

I wanted to check if it is possible to leverage virtual dataport to create a custom web based Data catalog to allow technical and business users query, search and browse data and metadata information stored in a Virtual DataPort using the Custom data c...

Answers: 3

Is paging possible in REST API?
answered 25-07-2018 01:36:33 -0400

I have created an REST API on Derived View which has 11 million records. Is paging possible in REST API? or Can I show REST API output in chunks, let's say on first page(chunck) it will show 10,000 records, next chunck will have 10,000 records and so o...

Answers: 1

REST API

Numbering of array elements in flatten()
answered 24-07-2018 19:43:57 -0400

Hi, I have a Denodo view "personaldata" with a column "addresses" containing an array of addresses. I created a flatten view like this CREATE OR REPLACE VIEW personaldata_addresses AS SELECT user_id, last_udpated, _updated AS address_last_updated, ...

Answers: 3

OData Authentication isue
answered 24-07-2018 15:53:49 -0400

I downloaded the OData wrapper and we are trying to connect to some lists we have in Sharepoint. I followed the instructions in this link: https://community.denodo.com/kb/view/document/Microsoft%20SharePoint%20as%20data%20source?category=Data+Sources...

Answers: 2

OData ODATA

Developing Custom Functions
answered 24-07-2018 13:10:48 -0400

Hi, I'm using Denodo Platform 6.0 and I have a specific requirement. I wanted to develop a custom to-date function that calls Denodo's to-date when it's not delegated and calls the underlying to-date of Hive when it's supposed to be delegated. I foll...

Answers: 1

TO_DATE Custom Functions

How do I pre-load cache for a base view. I do not have scheduler.
answered 24-07-2018 12:37:19 -0400

All I want to do is preload the cache for a base view. I don't have scheduler to do it. I want to pre-load all of the data using a query. I really don't understand how to do this and the documentation isn't clear. My base view option is set rto full ca...

Answers: 1

execute from an output of VQL
answered 24-07-2018 10:18:27 -0400

Hi , what is the best way to execute output from a VQL statement ? I have something like this select 'alter table ' || view_name || ' (alter column ' || column_name || ' add (description = ''' || column_name || ' ''));' as vql_script from (select * ...

Answers: 3

How to connect to a Hive External table located in S3 ?
answered 24-07-2018 08:44:33 -0400

I have an use case where I have parquet files in S3 which are made available through external Hive Tables located in S3 .I need to figure out how Denodo could connect to Hive table in S3.

Answers: 1

VDP with GIT
answered 23-07-2018 16:29:24 -0400

Where are the step by step configuring documentaion for GIT and VDP?? I see a note in the documentation that for "There are no postinstallation tasks to use GIT in Denodo". As such to configure or enable functionalities described under "VCS Operations...

Answers: 1