Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Legacy Presto components | MashZone NextGen Analytics | Getting Started with MashZone NextGen Analytics | Datatype Information for Loaded Datasets
 
Datatype Information for Loaded Datasets
The plain functions used to cast the datatype of a column in the previous section point out one issue to be aware of for RAQL queries: in many cases, the RAQL Engine that runs the query has no datatype information for a given column. This is particularly true for data in CSV or XML formats.
When datatype information is not available, the RAQL Engine derives a schema based on the first row of data. For most purposes, this means that the data is treated as a string unless you explicitly cast it to another datatype.
Instead of using casting functions, you can provide datatype information for datasets in your mashup. See Providing Dataset Path and Datatype Information in a Schema for more information.

Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release