Q&A

REST API - Expression in group by resulting Error
answered 14-03-2022 09:13:08 -0400

Hello team, I am working on REST API and forming my query dynamically. Query is forming correctly but I am facing error while it tries to evaluate expression present in GroupBy clause. It say such column does not exists. Below is the sample query and ...

Answers: 3

Get error when Joining 2 files
answered 14-03-2022 09:10:46 -0400

When I try to join the 2 files below, I get the below error. SQL Error [50001] [HY000]: Error executing query. Total time 1.632 seconds. QUERY [PROJECTION] [ERROR] QUERY [SELECTION] [ERROR] QUERY [PROJECTION] [ERROR] QUERY [PROJECTION] [ERROR] QUERY ...

Answers: 1

How to use variables
answered 14-03-2022 09:05:59 -0400

I have a base view created using JDBC (data source sql) which has billions of rows and has the columns product_id, product_name, country and price. Also I'm having another DF file which has only 1 row and the columns are country and exchange rate. I h...

Answers: 1

variables

lab
answered 14-03-2022 07:31:58 -0400

for lab, i am trying to find The delimited files can be found at "http://data-server/files/df/" (replace data-server with the real name or IP address of your server if the host file has not been configured). i am replacing it by http://127.0.0.1:9090/f...

Answers: 1

How to resolve AUTHORIZATION REQUIRED 403 error??
answered 14-03-2022 05:05:57 -0400

Hi there, I am trying to open the support.denodo.com webiste to download denodo solution manager but i am unble to do so. I am getting " error 403. AUTHORIZATION REQUIRED User does not have any valid licenses for this service". How to resolve this issue?

Answers: 1

Connecting to Denodo via PyCharm
answered 14-03-2022 03:25:55 -0400

Hi there, Is there a way to add Denodo as a data source in PyCharm? The website has this information: https://www.jetbrains.com/help/pycharm/managing-data-sources.html#show-comments-for-data-sources-and-database-objects But Denodo isn't listed as a ...

Answers: 1

pycharm

Denodo 8.0 Express - Extensions
answered 11-03-2022 17:07:16 -0500

I need test some custom function and did compile the sample function to jar. However, when I try to add it to Denodo. I don't see extension tab on extension management. I only see "Libraries" tab. File -> Extension Management -> (Only Libraries ...

Answers: 1

extension custom functions

WEBCONTAINER_ELEMENT_STATUS() "modified" column
answered 11-03-2022 08:28:57 -0500

I need a more detailed explanation of what WEBCONTAINER_ELEMENT_STATUS() "modified" column means. I tried to attach images of the stored procedure run and the VDP webservice status. This applies for all webservices. in the return from the stored proced...

Answers: 2

WEBCONTAINER_ELEMENT_STATUS() "modified"

JBOSS TO DENODO
answered 11-03-2022 07:23:49 -0500

Can you pls throw some light and possible ways/process to do easy migration from JBOSS to Denodo?

Answers: 1

Error While Saving Derived View "Error saving view: Syntax error: Exception parsing query near 'WITH'"
answered 11-03-2022 06:51:13 -0500

Hi, I am creating a derived view over top a base view generated from a postgres table (10.x). I can configure a view parameter and add it in the where clause, but it will not let me save the view due to the error "Error saving view: Syntax error: Exce...

Answers: 1

Denodo Express 8.0