Q&A

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

How to get list of base views which are created from query?
answered 04-04-2019 07:21:07 -0400

I need to fetch list of all baseviews which are created from query. Kindly suggest how can we get the list in Denodo 6.0

Answers: 3

baseview created from query

Error setting up SVN source control
answered 04-04-2019 07:11:52 -0400

I am getting the following error when trying to create an environment in the VCS Management window: Error creating environment: error creating environment: Error while executing svn status: Cannot run program "svn" (in directory "C:\Denodo\Denodo Plat...

Answers: 6

admin denodo 6.0 VDP VCS SVN