Q&A

Oracle DB enforce parallelism
answered 31-01-2020 01:53:34 -0500

Hi Team, We are facing issues while fetching data from Oracle DB, which is taking longer time than usual. When checking with DB team, they suggested to use below(with parallel option) while running a select command. I tried to run the same manually an...

Answers: 1

performance parallel JDBC Oracle DB connection Issue

Query Takes Longer Than Usual
answered 30-01-2020 20:43:34 -0500

I am running Denodo Virtual DataPort Administration Tool using a Virtual Machine. When I combine the data using a join method and retrieve all the rows from the join, it takes approximately 24 minutes to return ~6.6M rows. I have attached the Tree View...

Answers: 1

Query Speed

How to get file modified date for an excel file in FTP location
answered 30-01-2020 11:26:17 -0500

We have defined some excel datasources that resides in a FTP server and Denodo BVs are created on top of them. We have a requirement to put the last modified/update date of each of the files (coming from different sources at different time). Is there a...

Answers: 2

File Modification Date

Is there a way to connect Denodo to Unix server non-interactively and use it as a data source
answered 30-01-2020 11:19:42 -0500

Hello, I need to connect Denodo to the specific folder on the Unix server, so I can use flat files as a datasource. Our security team only permits non-interactive login. Is there a way to connect Denodo to the Server non-interactive, and how that con...

Answers: 1

#connection #server #Unix

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