Latest Activity

code

dense rank

get the 5TH highest annualincome

code

Parameters for function

on my linux Denodo 8.0 with the spatial extension I can't figure out how to substitute parameters into a function (at least I think that is the problem).When I run this query it works just like I would expect SELECT mbr_wkt FROM p_f_generatedxml_1 AS p...

code

Searching for a column used on derived(selection) views within "where" clause

Is there a way to search for columns used in derived "where" clause, but actually is not selected to derived view? Imagine we have a view bv_person with following properies: { FirstName, LastName, IsActive, Property1, Property2,......,Propery365 } T...

code

SCHEDULER IS DOWN

Hello team, We were unable to access the scheduler; to fix this, we restarted the pods, however we could see the below mentioned error, 839122 [RMI TCP Connection(13)-10.236.106.187] ERROR 2023-04-13T12:10:48.797 com.denodo.scheduler.core.server.authe...

code

IP Based Access

How to give access to the user based on IP Address to view tables and capture the logs ?

code

how to change substring dollar to number order

how to change substring dollar to number order in denodo

code

Misfire on Scheduler Job

Hi, On scheduler I keep seeing Misfire result on the Job when I have Trigger scheduled. I went through the causes but it doesnt really satify the scenarios I see. Is anyone having this kind of problem? Thank you, I hope I can be more clear but dont...

code

compatibility with pymssql

We are using package pymssql (2.2.4). Is our code comaptible with Denodo as-is, or will we have to mkae changes to use a different package?

Related to: How to connect to Denodo from Python - a starter for Data Scientists

code

Extra VQL query from the view

I have developed morethan 1000 derived views I am capturing all the Metadata with dependent views stored into one view or table I want to be extract VQL Query like select e.empid,e.empname,D.deptid from emp join dept on Emp.deptid= dept.deptid ...

#VQ
code

Extract CREATE VIEW AS SELECT soruce code statement

Hi, We are trying to ONLY extract all the CREATE VIEW vql source code to be able to isolate the AS SELECT statement of it. The goal is to have a list of all views we have created and their select statement. Can the output of the feature 'Creating re...