Q&A BY TAG 'denodo'
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 AWS S3 Create Base View
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
The version of Denodo on which window (analytic) function of SQL can be used
answered
12-01-2021 07:09:17 -0500
<Reference> https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&title=When+will+Denodo+support+analytic+functions+(i.e.+RANK%2C+NTILE%2C+PARTITION+BY....)%3F <Denodo VDP Version> 6.0 Administration tool:...
Answers:
1
Continuous Error at Excel Microsoft Query data retrieval from Denodo (6.0) through ODBC connectivity
answered
08-01-2021 05:42:07 -0500
All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo. <Error Description when retrieving data from De...
Answers:
1
Fetching Column issue in VQL
answered
05-01-2021 05:39:50 -0500
we have SAP Data Base, when we excute the base view in the denodo tool we could able get the 150 records. But, while excuting in the VQL shell for the specific Query like Select <Column_name> from <data_base>.<Base_view_name> throwin...
Answers:
1
I can able to execute the table but unable execute the specific column of the table
answered
04-01-2021 05:51:58 -0500
I can able to execute the table but unable execute the specific column of the table. error message Finished with error: Field not found 'bv_SYS_BIC_sap.bayer.CRM/CV_REP_CHANNEL_ENGAGEMENT_AGG_001.start_date' in view 'bv_SYS_BIC_sap.bayer.CRM/CV_REP_CH...
Answers:
1