Appendix : Legacy Presto components : MashZone NextGen Analytics : RAQL Queries : RAQL Datatypes and Data Formats : Valid RAQL Datatypes
Valid RAQL Datatypes
RAQL supports the following simple datatypes for column data:
RAQL Datatype
Java Equivalent
bigdecimal
java.math.BigDecimal
boolean
java.lang.boolean
byte
java.lang.byte
character
java.lang.character
datetime
java.util.Date
double
java.lang.Double
float
java.lang.Float
integer
java.lang.Integer
long
java.lang.Long
short
java.lang.Short
string
java.lang.String
Data types of CSV, JSON or XML datasets are generally detected automatically. You can, however, override detected types by Providing Dataset Path and Datatype Information in a Schema.
JDBC results sets can contain columns with complex data, such as BLOB, CLOB or Struct and these columns can be included in the query result. However, the query itself cannot access complex data to perform comparisons or calculations.
Copyright © 2013-2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback