Q&A

[SQL0401] Comparison operator = operands not compatible.
answered 24-02-2020 07:58:57 -0500

Error : [SQL0401] Comparison operator = operands not compatible. DataSource is DB2. and data type of DATE_TRANSACTION IS date(deprecated) None of the below query works. Queries: SELECT FROM "Discovery_FiservODS"."EFT_TRANS_HISTORY" WHERE "DATE_TRAN...

Answers: 1

VQL

Preventing Denodo from creating a base view in two places
answered 24-02-2020 07:09:57 -0500

In Denodo platform 7.0, is there a setting or way to create a base view such that it is not listed in two places of the server explorer? As per https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources...

Answers: 3

Base view records deletion
answered 24-02-2020 04:58:03 -0500

We have two base views base view 1 : temp_del Name , age base view 2 : temp_del_2 Name , age I want to delete some records in base view 2 (MSSQL) using the below query. delete from temp_del_2 where name not in (select name from temp_del) It res...

Answers: 1

Delegate deletion

DNS entry like catalog.se.demo.net
answered 24-02-2020 04:52:06 -0500

Hi Team, catalog is listening to port 9090 which is not that user-friendly. Is it possible to create a DNS entry like catalog.se.demo.net where you can access the data catalog Please let me know how to do that.

Answers: 1

data catalog

Is it possible to create a southbound connection as well from Denodo to Sap Business Objects Universe?
answered 21-02-2020 11:33:52 -0500

Is it possible to add SAP BO Universe as a datasource in Denodo, so southbound connectivity from Denodo to SAP BO Universe?

Answers: 1
Related to: How to access VDP from SAP BusinessObjects

Reading unformatted values from a XLS file
answered 21-02-2020 07:47:36 -0500

Hi, connecting to a XLS file, I am able to read all the content I wish. But the fact is that DENODO seems to read the formatted values from the cells (visible reading the XLS through Excel), not the actual values stored in it. Example : if a cell conta...

Answers: 3

XLS CELL FORMATTED

Startup scripts and password prompts?
answered 21-02-2020 07:34:17 -0500

When I manually execute vdpserver script, line: su -c "$DENODO_HOME/bin/vqlserver_startup.sh" $VDP_USER || return 0 ask me for the $VDP_USER's password. How will this work when the script is automatically run from /etc/init.d? (i.e. will the passwor...

Answers: 1
Related to: Linux startup scripts for Virtual DataPort, Scheduler and Web Tools

hive-spark
answered 21-02-2020 07:33:43 -0500

I use spark execution engine on hive , when I create queries on hive it creates spark job at return succsesfully , but at denodo when i connect hive by jdbc (jar files) or spark sql , it never success ERROR : Received exception with message 'org.apache...

Answers: 1

hive-denodo hive-spark

Commands to start/stop Scheduler Index Server
answered 21-02-2020 06:38:27 -0500

What is the command to start Scheduler Index Server? I'd like to create a startup script to do this but I don't know what are its startup/shutdown commands.

Answers: 1
Related to: Linux startup scripts for the Denodo Platform

Case statement using columns from two different tables in a business
answered 21-02-2020 03:59:17 -0500

Denodo Virtual DataPort Version 7.0 Hi. I've written a case statement in a computed field in a business view which includes references to columns from two different tables. The case statement is returning results for one table or the other but not bot...

Answers: 1

CASE