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 November 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.

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

Can I export data into text file from VDP
answered 15-03-2017 09:25:48 -0400

I am looking for a solution to export data from a denodo view into a text file, is there any option where i can achieve this through Denodo.

Answers: 2

OBIEE 12c ODBC connection with Denedo
answered 14-03-2017 11:51:43 -0400

Hi Team, Can we able to connect to OBIEE 12C with Denedo ? if yes, can you provide us what type of driver we should use and configuration ? you may try with 12.2.1.1.0. thnaks!!

Answers: 2

OBIEE 12c

HIVE issue with certain column names
answered 14-03-2017 09:54:25 -0400

I have a base view connecting to hive 1.2. I try to run the Execute query to get data on the base view and I get the error: Finished with error: Error executing query. Total time 0.929 seconds. BV_EHC_HE_FACT [BASE] [ERROR] HE_FACT AS HE_FACT_EHC [JD...

Answers: 1

HIVE "RESERVED WORDS"

Issues with connecting to JDBC data source
answered 14-03-2017 08:19:24 -0400

Hi, Encountered an issues again : Unable to connect to the database: Internal error: loader constraint violation: when resolving method "org.slf4j.impl.StaticLoggerBinder.getLoggerFactory()Lorg/slf4j/ILoggerFactory;" the class loader (instance of com/...

Answers: 1

JDBC Data-Source

All joins are executed when creating Star Schema
answered 13-03-2017 21:27:54 -0400

Hi Team I am having a star schema with 1 fact and 5 Dimensions .I created a view and Checked the data through Denodo. If I pull form column from 1 Dimension and one fact measure only small query should be fired against the Database and give me result...

Answers: 3

DENODO join

Not able to load S3 file with HDFSCustomWrapper
answered 13-03-2017 12:04:37 -0400

Hi all: I am trying to load an csv file from AWS S3, but i get an access error. Access & SecrectKey are assigned and with grant read and access permissions. So, I have some doubts about if S3 file need to have any special config. File access i...

Answers: 1

HDFSCustomWrapper; S3

Kerberos connection to Hive server is throwing error
answered 13-03-2017 11:56:15 -0400

Have added following below entries in vdpadmin.bat file to be taken during java command: -Dsun.security.krb5.debug=true -Djavax.security.auth.useSubjectCredsOnly=false -Djava.security.krb5.conf=C:\utility\conf\krb5.ini -Djava.security.auth.login.confi...

Answers: 1

Kerberos Hive Hive JDBC Hadoop keytab krb5

Converting ORACLE Data Data Type to Integer in Denodo
answered 13-03-2017 10:42:30 -0400

Hi, I am using an ORACLE table as my data source and need to convert DATE data type to integer format (YYYYMMDD). I tried using the syntax below and getting an error in Denodo. CAST(CONVERT(VARCHAR(8), address_01_filtered.add_from, 112) AS INTEGER) ...

Answers: 2

Date Conversion Data Type Conversion

Safety
answered 13-03-2017 09:53:31 -0400

Hi team, We are exploring Denono Express and we like working with it! We would like to connect DE to our source systems but we work with sensitive data. Therefore we would like to know how safe it is to connect our sources to Denodo, to prevent any p...

Answers: 2

safety security

anyway to debug issues with using of generic JDBC
answered 13-03-2017 09:18:09 -0400

Hi, I fail to find any logs under denodo express installation. I've implemented some JDBC driver, and for some reason it seems to be stuck in a loop while I am trying to test-connection. If there was a way to get the error/warning/debug logging, it wo...

Answers: 1

JDBC Data-Source