Q&A BY TAG 'Data Type Conversion'

You must sign in to ask a question. If you do not have an account, you can register here

Join is not recognizing the same data (type text) in the fields and returning null values
answered 23-11-2022 14:05:13 -0500

I have 2 views. Each of this view has a field unit with the type text. I want to join these 2 views over this unit field. When I tried to do it though, I realized that somehow Denodo doesn't find matching values. So it returns an empty view. The ty...

Answers: 1

Data Type Conversion join Data Modeling

MongoDB Custom Wrapper - Type Conversion (Object, String)
answered 07-08-2020 17:21:05 -0400

Hi everyone, I have some issues with data type conversion while using the MongoDB Custom Wrapper. The following example Data illustrates the issue. /* 1 */ { "_id" : ObjectId("5f22f0c2754d8395a9b0acb9"), "Id" : "00Qi000000Jr44XEAR", "Nam...

Answers: 3

Type Conversion Custom Connector Data Type Conversion Error Handling mongodb

DATE fields being converted to TIMESTAMP in Denodo.
answered 24-01-2020 15:28:35 -0500

While creating base views from data source (oracle), denodo converts all DATE fields to TIMESTAMP. When we try to access these date fields from any JDBC client in our case 'DBeaver' we get these fields as TIMESTAMP and not 'DATE' fields. Is there a way...

Answers: 2

Date Conversion Denodo 7.0 Data Type Conversion

Column precision error for decimals
answered 26-11-2019 14:15:53 -0500

I'm getting below error when I execute my final view. This view contain more then 130 columns which I've made change for 'Decimals' Is there a way I can find that specific column because of which I'm getting this error. Finished with error: Error exec...

Answers: 1

Error Data Type Conversion

Floating points not recognized correctly
answered 20-06-2019 08:47:15 -0400

Hi guys, I'm working with VDP 7.0 and I have this CSV file that amongst other airport-related data contains latitude and longitude information. Here's a sample row of the dataset so you don't have to download the whole file: 34,"Castlegar/West Koote...

Answers: 3

CSV data types Data Type Conversion locale

How to convert @LASTCACHEREFRESH to long type as YYMMDDHHMMSS?
answered 11-04-2018 15:40:38 -0400

My source is DB2 and the last updated field type is long as YYMMDDHHMMSS formate. I want to use the full cache-> incremental query->condition to retrive the changed data, how to do it?

Answers: 3

Data Type Conversion

Converting ORACLE Data Data Type to Integer in Denodo
answered 13-03-2017 10:42:30 -0400

Hi, I am using an ORACLE table as my data source and need to convert DATE data type to integer format (YYYYMMDD). I tried using the syntax below and getting an error in Denodo. CAST(CONVERT(VARCHAR(8), address_01_filtered.add_from, 112) AS INTEGER) ...

Answers: 2

Date Conversion Data Type Conversion