Q&A

Retrieve Cache Mode for a VIEW using JDBC
answered 08-04-2019 06:16:37 -0400

I am tring to retrieve "Cache Mode for a VIEW" (OFF, FULL, PARTIAL), But I didnt find a way to fetch it. I used "DESC VQL VIEW <viewName>", but it require write permission for the view. Please advice me to fetch "Cache Mode associated with a VIEW"

Answers: 2

JDBC

Starting Denodo express 7.0 issue
answered 08-04-2019 01:53:30 -0400

I am following following instructions to Start Denodo Express on linux Once the installation process is complete Denodo Express will be available in the destination folder that you selected during the install. You have now two options for starting Den...

Answers: 1

Connection refused on Impala connection with JDBC, kerberos
answered 07-04-2019 23:34:39 -0400

We have Cloudera5.12.2 and we’d like to connect to Impala(impala-2.9.0+cdh5.12.2+0) with JDBC. We use kerberos and we checked that we can kinit with the user we intend to use. We just DL the latest denodo express. Java is version8. We have DL Clouder...

Answers: 6

Kerberos JDBC impala

Split Comma separated string to rows
answered 05-04-2019 14:32:48 -0400

Hi I am trying to split a comma separated string to multiple rows. I am not able to find an easy method to do it using the available functions. Essentially I have a field called tracking number in the datawarehouse. It has multiple tracking numbers se...

Answers: 4

Denodo MPP Configuration guidelines (engine and memory)
answered 05-04-2019 10:40:34 -0400

In the Denodo MPP guidelines https://community.denodo.com/kb/view/document/MPP%20Query%20Acceleration:%20Sizing%20guidelines?category=Performance+%26+Optimization it is stated that for Impala the recommendation is to use 16 nodes with each 32GB memory....

Answers: 3

Still Unable to establish connection
answered 05-04-2019 05:59:25 -0400

I am using Denodo 7 and have followed these instructions and get the following error when I try to test the connection (and, yes, we do use integrated authentication for connecting to our SQL Server databases): Unable to establish connection: This dri...

Answers: 3
Related to: Accessing MS SQL Server using Windows Authentication

Scheduler Handler Section
answered 05-04-2019 01:01:38 -0400

Hi Team, Thanks for the response! In denodo 7.0 there is no Aracne section still there is Move-file repository in handler section. How I can use this handler section(move-file repository) for moving extracted file from scheduler jobs to different loc...

Answers: 1

file movement Scheduler Section

Can you assign a role in Denodo Data Catalog at the Category or folder level
answered 04-04-2019 08:53:47 -0400

We have 1 database but many Categories and Folders and Sub-folders with their own hierarchies. Can we assign users and roles at the Category and/or folder level. Example We want Data Steward 1 to have access to 3 out of 5 Categories. Within one of t...

Answers: 1

Roles Users

base view fals when select granted on columns subset
answered 04-04-2019 08:01:57 -0400

Hallo Denodo Team I am experimenting with authorizations and permissions. On a mysql database I gave select grant to a user on a subset of a table's columns. I created denodo base views as an "unrestricted" user. When I log into denodo as the "restrict...

Answers: 3

Grant MySQL pass-through

Import base view to other VBD
answered 04-04-2019 07:47:08 -0400

When I try to import a base view of a VBD exported to a VQL to another VBD, I get the error: *Command: CREATE OR REPLACE TABLE bvcccasedefinition I18N pteuro ( caseid: decimal (sourcetyperadix = '10', sourcetypedecimals = '0', sourcetypesize = '22', s...

Answers: 3