Denodo community Q&A RSS feedLatest Denodo community answered questionsMongoDB Base View Creation Array issue2024-12-09T10:36:33Z2024-12-09T10:36:33ZHi Team, I have connected MongoDB to Denodo through the Custom Wrapper.
I am trying to load the following document into Denodo. However, I only need specific fields from it:
{
"_id": { "$oid": "637cc839beb08100082158e2" },
"type": "Carrier",
"name": "BOSTON CARRIER CORP",
"mcNumberCheck": {
"date": { "$date": "2023-08-15T15:38:05.740Z" }
},
"addresses": [
{
"address1": "83 FARWELL ST APT E",
"city": "Newtonville",
"state": "Massachusetts",
"stateAbbr": "MA"
}
]
}
When I specify the following fields in the field box, the view works without issues:
_id:Varchar,
type:varchar,
name:varchar,
mcNumberCheck.date:timestamp
However, when I include fields from the addresses array, as shown below, the view fails to run:
_id:Varchar,
type:varchar,
name:varchar,
mcNumberCheck.date:timestamp,
addresses.address1:varchar,
addresses.city:varchar,
addresses.state:varchar,
addresses.stateAbbr:varchar
Denodo can process sub-documents but does not natively handle fields within arrays.2024-12-09T10:36:33ZOrder a nested field2024-12-06T00:10:20Z2024-12-06T00:10:20ZHi!
I'd like to know if it's possible to order a field within a nested column. For example, I have the following JSON structure:
```
{
"name": "test",
"elements":
[
{
"code": "01",
"description": "code 01"
},
{
"code": "05",
"description": "code 05"
},{
"code": "03",
"description": "code 03"
},{
"code": "02",
"description": "code 02"
},{
"code": "04",
"description": "code 04"
}
]
}
```
I have noticed that even after ordering the previous views, the order of the nested fields appears to be almost random. I believe this is because the nest function is processed by Denodo. Is it possible to achieve the desired ordering?
Thank you.
br2024-12-06T00:10:20ZSAP Descriptions missing in base views2024-12-05T23:09:06Z2024-12-05T23:09:06ZHi Experts
I'm importing data from SAP via RFC, during the import all description are missing for tables that been imported. Is there a way to get all field descriptions without manually editing them?
Thank you.2024-12-05T23:09:06ZDENODO SOLUTION MANAGER license error: SourceTypes are limited to 0 but 1 are found2024-12-05T17:12:34Z2024-12-05T17:12:34ZHi,
I create a datasource in DENODO SOLUTION MANAGER design-studio from VQL Shell and now i can´t access to design-studio.
I receive the error:
"license error: SourceTypes (arn, custom, df, gs, itp, jdbc, json, odbc, ws, xml, excel, saperp, sapbw, olap, essbase, sapbwbapi, salesforce) are limited to 0 but 1 are found"
Any ideia how i solve this problem?
Thanks
Best regards2024-12-05T17:12:34Z"where conditions" in join views2024-11-29T10:44:31Z2024-11-29T10:44:31ZVersion : 8
install update 2023/14/09
Hello,
I added a "where condition" via the web interface in a join view:
periodicite in 'QUOT','HEBDOS','FERIER'.
Extract of SQL sentence in denodo is : WHERE t17.periodicite IN (?, ?, ?)
With the parameters: [QUOT, HEBDOS, FERIE].
When I look at the execution plan on the source (SQLSERVER), I see an implicit conversion on the periodicite column:
CONVERT_IMPLICIT(nvarchar(30), [Vente].[dbo].[TITRE].[periodicite] as [t17].[periodicite], 0) = [@P198]
OR CONVERT_IMPLICIT(nvarchar(30), [Vente].[dbo].[TITRE].[periodicite] as [t17].[periodicite], 0) = [@P197]
OR CONVERT_IMPLICIT(nvarchar(30), [Vente].[dbo].[TITRE].[periodicite] as [t17].[periodicite], 0) = [@P196]
The column in the table is of type VARCHAR(30).
The base view in denodo also contain VARCHAR(30) type.
Why are the values specified in the WHERE condition typed as NVARCHAR(30)?
Is it necessary to always perform a CAST when specifying an alphanumeric value in this field?
Regards,
Emmanuel
**********************************************************
I find the solution in another case :
The solution was to change the Data Source property "Allow literal as parameter" from Yes to No.2024-11-29T10:44:31ZDescriptions not being propagated to nest fields2024-11-28T19:29:21Z2024-11-28T19:29:21ZHello,
I have a view with a nested column, but the fields inside it don't have descriptions, even though the source fields do. How can I ensure that the nested fields inherit the descriptions from the source?
br2024-11-28T19:29:21ZEntityâ??attributeâ??value (EAV) datasource2024-11-26T12:49:29Z2024-11-26T12:49:29ZI have JSON-over-HTTP datasource with EAV (Entity-attribute-value) model inside, like this one: https://pastebin.com/raw/XhHgR0VM
```
[
{
"id": "cb879cb8-a310-11ef-ba83-bab0678cb5af",
"number": "000000000001",
"date": "2024-09-10T21:34:55",
"template": "96fd7bb1-9bf8-11ef-ba83-bab0678cb5af",
"author": "Admin",
"fields": [
{
"fieldName": "date",
"fieldDescription": "",
"fieldType": "date",
"fieldValue": "2024-09-10T21:34:55"
},
{
"fieldName": "sex",
"fieldDescription": "",
"fieldType": "reference",
"fieldValue": "Male"
},
{
"fieldName": "amount",
"fieldDescription": "",
"fieldType": "number",
"fieldValue": "5"
},
{
"fieldName": "diagnosis",
"fieldDescription": "",
"fieldType": "reference",
"fieldValue": "Dystrophy"
},
{
"fieldName": "house",
"fieldDescription": "",
"fieldType": "reference",
"fieldValue": "RM-1-2"
}
]
}
]
```
I want to represent it like a table, like this:
```
date | sex | amount | diagnosis | etc
2024-09-10T21:34:55 | Male | 5 | Dystrophy | ...
```
What is the proper way to get it?2024-11-26T12:49:29Zhttp://XXXX:8081/metrics not working2024-11-25T08:57:12Z2024-11-25T08:57:12ZHi team,
after configured by steps above, i have error message while start denodo.
"Starting Denodo Virtual DataPort Server ... (press ENTER in case shell prompt was not automatically returned)
Could not load Logmanager "org.apache.logging.log4j.jul.LogManager"
java.lang.ClassNotFoundException: org.apache.logging.log4j.jul.LogManager
at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:471)"
port 8081 & other ports are up and denodo working fine.
but http://XXXX:8081/metrics not able to visit.
could you advise?2024-11-25T08:57:12ZTemplate for Element Descriptions2024-11-21T18:03:21Z2024-11-21T18:03:21ZIs there a way to set up a template in the Description field that ensures all descriptions follow the same format?2024-11-21T18:03:21ZGET PUBLIC COLUMN DEPENDENCIES2024-11-21T12:28:30Z2024-11-21T12:28:30ZHello
We are currently using the predefined stored procedure `GET_PUBLIC_VIEW_DEPENDENCIES` to get the direct dependencies between the public views only.
We want to do the same for the COLUMNS, but there is no predefined stored procedure for the public columns dependencies. The only available is `COLUMN_DEPENDENCIES` stored procedure which return private views.
Hence, Is there a stored procedure to do that?
Or how to elemenate the dependency on the private views so that all the direct dependencies are public views?2024-11-21T12:28:30Z