Q&A

Unable to start Denodo License Manager
answered 17-02-2021 03:46:46 -0500

Hi, When I am trying to start the license manager in Denodo I am getting the following error:- Caused by: org.apache.derby.shared.common.error.StandardException: A read-only user or a user in a read-only database is not permitted to disable read-only...

Answers: 1

Issue in running the samples of denodo testing tool 8.0
answered 17-02-2021 02:56:05 -0500

Hi Team, This is the first time we are working in Denodo testing tool. We have downloaded the sofware. Java 1.8 is already there in the machine. Javahome variable is also set. Thoguht to execute the sample tests given to understand the functionality. S...

Answers: 1

#testingtool #denodotestingtool

Workaround for double quotes around database name in queries
answered 16-02-2021 11:48:05 -0500

I'm trying to see how I can configure my database to not need the double quotes around the database name when using queries in the VQL Shell. I realize there is a Restricted vs Unicode configuration that I think I've turned on, but I'm still having to ...

Answers: 1

Denodo 8.0 double quote Vql shell Database unicode

Building derived views that originally have subqueries in them
answered 16-02-2021 10:07:04 -0500

I have a query that I'm trying to build the logic for as a derived view. Basically, translating my view that is on a DB to Denodo as a Derived View. Trying to figure out that if we have a subquery in the from or where clause, do we have to create anoth...

Answers: 2

Denodo 8.0 Subquery Derived views

Row restriction preventing user from utilizing view in a derived view in their own Denodo database.
answered 16-02-2021 07:59:18 -0500

We are running V7.0.20201003. Thanks for any insight that can be provided on the following security scenario we are struggling with. A view (v1) is created in database d1. Column access is granted to col1, col2 on v1 to a user’s AD group. Row access g...

Answers: 3

security

How to define CASE statement in view parameters
answered 16-02-2021 07:52:05 -0500

Hi, I need to use a case statement in Denodo view parameters. whenever a defaut date is selected (ex: 1900-01-01) it should fetch data based case condition(ex: current_date-1) else it should fetch data by given date. Ex: case when start_date='1900-01...

Answers: 1

#parameters #Denodo #Denodovaraiables #variables #CASE

Automation testing for Denodo deployments
answered 15-02-2021 06:53:34 -0500

Hi Team, We are looking for some automation tesing for regression testing after migrating from Denodo 7.0 to Denodo 8.0. Also after code deployments from one environment to another. Which tool is the best to suffice the purpose? Thanks, Manju

Answers: 1

#Denodo_Migration #DenodoDeployments #Regression_testing #automation_testing

Excellent tutorial. Need help with filters resolvers
answered 15-02-2021 06:36:52 -0500

Thanks for tutorial. I got great Idea. Can you help me How your Query resolver? You explained filters. But I have JSON data . I need to execute this Query on JSON Data.

Answers: 3
Related to: GraphQL in Action - Advanced Query Capabilities

Help Access Denodo Express GraphQL Denodo Query Exceqution Plan

Create a birmap indexes in a remote table
answered 15-02-2021 06:26:37 -0500

Hi, Is there a way to create a bitmap index in a remote table ? Pierre SANGUINETTI

Answers: 1

remote table Index

Configure Bulk data load API for databricks source in denodo 8.0
answered 15-02-2021 05:49:28 -0500

Would like to know how to configure bulk data load API for Databricks source in denodo 8.0. I have gone through the Bulk data load API docs for Databricks, spark and impala. But I didnt understand how to configure it. Can you please let know the step b...

Answers: 1

bulkload Bulk Data Load databricks Spark