Latest Activity

code

error in connecting to oracle database using oracle 11 g adapter

I have used this information for the connect to the database: Name: ds_web_orders Database Adapter: Oracle 11g Database URL: jdbc:oracle:thin:@localhost:1521:xe Replace data-server with the real name or IP address of your server. User: website_sy...

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