Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Denodo Scheduler authentication error
answered 30-01-2020 01:15:41 -0500

Hi, I can't execute a job in the scheduler because "dataSource 'PRE_CD2'. authentication error: The username or password is incorrect" I've configured in 'Data Sources > New Data Source > VDP' the PRE_CD2 which has the correct 'Connection URI' ...

Answers: 1

Fetching columns from denodo with space in column names through informatica bdm
answered 29-01-2020 21:08:34 -0500

While selecting columns with space in column names from denodo , informatica bdm is throwing error as such a column doesnot exist.

Answers: 1

Pass username and password with RESTful api.
answered 29-01-2020 19:20:34 -0500

when i am calling http://localhost:9090/denodo-restfulws/ from python request,porst() it throws a 401 not authorize error. how can i pass username and password here?

Answers: 1

REST API REST

Join with Excel data source
answered 29-01-2020 19:03:14 -0500

Hi, Is there a way to optimize a join from Excel that has 1.7M registers with other one that has 25M registers. The problem here is it takes longer than 15 minutes so it times out. Any suggestions? Thank you, Best regards.

Answers: 4

DATE / TIMESTAMP fields are not reflecting the i18n mapping change. Let us know if you need more info.
answered 29-01-2020 18:44:19 -0500

When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( ‘country’ = ‘US’ ‘datepattern’ = ‘MM/dd/yyyy’ ‘datesubtypepat...

Answers: 1

Denodo 7.0 Date Conversion i18n

From where can I install Apache Hive 2.0 JDBC Driver ?
answered 29-01-2020 18:35:19 -0500

Getting erorr: Unable to establish connection: The JDBC driver was not found. The Denodo Platform does not include the JDBC driver for this adapter. Copy the jar files of the driver to the folder "<DENODO_HOME>/lib-external/jdbc-drivers/hive-2.0...

Answers: 1

Hive apache hive hive 2.0

Denodo-Microsoft teams
answered 29-01-2020 10:45:58 -0500

Hi, I am trying to connect Denodo with Microsoft Teams or Microsoft Sharepoint or OneDrive. The documentation given in the community does not solve my problem it just makes it more complicated.

Answers: 3

Microsoft teams

No space left on device
answered 29-01-2020 07:40:17 -0500

Hi all, Could you kindly explain what is this issue? Why is this timeout and what is this "space" issue? "[ERROR] No space left on device " Error executing query. Total time 1378.258 seconds. QUERY [PROJECTION] [TOO_MANY_WORKS_TIMEOUT] Work 'Access(...

Answers: 1

Error

Substring Error
answered 29-01-2020 06:14:57 -0500

version is a column in a table called bv_table values for version looks like Dec[10+2], Jan[1+11]. I am trying to extract the number 10, 1 from the string, any number before +, I am running the below query in the vql shell select SUBSTRING(version, ...

Answers: 1

instr function substring

Denodo Express 7.0 installation Failed on MacOs Catalina
answered 29-01-2020 06:06:23 -0500

Hi, I have downloaded Denodo Express 7.0 to my Macbook which is running on MacOs Catalina.I have installed JDK 1.8 and assigned $JAVA_HOME to "/Library/Java/JavaVirtualMachines/jdk1.8.0_231.jdk/Contents/Home" in .zshrc file. When i run the command ba...

Answers: 2