How to write select query for composite keys in denodo like oracle Below is the example for oracle: SELECT * FROM table_name WHERE (key_part_1, key_part_2) IN ( ('B',1), ('C',2) ); Could you please let me know ASAP Thanks Satish K
Answers:
1
Hi, I need help constructing the correct VQL to change the password for a JDBC connection within VDP? I believe it is something like: ALTER DATASOURCE JDBC connectionname ENCRYPT_PASSWORD 'thisisthenewpassword';
Answers:
1
Hi, I recently created a Power BI report based on a Denodo datasource and published it to powerbi.com. I want to set up a scheduled refresh on powerbi.com. In order to do that, it looks like I need to use a gateway. To ensure that the refresh is cons...
Answers:
1
Hello, I know Denodo can be integrated with Presto. Is it planned to be also planned with Trino, the new fork of Presto? If yes, at which horizon? If not, why? Best regards, Tristan Labetoulle
Answers:
1
Denodo 7.0 Please how can I use AND for conditions in CASE command. I am getting error for the statement below: SELECT ST."EQUIPMENTID", CASE ST."INSERVICE"=1 WHEN SR."DATESERVICED" IS NOT NULL AND SC."INSTALLDATE" IS NULL AND SC."INSERVICEDATE" IS ...
Answers:
1
Hi, Steps followed for neo4j base view. 1) created data source for neo4j by using jdbc (adapter : generic , driver neo4j 4.0 , driver class : org.neo4j.jdbc.Driver) 2) Created a base view from Query using below query MATCH (n:Samplenode {name: 'xyz'})...
Answers:
1
Hello, I'm trying from Denodo to create a base view using introspection tool from Amazon Athena schema. The tool identifies correctly the data types for all the fields, but when I create the base view, the columns of type STRUCT are converted to text. ...
Answers:
1
Hi Team, Can denodo 8.0 read excel file thats stored on Azure blob storage? Or is has to be delimited file? and other standard files mentioned over KB? Thanks!
Answers:
7
Hello, We are trying to connect to a SAS/SHARE server from Denodo, using the SAS JDBC driver. Our table in our SAS server has a field called value and when we query that table through Denodo, the SQL generated by Denodo wraps the field name in double q...
Answers:
1
Hi Team, I am working on denodo 8.0. I was going to the training on Cache module and its recommended there not to use the cache maintanence task under server configuration as it is more expensive. Rather use the Clean_cache_database procedure. What i...
Answers:
1