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 September 2019.

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.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Date conversion issue when the input date has month in 'MMM' format
answered 08-04-2019 19:01:56 -0400

I am trying to convert an input of format 03-Aug-2018 into date using the function to_date('dd-MMM-yyyy',03-Aug-2018') but it's returning NULL value. Where I am doing wrong in above function. I am executing this in Denodo Xpress (although I think it's...

Answers: 1

use Azure Data Lake as cache?
answered 08-04-2019 18:08:41 -0400

Azure Data Lake as source is clear to me: https://community.denodo.com/answers/question/details?questionId=9060g000000L756AAC&title=Azure+Data+Lake+Connection can it also be used for caching?

Answers: 1

cache azure

Denodo Client 5.5 & 6.0
answered 08-04-2019 12:07:39 -0400

Hi, Can i have 2 client versions on same server, we have Denodo 5.5 version install on citrix server other team use it to connect to denodo servers. Can i install Denodo 6.0 client on same machine? if yes what are thing to keep into conciderations? Ple...

Answers: 1

denodo client

Ms-Access database connection for Lab - call_tracking
answered 08-04-2019 08:52:21 -0400

I am trying to connect to a MS ACCESS DB. I followed the instructions in the posts: https://community.denodo.com/answers/question/details?questionId=9060g0000000A0OAAU&title=Ms-Access+database+connection https://community.denodo.com/answers/questio...

Answers: 1

DESC VQL VIEW require Write Permission
answered 08-04-2019 08:43:08 -0400

May I know why "DESC VQL VIEW" require write permission

Answers: 1

Permissions

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