Denodo community Q&A RSS feedLatest Denodo community answered questionsHow to insert bit type value(b'10101010') into Boolean in denodo2024-09-11T10:03:04Z2024-09-11T10:03:04ZI have a scenario, where mysql data source has a table with BIT(8) data type.
I have created a view for this mysql table and in denodo BIT type is converted as BOOLEAN by default.
When I am trying to perform INSERT INTO BitTest (bit_col)
VALUES (b'10101010'); in view
i am getting `Syntax error: Exception parsing query near '''
`How we can insert bit values into Boolean type. Can you provide the syntax for the same2024-09-11T10:03:04ZTag search2024-09-10T14:31:21Z2024-09-10T14:31:21ZI am on V8 of Denodo. I have a tag applied to 4 views. In Data Catalog, when I enter that tag in the search bar, it only returns one of the views. Why?2024-09-10T14:31:21ZHow to insert binary value to BLOB type2024-09-10T10:53:05Z2024-09-10T10:53:05ZI have a Mysql table with BINARY AND BLOB types.
Created a Base view via Administration tool, where BINARY AND BLOB types taken as BLOB by default
If I want to perform insert operation with Hexadecimal values (0x68656C6C6F) in to the Binary col and Blob columns , I am getting `Exception parsing query near 'x68656C6C6F'.
`what is the right way to handle this scenario. What is the correct syntax
And How denodo differentiate Binary and BLOB types2024-09-10T10:53:05ZRefresh Time / Update frequency2024-09-09T14:36:12Z2024-09-09T14:36:12ZHello,
If I want to know the refresh time or update frequency of any particular data table which is on Denodo Data Catalogue how can I find it ?2024-09-09T14:36:12ZDenodo 9 Helm Charts2024-09-09T13:36:09Z2024-09-09T13:36:09ZHello,
I am looking for a detailed explanation on the keystore section of the Denodo 9 helm charts.
Looks like this is the way to configure encryption of the secrets, but I cannot understand how it is supposed to be configured (sample values and so on).
Could you help?2024-09-09T13:36:09ZDependencies2024-09-09T09:49:42Z2024-09-09T09:49:42ZHi Team,
Is there any way to get the list of all the dependent views of a base view.2024-09-09T09:49:42ZColumn space issue2024-09-06T11:00:35Z2024-09-06T11:00:35ZWe have a view which is generated from joining a view from collibra, this view has an extra space in the specific column of the view. This space from the view is affecting other views down the line, we have applied the option 'trim' to eliminate the unwanted space .
This space is not available from the source system views, it is observed that the space is present onky after the join.2024-09-06T11:00:35ZGit with HA configured VDPs2024-09-04T20:51:58Z2024-09-04T20:51:58ZWe use Git for source control on Design Studio objects, and since we have switched to HA, the local repository is locked when trying to commit an object. Additionally, we run git reports on the local repos to determine any uncommited files and changes in the last week. The commands are in a shell script, run on the local VDP in this directory: /opt/denodo/denodo-8/work/vdp/repository/
Here's the commands run in the script:
git log --pretty="%h - %s" --since="1 weeks ago"
git diff --stat origin/main
Since moving to a HA configuration, it depends on which VDP you connect to when running the script. If you commit on VDP 1, then you do not see these changes reflected in the copy of the local repository in VDP 2.
How do you force connection to the same VDP when in a HA configuration where you have multiple hot VDPs? Otherwise, the remote repo will have trouble synching to the local repos because you don't know which is connected when you do commits vs when you make changes and push.
Is there a way to force Denodo into using a common local repository directory across HA VDPs?2024-09-04T20:51:58ZS4 Private Cloud Source2024-08-30T02:42:15Z2024-08-30T02:42:15ZHello,
Anyone connected S4 HANA(on Private Cloud) as datasource in denodo?
Did you have to open DB port at S4 HANA end to enable this? What template with SAP had to be used for ticketing?
What are the other options for this source?
Thanks!2024-08-30T02:42:15ZTime Format2024-08-28T15:05:35Z2024-08-28T15:05:35ZHello Team
I want my hours to be return in 24 hour format and not in the AM/PM format.
for exemple, now, i have this kind of hour 03:38:00, and i would prefer 15:38:00.
Is there a function that can change it in the output?
Thanks2024-08-28T15:05:35Z