Q&A

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

No space left on device
asked 29-01-2020 03:07:55 -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: 0

Error

Query Takes Longer Than Usual
asked 28-01-2020 22:33: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: 0

Query Speed

CustomWrapper returns 0 records when the file has additional column headers
asked 28-01-2020 21:21:44 -0500

Hi We've written a basic custom wrapper to read a text file and export to a table. The scheduled job to call the wrapper has been working pefectly for many months, however a change was made to append some additional columns to the file without our kno...

Answers: 0

It's possible to deploy denodo in a Datacenter without X server
answered 28-01-2020 19:18:49 -0500

Dear all, Is it possible to install denodo using a CLI but I didn't find a web app to manage it. The only way is to use the graphical application like Virtual DataPort Administration Tool but it suppose an X server and the ssh X forward failed on it....

Answers: 1

Update data in Denodo
answered 28-01-2020 15:24:47 -0500

Good evening, I would like to know how the data is updated in Denodo. Ie upload the data on Monday, but on Wednesday I want to update my views as I would in that case. Greetings from Ecuador.

Answers: 1

From where can I install Apache Hive 2.0 JDBC Driver ?
asked 28-01-2020 14:54:08 -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: 0

apache hive Hive hive 2.0

Oracle DB enforce parallelism
asked 28-01-2020 14:32:36 -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: 0

performance parallel JDBC Oracle DB connection Issue

DATE / TIMESTAMP fields are not reflecting the i18n mapping change.
answered 28-01-2020 13:26:05 -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' 'datesubtypepa...

Answers: 1

Date Conversion Denodo 7.0 i18n