Schema - Data Types

The following Datatypes are supported by the Hydrolix system.

  • Transform types are types specified for the Ingest Schema
  • View types are the types specified for the Query Schema

Mappings for these are shown below.

Transform TypeIndexVirtualIgnorePrimaryShardKeycatch_allFormatResolutionDefaultElementsSourceScriptLimitsView Type
arrayignoredoptionaloptionaldisalloweddisalloweddisallowedignoredignoredoptionalrequiredoptionaloptionaloptionalarray
bool or booleanoptionaloptionaloptionaldisalloweddisalloweddisallowedignoredignoredoptionaldisallowedoptionaloptionaloptionaluint8
datetimeoptionaloptionaloptionalalloweddisalloweddisallowedrequiredoptionaloptionaldisallowedoptionaloptionaloptionaldatetime or datetime64
datetime64optionaloptionaloptionalalloweddisalloweddisallowedrequiredoptionaloptionaldisallowedoptionaloptionaloptionaldatetime or datetime64
doubleoptionaloptionaloptionaldisalloweddisalloweddisallowedignoredignoredoptionaldisallowedoptionaloptionaloptionaldouble
epochoptionaloptionaloptionalalloweddisalloweddisallowedrequiredoptionaloptionaldisallowedoptionaloptionaloptionaldatetime or datetime64
int32optionaloptionaloptionaldisalloweddisalloweddisallowedignoredignoredoptionaldisallowedoptionaloptionaloptionalint32
int8optionaloptionaloptionaldisalloweddisalloweddisallowedignoredignoredoptionaldisallowedoptionaloptionaloptionalint8
int64optionaloptionaloptionaldisalloweddisalloweddisallowedignoredignoredoptionaldisallowedoptionaloptionaloptionalint64
stringoptionaloptionaloptionaldisallowedalloweddisallowedignoredignoredoptionaldisallowedoptionaloptionaloptionalstring
uint32optionaloptionaloptionaldisalloweddisalloweddisallowedignoredignoredoptionaldisallowedoptionaloptionaloptionaluint32
uint8optionaloptionaloptionaldisalloweddisalloweddisallowedignoredignoredoptionaldisallowedoptionaloptionaloptionaluint8
uint64optionaloptionaloptionaldisalloweddisalloweddisallowedignoredignoredoptionaldisallowedoptionaloptionaloptionaluint64