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 Update and Insert Data into Table using source Table in different Environments.
answered 18-06-2018 06:15:22 -0400

Hi Team, Good morning!!!! Good Day!!! I Have a question that I having 3 tables(Table A,Table B and Table C) which or in different Environments so Here I want to Update table B using Table A and I want to Insert into Table C using Table A, simple we ca...

Answers: 1

SQL Unsupported Type error when doing a base view source refresh
answered 18-06-2018 03:46:55 -0400

I am trying to do a source refresh on a base view and am getting the following error: 543826675 [SwingWorker-pool-1-thread-7] ERROR 2018-05-23T18:17:47.339 com.denodo.vdb.admin.model.wrapper.WrapperAdminFacade - Not found mapping for sql type, using ...

Answers: 3

Source refresh unsupported data type

How to find the output after executing import.sh
answered 15-06-2018 08:37:55 -0400

Hi, I want to use Linux shell script to find the users attached to a Denodo role. I was using the command: import.sh -f test01.vql -h //localhost:9999/fad?USERNAME@PASSWORD The output, which contains the executed VQL also, shows: Parsing file 'test...

Answers: 1

VDP import command line

connecting workday through Denodo
answered 15-06-2018 06:05:47 -0400

Hi team, i have imported workday SOAP Web Service using an XML data source in denodo. The web service has multiple pages. But base view is giving data from only 1st page by default. Is there any possibility to display data from all the pages?

Answers: 3

Certificate after Completion
answered 14-06-2018 13:48:45 -0400

I took the training for Denodo Software Platform and still have received my certificate. Can you tell me when I should be receiving it? Thanks! Teresa Atnip taatnip@us.ibm.com

Answers: 2

GC overhead limit exceeded.
answered 14-06-2018 08:09:30 -0400

I'm trying to run Cache pre load for a base view with record count of 6221760. I'm getting the below erro. I tried changing the memory settings but no luck. Please suggest. "Finished with error: java.lang.OutOfMemoryError: GC overhead limit exceeded"

Answers: 3

Garbage Collector

how to present the received data from REST webservice
answered 14-06-2018 07:45:08 -0400

Hi there, First of all, I'm a newbie with Denodo, but I am experimenting a lot these days. We are using Denodo 7.0 and want to retrieve data from an rest-webservice. I'am to create the webservice call by using an XML datasource. Within the configura...

Answers: 3

S3-Athena connection
answered 13-06-2018 10:44:47 -0400

Hello Denodo Community, Please provide step by step connection/configuration procedure in getting data from AWS S3 Athena. Apologies for pressing a bit but this is needed urgently. Kindly revert back soonest for us to explore alternatives. Thank you.

Answers: 1

AWS S3 Athena

How to export the results using list command
answered 13-06-2018 07:19:47 -0400

How can we export the result of the below commands in VQL shell list functions list users list roles list databases

Answers: 1

How to create a parameterized derived view? Or Is there any way to access a subset of the data(base view) instead of accessing entire table(base view)?
answered 12-06-2018 12:50:33 -0400

I would like to create a derived view (one master base view will join with 3 code lookup base views). It has 5 millions records by Year (2002-2016). When I try to access this view from third party tool like Tableau, it is cripplingly slow and it timed ...

Answers: 1

Parameterize slow query Parameter derived view Tableau