Valid RAQL Datatypes

MashZone NextGen Analytics : RAQL Queries : RAQL Datatypes and Data Formats : 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 from CSV or XML datasets is generally treated as String. You can, however, add datatype meta data 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.

Contact Support | Community | Feedback