Q&A

UNION VQL throws java null pointer exception
answered 11-05-2020 08:09:37 -0400

Hello all, I am developing a solution which needs below scenario to work. *Select c1,c2,sum(c3) as C3 from A where x = <val1> group by c1,c2 UNION Select c1,c2,c3 from A where x = <val1>, y = <val 2>;* but this is throwing Java n...

Answers: 1

Java Null Pointer

VCS Error pushing database
answered 11-05-2020 07:03:51 -0400

We team use git for VDP VCS, we can pull, commit, but when we push code to Gitlab, error below will be showing: " Error pushing database XYZ: GitLab: Committer's email '' does not follow the pattern '@*xxxx.com$' " do we need some configuration change ...

Answers: 1

git push error VCS

Unable to connect to Azure SQL because of TCP/IP
answered 11-05-2020 02:28:23 -0400

Hi, I have been unable to connect to my Azure SQL database that i'm running on Azure VM. I am using Denodo Express to tryout the product. It keeps returning the "Unable to establish connection: The TCP/IP connection to the host, port 1433 has failed",...

Answers: 1

Azure Cloud TCP/IP SQL Server

Iam unable to execute NTILE function in denodo
answered 11-05-2020 00:03:55 -0400

Hi, While executing query in denodo by using ntile function is not executing. It is showing as below error.Kindly help on this. SQL Error [50006] [HY000]: Error executing view: Function ntile is not executable Much appreciate if you provide suggesti...

Answers: 1

#Analytic function

Connecting denodo to Hyperion DB
answered 08-05-2020 07:50:17 -0400

Hi Team, Can you please help me with some useful links or information on how to connect denodo to hyperion DB and create base views of the objects inside? Thank you !

Answers: 1

hyperion

Group by clause based on parameter
answered 08-05-2020 03:13:51 -0400

Denodo version 6 My question is I want to use "group by option" based on condition ie if I have parameter say Item, lot then its should group Item and Lot. Only item parameter is provided it should group by Item only...Is there is any way to acheive i...

Answers: 2

Can Denodo connect to files at AL11(t-code) application server of SAP BW
answered 08-05-2020 02:40:01 -0400

Hello Team, Can Denodo consume files at AL11(t-code) application server of SAP BW. When we connect any SAP BW system, it give infoarea structure only. Regards, Vijay

Answers: 2

SAP BW

Denodo Data Catalog: Having Clause
answered 07-05-2020 11:51:01 -0400

Hi, Even though Denodo 7 provides HAVING clause for filtering conditions on the results returned by a query using the GROUP BY clause, this functionality is not available in the Data Catalog that diminishes the value of the queries. Any attempts to add...

Answers: 2
Related to: Oracle SQL to Denodo VQL Quick Reference

Group By Having Clause Data Catalog Denodo Data Catalog. Version 7.0

How to connect to Denodo VDP using Oracle SQL Developer?
answered 07-05-2020 00:37:41 -0400

Is it possible to connect to Denodo VDP 7.0 using Oracle SQL Developer client using Denodo JDBC Driver?

Answers: 1

JDBC

Denodo Data Catalog.v.7.0: Request for Having Clause
answered 06-05-2020 17:55:30 -0400

Denodo Data Catalog. Version 7.0 According to https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/having_clause/having_clause the Denodo 7 provides HAVING clause for filtering conditions on the results returned by a query...

Answers: 1

Having clause Data Catalog Denodo Data Catalog. Version 7.0 Group By