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

Need help from Denodo Team.
answered 26-07-2018 05:26:08 -0400

Hi Team, I need your help on Denodo side on "No Name in query execution plan" long back i was posted this question, I could not find any solution yet. Just wanted to know below. is there any way to send the screeshots or attachment to you guys to u...

Answers: 1

Received exception with message 'Incorrect syntax near 'AT'.'
answered 25-07-2018 16:54:17 -0400

can please some one point me what does this error mean. The same query works fine in DEV and fails in QA select *,FORMATDATE('yyyy-MM-dd', dob) Finished with error: Error executing query. Total time 0.273 seconds. DV_XXXX_name [VIRTUAL] [ERROR] DV_...

Answers: 1

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