You can translate the question and the replies:

Problem with types in denodo

Hi, I imported a collection from mongodb. The collection is a json with different subfileds of type object and array. In denodo, some subfileds of type array are correctly identified as "array" and other subfileds are identified as "text" instead of "array". When displaying the column with the worng type ,I get this format : DOCUMENT{{elem1 = value, elem2 = value, elem3 = value}} Is there a way to correctly import the object as array? I can't cast the type of the filed after the importation.. Thank you
ARRAY CAST Compound Types
user
31-01-2023 11:42:16 -0500
code

1 Answer

Hi, The Virtual DataPort will display a field as text when that field is defined as JSON in the base view creation. This is expected behavior when using the Denodo MongoDB Custom Wrapper. For more details, you can refer to the [Denodo MongoDB Custom Wrapper - User Manual](https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20MongoDB%20Custom%20Wrapper%20-%20User%20Manual). If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
31-01-2023 17:51:15 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here