Latest Activity

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...

code

Denodo upgrade(denodo-v80-update-20230301)

Hello team, We have installed the update in the Docker image and pushed it to registry also we did the helm deployment but even though we can see in pod the other update related changes, however we are not able to see the MPP changes. Even when we log...

code

Association in Denodo

Hi, i have 3 base views (A,B and C). association has been created between A and B,B and C as per documentation it says Association helps with performance so when i run my VQL query which joins A to B and B to C .how do i know if association actually im...