Q&A

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

Scheduling Remote tables
answered 02-03-2022 06:06:20 -0500

Hi Team, I am working as a Data engineer and doing the Data Mesh Layer development. I am trying to create a Remote table to optimize the perfomance of the view created. I am not able to create it from Denodo Design Studio as not allowing to add a nam...

Answers: 1

Unable to connect to MariaDB server
answered 01-03-2022 07:11:27 -0500

Hello, I'm trying to connect to our MariaDB database in Denodo 7.0. As the MariaDB driver is not installed in our Denodo server, I tested using the MySQL5 Database adapter as a substitute, as suggested here: https://community.denodo.com/answers/quest...

Answers: 1

Denodo 7.0 MariaDB

Requests/Queries are in hung state
answered 01-03-2022 07:01:54 -0500

Requests in Diagnostic monitoring tool are shown in active and even cancelling these is not making them inactive. Same way, trying to cancel queries from Query Monitor but nothing is happening. Please suggest.

Answers: 1

Reserved words in query of a view
answered 01-03-2022 06:46:06 -0500

Hello Denodo Community, I am creating a view on top of baseview which has username as one of the columns. When I add a filter on username column, it is showing as reserved word. How do I get around it?

Answers: 1

Time Functions
answered 01-03-2022 06:14:38 -0500

Hi I have timestamps defined as decimals which I'm trying to convert to a date/time format to do a DaysBetween calculation --select getdaysbetween(to_date(date as decimal), to_date( '26-11-2021')) date as decimal = '20220225140000600' when I try t...

Answers: 1

Date time stamp

Update statement
answered 01-03-2022 05:48:35 -0500

Hi, how can i run an update statement? I have views and then views built on top of those views, but i also need to run an update statement. How can i do that, does it need to be in a stored procedure? I am hoping that there is a way to run updates etc ...

Answers: 1

update

calculating date -1
answered 01-03-2022 01:10:35 -0500

How do I achieve the functionality to calculate a date -1 to show a day prior in denodo?

Answers: 1

How to connect to running DQVM from locally running VDP Administration Tool? ( ie what is the server address)?
answered 28-02-2022 09:23:21 -0500

Hello Im looking to get going on Lab Create a JDBC data source and import tables graphically - DEN80EDU12D01LAB01 the first lab in the Connection to databases course. I've setup my Denodo Quickstart VM (DQVM) and its running on 192.168.100.3 and I ha...

Answers: 2

DQVM

Using WEBCONTAINER_ELEMENT_STATUS to get webservices statuses
answered 28-02-2022 07:21:33 -0500

I am using WEBCONTAINER_ELEMENT_STATUS() to retrieve information on the webservices showing the "deployed" status. Is this deployed=true enough to know if the webservice is accessible? Thank You. EA

Answers: 1