Q&A BY TAG 'denodo'
Denodo Hot backup
answered
15-04-2021 07:48:22 -0400
We wanted to setup a Denodo hot backup. I understand that this will be a separate always running server where metadata will be backed up/synchronized by the Solution manager and which will come up once main server goes down. However, I didn't find an...
Answers:
1
Query to Json and send result
answered
02-04-2021 08:49:30 -0400
Good Morning, Could someone be able to help me carry out the task we are trying to achieve. Since we did not finish finding the key. The tasks would be the following: 1- Connect to BBDD (We can connect without problems) 2- SQL query to the DB (It...
Answers:
3
Connect to Denodo from Lambda
answered
29-03-2021 06:44:00 -0400
Hello, I need to get the view and its information in one of the Lambda function built on AWS Lambda. I tried the below link but it says about the ODBC and JDBC connections but since the Lambda is serverless, can we have a connection to Denodo from Lam...
Answers:
5
Error when using RANK function for SAP data source
answered
17-03-2021 04:08:03 -0400
Hi, I am getting error while using a RANK function in Denodo v7. Error: "Finished with error: Error executing view: Function rank is not executable" Please let me know Will denodo support RANK function for SAP data source? If Yes, let me know how to f...
Answers:
1
Denodo view expose into kafka
answered
03-03-2021 08:55:17 -0500
Hello, I have some views in Denodo and I waant tthem to be exposed into kafka The views can be exposed to kafka using creating a REST API. Question Moreover is it possbile to send the view without an API? Can we expose the views using VCS int...
Answers:
1
Denodo 7.0 - Estimate and Actual Memory Used by a Query
answered
03-03-2021 07:28:58 -0500
We're encountering an error suggesting a query is too large. How do you derive the estimated and actual memory of a query? -John
Answers:
3
Denodo unable to fetch all the records for an entity which contains different Schemas file extensions for the parquet files from S3
answered
24-02-2021 06:15:56 -0500
Hello, I tried to create a base with file pattern (.) for the parquet file entity/table in s3 region. Then, when i excute the count query to fetch all the recodrs in the entity.I could able to get the below mentioned error. Finished with error: Error ...
Answers:
3
custom S3 HDFSCustomWrapper; S3 DENODO Create Base View AWS S3
Bring rules of the tables to base views
answered
12-02-2021 03:48:37 -0500
we have implemented security on tables in sql server ...we are using denodo 7.0.when we import the tables to create the base view do they bring them all or do we need to recreate them all again in denodo ? the denodo security doc dont have any comments...
Answers:
1
How to convert a date in string format to interval date
answered
18-01-2021 05:54:50 -0500
Hi community I need to convert a date in string format to interval. Does anyone knows how ? Example : I need to convert this '1974873205059' to interval Thank you,
Answers:
1
"SELECT top 1 1 as ID FROM <base view> uanble to excute
answered
13-01-2021 02:26:45 -0500
We have connected the SAP Database. when we are unable to excute the below query "SELECT top 1 1 as ID FROM <base view> " for the expected result ID 1 what changes can be done as the expected result thanks in Advance
Answers:
1