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.