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 April 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

Apache Tomcat service is down
answered 10-03-2017 05:05:49 -0500

Hi I'm trying to query a restful webservice, but it seems like tomcat might be down (Windows). VDP is up and running, so how do I start the tomcat service? I can't find any windows services that looks like tomcat? Thanks Cheers

Answers: 1

Special character
answered 09-03-2017 07:24:02 -0500

I want to stripe-off special character when i query the column. is there a special funtion to do this. e.g. i have characters like ~ @ in the data. so if have value@like, i want to select valuelike. if i have panda~, i want to select panda.

Answers: 1

#SQL #VQL

List multiple servers (of a replication set) in Connection String when creating MongoDB base view
answered 09-03-2017 07:10:49 -0500

I need to know the connection string to use when connecting to MongoDB which is part of a replication set (the set consists of 3 servers). The Connection String I use when connecting to one MongoDB database is: mongodb://server1:port/dbname?authSource...

Answers: 1

custom wrapper mongodb

Denodo 6 : Unable to fetch records from Hive
answered 09-03-2017 02:01:49 -0500

I picked up all the relevant Hadoop & Hive JAR files for making connection with Denodo 6 and was successfully able to connect. Did created the views from existing hive tables, but when I try to VQL simple query to fetch records, it throw error. Bel...

Answers: 2
Related to: Denodo and Hadoop

Hive Issue

Subqueries cannot be included in a SELECT clause
answered 08-03-2017 13:45:30 -0500

Hello, Denodo isn't allowing a subquery to be included in the SELECT clause. Is there any alternative for this? Thanks, Hemant

Answers: 1

subquery

Adding a jdbc driver compiled with java 1.8
answered 07-03-2017 23:28:23 -0500

Is it possible , without getting the major minor 0.52 error ?

Answers: 1

jdbc java8

Reset Window layout command for the Virtual Dataport Admin Tool
answered 07-03-2017 21:39:07 -0500

Does Denodo have a reset window layout command for the Virtual Dataport Admin Tool? One of our windows has gone missing and we need a way to unhide it

Answers: 1

VDP

Error executing on a Hive Table
answered 07-03-2017 08:52:41 -0500

I have configured Hive on Denodo 6.0 using following parameters: database adapter: Hive 0.12.0 (Hiveserver2) Driver classpath: 'hive-0.12.0' Driver class: org.apache.hive.jdbc.HiveDriver Database URI: jdbc:hive2://13.82.57.6:10000/default Transaction i...

Answers: 1

Hive Issue hive; hadoop

How to find which denodo version is installed
answered 06-03-2017 08:32:55 -0500

Team, We have installed denodo in our unix environment How to find which denodo version is installed? (Do you have some command to check which version is installed and which latest patch need to update) mannually we can check going into dir and find...

Answers: 4

DENODO Denodo server starting trouble.

Issue with Import.sh script - locations of the vdp-requests.log and the db-tools.log files
answered 06-03-2017 07:59:33 -0500

When running the Import.sh script (file name.../denodo6.0/bin/import.sh), I am getting the following errors regarding the LOG files: log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /app/denodo/denodo_6.0/logs/vdp-requests.lo...

Answers: 1

import errors import